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 all subjects for the form
$subjects = [];
try {
$subjects = $pdo->query("SELECT id, name FROM subjects ORDER BY name")->fetchAll(PDO::FETCH_ASSOC);
} catch (PDOException $e) {
error_log("Error fetching subjects: " . $e->getMessage());
}
// Get next question number
$next_question_number = 1;
if (!empty($questions)) {
$stmt = $pdo->prepare("SELECT MAX(question_number) as max_number FROM questions WHERE exam_id = ?");
$stmt->execute([$exam_id]);
$max_number = $stmt->fetch(PDO::FETCH_ASSOC);
$next_question_number = $max_number['max_number'] + 1;
}
// Handle form submission
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
try {
$pdo->beginTransaction();
if (isset($_POST['update_questions'])) {
// Update existing questions
$updateStmt = $pdo->prepare("
UPDATE questions
SET question_text = ?, option_a = ?, option_b = ?, option_c = ?, option_d = ?,
correct_option = ?, marks = ?, subject_id = ?, question_number = ?
WHERE id = ?
");
foreach ($_POST['questions'] as $questionId => $questionData) {
if (is_numeric($questionId)) { // Only update existing questions (numeric IDs)
$updateStmt->execute([
$questionData['text'],
$questionData['options']['A'],
$questionData['options']['B'],
$questionData['options']['C'],
$questionData['options']['D'],
$questionData['correct_option'],
$questionData['marks'],
$questionData['subject_id'],
$questionData['question_number'],
$questionId
]);
}
}
}
if (isset($_POST['add_questions'])) {
// Add new questions
$insertStmt = $pdo->prepare("
INSERT INTO questions
(exam_id, subject_id, question_number, question_text, option_a, option_b, option_c, option_d, correct_option, marks, created_at)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, NOW())
");
$new_question_number = $next_question_number;
foreach ($_POST['new_questions'] as $newQuestionData) {
if (!empty($newQuestionData['text'])) {
$insertStmt->execute([
$exam_id,
$newQuestionData['subject_id'],
$new_question_number++,
$newQuestionData['text'],
$newQuestionData['options']['A'],
$newQuestionData['options']['B'],
$newQuestionData['options']['C'],
$newQuestionData['options']['D'],
$newQuestionData['correct_option'],
$newQuestionData['marks']
]);
}
}
}
$pdo->commit();
$success = "Questions updated successfully";
// Refresh questions
$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);
// Update next question number
$stmt = $pdo->prepare("SELECT MAX(question_number) as max_number FROM questions WHERE exam_id = ?");
$stmt->execute([$exam_id]);
$max_number = $stmt->fetch(PDO::FETCH_ASSOC);
$next_question_number = $max_number['max_number'] + 1;
} catch (PDOException $e) {
$pdo->rollBack();
error_log("Error updating questions: " . $e->getMessage());
$error = "Failed to update questions: " . $e->getMessage();
}
}
// 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());
}
?>
Edit Questions - <?= htmlspecialchars($exam['exam_name']) ?> - Exam Portal
New Question
Options