Manage Slider | BSPS Admin

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

Manage Sliders

fetch_assoc()): ?>

Image	Content	Action

BSPS ADMIN

Manage Sliders

Slider Details