prepare(" INSERT INTO events (title, description, event_date, event_time, location, image, status, created_at) VALUES (?, ?, ?, ?, ?, ?, ?, NOW()) "); $stmt->execute([$title, $description, $event_date, $event_time, $location, $image, $status]); $message = 'Event added successfully!'; } else { // Keep existing image if no new image uploaded if (empty($image)) { $stmt = $db->prepare("SELECT image FROM events WHERE id = ?"); $stmt->execute([$id]); $existing = $stmt->fetch(); $image = $existing['image'] ?? ''; } $stmt = $db->prepare(" UPDATE events SET title = ?, description = ?, event_date = ?, event_time = ?, location = ?, image = ?, status = ? WHERE id = ? "); $stmt->execute([$title, $description, $event_date, $event_time, $location, $image, $status, $id]); $message = 'Event updated successfully!'; } $action = 'list'; } catch (Exception $e) { $error = 'Error: ' . $e->getMessage(); } break; case 'delete': try { $delete_id = $_POST['id']; // Get image filename before deleting $stmt = $db->prepare("SELECT image FROM events WHERE id = ?"); $stmt->execute([$delete_id]); $event = $stmt->fetch(); // Delete event $stmt = $db->prepare("DELETE FROM events WHERE id = ?"); $stmt->execute([$delete_id]); // Delete image if it exists if (!empty($event['image']) && file_exists('../img/' . $event['image'])) { unlink('../img/' . $event['image']); } $message = 'Event deleted successfully!'; } catch (Exception $e) { $error = 'Error deleting event: ' . $e->getMessage(); } break; } } } // Get event data for editing $event_data = null; if ($action === 'edit' && $id > 0) { $stmt = $db->prepare("SELECT * FROM events WHERE id = ?"); $stmt->execute([$id]); $event_data = $stmt->fetch(); if (!$event_data) { $error = 'Event not found!'; $action = 'list'; } } // Get events list $events_list = []; if ($action === 'list') { $stmt = $db->prepare("SELECT * FROM events ORDER BY event_date DESC"); $stmt->execute(); $events_list = $stmt->fetchAll(); } include 'includes/header.php'; ?>

Events List

Image	Title	Date/Time	Location	Status	Actions

Title *

Description *

Event Date *

Time *

Status *

Location *

Image

Cancel

Event Management

Events List