QuizMasterDB/custom_quiz_submit.php at master · sjasthi/QuizMasterDB · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
<?php
require 'db_configuration.php';
include('header.php');

if ($_SERVER["REQUEST_METHOD"] == "POST") {
    // Initialize variables to track the score and number of correct answers
    $score = 0;
    $correct_answers = 0;

    // Loop through the submitted answers and compare them with the correct answers
    foreach ($_POST as $key => $value) {
        if (substr($key, 0, 9) === 'question_') {

			// Extract the question ID from the input name
            $question_id = substr($key, 9);
            $submitted_answer = $value;

            // Retrieve the correct answer from the database
            $sql = "SELECT answer FROM questions WHERE id = $question_id";
            $result = mysqli_query($db, $sql);
            $row = mysqli_fetch_assoc($result);
            $correct_answer = $row['answer'];

            // Check if the submitted answer is correct
            if ($submitted_answer === $correct_answer) {
                $correct_answers++;
            }

        }
    }

    // Calculate the score as a percentage
    $total_questions = count($_POST) / 2;
    if ($total_questions > 0) {
        $score = ($correct_answers / $total_questions) * 100;
        // Round up number
        $score = number_format($score, 2);
    }
}
?>

<!-- Display to the screen  -->
<!DOCTYPE html>
<html>
<head>
    <!-- Include Bootstrap CSS -->
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-EVSTQN3/azprG1Anm3QDgpJLIm9Nao0Yz1ztcQTwFspd3yD65VohhpuuCOmLASjC" crossorigin="anonymous">
</head>
<body>
    <div class='fs-3 text-center'>
    <?php
    if ($total_questions == 0) {
        echo "<h2>Quiz had zero questions. Please try again.</h2>";
        echo "<a href='generate_quiz.php' class='btn btn-primary'>Generate New Quiz</a>";
    } else {
        echo "<h2>Quiz Score:</h2>";
        echo "<p>You answered $correct_answers out of $total_questions questions correctly.</p>";
        echo "<p>Your score:<strong> $score% </strong></p>";
    }
    ?>
    </div>
</body>
</html>