Access Denied. You do not have permission."); } $exam_id = isset($_GET['id']) ? (int)$_GET['id'] : 0; $stmt = $pdo->prepare("SELECT * FROM exams WHERE id = ?"); $stmt->execute([$exam_id]); $exam = $stmt->fetch(); if (!$exam) { die("Exam not found!"); } $tab = isset($_GET['tab']) ? $_GET['tab'] : 'settings'; if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['save_settings'])) { $title = trim($_POST['title']); $live_start_date = !empty($_POST['live_start_date']) ? $_POST['live_start_date'] : null; $live_end_date = !empty($_POST['live_end_date']) ? $_POST['live_end_date'] : null; $practice_date = !empty($_POST['practice_date']) ? $_POST['practice_date'] : null; $duration = (int)$_POST['duration']; $max_attempts = (int)$_POST['max_attempts']; $negative_marks = (float)$_POST['negative_marks']; $passcode = trim($_POST['exam_passcode']); $exam_type = $_POST['exam_type'] ?? 'live'; $stmt = $pdo->prepare("UPDATE exams SET title = ?, live_start_date = ?, live_end_date = ?, duration = ?, max_attempts = ?, negative_marks = ?, passcode = ?, practice_date = ?, exam_type = ? WHERE id = ?"); $stmt->execute([$title, $live_start_date, $live_end_date, $duration, $max_attempts, $negative_marks, $passcode, $practice_date, $exam_type, $exam_id]); header("Location: admin_edit_exam.php?id=$exam_id&tab=settings&msg=saved"); exit; } if (isset($_GET['delete_q'])) { $del = (int)$_GET['delete_q']; $pdo->prepare("DELETE FROM questions WHERE id = ? AND exam_id = ?")->execute([$del, $exam_id]); header("Location: admin_edit_exam.php?id=$exam_id&tab=questions&msg=q_deleted"); exit; } if (isset($_GET['copy_q'])) { $cpy = (int)$_GET['copy_q']; $st = $pdo->prepare("SELECT * FROM questions WHERE id = ? AND exam_id = ?"); $st->execute([$cpy, $exam_id]); $q_to_copy = $st->fetch(PDO::FETCH_ASSOC); if ($q_to_copy) { $_SESSION['copied_question'] = $q_to_copy; header("Location: admin_edit_exam.php?id=$exam_id&tab=questions&msg=q_copied"); exit; } } if (isset($_GET['paste_q'])) { if (isset($_SESSION['copied_question'])) { $q = $_SESSION['copied_question']; $stmt = $pdo->prepare("INSERT INTO questions (exam_id, question_text, image_url, opt_a, opt_b, opt_c, opt_d, correct_opt, explanation, explanation_image_url, mark) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"); $stmt->execute([$exam_id, $q['question_text'], $q['image_url'], $q['opt_a'], $q['opt_b'], $q['opt_c'], $q['opt_d'], $q['correct_opt'], $q['explanation'], $q['explanation_image_url'] ?? null, $q['mark']]); header("Location: admin_edit_exam.php?id=$exam_id&tab=questions&msg=q_pasted"); exit; } } if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['add_question'])) { $qt = trim($_POST['question_text']); $optA = trim($_POST['opt_a']); $optB = trim($_POST['opt_b']); $optC = trim($_POST['opt_c']); $optD = trim($_POST['opt_d']); $correct = $_POST['correct']; $explanation = trim($_POST['explanation']); $image_url = null; $upload_dir = 'uploads/questions/'; if (!is_dir($upload_dir)) mkdir($upload_dir, 0777, true); if (isset($_FILES['question_image']) && $_FILES['question_image']['error'] == 0) { $file_ext = pathinfo($_FILES['question_image']['name'], PATHINFO_EXTENSION); $file_name = time() . '_' . rand(100, 999) . '.' . $file_ext; move_uploaded_file($_FILES['question_image']['tmp_name'], $upload_dir . $file_name); $image_url = $upload_dir . $file_name; } $expl_image_url = null; if (isset($_FILES['explanation_image']) && $_FILES['explanation_image']['error'] == 0) { $file_ext = pathinfo($_FILES['explanation_image']['name'], PATHINFO_EXTENSION); $file_name = 'expl_' . time() . '_' . rand(100, 999) . '.' . $file_ext; move_uploaded_file($_FILES['explanation_image']['tmp_name'], $upload_dir . $file_name); $expl_image_url = $upload_dir . $file_name; } $stmt = $pdo->prepare("INSERT INTO questions (exam_id, question_text, image_url, opt_a, opt_b, opt_c, opt_d, correct_opt, explanation, explanation_image_url, mark) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"); $stmt->execute([$exam_id, $qt, $image_url, $optA, $optB, $optC, $optD, $correct, $explanation, $expl_image_url, $exam['per_question_mark'] ?? 1.0]); header("Location: admin_edit_exam.php?id=$exam_id&tab=questions&msg=q_added"); exit; } if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['edit_question'])) { $q_id = (int)$_POST['question_id']; $qt = trim($_POST['question_text']); $optA = trim($_POST['opt_a']); $optB = trim($_POST['opt_b']); $optC = trim($_POST['opt_c']); $optD = trim($_POST['opt_d']); $correct = $_POST['correct']; $explanation = trim($_POST['explanation']); $upload_dir = 'uploads/questions/'; if (!is_dir($upload_dir)) mkdir($upload_dir, 0777, true); $update_fields = ["question_text = ?", "opt_a = ?", "opt_b = ?", "opt_c = ?", "opt_d = ?", "correct_opt = ?", "explanation = ?"]; $params = [$qt, $optA, $optB, $optC, $optD, $correct, $explanation]; if (isset($_FILES['question_image']) && $_FILES['question_image']['error'] == 0) { $file_ext = pathinfo($_FILES['question_image']['name'], PATHINFO_EXTENSION); $file_name = time() . '_' . rand(100, 999) . '.' . $file_ext; move_uploaded_file($_FILES['question_image']['tmp_name'], $upload_dir . $file_name); $update_fields[] = "image_url = ?"; $params[] = $upload_dir . $file_name; } if (isset($_FILES['explanation_image']) && $_FILES['explanation_image']['error'] == 0) { $file_ext = pathinfo($_FILES['explanation_image']['name'], PATHINFO_EXTENSION); $file_name = 'expl_' . time() . '_' . rand(100, 999) . '.' . $file_ext; move_uploaded_file($_FILES['explanation_image']['tmp_name'], $upload_dir . $file_name); $update_fields[] = "explanation_image_url = ?"; $params[] = $upload_dir . $file_name; } $params[] = $q_id; $params[] = $exam_id; $stmt = $pdo->prepare("UPDATE questions SET " . implode(', ', $update_fields) . " WHERE id = ? AND exam_id = ?"); $stmt->execute($params); header("Location: admin_edit_exam.php?id=$exam_id&tab=questions&msg=q_updated"); exit; } $q_stmt = $pdo->prepare("SELECT * FROM questions WHERE exam_id = ?"); $q_stmt->execute([$exam_id]); $questions = $q_stmt->fetchAll(); ?> Edit Exam - <?php echo htmlspecialchars($exam['title']); ?>
ADMIN
EDIT EXAM:
Settings updated successfully!
Question added successfully! You can add another one below.
Question copied to clipboard! You can paste it into this or another exam.
Question pasted successfully!
Question updated successfully!
When practice mode opens (or live exam transitions to practice)
prepare("SELECT * FROM questions WHERE id = ? AND exam_id = ?"); $st->execute([(int)$_GET['edit_q_id'], $exam_id]); $edit_q = $st->fetch(PDO::FETCH_ASSOC); } ?>
CANCEL EDIT
Images can be resized by clicking on them!
Single line option text
required> A.
> B.
> C.
> D.
$q): ?>
Q.
No questions added yet.
window.location='admin_results.php?exam_id=$exam_id';"; ?>