Creation of a personal account. How to make (listed in details)?

Hello, bread. I will try to describe everything briefly and clearly. I hope this works.
In General.. I Want to make a personal account, but the creation was faced with the following problem:
I'm a real KETTLE. Tried to conclude a normal user name from the database, but realized that it needs somewhere to save the id to define in WHERE clause (mysql).
Also faced with misunderstand, but how exactly to do so, to not have every time to write a long text output data from the database. Even if I started to do it, it would be faced with the previous problem!
Yes, a little knowledge, and habits large. I hope I wrote understandable. Please explain how to do it. If you have the time and it's not difficult, I can tell VK, Skype or Discord.
Thanks in advance!
March 20th 20 at 11:26
3 answers
March 20th 20 at 11:28
You should read the tutorial and get hand on training examples. Misunderstanding will disappear and questions will be solved.
March 20th 20 at 11:30
0. Metalogeny the user came to the site, the session is empty.
1. When he logs on or logs - write in the session id.
2. When the user logopaedia - clean session.

If the session has an id - display name and that there is still need.

to not have every time to write a long text output data from the database
use orm or nakahashi your functions to work with databases, if they haven't mastered OOP.
March 20th 20 at 11:32
You have in the database should be the id field with autoincrement option which will automatically assign a number to each new user. Here on it and going to choose. Here here esteem, there it is. In my profile there is mail, throw in there a link to VC. If anything, tell me.

Find more questions by tags PHPMySQL