Show sourcecode

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

webbserverprogrammering/projekt/quiz/

createtable.php
dbconnection.php
deletepost.php
deletetable.php
insertdefaultposts.php
insertposts.php
leaderboard.php
log_in.php
log_out.php
main.php
question_maker.php
quiz_form.php
quiz_list.php
quiz_maker.php
result.php
selectposts.php
sign_in.php
style.js
updateposts.php

`question_maker.php`

85 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


<!DOCTYPE html>

<html lang="sv">

<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');

  session_start();



  if (isset($_SESSION["username"])) {

    $username = $_SESSION["username"];

    $usertype = $_SESSION["usertype"];

    echo "  <h2>Quiz Skapare</h2><h3>Välkommen " . $username . "! (" . $usertype . ")</h3>";

  } else {

    $_SESSION = [];

    session_destroy();



    // Skickar oönskade till startsidan

    header("Location: main.php");

  }

  ?>

  <hr>

  <!-- Quiz skapare -->

  <br>

  <?php

  if (isset($_POST["quiz_name"])) {

    $quiz_name = $_POST["quiz_name"];

    echo "$quiz_name<br><br>";



    try {    

        # prepare

        $sql = "INSERT INTO quizzes (quiz_name) 

          VALUES (?)";

        $stmt = $dbconn->prepare($sql);

        # the data we want to insert

        $data = array($quiz_name);

        # execute width array-parameter

        $stmt->execute($data);

            

        $lastId = $dbconn->lastInsertId();



        // Sparar nuvarande quiz id som skapas

        $_SESSION["current_quiz_id"] = $lastId;



      }

      catch(PDOException $e)

          {

          echo $sql . "<br>" . $e->getMessage();

      }

      $dbconn = null;



  };

  ?>

  <form method="post" action="">

    <p>Lägg till frågor och alternativ:</p>

    <input type="text" placeholder="Fråga">

    <div id="answerDiv">

      <input type="text" name="answer1" placeholder="Alternativ">

        <select name="y/n">

          <option>Falskt</option>

          <option>Sant</option>

        </select>

    </div>

    <button type="button" onclick="createAlternative()">Lägg till alternativ</button>

    <br><br>

    <input type="submit" value="Lägg till fråga">

  </form>

  <br><br>

  <!--Tillbaka-->

  <hr>

  <h4>Tillbaka</h4>

  <a href="main.php">Startsida</a>

  <br><br>

  <a href="leaderboard.php">Leaderboard</a>

  <br><br>

  <a href="log_out.php">Logga ut</a>

  <br><br>

  <hr>



  <style src="style.js"></style>

</body>

</html>