Webbserverprogrammering 1

Show sourcecode

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

webbsrvprg/gya/

createTables.php
deleteActions.php
deletePlayers.php
index.js
index.php
javascript.js
jsonIndex.json
save.json
seePlayers.php
test.php

index.php

73 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
<!DOCTYPE html>
<html lang="sv">
  <head>
    <meta charset="utf-8" />
    <meta name="viewport">
    <title>Första sidan</title>
  </head>

  <body>
    <?php 
      if (isset($_POST["actions"]) && isset($_POST["time"])) {
        $actions = explode(",", $_POST["actions"]);

        array_pop($actions);

        foreach ($actions as $i => $action) {
          $actions[$i] = explode(" ", $action);
        }

        $startTime = $_POST["time"];

        $lastIndex = count($actions) - 1;
        $playTime = (int)$actions[$lastIndex][0];

        include ('../dbconnection.php');
        try {    
          # prepare
          $sql = "INSERT INTO players (startTime, playTime) 
            VALUES (?, ?)";
          $stmt = $dbconn->prepare($sql);
          # the data we want to insert
          $data = array($startTime, $playTime);
          # execute width array-parameter
          $stmt->execute($data);
              
          echo "New record created successfully";
          $lastId = $dbconn->lastInsertId();

          foreach ($actions as $action) {
            try {    
              # prepare
              $sql = "INSERT INTO actions (timeStamp, action, direction, playerId) 
                VALUES (?, ?, ?, ?)";
              $stmt = $dbconn->prepare($sql);
              # the data we want to insert
              $data = array($action[0], $action[1], $action[2], $lastId);
              # execute width array-parameter
              $stmt->execute($data);
            }
            catch(PDOException $e)
                {
                echo $sql . "<br>" . $e->getMessage();
            }
          }
        }
        catch(PDOException $e)
            {
            echo $sql . "<br>" . $e->getMessage();
        }
        
        $dbconn = null;
      }
    ?>

    <form method="POST" action="">
      <input type="hidden" id="time" name="time">
      <input type="hidden" id="actions" name="actions">
      <input type="submit" value="Skicka">
    </form>

    <script src="javascript.js"></script>
  </body>
</html>