View sourcecode

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

`dashboard.php`

52 lines ASCII 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


<?php

require "database.php";

require "auth.php";

requireLogin();





$stmt = $conn->prepare(

    "SELECT L.LadderID, L.LadderName

     FROM Ladder L

     JOIN LadderPlayers LP ON L.LadderID = LP.LadderID

     WHERE LP.PlayerID = ?"

);

$stmt->execute([$_SESSION["player_id"]]);

$ladders = $stmt->fetchAll();

?>



<!DOCTYPE html>

<html>

<head>

    <title>Dashboard</title>

    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.3/dist/css/bootstrap.min.css" rel="stylesheet">

</head>

<body>



<div class="container mt-5">

    <h2>Welcome, <?= htmlspecialchars($_SESSION["username"]) ?></h2>





    <h4 class="mt-4">Your Ladders</h4>



<!--Show ladders on page-->

<ul class="list-group">

<?php foreach ($ladders as $ladder): ?>

    <li class="list-group-item d-flex justify-content-between">

        <?= htmlspecialchars($ladder["LadderName"]) ?>

        <a class="btn btn-sm btn-outline-primary"

           href="ladder.php?id=<?= $ladder["LadderID"] ?>">View</a>

    </li>

<?php endforeach; ?>

</ul>



<!--Buttons for create or join a ladder and logout-->

    <div class="mt-4">

        <a href="create_ladder.php" class="btn btn-success me-2">Create Ladder</a>

        <a href="ladder_join.php" class="btn btn-primary me-2">Join Ladder</a>

        <a href="logout.php" class="btn btn-danger">Logout</a>

    </div>

</div>



</body>

</html>