prepare("
INSERT INTO events (title, event_date, end_time, location, description, category, is_public, created_by)
VALUES (?, ?, ?, ?, ?, ?, ?, ?)
");
$stmt->execute([$title, $event_date, $end_time, $location, $description, $category, $is_public, $_SESSION['member_id']]);
$formSuccess = "Event added successfully.";
}
}
// Handle Delete (members only)
if (isset($_GET['delete']) && $loggedIn) {
$delId = (int)$_GET['delete'];
$pdo->prepare("DELETE FROM events WHERE id = ?")->execute([$delId]);
header("Location: events.php");
exit();
}
// Fetch events: members see all, public sees only is_public=1
if ($loggedIn) {
$stmt = $pdo->query("SELECT * FROM events WHERE event_date >= DATE('now') ORDER BY event_date ASC");
} else {
$stmt = $pdo->query("SELECT * FROM events WHERE is_public = 1 AND event_date >= DATE('now') ORDER BY event_date ASC");
}
$events = $stmt->fetchAll(PDO::FETCH_ASSOC);
// Split into featured (first) and side cards (next 2)
$featuredEvent = !empty($events) ? $events[0] : null;
$sideEvents = array_slice($events, 1, 2);
$remainingEvents = array_slice($events, 3);
function formatDay($dateStr) {
return date('d', strtotime($dateStr));
}
function formatMonth($dateStr) {
return date('M', strtotime($dateStr));
}
function formatTime($dateStr) {
return date('g:i A', strtotime($dateStr));
}
function formatFullDate($dateStr) {
return date('F j, Y', strtotime($dateStr));
}
?>
Events | Knights of Columbus Council 11908
DeQueen Council Heritage
Brotherhood & Service
add Add Event
Upcoming Events
No upcoming events scheduled.
Use the "Add Event" button to create one.
event
= formatDay($featuredEvent['event_date']) ?>
= formatMonth($featuredEvent['event_date']) ?>
delete
schedule
= htmlspecialchars(formatTime($featuredEvent['event_date'])) ?>
= $featuredEvent['end_time'] ? '— ' . htmlspecialchars($featuredEvent['end_time']) : '' ?>
location_on
= htmlspecialchars($featuredEvent['location']) ?>
Members Only
= htmlspecialchars($featuredEvent['title']) ?>
= nl2br(htmlspecialchars($featuredEvent['description'])) ?>
delete
= formatDay($ev['event_date']) ?>
= formatMonth($ev['event_date']) ?>
= htmlspecialchars($ev['category']) ?>
= htmlspecialchars($ev['title']) ?>
= htmlspecialchars($ev['description']) ?>
location_on
= htmlspecialchars($ev['location']) ?>
schedule
= htmlspecialchars(formatTime($ev['event_date'])) ?> — = htmlspecialchars($ev['end_time']) ?>
More events coming soon.
More Upcoming Events
= formatMonth($ev['event_date']) ?>
= formatDay($ev['event_date']) ?>
= htmlspecialchars($ev['title']) ?>
= htmlspecialchars(formatTime($ev['event_date'])) ?>
= $ev['location'] ? ' • ' . htmlspecialchars($ev['location']) : '' ?>
delete
Our Mission in Action
Building a community through shared service.
Our events aren't just dates on a calendar. They are opportunities to strengthen the bonds of brotherhood, serve our local parish, and support those in need throughout DeQueen.
close
Add New Event
= htmlspecialchars($formError) ?>
= htmlspecialchars($formSuccess) ?>
Knights of Columbus
© 2026 Knights of Columbus, DeQueen Council. All Rights Reserved.