In which direction to dig to create a local CMS?

Question

CMS

Good afternoon! For the diploma, I need a working project, what I want to implement:
1) Write SMS to access the database (adding, editing and deleting records)
2) I want to put the whole thing on a local server so that the user on the local network has access to the database.
The problem is:
1) I don't know where to start. Where can I read material in line with my ideas? With the basics of PHP, SQL familiar. (HHTML, CSS, JS respectively too).
2) Does my idea differ from the creation of a regular project, access to which is carried out by one user, the database of which is located not on the server but on the PC.
Please tell me where to get the material (video, articles, books). Maybe someone met the implementation of this project in their practice, and maybe there is a course on creation?

Answer 1

1. why write a bicycle, there is already phpMyAdmin.
2. We put Apache, PHP and MySql on one machine, specify localhost in the database connection settings and that's it. it's easier to take XAMMP, everything is set up for you there.