please do notify me if there are any errors restricting my code from functioning. Thank!!
<body>
Code: Select all
<?php
$con = mysqli_connect ("localhost", "rupert", "" , "example") or die ("Database connect error");
mysqli_select_db($con, "example") or die ("error connecting to database");
$query = "SELECT * FROM validation";
$result = mysqli_query($con , $query);
$rows = mysqli_fetch_assoc($result);
$totals = mysqli_num_rows($result);
?>
<div id="css">
<form action="<?php htmlentities ($_SERVER['PHP_SELF'])?>" method="post" >
<table width="80%" border="0" cellpadding="2" cellspacing="2" >
<caption><h2>Personal Details of Customers</h2></caption>
<tr class="white">
<td bgcolor="#330033"> </td>
<td bgcolor="#330033"> Id Number </td>
<td bgcolor="#330033"> Full Name </td>
<td bgcolor="#330033"> Email Address </td>
<td bgcolor="#330033"> Website </td>
<td bgcolor="#330033"> Comment </td>
<td bgcolor="#330033"> Time </td>
</tr>
<?php while($rows=mysqli_fetch_assoc($result))
{
?>
<tr>
<td><input type="radio" name="ID" value="<?php $rows['ID']?>;"/></td>
<td bgcolor="#FFFFCC"><?php echo $rows['ID'];?></td>
<td bgcolor="#FFFFCC"><?php echo $rows['Name'];?></td>
<td bgcolor="#FFFFCC"><?php echo $rows['Email'];?></td>
<td bgcolor="#FFFFCC"><?php echo $rows['Website'];?></td>
<td bgcolor="#FFFFCC"><?php echo $rows['Comment'];?></td>
<td bgcolor="#FFFFCC"><?php echo $rows['Time'];?></td>
<td> </td>
</tr>
<?Php
}
?>
<td><input type="submit" name="del" value="delete" /></td>
</table>
</form>
</div>
<?php
if (isset($_POST['del'])) {
$con = mysqli_connect ("localhost", "rupert", "" , "example") or die ("Database connect error");
mysqli_select_db($con, "example") or die ("error connecting to database");
$query1 = "DELETE FROM validation where ID = ";
$result1 = mysqli_query($con,$query1);
}
?></html>