Im trying to get the input from a form and delete the table data then display the the updated table but i get a blank page I don't know what could be the problem any help would be appericiated here's my code:
<html>
<body>
<?php
$mysqli = new mysqli("xxxxx", "xxxxxx", "xxxxx", "xxxxxx");
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}
//----------------------------------------------------------------------------------//
$name = $_POST['Car_ID'];
if ($stmt = $mysqli->prepare("delete from CARS where name=?")) {
// Bind the variable to the parameter as a string.
$stmt->bind_param("s", $name);
// Execute the statement.
$stmt->execute();
echo "Deleted data successfully\n";
// Close the prepared statement.
$mysqli->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$result = $db->prepare("SELECT id, Doors, TRANSMISSION, Fuel_type, Engine_Size, Total FROM CARS");
$result->execute();
while ($row = $result->fetch(PDO::FETCH_ASSOC)){
$doors=$row["Doors"];
$engine=$row["Engine_Size"];
$total=$row["Total"];
$trans=$row["Transmission"];
}
?>
<table>
<tr>
<td><?php echo $doors; ?></td>
<td><?php echo $engine; ?></td>
<td><?php echo $total; ?></td>
<td><?php echo $trans; ?></td>
</tr>
<?php } ?>
</table>
</body>
</html>