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()); } // Get filter parameters $exam_id = isset($_GET['exam_id']) ? intval($_GET['exam_id']) : 0; $class_id = isset($_GET['class_id']) ? intval($_GET['class_id']) : 0; $student_id = isset($_GET['student_id']) ? intval($_GET['student_id']) : 0; // Initialize results data $results = []; $exams = []; $students = []; $classes = []; try { // Fetch all exams for filter dropdown $exams = $pdo->query("SELECT id, exam_name FROM exams ORDER BY exam_date DESC")->fetchAll(PDO::FETCH_ASSOC); // Fetch all classes for filter dropdown $classes = $pdo->query("SELECT id, class_name FROM classes ORDER BY class_name")->fetchAll(PDO::FETCH_ASSOC); // Build query based on filter parameters $query = " SELECT r.id, r.exam_id, e.exam_name, r.student_id, a.full_name as student_name, a.class_id, c.class_name, r.subject_id, s.name as subject_name, r.score, r.total_questions, ROUND((r.score / r.total_questions) * 100, 2) as percentage, r.completed_at FROM cbt_results r JOIN exams e ON r.exam_id = e.id JOIN applicants a ON r.student_id = a.id LEFT JOIN classes c ON a.class_id = c.id JOIN subjects s ON r.subject_id = s.id "; $conditions = []; $params = []; if ($exam_id > 0) { $conditions[] = "r.exam_id = ?"; $params[] = $exam_id; } if ($class_id > 0) { $conditions[] = "a.class_id = ?"; $params[] = $class_id; } if ($student_id > 0) { $conditions[] = "r.student_id = ?"; $params[] = $student_id; } if (!empty($conditions)) { $query .= " WHERE " . implode(" AND ", $conditions); } $query .= " ORDER BY r.completed_at DESC"; $stmt = $pdo->prepare($query); $stmt->execute($params); $results = $stmt->fetchAll(PDO::FETCH_ASSOC); } catch (PDOException $e) { error_log("Error fetching results: " . $e->getMessage()); $error_message = "Error loading results. Please try again later."; } // Calculate statistics $total_results = count($results); $average_score = 0; $highest_score = 0; $lowest_score = 100; if ($total_results > 0) { $scores = array_column($results, 'percentage'); $average_score = round(array_sum($scores) / $total_results, 2); $highest_score = round(max($scores), 2); $lowest_score = round(min($scores), 2); } ?> View Results - Verbum Dei Academy & Verbum Dei Int'l College

Examination Results

View and analyze CBT exam results

Back to Dashboard

Total Results

Examination records

Average Score

%

Across all results

Highest Score

%

Best performance

Lowest Score

%

Needs improvement

Filter Results

Select Exam

Select Class

Student ID (Optional)

Reset