How To Create A Secure Login System in PHP with MySQL Database (2020)

If you enjoyed the video, or it helped you out - please consider buying me a coffee!

Get the source code here:

How to install Linux Apache MySql and PHP (LAMP):

In this PHP tutorial I will show you how to create a secure login system using mysql, which is secure against mysql injection attacks. Most login system tutorials do not use PDO prepared statements and are vulnerable to mysql injection attacks. You will be using the LAMP stack, linux apache mysql and php to create this login system, as well as phpmyadmin. Phpmyadmin is a tool for controlling your mysql database with a graphical user interface. This login system will use php sessions for persistent login. This means if you close the browser and open it again, the login data persists and you are still logged into the website.

Get my eBook here:

[ez-it-solutions]

Excellent video -> keep up the great work.
Would have loved a much shorter version of this.

If we already had LAMP setup, we could've skipped ahead to 31:46 to see how to actually secure the code from SQL Injection.
It's also important to note that this code is still not 100% secure as it's still open to a Cross Site Request Forgery (CSRF) attack and would need to be secured with a random session key.

[bernpaul]

very well explained thank you so much for this kind of content

[Scaleus]

Is that next video with bootstrap and all the stuff coming?

Really good job with that code, btw.

[ez-it-solutions]

I've never written a PHP login from scratch but I'm curious why we would connect to the database before we sanitize the information?
At 19:00, we were already connected to the database and checked for errors, before sanitizing the string...

[amadeusfigueiredo]

I did read your book, really nice man.
Thanks for the help!

[agithrahkamalanthan]

Hi Oscar, would I be able to use WAMP instead of LAMP and still follow your tutorial?

[kasedsoftsilicon]

Wow very good. i like this a video form content

[bencryptoking]

#oscarchambers, I forked the latest version "Bitcoin" source code and I create my altcoin successfully. But I want edit all information in the option "about Bitcoin Core" from "HELP" section in menu bar. Which are the files to edit, where can I find them? ...Please, help me!

[eatsomerice]

Undefined function 'mcrypt_create_iv' and Undefined constant 'MCRYPT_DEV_URANDOM'. How to fix this? I'm using windows

[americanconsumer]

Hi Oscar :), I am getting a 404 error when I try to download your files and ebook.

[jwaweruk]

You're not using prepared statements, is it still secure?

[fred]

NO E-BOOK, NO SOURCE CODE. JUST AN ERROR MEASSAGE AFTER SUBSCRIBING. CLICK BAIT.