prepare($sql . " AND category = ? ORDER BY created_at DESC"); $stmt->execute([$active_category]); } else { $stmt = $pdo->query($sql . " ORDER BY created_at DESC"); } $videos = $stmt->fetchAll(PDO::FETCH_ASSOC); // Get categories with counts $categories = $pdo->query("SELECT category, COUNT(*) as count FROM video_gallery WHERE status='active' GROUP BY category ORDER BY category")->fetchAll(PDO::FETCH_ASSOC); // Get total active videos count $total_active = $pdo->query("SELECT COUNT(*) FROM video_gallery WHERE status='active'")->fetchColumn(); // Get featured videos $featured_stmt = $pdo->query("SELECT * FROM video_gallery WHERE status='active' AND featured=1 ORDER BY created_at DESC LIMIT 3"); $featured_videos = $featured_stmt->fetchAll(PDO::FETCH_ASSOC); $page_title = ($active_category != 'all') ? htmlspecialchars($active_category) . " Videos" : "Video Gallery"; } catch (Exception $e) { $videos = []; $categories = []; $total_active = 0; $featured_videos = []; $page_title = "Video Gallery"; } ?> <?php echo $page_title; ?> - WebixSchool
Video Gallery

Explore Our Video Collection

Watch educational content, campus events, student activities, and more

+
Total Videos
Categories
Featured
All Videos 'fa-book-open', 'Events' => 'fa-calendar-star', 'Tutorial' => 'fa-chalkboard-teacher', 'Career' => 'fa-briefcase', 'Sports' => 'fa-running', 'Cultural' => 'fa-music', 'General' => 'fa-video' ]; $icon = $icons[$cat['category']] ?? 'fa-folder'; ?>

Featured Videos

Handpicked content for you

<?php echo htmlspecialchars($video['title']); ?>
Featured

Videos All Videos

video available

<?php echo htmlspecialchars($video['title']); ?>
Featured

views

No Videos Found

No videos available in this category yet. Check back later!

View All Videos