prepare("SELECT * FROM exams WHERE id = ?"); $stmt->execute([$exam_id]); $exam = $stmt->fetch(PDO::FETCH_ASSOC); if (!$exam) { die("Exam not found"); } } catch (PDOException $e) { error_log("Error fetching exam: " . $e->getMessage()); die("Failed to load exam details"); } // Fetch all questions for this exam with subject names $questions = []; try { $stmt = $pdo->prepare(" SELECT q.*, s.name as subject_name FROM questions q JOIN subjects s ON q.subject_id = s.id WHERE q.exam_id = ? ORDER BY s.name, q.question_number "); $stmt->execute([$exam_id]); $questions = $stmt->fetchAll(PDO::FETCH_ASSOC); } catch (PDOException $e) { error_log("Error fetching questions: " . $e->getMessage()); die("Failed to load questions"); } // Fetch admin username $admin_name = 'Admin'; try { $stmt = $pdo->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()); } ?> View Questions - <?= htmlspecialchars($exam['exam_name']) ?> - Exam Portal

Date: | Duration: minutes | Questions:

No questions found for this exam

Questions will appear here once they are added to the exam.

$subjectQuestions): ?>

questions

$question): ?>
Q
mark(s)
>