career_advisor/process_quiz.php at main · manishkr1313/career_advisor · 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
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
<?php
require_once 'includes/db.php';
require_once 'includes/functions.php';

requireLogin();

$user_id = $_SESSION['user_id'];

// Initialize scores
$science_score = 0;
$commerce_score = 0;
$arts_score = 0;

// Fetch all questions
$questions = [];

$result = $conn->query("SELECT * FROM quiz_questions ORDER BY id ASC");

while ($row = $result->fetch_assoc()) {
    $questions[] = $row;
}

// Calculate scores based on answers
foreach ($questions as $index => $q) {

    $answer = $_POST["q$index"] ?? '';

    if ($answer == "agree") {

        if ($q['category'] == "Science") {

            $science_score++;

        } elseif ($q['category'] == "Commerce") {

            $commerce_score++;

        } elseif ($q['category'] == "Arts") {

            $arts_score++;

        }

    }

}

// Determine suggested stream
$suggested_stream = getStreamFromScore(
    $science_score,
    $commerce_score,
    $arts_score
);

// Save result
$stmt = $conn->prepare("
INSERT INTO quiz_results
(user_id, science_score, commerce_score, arts_score, suggested_stream)
VALUES (?, ?, ?, ?, ?)
");

$stmt->bind_param(
    "iddds",
    $user_id,
    $science_score,
    $commerce_score,
    $arts_score,
    $suggested_stream
);

if ($stmt->execute()) {

    $_SESSION['last_quiz_result'] = [

        'science_score' => $science_score,
        'commerce_score' => $commerce_score,
        'arts_score' => $arts_score,
        'suggested_stream' => $suggested_stream

    ];

    header("Location: result.php");
    exit();

} else {

    showError("Error saving quiz results!");
    header("Location: quiz.php");
    exit();

}

$stmt->close();
$conn->close();
?>