Signup and Login with PHP and MySQL

Learn how to create signup / registration, login and logout using PHP, MySQL and best practices.
Please consider supporting my channel:
☕ ko-fi.com/davehollingworth
Recommended hosting:
davehollingworth.net/hosting
Part 2: PHP Password Reset by Email is here: • PHP Password Reset by ...
In this video you'll learn how to:
• create a signup page
• validate the data on the server in PHP
• save the signup data to a MySQL database using PHP
• create login and logout pages
• validate the data in the browser using JavaScript
• validate the email using an Ajax request
Code shown in the video:
‣ github.com/daveh/php-signup-l...
Relevant documentation:
‣ watercss.kognise.dev/
‣ www.php.net/manual/en/functio...
‣ just-validate.dev/
00:00 Introduction
00:23 Signup form HTML
03:24 Add classless CSS
04:04 Process form in PHP
05:12 Server-side validation
08:33 Hash the password
09:59 Create the MySQL database
11:36 Connect to the database from PHP
14:27 Insert a new record
17:00 Prevent duplicate emails
18:55 POST / Redirect / GET
20:33 Login form
21:53 Process the login form
24:45 Verify the password
27:45 Use the session for login
28:10 Add index page
30:42 Add logout page
32:22 Show logged-in user's name
34:30 JavaScript signup validation
37:35 Custom validation
39:20 Remote validation
42:49 Summary
#PHP #MySQL #signup #login

[@nnzzz9581]

Hi Dave! Starting as a Web Dev intern soon, and I just wanted to say, how great and informative these videos are for understanding "what's under the hood" so to say. Keep up the amazing work!

[@cosmonautilus1181]

This has got to be the best php tutorial on KZbin. I really appreciate your work Dave! keep going.

[@Oletechiegirl]

This HAS TO BE the best tutorial I’ve seen on this subject. Excellent and thank you.

[@salma-amlas]

i'm a beginner at php and i found this extremely clear and easy to understand! thank you so much!

[@retrorusty2012]

WOW! I always want videos like this. You do an amazing job. Thorough explanation on why each code block is chosen. How to test implementation along the way. And a full video from start to finish comprehensively solving the entire subject at hand. Thank you for your dedication to excellence and kindly sharing it with the rest of us.

[@annemimosa]

I followed 5 different tutorials from other authors and none of them worked! This is the only one that worked! Code works! Thank you so much!!!

[@DavidHeyManS]

The best signup and login with php and mysql video I've seen so far with some serious validation. Thank you for the amazing video Dave!

[@samuelrichard4117]

I've been struggling for days on how to setup php on my website and you just made everything clear in 45 minutes. Cheers!

[@DavidEMunozR]

I never found someone who explains the way you do. Thank you very much.

[@kingsleyrams742]

Fatal error: Uncaught Error: Undefined constant "require_DIR_" in C:\xampp\htdocs\process-signup.php:29 Stack trace: #0 {main} thrown in C:\xampp\htdocs\process-signup.php on line 29 i keep getting this error

[@markprouty5029]

I've looked at a number of other login and register tutorials. This is the easiest to work with! THANKS

[@user-yy1rx9wv3l]

It's the best and most complete video i saw on that topic to create a register and login form. Thank you Dave !!

[@saeidvaygani9709]

I think this video is one of the best tuturial of creating the registration form in youtube.

[@zbysiu100]

I have just discovered this wonderful tutorial of PHP. Incredible. Thank you very, very much!!!

[@emmanuellyons6827]

This is the best PHP tutorial on KZbin! ❤️❤️❤️❤️🤜🤛

[@ayam3330]

one of the video that got me understand, i've watched 5-more videos, and this is clear. tommorow is deadline for university assigment and my lecturer never teach php

[@errollsipagan4617]

Thank you Dave. I've been brushing up my php skills and your video helped me a lot.

[@Hevletica]

Superb to-the-point video. I especially enjoyed the AJAX + API part, you nailed it under a couple of seconds.

[@sixtusushahemba9419]

Wow, this's a very clear and deep explanation here. Thanks so much for the tutorial. It's obvious you really deeply understand this, based on your explanation and work through. It's so clear and confident. I really appreciate your effort into this tutorial.

[@PhiloMusix24]

I like your style as it is very consistent throughout.

[@casiangutu545]

This tutorial is pure gold

[@Shams_]

Till now the best tutorial I have ever seen 👍

[@mikeg12345]

Dave, this was exactly what I was looking for, and it's a great, clear & concise tutorial - thanks for making it!

[@Suskanna]

Thank you so much for this tutorial! It was super easy to follow and I didn't get any errors (other than the ones showed in the video of course). This'll be a big help for a lot of people!

[@ryanfox516]

This is super informative and really explained in simple terms. Thank you!

[@CanadianGuyPeter]

This is such a great tutorial. You explained everything step by step which is easy to understand.

[@anatolydemianov9270]

One of the best tutorials I've ever watched! Keep up the good work and thank you very much!

[@WesleyInsleyComedy]

Very well explained. Great work, Dave! And thank you very much.

[@shreeyachatterji7972]

Amazing tutorial loved it

[@dijanamatkovic6136]

I really love this tutorial! You should make more Projects like this like (Task List, Converter, Calculator, .... ) I would really loved if you could be my Mentor . You clearly have magic to teach... Can wait to see a new project.

[@jacoboferkalfa3476]

Dave, thank you for your tutorial. Very well explained and useful.

[@AsicEdits]

this is gold, best tutorial I've seen so far

[@PhiloMusix24]

Very bright tutorial and it's so easy to understand the concepts.

[@dannyreg8405]

I second the vote about being the best php tutorial on KZbin. I'm still confused (born that way) about the validation of the information before being written to the DB.

[@frankkaundamukhuni]

You are a great lecturer your code helped me

[@dewangatheakshana1049]

This is super informative and really explained in simple terms. Thank you

[@user-sl3tq8zv6k]

Explanation is very clear, thank you so much!

[@davidrangel7533]

Man, I thought the thumbnail of your video was a creepypasta, but u really help me to understand the topic.

[@nicoschulz4037]

This tutorial is awesome! Thank you Dave! I'll try to add your "email-verification tutorial" to this. Maybe with an extra email verification link for user verification. I am a total newbie to php and coding, but your tutorials are THE BEST on youtube! Thank you very much!

[@dave-hollingworth]

Thank you for your kind words! I'm hoping to do a "part 2" to this soon with email verification, remember me and so on

[@cortexmap]

Brilliant, thank you for the free and open education.

[@nehalkamal6490]

This channel is amazing

[@ackinito]

Fantastic tutorial!

[@shakhzodweb-programmer7034]

thank you I am a beginner and it helped me a lot to understand the fundamental. You have explained all one by one and clear. Thanks!!!

[@andy_frank]

Excellent tutorial. Heading to part 2. Thank you very much!!!

[@tanyidavid2755]

Good teacher. Articulates well and straight to rhe point

[@Maja-pf3vp]

Thanks for explaining this so well! Each step is so clear. Subscribed :D

[@alamkhan105]

Excellent, thank you, Dave!!

[@solange3172]

BEST TUTORIAL EVERRR THANK YOU!

[@nigelpallatt]

Very Good! Very well explained and demonstrated.

[@soloelite3995]

Hi Dave, You have been so helpful with this code. Thank You!

[@1909jaya]

Thank you so much!! Im your fan from now on!

[@alanwilliams8622]

Excellent thanks Dave.

[@Skilital]

Thank you so much for this awesome tutorial!

[@Kondwani_simwanza]

This the best tutorial on php. Good and straight to the point explanation

[@achmaliki8389]

mysqli_report(MYSQLI_REPORT_OFF);

[@Kondwani_simwanza]

Is this a question ?@@achmaliki8389

[@aijiexi]

I especially enjoy your tutorials; they are some of my favorites. As a person who is career-transitioning into full stack development, I would grasp further from this tutorial if it was presented separately as PHP and JS, front and back end. Your current method was most logical. However, being only slightly familiar with JavaScript, I became a bit lost when you began this tutorial's JSON/front-end section. My javascript course will start in October, but I wanted to mention this for your consideration for those who are not able to return to school for instruction. I have now subscribed to your channel. Your time and expertise are much appreciated!

[@dave-hollingworth]

Thank you very much for the feedback!

[@shewmonohoto]

Lifesaver! Thank you!!!

[@okilulbary1581]

just wow, keep going. ❤

[@lincolncardines8099]

This tutorial... Just wow... I don't know how to code as I am in the Network Admin side of IT, but with this tutorial I as able to run my very first programming page.

[@efbYouTube]

excellent stuff as always! & txs again (& again & again!!) for yr wonderful class on udemy. constantly using as a ref! u've completely won me over to php & as on an old vb programmer i genuinely never thought i'd ever say that! :)

[@Steve-Richter]

ton of info. Excellent video. thank you!

[@Shams_]

This video is like a hidden gem!

[@bamboo8212]

This is great work! I can tell you are a god. Now my mind has enlighted and I understand much more than I did before watching this video! Thank you!

[@osvaldodiasdossantos6625]

Thank you for how so well you taught this, leaving a chance for improvement from ourselves. Much appreciated.

[@farahirdina8804]

THANK YOU SO MUCH FOR THIS, YOU SAVED MY LIFE I LOVE YOU

[@mademen3804]

wow, simple and precise

[@pivotai525]

Thank you very much! Really helpful!

[@assiaissou1003]

This is super informative

[@Youcan352]

thank you, you made it very clear for me

[@daria.butterflycookies]

amazing tutorial. you explain everything very clearly and add code that is crucial for typical website building, for us not to forget. thank you very, very much!

[@mohdnaseemhashmi5457]

Very helpful. Thank you

[@onwubikojedidiahsolomon4429]

Thank you dave you helped me

[@zb2747]

Simple and clear! As long as PHP has been around it’s quite difficult to find solid tutorials - thank you!

[@vodkafordinner540]

My code stops at $stmt->execute() doesn't go to else plz answer me

[@dav2108]

@@vodkafordinner540 did you add the correct amount of strings? in $stmt->bind_param. For example I have first_name, last_name, username, password_hash. so mine is: $stmt->bind_param("ssss", $_POST["first_name"], $_POST["last_name"], $_POST["username"], $password_hash);

[@dav2108]

4 strings, 4 lots of s (as opposed to 3 lots of s in the video)

[@doso1083]

BEST TUTORIAL

[@pablofalco]

Finally, I see the whole enchilada in one go! Thank you. The only thing that it didn't work for me was just- validate, I couldn't find (yet) why not.

[@dave-hollingworth]

Check the browser console to see if there are any network errors loading the justValidate library

[@po9572]

thank you very much for this!

[@oneangelartyz1090]

thank you very much! really helpful

[@Johan_tube]

Awesome 🎉 lesson. Cool knowledge.

[@CC-rx7kt]

Thank you so much sir. This helped me a lot.

[@jonathanmotivational7036]

Well simplified

[@dayzrespite]

thank you so much for your content! It was great!

[@user-ki2gz3pj3n]

I really appreciate your work ....

[@f.t.5859]

Amazing content, every step is explained why this is happening, very calm instructor. Sad there's no javascript projects in your channel Dave. If you could indicate some channel that have the same aspects of your channel I would appreciate. Thanks.

[@gin8275]

Thanks a lot sir for this useful video. It helps me a lot for making the mid term project

[@adeelmeer3244]

I tNice tutorialnk you speak for a good portion of us.

[@AbdessamadBelm]

Amazing video,Just in the time

[@adeoyemuhdfawas]

Nice video. Thanks!👍🏿 I have a question. I don’t know if you do React. Can I follow this same process if I want to use PHP for the backend of a react project?

[@RShorts17]

Thank you😊

[@samuelkorede5100]

Also thanks for the video it really helps

[@Pedders-is9th]

Very nicely done and basically just saved my bacon, great tutorial and added a lot of security measures which are always important :)

[@kingsleyrams742]

Fatal error: Uncaught Error: Undefined constant "require_DIR_" in C:\xampp\htdocs\process-signup.php:29 Stack trace: #0 {main} thrown in C:\xampp\htdocs\process-signup.php on line 29 i keep getting this error

[@balitangsikat]

very impressive

[@user-hj5xj6pq5o]

great explanation........salute!

[@Naxx_]

you're a freaking genius jsjjsjsjsjs thanks my friend

[@dave-hollingworth]

What other topics would you like to see a video on? Please let me know!

[@aogunnaike]

I would say OOP concepts in general , Solid principle, Phpunit

[@NedumEze]

A PHP Event Calendar as I explained below. Using Datetime, PDO for database access, & dispay a message on a date that meets some criterion. Pls.

[@efbYouTube]

creating an api plz :)

[@efbYouTube]

... maybe an example manipulating SQL lite?

[@fire23hummer]

Video about pagination

[@zainkhalid3670]

Thank you very much for this. Thanks for also teaching us how to avoid SQL attacks or client-side bypasses. I've subscribed to your channel and can't wait to see more of your content. I've one question that how can I ensure that the email actually exists and is not a made-up email. I will also appreciate if you made video on how to sign up using google or apple account.

[@pivotai525]

Amazing really!

[@momohezekieltrump6835]

This tutorial is bomb 🔥;

[@ilya_123__]

thank you a lot!

[@noahwren7739]

Thank you.

[@aliadel1723]

underrated channel ♥

[@yatakitombi3965]

I like this tutorial because it's will explained on what happening on codes and step by step and simple

[@user-so5he3op1q]

Great video thanks