Secure Login Form Authentication System (Cookies, Sessions, Token, PDO) PHP & MySQL Tutorial Part 5

I am using PDO for my database access which is a safe method against common sql injection attacks.
Even though I simply go with my root mysql user in the tutorial I recommend you guys to create a dedicated mysql user with just enough permission so you can use the login form as it will protect your database or site from evil people trying to drop tables or delete entries.
The method I use in this video can be found in the links below. Feel free to apply this best practice method to your projects as this is actually pretty good.

Feel free to leave CONSTRUCTIVE criticism for me as I am NOT programming in PHP or SQL professionally.

Why I send it to patreons only? Tutorials compensate my time and effort I invested when you take your time watching the video and following along. If you would like to save yourself some time you can use another way to help and support my channel and my tutorials :)

#Website

#Social

#Messenger
Skype: hazardedit

[Analogue-India]

@HazardEdit can you please provide the download link of complete code, It would be greatly appreciated

[rv]

can you put the download, I couldn't follow you, when you correct some bugs or errors its defficult to understand becase you go so fast, and for me a beginner its hard. How can i compare the code to my code to see where I have the bug?

[hakuna_matata]

Can you share with us the code ? thanks in advance

[elminion]

I have a question, how can i block a application, made by me, in visual studio?, imagine i let a friend download my app, and i want to make he stop use it, its posilbe lock it? and if is it, what i need? SQL? or what, pls answer :cc (srry for english)

[MrNagySebestyen]

Hi, can you post your final code in a zip?

[carloautor]

@HazardEdit
Can you continue it and make a register page ?
Thanks

[DamirDuvnjak]

hey i manage to folow up and all work. Great job. If i want to add extra column in User table like 'surname' and i want that value to be show in Admin page (Welcome <?php echo $_COOKIE['Surname']; ?>) how can i do that? i try to add Surname next to setcookie in function.php but did not work.

[georgestatefield]

maaan, without source-code its impossible to get the same results, cuz it is all goes after debugging

[thijs]

HazardEdit first of all thanks for the great explanation. But when I am trying to login with admin admin. then the page load and I am coming back to the loging page. nothing happends. the if loop in the index.php keep me returning to the login.php

[CaPbAnAnEwEiZeN]

hey which tool you use for php programming

[the_creative_dev_official]

Hello, I contact you because I have a project but I can not do it by any means to try, I would like to know if you can bring me to help, thank you in advance

[BRdaXJ]

Can you help me with a csgo cheat please ?

[eithan]

Sorry for pin picking your videos, but you should also tell users to htmlspecialchars before echoing a non html string. This'll prevent xss.

[DagsPlaysMinecraft]

FOR THE LOVE OF GOD I NEED HELP CMON!!!!