-
Notifications
You must be signed in to change notification settings - Fork 0
/
leaderboard.php
39 lines (38 loc) · 1.06 KB
/
leaderboard.php
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
<?php
session_start();
$server = "localhost";
$user = "talhaa";
$password = "WebDev2021";
$db = "tetris";
$conn = mysqli_connect($server, $user, $password, $db);
if (!$conn) {
die("Connection error: " . mysqli_connect_error());
}
?>
<html>
<head>
<link rel="stylesheet" href="style.css">
</head>
<body>
<ul>
<li style="float:left"><a href="index.php">Home</a></li>
<li><a href="leaderboard.php">Leaderboard</a></li>
<li><a href="tetris.php">Play Tetris</a></li>
</ul>
<div class="main">
<div class="bg">
<?php
$sql = "SELECT Username, Score FROM Scores ORDER BY Score DESC;";
$results = mysqli_query($conn, $sql);
if (isset($results)) {
echo "<table class='leaderboardtable'><tr><th class='leaderboardheader'>Username</th><th class='leaderboardheader'>Score</th></tr>";
while ($row = mysqli_fetch_assoc($results)) {
echo "<tr><td class='leaderboardcell'>".$row["Username"]."</td><td class='leaderboardcell'>".$row["Score"]."</td></tr>";
}
echo "</table>";
}
?>
</div>
</div>
</body>
</html>