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; } } // Fetch all questions with subject names $questions = []; try { $questions = $pdo->query(" SELECT q.*, s.name as subject_name FROM questions q JOIN subjects s ON q.subject_id = s.id ORDER BY s.name, q.question_number ")->fetchAll(); } catch (PDOException $e) { error_log("Error fetching questions: " . $e->getMessage()); $_SESSION['error'] = "Failed to load questions"; } // 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()); } // Filter questions by subject if requested if (isset($_GET['subject_id']) && !empty($_GET['subject_id'])) { $subjectId = $_GET['subject_id']; 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.subject_id = ? ORDER BY q.question_number "); $stmt->execute([$subjectId]); $questions = $stmt->fetchAll(); } catch (PDOException $e) { error_log("Error filtering questions: " . $e->getMessage()); $_SESSION['error'] = "Failed to filter questions"; } } // 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) ]; ?> Manage Questions - Verbum Dei Academy & College Entrance Exam Portal

Manage Questions

Add New Question
Total Questions

Subjects Available

Clear
# Question Subject Options Answer Actions
No questions found. .
Question Management Tips
  • Questions are organized by subject and question number
  • Use the filter to view questions for a specific subject
  • Add questions systematically to maintain proper numbering
  • Edit questions to update content or correct answers
  • Export questions to backup or share with other educators