prepare("SELECT * FROM applicants WHERE id = ?"); $stmt->execute([$student_id]); $student = $stmt->fetch(PDO::FETCH_ASSOC); if (!$student) { session_destroy(); header("Location: ../login.php"); exit(); } // Get student's class $class_id = $student['class_id']; // Get upcoming exams for the student's class $upcoming_exams = []; $stmt = $pdo->prepare("SELECT e.* FROM exams e JOIN exam_classes ec ON e.id = ec.exam_id WHERE ec.class_id = ? AND e.exam_date >= CURDATE() AND e.is_active = 1 ORDER BY e.exam_date ASC"); $stmt->execute([$class_id]); $upcoming_exams = $stmt->fetchAll(PDO::FETCH_ASSOC); // Get completed exams with results - FIXED VERSION $completed_exams = []; $stmt = $pdo->prepare("SELECT e.*, r.score, r.total_questions, r.completed_at FROM exams e JOIN exam_classes ec ON e.id = ec.exam_id JOIN cbt_results r ON e.id = r.subject_id WHERE ec.class_id = ? AND r.applicant_id = ? AND e.exam_date < CURDATE() ORDER BY e.exam_date DESC"); $stmt->execute([$class_id, $student_id]); $completed_exams = $stmt->fetchAll(PDO::FETCH_ASSOC); // Count total exams taken $total_exams_taken = count($completed_exams); // Calculate average score $average_score = 0; if ($total_exams_taken > 0) { $total_score = 0; foreach ($completed_exams as $exam) { $total_score += ($exam['score'] / $exam['total_questions']) * 100; } $average_score = round($total_score / $total_exams_taken, 2); } ?> Student Dashboard - CBT System
Profile Image

Edit Profile
Exams Taken
%
Average Score
Upcoming Exams
Student Information

Applicant ID:

Class:

Phone:

Date of Birth:

Gender:

Address:

Upcoming Exams

No upcoming exams scheduled.

  • Date:
  • Duration: minutes
  • Passing Score: %
View Details

Recent Exam Results

No exam results available.
= $exam['passing_score'] ? 'Passed' : 'Failed'; $status_class = $status === 'Passed' ? 'success' : 'danger'; ?>
Exam Name Date Taken Score Total Questions Percentage Status Action
% View Details