query("SELECT COUNT(*) as total FROM sliders")->fetch_assoc()['total'] ?? 0;
$gallery_count = $conn->query("SELECT COUNT(*) as total FROM gallery")->fetch_assoc()['total'] ?? 0;
$board_count = $conn->query("SELECT COUNT(*) as total FROM board_members")->fetch_assoc()['total'] ?? 0;
$events_count = $conn->query("SELECT COUNT(*) as total FROM event_gallery")->fetch_assoc()['total'] ?? 0;
$schools_count = $conn->query("SELECT COUNT(*) as total FROM our_schools")->fetch_assoc()['total'] ?? 0;
$sites_count = $conn->query("SELECT COUNT(*) as total FROM important_sites")->fetch_assoc()['total'] ?? 0;
$pending_leaves = $conn->query("SELECT COUNT(*) as c FROM leave_applications WHERE status = 'Pending'")->fetch_assoc()['c'] ?? 0;
$total_leaves = $conn->query("SELECT COUNT(*) as c FROM leave_applications")->fetch_assoc()['c'] ?? 0;
?>
Admin Dashboard | BS Public School