prepare("DELETE FROM questions WHERE id = ?"); $stmt->execute([$_GET['id']]); $_SESSION['success'] = "Question deleted successfully"; header("Location: questions.php"); exit; } catch (PDOException $e) { error_log("Error deleting question: " . $e->getMessage()); $_SESSION['error'] = "Failed to delete question"; header("Location: questions.php"); exit; } } // Handle delete all questions for an exam if (isset($_GET['delete_all']) && isset($_GET['exam_id'])) { $exam_id = (int)$_GET['exam_id']; try { $stmt = $pdo->prepare("DELETE FROM questions WHERE exam_id = ?"); $stmt->execute([$exam_id]); $_SESSION['success'] = "All questions for this exam deleted successfully"; header("Location: questions.php"); exit; } catch (PDOException $e) { error_log("Error deleting all questions: " . $e->getMessage()); $_SESSION['error'] = "Failed to delete questions"; header("Location: questions.php"); exit; } } // Fetch all exams for filter $exams = []; try { $exams = $pdo->query("SELECT id, exam_name FROM exams ORDER BY exam_name")->fetchAll(); } catch (PDOException $e) { error_log("Error fetching exams: " . $e->getMessage()); } // Fetch all subjects for filter $subjects = []; try { $subjects = $pdo->query("SELECT id, name FROM subjects ORDER BY name")->fetchAll(); } catch (PDOException $e) { error_log("Error fetching subjects: " . $e->getMessage()); } // Initialize filter variables $examFilter = $_GET['exam_id'] ?? ''; $subjectFilter = $_GET['subject_id'] ?? ''; $questions = []; // Build base query $query = " SELECT q.*, s.name as subject_name, e.exam_name FROM questions q JOIN subjects s ON q.subject_id = s.id JOIN exams e ON q.exam_id = e.id WHERE 1=1 "; $params = []; // Apply filters if (!empty($examFilter)) { $query .= " AND q.exam_id = ?"; $params[] = $examFilter; } if (!empty($subjectFilter)) { $query .= " AND q.subject_id = ?"; $params[] = $subjectFilter; } $query .= " ORDER BY e.exam_name, s.name, q.question_number"; // Fetch filtered questions try { $stmt = $pdo->prepare($query); $stmt->execute($params); $questions = $stmt->fetchAll(); } catch (PDOException $e) { error_log("Error fetching questions: " . $e->getMessage()); $_SESSION['error'] = "Failed to load questions"; } // Get question counts by exam for the exam list $examCounts = []; try { $stmt = $pdo->query(" SELECT e.id, e.exam_name, COUNT(q.id) as question_count FROM exams e LEFT JOIN questions q ON e.id = q.exam_id GROUP BY e.id ORDER BY e.exam_name "); $examCounts = $stmt->fetchAll(PDO::FETCH_ASSOC); } catch (PDOException $e) { error_log("Error fetching exam counts: " . $e->getMessage()); } // Fetch admin username for the navbar $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()); } // Get counts for dashboard $stats = [ 'total_questions' => count($questions), 'total_subjects' => count($subjects), 'total_exams' => count($exams) ]; ?> Manage Questions - Exam Portal

Question Management

Add New Question

Total Questions

Subjects

Exams

question(s)

View Edit All Add More 0): ?> Delete All

Filter by Exam

Filter by Subject

Clear

#	Question	Exam	Subject	Options	Answer	Actions
No questions found. .