prepare("SELECT full_name FROM applicants WHERE id = ?"); $stmt->execute([$student_id]); $student = $stmt->fetch(PDO::FETCH_ASSOC); if ($student) { $student_name = $student['full_name']; } } catch (PDOException $e) { error_log("Error fetching student: " . $e->getMessage()); header("Location: student_dashboard.php?error=db_error"); exit; } // Fetch exam details and verify access $exam = []; $questions_by_subject = []; $time_remaining = 0; $exam_started = false; try { // Verify exam access and get details $stmt = $pdo->prepare(" SELECT e.*, ec.class_id FROM exams e JOIN exam_classes ec ON e.id = ec.exam_id JOIN applicants a ON ec.class_id = a.class_id WHERE e.id = ? AND a.id = ? AND e.is_active = 1 AND (e.exam_date = CURDATE() OR e.exam_date < CURDATE()) "); $stmt->execute([$exam_id, $student_id]); $exam = $stmt->fetch(PDO::FETCH_ASSOC); if (!$exam) { throw new Exception("You are not authorized to take this exam or it's not available"); } // Check for existing exam session $stmt = $pdo->prepare(" SELECT * FROM student_exams WHERE exam_id = ? AND student_id = ? "); $stmt->execute([$exam_id, $student_id]); $exam_session = $stmt->fetch(PDO::FETCH_ASSOC); if (!$exam_session) { // Start new exam session $time_remaining = $exam['duration_minutes'] * 60; $start_time = date('Y-m-d H:i:s'); $stmt = $pdo->prepare(" INSERT INTO student_exams (student_id, exam_id, start_time, time_remaining, status) VALUES (?, ?, ?, ?, 'in_progress') "); $stmt->execute([$student_id, $exam_id, $start_time, $time_remaining]); } else { // Resume existing session if ($exam_session['status'] == 'completed') { header("Location: results.php?exam_id=" . $exam_id); exit; } $time_remaining = $exam_session['time_remaining']; $exam_started = true; } // Fetch questions grouped by subject $stmt = $pdo->prepare(" SELECT q.*, s.name as subject_name, s.id as subject_id FROM questions q JOIN subjects s ON q.subject_id = s.id WHERE q.exam_id = ? ORDER BY s.id, q.question_number "); $stmt->execute([$exam_id]); $all_questions = $stmt->fetchAll(PDO::FETCH_ASSOC); if (empty($all_questions)) { throw new Exception("No questions found for this exam"); } // Group questions by subject $questions_by_subject = []; foreach ($all_questions as $q) { $subject_id = $q['subject_id']; if (!isset($questions_by_subject[$subject_id])) { $questions_by_subject[$subject_id] = [ 'subject_name' => $q['subject_name'], 'questions' => [] ]; } $questions_by_subject[$subject_id]['questions'][] = $q; } // Get list of subject IDs in order $subject_ids = array_keys($questions_by_subject); // Get current subject and question index $current_subject_id = isset($_GET['subject_id']) ? (int)$_GET['subject_id'] : (isset($_SESSION['current_subject_id']) ? (int)$_SESSION['current_subject_id'] : $subject_ids[0]); $current_question_index = isset($_GET['question']) ? max(0, (int)$_GET['question'] - 1) : (isset($_SESSION['current_question_index']) ? (int)$_SESSION['current_question_index'] : 0); // Validate current subject if (!in_array($current_subject_id, $subject_ids)) { $current_subject_id = $subject_ids[0]; $current_question_index = 0; } // Get current subject and questions $current_subject = $questions_by_subject[$current_subject_id]; $questions = $current_subject['questions']; $total_questions = count($questions); $current_subject_index = array_search($current_subject_id, $subject_ids); $total_subjects = count($subject_ids); // Validate current question index $current_question_index = max(0, min($current_question_index, $total_questions - 1)); $_SESSION['current_subject_id'] = $current_subject_id; $_SESSION['current_question_index'] = $current_question_index; // Get current question data $current_q = $questions[$current_question_index]; // Check for existing answer $stmt = $pdo->prepare(" SELECT answer FROM student_answers WHERE student_id = ? AND exam_id = ? AND question_id = ? "); $stmt->execute([$student_id, $exam_id, $current_q['id']]); $existing_answer = $stmt->fetchColumn(); } catch (Exception $e) { error_log("Exam Error: " . $e->getMessage()); header("Location: student_dashboard.php?error=" . urlencode($e->getMessage())); exit; } // Handle answer submission via AJAX if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['action'])) { header('Content-Type: application/json'); try { $question_id = (int)$_POST['question_id']; $answer = isset($_POST['answer']) ? strtoupper(trim($_POST['answer'])) : null; if ($answer && !in_array($answer, ['A', 'B', 'C', 'D'])) { throw new Exception("Invalid answer"); } // Save answer $stmt = $pdo->prepare(" INSERT INTO student_answers (student_id, exam_id, question_id, answer, created_at, updated_at) VALUES (?, ?, ?, ?, NOW(), NOW()) ON DUPLICATE KEY UPDATE answer = VALUES(answer), updated_at = NOW() "); $stmt->execute([$student_id, $exam_id, $question_id, $answer]); // Update exam session timestamp $stmt = $pdo->prepare(" UPDATE student_exams SET updated_at = NOW() WHERE student_id = ? AND exam_id = ? "); $stmt->execute([$student_id, $exam_id]); echo json_encode(['status' => 'success']); exit; } catch (Exception $e) { error_log("Answer Save Error: " . $e->getMessage()); echo json_encode(['status' => 'error', 'message' => $e->getMessage()]); exit; } } ?> Take Exam - <?= htmlspecialchars($exam['exam_name']) ?> - <?= htmlspecialchars($current_subject['subject_name']) ?> - Verbum Dei Academy

-

• Duration: minutes

Question of () % Complete
Question
$current_q['option_a'], 'B' => $current_q['option_b'], 'C' => $current_q['option_c'], 'D' => $current_q['option_d'] ]; foreach ($options as $letter => $text): if (!empty(trim($text))): ?>
>

Time Remaining

Hours:Minutes:Seconds
Question Navigator ()
prepare(" SELECT 1 FROM student_answers WHERE student_id = ? AND exam_id = ? AND question_id = ? "); $stmt->execute([$student_id, $exam_id, $questions[$i]['id']]); $is_answered = $stmt->fetch(); ?>
Current Question Answered Not Answered