Webbserverprogrammering 1

Show sourcecode

The following files exists in this folder. Click to view.

webbserver/Projekt1/

createquiz.php
createtable.php
dbconnection.php
index.php
login.php
myquiz.php
registrera.php
results.php
results2.php
takequiz.php

createquiz.php

103 lines UTF-8 Windows (CRLF)
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
96
97
98
99
100
101
102
103
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Document</title>
</head>
<body>
    <?php

    include('dbconnection.php');
    /** @var PDO $dbconn */

$step = "quiz";

if (isset($_SESSION['quiz_id'])) {
    $step = "question";
}

if (isset($_POST['create_quiz'])) {

    $stmt = $dbconn->prepare(
        "INSERT INTO quiz (title, user_id)
         VALUES (:title, :user_id)"
    );
    $stmt->execute([
        ':title' => $_POST['title'],
        ':user_id' => $_SESSION['user_id']
    ]);

    $_SESSION['quiz_id'] = $dbconn->lastInsertId();
    $step = "question";
}

if (isset($_POST['save_question'])) {

    $quiz_id = $_SESSION['quiz_id'];

    $stmt = $dbconn->prepare(
        "INSERT INTO questions (quiz_id, question)
         VALUES (:quiz_id, :question)"
    );
    $stmt->execute([
        ':quiz_id' => $quiz_id,
        ':question' => $_POST['question']
    ]);

    $question_id = $dbconn->lastInsertId();

    for ($i = 1; $i <= 3; $i++) {
        $stmt = $dbconn->prepare(
            "INSERT INTO answers (question_id, answer, is_correct)
             VALUES (:qid, :answer, :correct)"
        );
        $stmt->execute([
            ':qid' => $question_id,
            ':answer' => $_POST["answer$i"],
            ':correct' => ($_POST['correct'] == $i ? 1 : 0)
        ]);
    }

    if ($_POST['action'] === "done") {
        unset($_SESSION['quiz_id']);
        header("Location: index.php");
        exit;
    }
}
?>
<h1>Skapa quiz</h1>

<?php if ($step === "quiz") { ?>
<form method="post">
    <label>Quiztitel</label><br>
    <input type="text" name="title" required><br><br>
    <button name="create_quiz">Skapa quiz</button>
</form>
<?php } ?>

<?php if ($step === "question") { ?>
<form method="post">

    <label>Fråga</label><br>
    <input type="text" name="question" required><br><br>

    <label>Svar</label><br>

    <input type="radio" name="correct" value="1" required>
    <input type="text" name="answer1" required><br>

    <input type="radio" name="correct" value="2">
    <input type="text" name="answer2" required><br>

    <input type="radio" name="correct" value="3">
    <input type="text" name="answer3" required><br><br>

    <button name="action" value="add">Lägg till fråga</button>
    <button name="action" value="done">Klar</button>

    <input type="hidden" name="save_question" value="1">
</form>
<?php } ?>
</body>
</html>