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>";
?>