query("
SELECT 1
FROM quiz_payments
WHERE quiz_id = $quiz_id
AND student_id = $student_id
AND status = 'paid'
")->num_rows;
$is_free = $mysqli->query("
SELECT qs.amount
FROM quiz_school qs
WHERE qs.quiz_id = $quiz_id
AND qs.school_id = {$_SESSION['school_id']}
")->fetch_row()[0] == 0;
if (!$is_free && !$check) {
die('Payment required');
}
$access = $mysqli->query("
SELECT q.title, q.description, q.duration
FROM quizzes q
JOIN quiz_school qs ON qs.quiz_id = q.id
WHERE q.id = $quiz_id
AND q.is_active = 1
AND qs.school_id = $school_id
")->fetch_assoc();
if (!$quiz_id || !$access) die('Quiz not available.');
$done = $mysqli->query("
SELECT COUNT(*) FROM attempts
WHERE student_id=$student_id AND quiz_id=$quiz_id AND status='completed'
")->fetch_row()[0];
if ($done) { header('Location: /index.php'); exit; }
$mysqli->query("
INSERT INTO attempts (student_id, quiz_id, status)
VALUES ($student_id,$quiz_id,'in_progress')
ON DUPLICATE KEY UPDATE started_at=CURRENT_TIMESTAMP
");
$attempt_id = $mysqli->insert_id ?: $mysqli->query("SELECT id FROM attempts WHERE student_id=$student_id AND quiz_id=$quiz_id AND status='in_progress'")->fetch_row()[0];
$questions=[];
$qRes=$mysqli->query("SELECT id, question, marks FROM questions WHERE quiz_id=$quiz_id ORDER BY id");
while($q=$qRes->fetch_assoc()){
$opts=[];
$oRes=$mysqli->query("SELECT id, option_text FROM options WHERE question_id={$q['id']} ORDER BY id");
while($o=$oRes->fetch_assoc()) $opts[]=$o;
$q['options']=$opts;
$questions[]=$q;
}
$total=count($questions);
?>
<?= e($access['title']) ?> • Quiz