prepare("SELECT username FROM admins WHERE id = ?"); $stmt->execute([$_SESSION['user_id']]); $admin = $stmt->fetch(PDO::FETCH_ASSOC); if ($admin) { $admin_name = $admin['username']; } } catch (PDOException $e) { error_log("Error fetching admin username: " . $e->getMessage()); } // Initialize variables with fallback values $stats = [ 'total_applicants' => 'N/A', 'active_cbts' => 'N/A', 'pending_applications' => 'N/A', 'total_classes' => 'N/A', 'total_questions' => 'N/A', 'total_subjects' => 'N/A' ]; try { $stats['total_applicants'] = $pdo->query("SELECT COUNT(*) FROM applicants")->fetchColumn(); $stats['active_cbts'] = $pdo->query("SELECT COUNT(*) FROM subjects WHERE status = 'active'")->fetchColumn(); $stats['pending_applications'] = $pdo->query("SELECT COUNT(*) FROM applicants WHERE status = 'pending'")->fetchColumn(); $stats['total_classes'] = $pdo->query("SELECT COUNT(*) FROM classes")->fetchColumn(); $stats['total_questions'] = $pdo->query("SELECT COUNT(*) FROM questions")->fetchColumn(); $stats['total_subjects'] = $pdo->query("SELECT COUNT(*) FROM subjects")->fetchColumn(); } catch (PDOException $e) { error_log("Database error in admin_dashboard.php: " . $e->getMessage()); $error_message = "Database error. Check logs for details."; } ?> Admin Dashboard - Verbum Dei Academy & Verbum Dei Int'l College

Admin Dashboard

Overview of Verbum Dei Academy & Verbum Dei Int'l College

Total Applicants

View all applicants
Active CBT SUBJECTS

Manage CBTs
Pending Applications

Review applications
Total Classes

Manage classes

Quick Actions

Register Applicant

Add new applicant to the system

Register
Manage Subjects

Add, edit or remove subjects

Manage
Manage Questions

Add or edit exam questions

Manage
View Results

Check CBT exam results

View

System Management

Manage Classes

Create and manage classes
System Settings

Configure system preferences
Reports & Analytics

View system reports

Recent Activity

New Applicant Registered
2 minutes ago
New Subject Added
15 minutes ago
10 New Questions Added
1 hour ago