prepare("SELECT id, title, description, image, activity_date, created_at FROM recent_activities WHERE id = ? AND status = 'active'");
$stmt->execute([$id]);
$activity = $stmt->fetch(PDO::FETCH_ASSOC);
if (!$activity) {
header("Location: index.php");
exit;
}
// Sanitize activity data
$activity['title'] = htmlspecialchars($activity['title']);
$activity['description'] = htmlspecialchars($activity['description'] ?? 'कोई विवरण उपलब्ध नहीं।');
// Fetch recent activities for sidebar (limit to 5, exclude current)
$stmt = $db->prepare("SELECT id, title, image, activity_date FROM recent_activities WHERE status = 'active' AND id != ? ORDER BY activity_date DESC LIMIT 5");
$stmt->execute([$id]);
$recentActivities = $stmt->fetchAll(PDO::FETCH_ASSOC);
foreach ($recentActivities as &$act) {
$act['title'] = htmlspecialchars($act['title']);
}
include 'header.php';
include 'navbar.php';
?>
![<?php echo $activity['title']; ?>](<?php echo SITE_URL . '/img/activities/' . htmlspecialchars($activity['image']); ?>)
![<?php echo $act['title']; ?>](<?php echo SITE_URL . '/img/activities/' . htmlspecialchars($act['image']); ?>)