query("SELECT id, name FROM subjects ORDER BY name")->fetchAll(PDO::FETCH_ASSOC); $classes = $pdo->query("SELECT id, class_name FROM classes ORDER BY class_name")->fetchAll(PDO::FETCH_ASSOC); } catch (PDOException $e) { error_log("Error fetching data: " . $e->getMessage()); $_SESSION['error'] = "Failed to load required data"; header("Location: questions.php"); exit; } // Handle form submission if ($_SERVER['REQUEST_METHOD'] === 'POST') { $subjectId = $_POST['subject_id']; $classId = $_POST['class_id']; $questions = $_POST['questions']; try { $pdo->beginTransaction(); // Get next question number $stmt = $pdo->prepare(" SELECT COALESCE(MAX(question_number), 0) + 1 FROM questions WHERE subject_id = ? AND class_id = ? "); $stmt->execute(array($subjectId, $classId)); $nextQuestionNumber = $stmt->fetchColumn(); // Insert each question $questionStmt = $pdo->prepare(" INSERT INTO questions ( subject_id, class_id, question_number, question_text, option_a, option_b, option_c, option_d, correct_option, marks, picture_url ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) "); foreach ($questions as $q) { // Handle question image upload $questionImage = ''; if (!empty($_FILES['questions']['name'][$q['index']]['image'])) { $uploadDir = '../uploads/questions/'; if (!is_dir($uploadDir)) { mkdir($uploadDir, 0755, true); } $ext = pathinfo($_FILES['questions']['name'][$q['index']]['image'], PATHINFO_EXTENSION); $filename = 'q_' . uniqid() . '.' . $ext; $destination = $uploadDir . $filename; if (move_uploaded_file($_FILES['questions']['tmp_name'][$q['index']]['image'], $destination)) { $questionImage = $filename; } } $questionStmt->execute(array( $subjectId, $classId, $nextQuestionNumber++, $q['text'], $q['options']['A'], $q['options']['B'], $q['options']['C'], $q['options']['D'], $q['correct_option'], 1, // Default marks $questionImage )); } $pdo->commit(); $_SESSION['success'] = "Questions added successfully"; header("Location: questions.php"); exit; } catch (PDOException $e) { $pdo->rollBack(); error_log("Error saving questions: " . $e->getMessage()); $_SESSION['error'] = "Failed to save questions"; header("Location: question_form.php"); exit; } } // Fetch admin username for the navbar $admin_name = 'Admin'; try { $stmt = $pdo->prepare("SELECT username FROM admins WHERE id = ?"); $stmt->execute(array($_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()); } ?> Add Questions - British Entrance Exam Portal

Add Questions

Back to Questions