Link to delete row from mysql
Posted: Wed Dec 17, 2008 9:54 pm
I am writing a simple script to insert data into mysql via an HTML form and then display it in an HTML table. That part of the script is working perfectly. What I want to do now is add a link next to each row in the HTML table that will let me delete that specific row.
I know that to accomplish this I need something like:
but I completely at a loss as how to implement this in my page. I don't know how to pass the ID of the row I want to the $id variable.
Here is the code to the page that displays the data, where I imagine all the code to do this would need to be.
Any help that anyone can offer would be greatly appreciated. If I haven't given enough information please let me know. Thanks.
I know that to accomplish this I need something like:
Code: Select all
$ok1 = @mysql_query("DELETE FROM ipaddrs WHERE ID='$id'");
if ($ok1) {
echo('<p>Row Deleted Succesfully!</p>');
} else {
echo('<p>Error deleting row from database!<br />'.
'Error: ' . mysql_error() . '</p>');
}
Here is the code to the page that displays the data, where I imagine all the code to do this would need to be.
Code: Select all
<?php
mysql_connect('localhost', 'username', 'password');
mysql_select_db('network') or die ('Unable to connect to database: ' . mysql_error());
$query="SELECT * FROM ipaddrs";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
?>
<table border="0" cellspacing="5" cellpadding="5">
<tr>
<th><font face="Arial, Helvetica, sans-serif">ID</font></th>
<th><font face="Arial, Helvetica, sans-serif">IP Address</font></th>
<th><font face="Arial, Helvetica, sans-serif">Port</font></th>
<th><font face="Arial, Helvetica, sans-serif">Router</font></th>
<th><font face="Arial, Helvetica, sans-serif">FW Version</font></th>
<th><font face="Arial, Helvetica, sans-serif">Username</font></th>
<th><font face="Arial, Helvetica, sans-serif">Password</font></th>
<th><font face="Arial, Helvetica, sans-serif">Notes</font></th>
<th><font face="Arial, Helvetica, sans-serif">Delete</font></th>
</tr>
<?php
$i=0;
while ($i < $num) {
$id=mysql_result($result,$i,"id");
$ip=mysql_result($result,$i,"ip");
$port=mysql_result($result,$i,"port");
$router=mysql_result($result,$i,"router");
$fwversion=mysql_result($result,$i,"fwversion");
$user=mysql_result($result,$i,"user");
$pass=mysql_result($result,$i,"pass");
$notes=mysql_result($result,$i,"notes");
?>
<tr>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $id; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $ip; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $port; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $router; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $fwversion; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $user; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $pass; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $notes; ?></font></td>
<?php
$i++;
}
echo "</table>";
?>