prepare("INSERT INTO books (book_name, author_name) VALUES (?, ?)");
$stmt->execute([$book, $author]);
}
header("Location: delete.php");
exit;
}
// Delete record
if (isset($_GET['delete'])) {
$id = (int) $_GET['delete'];
$stmt = $pdo->prepare("DELETE FROM books WHERE id = ?");
$stmt->execute([$id]);
header("Location: delete.php");
exit;
}
// Fetch all records
$stmt = $pdo->query("SELECT * FROM books ORDER BY id DESC");
$books = $stmt->fetchAll(PDO::FETCH_ASSOC);
?>
Book Records
Add Book
Book List
| # |
Book Name |
Author Name |
Action |
$book): ?>
|
|
|
Delete
|
No records found.