Manage Events Gallery

query("SELECT image FROM event_gallery WHERE id = $id"); if ($row = $res->fetch_assoc()) { $img_file = $row['image']; if ($img_file && file_exists($upload_dir . $img_file) && !str_starts_with($img_file, 'http')) { @unlink($upload_dir . $img_file); } } $conn->query("DELETE FROM event_gallery WHERE id = $id"); $message = "Event photo deleted successfully!"; } // Handle Status Toggle if (isset($_GET['toggle_status'])) { $id = intval($_GET['toggle_status']); $conn->query("UPDATE event_gallery SET status = IF(status=1, 0, 1) WHERE id = $id"); header("Location: manage_events.php"); exit(); } // Handle Add / Edit if ($_SERVER['REQUEST_METHOD'] === 'POST') { $id = isset($_POST['id']) ? intval($_POST['id']) : 0; $title = trim($_POST['title'] ?? ''); $order_num = intval($_POST['order_num'] ?? 0); if (empty($title)) { $title = "School Event"; } $image_name = ""; if (!empty($_FILES['image']['name'])) { $ext = strtolower(pathinfo($_FILES['image']['name'], PATHINFO_EXTENSION)); $allowed = ['jpg', 'jpeg', 'png', 'webp', 'gif']; if (in_array($ext, $allowed)) { $image_name = 'event_' . time() . '_' . rand(100, 999) . '.' . $ext; move_uploaded_file($_FILES['image']['tmp_name'], $upload_dir . $image_name); if ($id > 0) { $old_res = $conn->query("SELECT image FROM event_gallery WHERE id = $id"); if ($old = $old_res->fetch_assoc()) { if ($old['image'] && file_exists($upload_dir . $old['image'])) { @unlink($upload_dir . $old['image']); } } } } else { $error = "Invalid image file format! Use JPG, PNG, WEBP, or GIF."; } } if (empty($error)) { if ($id > 0) { if ($image_name !== "") { $stmt = $conn->prepare("UPDATE event_gallery SET title=?, image=?, order_num=? WHERE id=?"); $stmt->bind_param("ssii", $title, $image_name, $order_num, $id); } else { $stmt = $conn->prepare("UPDATE event_gallery SET title=?, order_num=? WHERE id=?"); $stmt->bind_param("sii", $title, $order_num, $id); } $stmt->execute(); $message = "Event updated successfully!"; } else { if ($image_name === "") { $error = "Please upload an event image!"; } else { $stmt = $conn->prepare("INSERT INTO event_gallery (title, image, order_num, status) VALUES (?, ?, ?, 1)"); $stmt->bind_param("ssi", $title, $image_name, $order_num); $stmt->execute(); $message = "New event photo added successfully!"; } } } } // Fetch all events $events = $conn->query("SELECT * FROM event_gallery ORDER BY order_num ASC, id ASC"); ?> Manage Events Gallery | BSPS Admin

Our Events Gallery

Manage the 5-photo mosaic grid displayed in the center of the leadership section.

num_rows > 0): ?> fetch_assoc()): $img_src = (str_starts_with($row['image'], 'http') || str_starts_with($row['image'], 'images/')) ? $row['image'] : (file_exists('../uploads/events/' . $row['image']) ? '../uploads/events/' . $row['image'] : '../images/' . $row['image']); ?>

Order	Image	Event Title	Status	Actions
			Active' : ' Inactive'; ?>
No event photos found. Click "Add Event Photo" to upload.

BSPS ADMIN

Our Events Gallery