prepare("SELECT full_name, class_id, status, image_path FROM applicants WHERE id = ?"); $stmt->execute([$_SESSION['user_id']]); $student = $stmt->fetch(PDO::FETCH_ASSOC); if ($student) { $student_name = $student['full_name']; $student_status = ucfirst($student['status']); $student_photo = $student['image_path']; // Get class name if assigned if ($student['class_id']) { $stmt = $pdo->prepare("SELECT class_name FROM classes WHERE id = ?"); $stmt->execute([$student['class_id']]); $class = $stmt->fetch(PDO::FETCH_ASSOC); if ($class) { $student_class = $class['class_name']; } } } } catch (PDOException $e) { error_log("Error fetching student details: " . $e->getMessage()); } // Get active exams and results $active_exams = []; $exam_results = []; $upcoming_exams = []; try { // Get active exams for student's class if (!empty($student['class_id'])) { // Get exams assigned to student's class that are active $stmt = $pdo->prepare(" SELECT e.id, e.exam_name, e.exam_date, e.duration_minutes, GROUP_CONCAT(DISTINCT s.name SEPARATOR ', ') as subjects FROM exams e JOIN exam_classes ec ON e.id = ec.exam_id JOIN exam_subjects es ON e.id = es.exam_id JOIN subjects s ON es.subject_id = s.id WHERE ec.class_id = ? AND e.is_active = 1 AND e.exam_date >= CURDATE() GROUP BY e.id ORDER BY e.exam_date ASC "); $stmt->execute([$student['class_id']]); $active_exams = $stmt->fetchAll(PDO::FETCH_ASSOC); // Get upcoming exams (next 7 days) $stmt = $pdo->prepare(" SELECT e.id, e.exam_name, e.exam_date, e.duration_minutes FROM exams e JOIN exam_classes ec ON e.id = ec.exam_id WHERE ec.class_id = ? AND e.is_active = 1 AND e.exam_date BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 7 DAY) ORDER BY e.exam_date ASC "); $stmt->execute([$student['class_id']]); $upcoming_exams = $stmt->fetchAll(PDO::FETCH_ASSOC); } // Get exam results (limit to 3 most recent) $stmt = $pdo->prepare(" SELECT r.id, r.exam_id, e.exam_name, r.subject_id, s.name as subject_name, r.score, r.total_questions, r.completed_at FROM cbt_results r JOIN exams e ON r.exam_id = e.id JOIN subjects s ON r.subject_id = s.id WHERE r.student_id = ? ORDER BY r.completed_at DESC LIMIT 3 "); $stmt->execute([$_SESSION['user_id']]); $exam_results = $stmt->fetchAll(PDO::FETCH_ASSOC); // Check if student has any exams in progress $stmt = $pdo->prepare(" SELECT exam_id, time_remaining, status FROM student_exams WHERE student_id = ? AND status = 'in_progress' LIMIT 1 "); $stmt->execute([$_SESSION['user_id']]); $in_progress_exam = $stmt->fetch(PDO::FETCH_ASSOC); } catch (PDOException $e) { error_log("Error fetching exam data: " . $e->getMessage()); $error_message = "Error loading exam information. Please try again later."; } ?> Student Dashboard - Verbum Dei Academy & College

Student Dashboard

Welcome to your examination portal

You have an exam in progress. Would you like to continue?

Continue Exam

Available Exams

View all exams

Completed Exams

View results

Upcoming Exams

View schedule

Your Status

View profile

Available Examinations

There are currently no examinations available for your class.

Available

h m

Subjects:

View Details

Recent Results

You haven't completed any exams yet.

Exam	Subject	Score	Date

View All Results

Upcoming Examinations

No upcoming examinations scheduled.

· h m

Upcoming

View Full Schedule

Your Profile

Status:

Edit Profile

Recent Activity

Logged in to the system

Today at

Completed exam

New exam available:

Recently added

View All Activity