prepare("SELECT * FROM sliders WHERE status = 'active' ORDER BY sort_order ASC LIMIT 10"); $stmt->execute(); $sliders = $stmt->fetchAll(); // Get about content $stmt = $db->prepare("SELECT * FROM about_content WHERE status = 'active' ORDER BY sort_order ASC LIMIT 1"); $stmt->execute(); $about_content = $stmt->fetch(); // Get president message $stmt = $db->prepare("SELECT * FROM president_message WHERE status = 'active' LIMIT 1"); $stmt->execute(); $president_message = $stmt->fetch(); // Get objectives $stmt = $db->prepare("SELECT * FROM objectives WHERE status = 'active' ORDER BY sort_order ASC LIMIT 6"); $stmt->execute(); $objectives = $stmt->fetchAll(); // Get youtube videos $stmt = $db->prepare("SELECT * FROM youtube_videos WHERE status = 'active' ORDER BY created_at DESC LIMIT 6"); $stmt->execute(); $youtube_videos = $stmt->fetchAll(); // Get gallery images $stmt = $db->prepare("SELECT * FROM gallery WHERE status = 'active' ORDER BY created_at DESC LIMIT 6"); $stmt->execute(); $gallery_images = $stmt->fetchAll(); // Get testimonials $stmt = $db->prepare("SELECT * FROM testimonials WHERE status = 'active' ORDER BY created_at DESC LIMIT 6"); $stmt->execute(); $testimonials = $stmt->fetchAll(); // Get recent users with their specific designation $stmt = $db->prepare(" SELECT u.*, md.designation_hindi FROM users u LEFT JOIN membership_designations md ON u.membership_type = md.membership_type AND u.designation = md.designation WHERE u.status = 'approved' AND (md.status = 'active' OR md.status IS NULL) ORDER BY u.created_at DESC LIMIT 5 "); $stmt->execute(); $recent_users = $stmt->fetchAll(); // Get management team $stmt = $db->prepare("SELECT * FROM team_members WHERE member_type = 'management' AND status = 'active' ORDER BY sort_order ASC, created_at DESC LIMIT 5"); $stmt->execute(); $management_team = $stmt->fetchAll(); // Get recent activities $stmt = $db->prepare("SELECT * FROM recent_activities WHERE status = 'active' ORDER BY created_at DESC LIMIT 5"); $stmt->execute(); $recent_activities = $stmt->fetchAll(); // Get recent news $stmt = $db->prepare("SELECT * FROM news WHERE status = 'active' ORDER BY created_at DESC LIMIT 6"); $stmt->execute(); $news = $stmt->fetchAll(); // Get upcoming events $currentDate = date('Y-m-d'); $stmt = $db->prepare("SELECT * FROM events WHERE status = ? AND event_date >= ? ORDER BY event_date ASC, event_time ASC LIMIT 5"); $stmt->execute(['active', $currentDate]); $upcoming_events = $stmt->fetchAll(PDO::FETCH_ASSOC); include 'header.php'; include 'navbar.php'; ?>

$slider): ?>