How to create a level system for players in an online browser game?

Question

Game development

Hello!
I'm making a browser-based online game in php/sql, but I don't know how best to think over the character's level structure, how to calculate how much experience is needed to level up, etc.?
Please share your experience or just ideas. Thanks in advance!
And where to store all these "levels" in the database?
id| lvl | max_exp_for_up
1 | 1 | 100
2 | 2 | 500
3 | 3 | 1000
lvl - level
max_exp_for_up - how much experience you need to level up

Answer 1

Well, I kept my promise and wrote a guide on how I made the level system in my browser game (which, despite a year of work, is still in the early stages of development):
Demo: walkweb.ru/level
Code: https: //github.com/WalkWeb/Browser-MMORPG-Level-System
Description: www.diablo1.ru/dusk-world/diary-05.php
I must say right away that I tried to write the minimum amount of code to make the levels functional. I did not use MVC, the work with the database was done "if only it worked." An example of all this can be seen in modern frameworks (more precisely, you don’t even need to look - take it and use it), but I set myself the goal of showing exactly the implementation of the level mechanics.