Creating your own Leaderboard / Highscores Easy and Free (PHP & MySQL) [UPDATED 2020]

Check the new attachments in this tutorial. I have uploaded a 'getrank.php' ;)

To use it you call it like described in page 4 of this tutorial! :)

(Continued...)

Changes in getrank.php:

1)

$sql = "SELECT COUNT(*) AS rank FROM scores WHERE score > " . $_GET['score'] . " GROUP BY name";

2)

In the while loop remove the "echo part". Outside of the loop, print i:

echo ($i + 1);

There are a few ways to do this.

Here is one idea:

Check the current getScores.php. Copy the PHP file and rename to getRank.php

When you call this PHP, check the DataBase and return a Number (the player RANK).

How?

When calling getRank you need to send a parameter. So the PHP code knows what to look for inside the DB.

One option is to use a UserName or Email, whatever "unique" identifier of the current player. The PHP would be called like this: "www.URL.com/getRank.php?playername=john"

It must return, for example: "99"

MY CHOICE. The second option.

Call the PHP using your best score, and the PHP code will check HOW MANY people have a better score than YOU.

Example: "www.URL.com/getRank.php?score=75"

The PHP code checks how many players have a better score than 75 and will return:

98

So you know that you are #99 in the rank