Manage Gallery

query("SELECT image FROM gallery WHERE id = $id"); if ($row = $res->fetch_assoc()) { if (file_exists('../uploads/gallery/' . $row['image'])) { unlink('../uploads/gallery/' . $row['image']); } } $conn->query("DELETE FROM gallery WHERE id = $id"); $message = "Gallery item deleted successfully!"; } // Handle Add/Update if ($_SERVER['REQUEST_METHOD'] == 'POST') { $heading = $_POST['heading']; $id = $_POST['id']; if (!empty($_FILES['image']['name'])) { $image = time() . '_' . $_FILES['image']['name']; move_uploaded_file($_FILES['image']['tmp_name'], '../uploads/gallery/' . $image); if ($id) { // Delete old image $res = $conn->query("SELECT image FROM gallery WHERE id = $id"); if ($row = $res->fetch_assoc()) { if (file_exists('../uploads/gallery/' . $row['image'])) { unlink('../uploads/gallery/' . $row['image']); } } $stmt = $conn->prepare("UPDATE gallery SET image=?, heading=? WHERE id=?"); $stmt->bind_param("ssi", $image, $heading, $id); } else { $stmt = $conn->prepare("INSERT INTO gallery (image, heading) VALUES (?, ?)"); $stmt->bind_param("ss", $image, $heading); } } else { if ($id) { $stmt = $conn->prepare("UPDATE gallery SET heading=? WHERE id=?"); $stmt->bind_param("si", $heading, $id); } } if ($stmt->execute()) { $message = "Gallery item saved successfully!"; } } $gallery = $conn->query("SELECT * FROM gallery ORDER BY id DESC"); ?> Manage Gallery | BSPS Admin

fetch_assoc()): ?>

Image	Heading	Action

BSPS ADMIN

Manage Gallery

Gallery Details