Where to start designing a website?

Question

API

Hey! I am new to the field of programming. I designed the website design and described its functionality.
Now I want to implement.
Question:
How to properly approach the issue of designing an administration and site management system?
I need to make an admin panel for the site, and in fact it is a more significant part of the site at this stage.
Since the site itself is scheduled to display only the 1st page of information (this is a directory with pagination).
The admin panel should already have pages for working with tables in the database.
And also some tables can be created directly in the admin panel.
What books or resources would you recommend on this topic? I have a poor understanding of how to design architecture and where to start.
I know about such a pattern as MVC, but I still do not understand why it is the way it is, and why it is designed the way it is.
And I don’t want to stupidly repeat actions after others. I want to understand what I'm doing.
Also, I don’t understand in which case it is necessary to make an API server, and in which case a regular server.

Answer 1

Do as you can, in the process there will most likely be thoughts on how to simplify / improve something. Gradually you will understand why it was done this way and not otherwise. Stupid repetition will lead to almost nothing
Read about design patterns and delve into it
Useful to read Perfect code
More like a backend, not a server. The API is being made to simplify support. You get a single point for working with the site, with which the frontend can interact (for example, by making AJAX requests), a mobile application and anything else
Everything has a reason, which means that the pattern solves some problem. There are many other patterns (e.g. MVC, MVVC), for web applications MVC is an easy way to separate the responsibilities, but no one obliges you to follow it, you can try other patterns

Answer 2

See what OctoberCMS is (it has translated documentation).
Your Wishlist is very reminiscent of what is implemented in it out of the box.
Even if you do not want ready-made - a good role model.

Answer 3

The admin panel should already have pages for working with tables in the database

any CRUD generator, and then you can "comb" a bit

And also some tables can be created directly in the admin panel

why else is this? o_o

Answer 4

If you want to earn money, then why should you spend time inventing and creating your own bicycle, when there are many ready-made and free ones. Take one of the ready-made CMS and use it. In business, time is money.
If it's just for training in programming, then yes.