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

  • 80 favourites


Attached Files

The following files have been attached to this tutorial:



Download now 180.37 KB


41,269 visits, 110,858 views



This tutorial is licensed under CC BY 4.0. Please refer to the license text if you wish to reuse, share or remix the content contained within this tutorial.

Highscores in Construct 2

We have our PHPs ready. Now you only need to call these PHPs to read/write scores from your Construct 2 game!

Open your game and do the following steps:

1. Right Click and "Insert new object". Select Web -> AJAX

2. Open the highscore_example.capx to help you

3. You need a "Score" variable

4. You need a "DOMAIN_SCORES" constant. Write here your free domain! Where your phps are uploaded. Example: ""

Reading Scores

To read scores from your server database, take a look to the example .capx attached to this tutorial.

Line 2:

Here an AJAX Request reads the php file "getscores.php" from your server

Line 3:

"On Completed" the Reading of Scores, we will receive the data in Ajax.LastData. Here is the actions we will do:

a) Set the group "Do Array" active: to show a Top 10 Leaderboard with names and scores

b) Read the Best Score #1 (name and score) and write that in a Text field.

Do Array:

This group reads the 10 scores received and populates the Text fields.

Scores are received as a string with the following format: name1|score1|name2|score2|name3|score3...


We split this info using the separator "|". To access any of them you can use this:

"Best Score: " & tokenat(AJAX.LastData, 0, "|") & " - " & tokenat(AJAX.LastData, 1, "|")


"1st best score: " & tokenat(AJAX.LastData, 0, "|") & " - " & tokenat(AJAX.LastData, 1, "|")

"2nd best score: " & tokenat(AJAX.LastData, 2, "|") & " - " & tokenat(AJAX.LastData, 3, "|")

"3rd best score: " & tokenat(AJAX.LastData, 4, "|") & " - " & tokenat(AJAX.LastData, 5, "|")


Sending Scores

For sending scores, you can read the example .capx:

Line 8:

When you click "Submit", your typed name and the score (randomly generated in this example) will be sent to 'savescores.php'

Line 9:

This is an example of doing some action when the score sending is succesfully "Completed". In this case, we will reload again the best scores. And we write a Text message "Score Saved!"

BONUS: Get Player's Rank

Want to know your Rank? By popular demand, a 'getrank.php' file has been included inside this tutorial. You call this file like this: [YOUR-DOMAIN]/getrank.php?score=57 (use the current player's best score)


This will check all the scores in the database higher than '57'. Let's say we have scores '100' and '93' and '48'. Then the php file will return rank: '3' for score '57'. Because with your score we found 2 better guys, so you are number 3.

This is included in the .capx example.

What's Next?

This is a basic High Score system to learn the basics. Once you understand well what is happening behind the scenes, I suggest you to play around and make a few improvements.

Here is a list of a few things you can do:

  • Add an 'email' field/column to your 'scores' table.
  • Add a 'time' column to your 'scores' table to save when the score was submitted.
  • You can have scores separated by 'level' or by 'difficulty' (easy, medium, hard).
  • Prevent Cheating. Idea: Add a secret key when you send scores to [YOUR-SITE]/savescores.php?name=john&score=51&hash=[7hdndid2in2d...]. Then you can decypher this key inside 'savescores.php' and it should correspond with the submitted score. This way you guess if the score is real or fake. If the score/key is invalid, you don't save it to the DB. Idea 2: "record" player's input and save it (moves, rand seed, etc). Replay the game and check if the score is correct.
  • Only One (the best) score per person.
  • If you have 2 or more games on the same DB, you will need different table names. Like "flappybird-scores" and "stickninja-scores".
  • Inside your .capx you can make Leaderboard pages, like: page 1 [scores 1-10], page 2 [scores 11-20], etc.

Final Words

Any other thing you need to do, leave your questions. You can find great PHP and MySQL tutorials on Also try Google, there is a lot of info on PHP and scores, etc.

Hope you find this tutorial useful. Let your comments at the bottom!

Enjoy and thanks for reading!



Download now 180.37 KB

  • Order by
Want to leave a comment? Login or Register an account!
  • [FIXED] The scripts save/get should be updated according to the latest PHP formatting rules. After fiddling after a bit I found that in the save.php you should remove the "id" parts when inserting the score.

  • Great tutorial for a refresher. Ive just finished reading through the tutorial and will soon be implementing the PHP.

  • I may be a bit late to the party, but I just finished this great tutorial by the letter, but the construct 3 part did not work. "work" means, no data was retreived after the ajax request. The phps work just fine, so I went bugfixing. as some users here seem to have similar problems, I want to share my solution:

    Instead of using a constant for the URL as suggested in the tutorial, i hardcoded it in the ajax request. this works like a charm. maybe it helps somebody else :-)

    thank you, dear author of this fine tutorial. well written and a huge help.

    • Hey! Thanks for writing and I am happy that you enjoyed the tutorial and it was helpful!! Go and make some super awesome games and share them here later! ;)

      • Hi, thanks fo the wonderful tutorial but I have an Issue, I hope you can help me by getting block issue in CORS

        how do I deal with it?

        how do I implement the code that allowing me to access in different site address?

  • Thankyou DuqueKarl for putting together this Tutorial. Very helpful

  • thank you for the tutorial it was very helpful in my game development

  • Load more comments (103 replies)