"Webgame web game development and design concise tutorial"

This book is a tutorial on web game development

We know that simply discussing data processes is painful.
It is also more painful to discuss the program without giving the code.
The one used here is php mysql.
Then let’s discuss it in a super simple webgame way. Paired with appropriate code. Should help. Please point out any shortcomings, it will be helpful to me personally.
We do not consider the playability of the game, numerical balance and other issues. Let us first consider only the implementation of a simple example.
So what is the basic content of a webgame?
Database: Player, map, city, building, weapon, soldier.
Functions: Login, upgrade, personal battles, battles between soldiers, battles with cities, building buildings, crafting weapons, buying and selling props.
(Note: Each function must correspond to 1 or more data tables. What is listed in the database above is only the basis of the foundation.)