Show Code:
piece-delete.php
<?php include 'session.php'; ?>
<!DOCTYPE html>
<html>
<head>
<title>Alexandria</title>
<link href="style1.css" rel="stylesheet" type="text/css">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
</head>
<body>
<?php include 'nav.php'; ?>
<?php include 'db-connect.php'; ?>
<main>
<?php
$piece_id=$_GET['piece_id'];
$sql = 'DELETE FROM t_pieces WHERE piece_id='.$piece_id;
//if(mysqli_query($con,$sql)){
// echo 'Piece has been deleted';
//}
//else{
// echo "Error deleting Piece record: " . mysqli_error($con);
//}
?>
I'm temporarily suspending the delete action on this page so as we get a good growth of data in the database. You can still look at the code for this page and see the query commented out. Owen
<?php mysqli_close($con); //Close Connection?>
</main>
</body>
</html>