<?php
Connecting to a database
$link _id = mysql_connect ("localhost", "root", "") or Die ("Connection failed");
if ($link _id)
{
mysql_select_db ("My_test");
if (!$_get[id])
{
$result =mysql_query ("SELECT * from UserInfo");
echo "<table border=1>
<TR>
<TD> number </TD>
<TD> User name </TD>
<TD> Sex </TD>
<TD> Age </TD>
<TD> Registration Time </TD>
<TD> Operations </TD>
</TR> ";
while ($row =mysql_fetch_array ($result)) {
echo "<TR>
<TD> ". $row [id]." </TD>
<TD> ". $row [username]." </TD>
<TD> ". $row [Gender]." </TD>
<TD> ". $row [age]." </TD>
<TD> ". $row [RegDate]." </TD>
<td><a href=delete.php?id= ". $row [id]." > Delete </a></TD>
</TR> ";
}
echo "</TABLE>";
}//Display the contents of a list
Else
{
$sql = "Delete from userinfo where id=". $_get[id];
$result =mysql_query ($sql);
if ($result)
echo "Record has been successfully deleted Www.111cn.net<br><a href= ' delete.php ' > Return </a>";
Else
echo "Record deletion failed <br><a href=delete.php.php?id=". $_get[id]. " > Return </a> ";
}//else ($id part)
}//End If
?>
Www.111cn.net