note 32557 rejected from faq.html by rioter
| From: | rioter@php.net | Date: | Sat, 31 May 2003 06:46:16 +0000 |
| Subject: | note 32557 rejected from faq.html by rioter | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-49476@lists.php.net to get a copy of this message | ||
Note Submitter: srmwin@yahoo.com
----
Question: Follwing codes suceesfully open the database and show the data,but when deletation is not
work,i delete the
data by getting ID from database,i don't how i pass the value
of the box to PHP and How i check it
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE> CVS-VSS Integaration </TITLE>
<META NAME="Generator" CONTENT="EditPlus">
<META NAME="Author" CONTENT="">
<META NAME="Keywords" CONTENT="">
<META NAME="Description" CONTENT="">
</HEAD>
<BODY bgcolor=#808080 text=#FFFFFF>
<?php
$dbconn = pg_Connect ("user=root password=password dbname=cvs2vssdb");
if ($dbconn)
echo "<h3>You Successfully open the database</h3>";
$result = pg_Exec($dbconn, "SELECT * FROM persistence");
$fieldno=pg_numrows($result);
//echo $fieldno;
echo ("<table border ='1' bordercolor=#FFFF00> ");
//this part displays our headings
echo ("<tr><td>ID</td><td>User Namer</td><td>File
Directory</td><td>File
Name</td><td>Status</td><td>Log</td>");
for($i=0;$i<$fieldno;$i++)
{
$data = pg_fetch_object($result, $i);
echo ("<tr><td>$data->id</tr></td>");
echo ("<td>$data->username</td>");
echo ("<td>$data->filedir</tr>");
echo ("<td>$data->filename</tr>");
echo ("<td>$data->status</td>");
echo ("<td>$data->log</td>");
}
?>
<p>Enter your Id No:<p>: <input type="text" name="add"
value="muthu ">
<input type="Button" value="Delete" onclick='alert("Successfully
Deleted")'>
<?php
$val=add.value;
$result = pg_Exec($dbconn, "DELETE FROM persistence WHERE id=$val");
?>
</BODY>
</HTML>