query("SELECT name FROM terms WHERE is_active = 1 LIMIT 1")->fetch_assoc(); $active_session_row = $conn->query("SELECT name FROM sessions WHERE is_active = 1 LIMIT 1")->fetch_assoc(); $activeTerm = $active_term_row ? $active_term_row['name'] : ''; $activeSession = $active_session_row ? $active_session_row['name'] : ''; /* ================= UPDATE ================= */ if(isset($_POST['update_question'])){ $id = (int)$_POST['id']; $class_id = (int)$_POST['class_id']; $subject_id = (int)$_POST['subject_id']; $term = $activeTerm; $session = $activeSession; $question = trim($_POST['question']); $a = trim($_POST['option_a'] ?? ''); $b = trim($_POST['option_b'] ?? ''); $c = trim($_POST['option_c'] ?? ''); $correct = trim($_POST['correct_option']?? ''); $type = trim($_POST['question_type'] ?? 'objective'); $instruction = trim($_POST['instruction'] ?? ''); $sample_answer = trim($_POST['sample_answer'] ?? ''); $stmt = $conn->prepare(" UPDATE questions SET question=?, option_a=?, option_b=?, option_c=?, correct_option=?, question_type=?, instruction=?, sample_answer=? WHERE id=? "); $stmt->bind_param("ssssssssi", $question, $a, $b, $c, $correct, $type, $instruction, $sample_answer, $id ); $stmt->execute(); /* ── cropped image ── */ if(!empty($_POST['cropped_image'])){ $imageData = $_POST['cropped_image']; $imageData = str_replace('data:image/jpeg;base64,', '', $imageData); $imageData = str_replace(' ', '+', $imageData); $imageBinary = base64_decode($imageData); if(!is_dir('uploads/questions')){ mkdir('uploads/questions', 0777, true); } $imgName = 'edit_' . $id . '_' . time() . '.jpg'; $fullPath = 'uploads/questions/' . $imgName; file_put_contents($fullPath, $imageBinary); $check = $conn->prepare("SELECT id FROM question_images WHERE question_id=?"); $check->bind_param("i", $id); $check->execute(); if(stmt_get_result($check)->num_rows > 0){ $up = $conn->prepare("UPDATE question_images SET image_name=? WHERE question_id=?"); $up->bind_param("si", $imgName, $id); $up->execute(); } else { $ins = $conn->prepare("INSERT INTO question_images(question_id,image_name) VALUES(?,?)"); $ins->bind_param("is", $id, $imgName); $ins->execute(); } /* also update questions.question_image column if it exists */ $conn->query("UPDATE questions SET question_image='$imgName' WHERE id=$id"); } header("Location: edit_questions.php?class_id=$class_id&subject_id=$subject_id&updated=1"); exit; } /* ================= DELETE ================= */ if(isset($_POST['delete_question'])){ $id = (int)$_POST['id']; $class_id = (int)$_POST['class_id']; $subject_id = (int)$_POST['subject_id']; $d = $conn->prepare("DELETE FROM questions WHERE id=?"); $d->bind_param("i",$id); $d->execute(); header("Location: edit_questions.php?class_id=$class_id&subject_id=$subject_id&deleted=1"); exit; } /* ================= DELETE IMAGE ================= */ if(isset($_POST['action']) && $_POST['action'] === 'delete_img'){ $id = (int)$_POST['id']; $class_id = (int)$_POST['class_id']; $subject_id = (int)$_POST['subject_id']; // get image name $r = $conn->prepare("SELECT image_name FROM question_images WHERE question_id=? LIMIT 1"); $r->bind_param("i", $id); $r->execute(); $imgRow = stmt_get_result($r)->fetch_assoc(); if($imgRow && !empty($imgRow['image_name'])){ $filePath = 'uploads/questions/' . $imgRow['image_name']; if(file_exists($filePath)) unlink($filePath); } $di = $conn->prepare("DELETE FROM question_images WHERE question_id=?"); $di->bind_param("i",$id); $di->execute(); $conn->query("UPDATE questions SET question_image='' WHERE id=$id"); header("Location: edit_questions.php?class_id=$class_id&subject_id=$subject_id&img_deleted=1"); exit; } include "header.php"; /* ================= LISTS ================= */ $classes = $conn->query("SELECT * FROM classes ORDER BY class_name ASC"); $subjects = $conn->query("SELECT * FROM subjects ORDER BY subject_name ASC"); /* ================= FILTER ================= */ $class_id = $_GET['class_id'] ?? ''; $subject_id = $_GET['subject_id'] ?? ''; $viewMode = !empty($class_id) && !empty($subject_id) && !empty($activeTerm) && !empty($activeSession); /* ================= QUESTIONS ================= */ $questions = []; if($viewMode){ $stmt = $conn->prepare(" SELECT q.*, c.class_name, s.subject_name, qi.image_name FROM questions q LEFT JOIN classes c ON q.class_id = c.id LEFT JOIN subjects s ON q.subject_id = s.id LEFT JOIN question_images qi ON qi.question_id = q.id AND qi.id = (SELECT MAX(id) FROM question_images WHERE question_id = q.id) WHERE q.class_id=? AND q.subject_id=? AND q.term=? AND q.session=? ORDER BY q.id ASC "); $stmt->bind_param("iiss", $class_id, $subject_id, $activeTerm, $activeSession); $stmt->execute(); $res = stmt_get_result($stmt); while($row = $res->fetch_assoc()){ $questions[] = $row; } } ?> Edit Questions

Edit Examination Questions

Albayan Academy Shendam

📅 Term:  •  🗓️ Session:
⚠️ No active term or session set. Please update in Settings.
question(s) found ← Change Class/Subject
No questions found for the selected class and subject.
Question
120 ? substr($q['question'], 0, 117) . '...' : $q['question']) ?>
A. B. C.
Type:
✏️ Tap to edit