Create a database for the accumulation of experience how to implement?

Question

PHP

Hello, I’m trying to figure out PHP myself, I just don’t understand the possibilities of databases for sites, i.e.:
- is it possible to attach a database to a beautiful menu of a site with windows, so that later through this menu you can enter various data into the database, find them, edit them, not through phpAdmin, but through your shell - everywhere video through the admin ......
- how to decide how much space I need for my database on the server
- can I then backup this database file from the server
Let me explain why I need all this - I got tired of re-reading the same building codes for work many times, I want to systematize all this and make it available online with the ability to use and edit the database from any device connected to the Internet - I need something in turn object, chose the necessary categories in the menu, pressed the button, all the necessary information is there)
please help me figure it out ....)

Answer 1

The best way to gain experience is bicycle building, i.e. instead of using ready-made frameworks, cut everything yourself almost from scratch.
Everything that you described can be done, and not necessarily on php and databases, but if we are talking about them, then go ahead. Since you are doing it for yourself, you don't need any mysql/postgres, etc., a simple sql database based on sqlite is enough - the advantage is that you don't need to install or configure anything, database = file, php support out of the box, etc. . (you don’t need to make your database on files in your own format, this path will not bring you anywhere, but if you have immutable data that does not need to be changed from the interface, such are some directories, for example, then you can use data formats, offered by php - json, serialize, or var_dump i.e. php format when the data is described directly in the code as an array)
Another question is whether you need this experience. My opinion is yes, the other one says no? because the real work is not bicycles, but the use of ready-made technologies, quickly, simply efficiently .. though when the rake appears, you will be in complete confusion about what is where, because you will not have experience as such.

Answer 2

try the same evernote, there is also google doc\disk, no need to program anything

Answer 3

getjump.github.io/ru-php-the-right-way Use
this link to look for work with databases there. Plus it's a good source.