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.

[@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.

[@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!

[@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!

[@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!

[@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!!!

[@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

[@zbysiu100]

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

[@markprouty5029]

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

[@errollsipagan4617]

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

[@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 !!

[@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.

[@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

[@mikeg12345]

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

[@Hevletica]

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

[@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!

[@WesleyInsleyComedy]

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

[@TheFuture36520]

I like your style as it is very consistent throughout.

[@NetReklam-om3ds]

You are a great Teacher!!! This is the best php tutorial i've seen. There are so many tutorials where you can't understand what about they are talking. Your tutorial is step by step, so clear and easy to understand. I must watch all your videos... Thanks a lot!!!

[@emmanuellyons6827]

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

[@saeidvaygani9709]

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

[@ryanford516]

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

[@anatolydemianov9270]

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

[@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.

[@cortexmap]

Brilliant, thank you for the free and open education.

[@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.

[@CanadianGuyPeter]

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

[@jacoboferkalfa3476]

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

[@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.

[@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!

[@Maja-pf3vp]

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

[@alamkhan105]

Excellent, thank you, Dave!!

[@shreeyachatterji7972]

Amazing tutorial loved it

[@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

[@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!!!

[@davidrangel7533]

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

[@Shams_]

Till now the best tutorial I have ever seen 👍

[@nigelpallatt]

Very Good! Very well explained and demonstrated.

[@frankkaundamukhuni]

You are a great lecturer your code helped me

[@TheFuture36520]

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

[@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!

[@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! :)

[@dewangatheakshana1049]

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

[@soloelite3995]

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

[@osvaldodiasdossantos6625]

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

[@user-sl3tq8zv6k]

Explanation is very clear, thank you so much!

[@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.

[@andy_frank]

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

[@1909jaya]

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

[@casiangutu545]

This tutorial is pure gold

[@codecr8ive]

You are the best! Thank You for yours tutorials.

[@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!

[@alanwilliams8622]

Excellent thanks Dave.

[@tanyidavid2755]

Good teacher. Articulates well and straight to rhe point

[@AsicEdits]

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

[@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

[@pivotai525]

Thank you very much! Really helpful!

[@gin8275]

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

[@nehalkamal6490]

This channel is amazing

[@aaronsoto5711]

I love your videos!

[@solange3172]

BEST TUTORIAL EVERRR THANK YOU!

[@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

[@Steve-Richter]

ton of info. Excellent video. thank you!

[@farahirdina8804]

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

[@Youcan352]

thank you, you made it very clear for me

[@KristofferMorad]

You are the best!

[@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)

[@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

[@muhammedhassan9236]

best php channel imo

[@onwubikojedidiahsolomon4429]

Thank you dave you helped me

[@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

[@Skilital]

Thank you so much for this awesome tutorial!

[@CC-rx7kt]

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

[@user-ki2gz3pj3n]

I really appreciate your work ....

[@okilulbary1581]

just wow, keep going. ❤

[@dayzrespite]

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

[@ackinito]

Fantastic tutorial!

[@oneangelartyz1090]

thank you very much! really helpful

[@po9572]

thank you very much for this!

[@mohdnaseemhashmi5457]

Very helpful. Thank you

[@shewmonohoto]

Lifesaver! Thank you!!!

[@assiaissou1003]

This is super informative

[@Shams_]

This video is like a hidden gem!

[@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.

[@mademen3804]

wow, simple and precise

[@yatakitombi3965]

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

[@rshekhar11]

just one word for this video: awesom, by the way dave could you please add forgot password and email verification process if possible.

[@AbdessamadBelm]

Amazing video,Just in the time

[@dave-hollingworth]

Part 2: PHP Password Reset by Email is here: kzbin.info/www/bejne/iGrFl6epbr95oNU

[@ousainoubanja2696]

It's not working for me and am copying thesame

[@dave-hollingworth]

@@ousainoubanja2696In what way isn't it working?

[@adeelmeer3244]

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

[@andreivlaicu51]

Very good. Thank you!

[@Johan_tube]

Awesome 🎉 lesson. Cool knowledge.

[@samuelkorede5100]

Also thanks for the video it really helps

[@doso1083]

BEST TUTORIAL

[@user-hj5xj6pq5o]

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

[@pivotai525]

Amazing really!

[@segaran]

Great. Thanks brother. Awesome content. I am amazed at the speed you type the codes.😳

[@dave-hollingworth]

Thank you! There might be some editing tricks in there ;-)

[@segaran]

that is good. we learned all the important concepts as quickly as possible because of the editing. @@dave-hollingworth

[@jonathanmotivational7036]

Well simplified