<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=, initial-scale=1.0">
    <title>Document</title>
</head>
<body>
<?php
include("db.php");
$id=$_GET['id'];
echo "ลบข้อมูล $id";
// sql to delete a record
$sql = "DELETE FROM books WHERE book_id='$id' ";

if ($conn->query($sql) === TRUE) {
  echo "Record deleted successfully";
  header( "location: index.php" );
} else {
  echo "Error deleting record: " . $conn->error;
}
?>
</body>
</html>