prepare("SELECT * FROM events WHERE status = ? AND event_date >= ? ORDER BY event_date ASC, event_time ASC"); $stmt->execute(['active', $currentDate]); $events = $stmt->fetchAll(PDO::FETCH_ASSOC); // Sanitize event data $uniqueEvents = []; // To prevent duplicates (just in case) $eventIds = []; // Track IDs to ensure uniqueness foreach ($events as &$event) { if (!in_array($event['id'], $eventIds)) { $event['title'] = htmlspecialchars($event['title']); $event['description'] = htmlspecialchars($event['description']); $event['location'] = htmlspecialchars($event['location']); $uniqueEvents[] = $event; $eventIds[] = $event['id']; } } $events = $uniqueEvents; // Use sanitized and unique events include 'header.php'; include 'navbar.php'; ?>
Upcoming Events
$event): ?>
<?php echo $event['title']; ?>

|

$currentDateTime): ?> Upcoming Today

No upcoming events available at this time.