connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$lb_easy = $conn->query("SELECT username, highscore_easy FROM users WHERE highscore_easy > 0 ORDER BY highscore_easy DESC LIMIT 10");
$lb_medium = $conn->query("SELECT username, highscore_medium FROM users WHERE highscore_medium > 0 ORDER BY highscore_medium DESC LIMIT 10");
$lb_hard = $conn->query("SELECT username, highscore_hard FROM users WHERE highscore_hard > 0 ORDER BY highscore_hard DESC LIMIT 10");
$isLoggedIn = isset($_SESSION['user']);
?>
Leaderboard - Breakout Game
Hall of Fame
Easy Level
| Username |
Score |
num_rows > 0) {
while($r = $lb_easy->fetch_assoc()) {
echo "
| " . htmlspecialchars($r['username']) . " |
" . htmlspecialchars($r['highscore_easy']) . " |
";
}
} else {
echo "| No records yet |
";
}
?>
Medium Level
| Username |
Score |
num_rows > 0) {
while($r = $lb_medium->fetch_assoc()) {
echo "
| " . htmlspecialchars($r['username']) . " |
" . htmlspecialchars($r['highscore_medium']) . " |
";
}
} else {
echo "| No records yet |
";
}
?>
Hard Level
| Username |
Score |
num_rows > 0) {
while($r = $lb_hard->fetch_assoc()) {
echo "
| " . htmlspecialchars($r['username']) . " |
" . htmlspecialchars($r['highscore_hard']) . " |
";
}
} else {
echo "| No records yet |
";
}
?>
⬅ Back to Game