query( "SELECT * FROM computer_quizzes WHERE is_active = 1 ORDER BY created_at DESC LIMIT 1" ); if ($result && $result->num_rows > 0) { $quiz = $result->fetch_assoc(); } $error = ''; if ($_SERVER['REQUEST_METHOD'] === 'POST') { if (!$quiz) { $error = "Quiz not started yet."; } else { $name = trim($_POST['student_name']); $class = trim($_POST['class']); $roll = trim($_POST['roll_number']); if ($name === '' || $class === '' || $roll === '') { $error = "All fields are required."; } else { // Save attempt $stmt = $conn->prepare( "INSERT INTO computer_quiz_attempts (quiz_id, student_name, class, roll_number) VALUES (?, ?, ?, ?)" ); $stmt->bind_param( "isss", $quiz['id'], $name, $class, $roll ); $stmt->execute(); $attempt_id = $stmt->insert_id; $stmt->close(); // Store attempt in session $_SESSION['quiz_attempt_id'] = $attempt_id; $_SESSION['quiz_id'] = $quiz['id']; header("Location: computer_quiz_questions.php"); exit; } } } ?>
Please enter your details to begin.
No active quiz at the moment.