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

`seePlayers.php`

90 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


<!doctype html>

<html>

<head>

<meta charset="utf-8">

<title>Delete</title>

</head>



<body>



<?php

include ('../dbconnection.php');

$message = null;

$id = null;



if (isset($_POST['id']) && !empty($_POST['id'])) {

  $id = $_POST['id'];

      

  try {    

    $sql = "SELECT * FROM actions where playerId=?";

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

    // fetch width column names, create a table

    $data = array($id);  

    $stmt->execute($data);

    $output = "<table><tr>

    <td>ID</td>

    <td>Starttid</td>

    <td>Speltid</td>

    </tr>";

    while ($res = $stmt->fetch(PDO::FETCH_ASSOC)) {

      $id = htmlentities($res['id']);

      $timeStamp = htmlentities($res['timeStamp']);

      $action = htmlentities($res['action']);

      $direction = htmlentities($res['direction']);

      

      $output .= "<tr>".

          "<td>$id</td>".

          "<td>$timeStamp</td>".

          "<td>$action</td>".

          "<td>$direction</td>".

      "</tr>";

    }

    $output .= "</table>";

    echo "$output";

  }

  catch(PDOException $e)

    {

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

  }

} else {

    $message .= "<br />";

}



echo $message;



    

// Ouput table with all posts

/*** The SQL SELECT statement ***/

$sql = "SELECT * FROM players";

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

// fetch width column names, create a table

$data = array();  

$stmt->execute($data);

$output = "<table><tr>

<td>ID</td>

<td>Starttid</td>

<td>Speltid</td>

</tr>";

while ($res = $stmt->fetch(PDO::FETCH_ASSOC)) {

    $id = htmlentities($res['id']);

    $start = htmlentities($res['startTime']);

    $play = htmlentities($res['playTime']);

    

    $output .= "<tr>".

        "<td>$id</td>".

        "<td>$start</td>".

        "<td>$play</td>".

        "<td><form method='post' action=''>".

        "<input type='hidden' name='id' value='$id'>".

        "<button type='submit'>Välj</button></form></td>".

    "</tr>";

    

}

$output .= "</table>";

echo "$output";



$dbconn = null;

?>



</body>

</html>