We got this video for you so that you don’t need to spend your time in the search.

How to create a complete connection system in PHP. In this PHP tutorial, you will learn how to create a simple PHP login system and how to view content after you have logged in. In this PHP connection tutorial, you will learn MySQLi error handlers and databases a login form and a registration form.


I am aware that we need to connect to the database using Prepared Statements to secure the login system. This video was uploaded before I taught statements prepared in this course, which is why I left it out of this video.

So, if you want to see how this is done using Prepared Statements, you can do it in my downloadable lesson files, or watch my lesson "prepared statements" a few episodes back.

ALSO, for people who ask why I have not used PDO to connect to the database, I want to remind everyone that PDO is used in Object-Oriented PHP ONLY! Therefore, we can not use it in this episode since we are doing procedural programming.


1: "inscription = empty"
If you continue to receive a message "signup = empty" after creating the registration script and have tried it, it is most likely due to the mysqli_real_escape_string () function. To resolve this problem, completely remove this feature and instead use prepared statements.

2: "unexpected" "
If you get this error message:
Error parsing: syntax error, unexpected '& # 39;
So that's because you forgot to close a) somewhere.

3: "unexpected"
If you get this error message:
Error parsing: syntax error, unexpected '& # 39;
So that's because you forgot to shut up somewhere.

4: "hashed pwd error"
If you get an error in the script when you haveh the password, it's because you decided not to exactly follow my steps in the video when I created the database table. Make sure you do not set the varchar () to a lower value! When you hatch the password, it will take a lot of space in this column, and if you set a lower number, it will not fit!

5: "registration = success but the database is empty?"
Here, there may be two reasons for your mistake. The first is that you made a syntax / spelling error in your code. And yes, you will say that your code is identical to mine, but in 80% of cases, people claim, I always find a syntax error in their code. So check your code for errors!
The second reason might be that you did not follow the tutorial 100% when we set up the database at the beginning. MAKE SURE that you do not set the values ​​for columns that are less than mine (user_pwd varchar (256) is not null). Otherwise, the password will not fit in the column after we have chopped it!

Lesson chapters:

1: (02:43) Configure our database
2: (10:24) Create visuals using HTML and CSS
3: (36:25) Login to our database
4: (40:46) Create the PHP script for registration
5: (1:07:09) Create the PHP login / logout script

How to configure a local server on your PC: https://www.youtube.com/watch?v=mXdpCRgR-xE&list=PL0eyrZgxdwhwBToawjm9faF1ixePexft-&index=2
CSS reset code: https://html5doctor.com/html-5-reset-stylesheet/
How to find the Pipe symbol on your keyboard: https://www.computerhope.com/jargon/p/pipe.htm


First of all, thank you for all the support you have given me!

I am really happy to have such a great community on my channel. It motivates me to keep creating and downloading content! So thanks!

I am now using Patreon to share improved and updated teaching materials, and for a small fee you can access all the material. I have worked hard and I have done my best to help you understand what I'm teaching.

I hope you find it useful πŸ™‚

Material for this lesson: https://www.patreon.com/posts/php-44-download-15654514


We inserted this video based on certain parameters as on date of insertion. Few of them are below.

Video Views: 307580

Video Rating: 4.90


Please enter your comment!
Please enter your name here