prepare("SELECT id, name FROM groups WHERE slug = ?"); $stmt->execute([$groupSlug]); $group = $stmt->fetch(PDO::FETCH_ASSOC); if (!$group) { die("Group not found."); } /* =============================== MONTH / YEAR SETUP ================================ */ $month = isset($_GET['month']) ? (int)$_GET['month'] : (int)date('m'); $year = isset($_GET['year']) ? (int)$_GET['year'] : (int)date('Y'); if ($month < 1) { $month = 12; $year--; } if ($month > 12) { $month = 1; $year++; } $prevMonth = $month - 1; $prevYear = $year; if ($prevMonth < 1) { $prevMonth = 12; $prevYear--; } $nextMonth = $month + 1; $nextYear = $year; if ($nextMonth > 12) { $nextMonth = 1; $nextYear++; } /* Calendar math */ $firstDayTimestamp = strtotime("$year-$month-01"); $daysInMonth = date('t', $firstDayTimestamp); $startDay = date('w', $firstDayTimestamp); /* =============================== GROUP EVENT COUNTS ================================ */ $stmt = $pdo->prepare(" SELECT event_date, COUNT(*) AS total FROM events WHERE group_id = ? AND MONTH(event_date) = ? AND YEAR(event_date) = ? GROUP BY event_date "); $stmt->execute([$group['id'], $month, $year]); $eventCounts = $stmt->fetchAll(PDO::FETCH_KEY_PAIR); /* =============================== RETURN URL ================================ */ $currentUrl = $_SERVER['REQUEST_URI']; ?> <?= htmlspecialchars($group['name']) ?> Calendar
Calendar
← Prev
Next →
"; } /* Days */ while ($day <= $daysInMonth) { $date = sprintf('%04d-%02d-%02d', $year, $month, $day); $count = $eventCounts[$date] ?? 0; $classes = []; if ($count > 0) $classes[] = 'has-event'; if ($date === date('Y-m-d')) $classes[] = 'today'; //$eventUrl = "../events.php?date=$date&return=" . urlencode($currentUrl); $eventUrl = "/cathedral-portal/events.php?date=$date&return=" . urlencode($currentUrl); echo ""; if ((($day + $startDay) % 7) == 0) { echo ""; } $day++; } ?>
SunMonTue WedThuFriSat
$day"; if ($count == 1) { echo ""; } elseif ($count > 1) { echo "$count"; } echo "