Signup and Login with PHP and MySQL

[@cosmonautilus1181]

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

[@abduljayconteh1858]

Exactly you are right @Dave Hollingworth

[@EricsWormPlayground]

The comments in here mentioning your clear and quality message in this video were dead on. I haven’t touched PHP in years and only recently MySQL for a personal project. You connected neurons that haven’t engaged in ages, your delivery style is so good. Liked and subbed and would definitely love to learn more from you.

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

[@Oletechiegirl]

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

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

[@TheGreenOfficial]

Massive respect for you, Senior Developer! 🙌 No KZbinr explains concepts as clearly and effectively as you do. Your content is truly next-level-keep up the amazing work! 🚀🔥

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

[@salma-amlas]

i'm a beginner at php and i found this extremely clear and easy to understand! thank you so 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.

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

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

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

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

[@davidrangel7533]

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

[@retrorusty99]

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.

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

[@dave-hollingworth]

This is part 1. Part 2 is here: PHP Password Reset by Email: ‣ kzbin.info/www/bejne/iGrFl6epbr95oNU and part 3 is here: PHP Account Activation by Email: ‣ kzbin.info/www/bejne/oXSTcnyfpZx1rdk

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

[@zbysiu100]

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

[@saeidvaygani]

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

[@emmanuellyons6827]

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

[@mikeg12345]

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

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

[@soniaamari-g8s]

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

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

[@TheFuture36520]

I like your style as it is very consistent throughout.

[@markprouty5029]

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

[@frankkaundamukhuni]

You are a great lecturer your code helped me

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

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

[@shreeyachatterji7972]

Amazing tutorial loved it

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

[@errollsipagan4617]

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

[@anatolydemianov9270]

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

[@Shams_]

Till now the best tutorial I have ever seen 👍

[@Hevletica]

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

[@casiangutu545]

This tutorial is pure gold

[@Maja-pf3vp]

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

[@CanadianGuyPeter]

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

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

[@Gelantour]

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

[@WesleyInsleyComedy]

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

[@TheFuture36520]

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

[@zb2747]

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

[@Unscripted24Hours]

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

[@dav2108]

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

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

[@Unscripted24Hours]

My error msg shows up as fatal error not like a description error

[@TheMrLaito]

Same here

[@TheMrLaito]

I FIXED IT! You need to add this line mysqli_report(MYSQLI_REPORT_OFF); when creating the connection

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

[@Kondwanisimwanza]

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

[@achmaliki8389]

mysqli_report(MYSQLI_REPORT_OFF);

[@Kondwanisimwanza]

Is this a question ?@@achmaliki8389

[@cortexmap]

Brilliant, thank you for the free and open education.

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

[@stingerprime1386]

Your help has gotten my own website working wonders now. Thank you so much for the help and I hope you do well.

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

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

[@jacoboferkalfa3476]

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

[@AsicEdits]

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

[@rshekhar11]

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

[@farahirdina8804]

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

[@1909jaya]

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

[@ryanford516]

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

[@nigelpallatt]

Very Good! Very well explained and demonstrated.

[@olivermanley9463]

39:25 On line 33, I get an error saying that "event" is deprecated. What do I do?

[@dave-hollingworth]

Where do you get that error, in the editor? Does it still work in the browser?

[@NedumEze]

Please Dave, Could you do a video on MVC? Explaining the role of each part and how to set code up to achieve the objectives of the Pattern. Lots of videos on KZbin on the subject are merely showboating! Folks showing off their skills! But, you're a natural Teacher. Can you please help ground us in how MVC works? What makes Views, views, Controllers, controllers, and Models, Models and the linkages. Please, Dave.

[@dave-hollingworth]

Thank you for your kind words! I do have a video on that: kzbin.info/www/bejne/b6WXfn2Qq7d-bZo It's an older video, but it's still valid. I also have a full course on that on Udemy that I'm working on updating right now.

[@fabioto-y7w]

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.

[@joel-rg8xm]

First of all, I am a big big fan of your PHP videos and courses,. To complement what they teach, I would love to see: 1. (Besides Authentication) Authorization: Creating an Admin area in a website, assigning roles and such things • Learning the differences, pros and cons of a basic Admin area VS. a full-fledged Dashboard 2. Implementation of a shopping cart and integration with payment methods and platforms (eCommerce basics) 3. Editing and managing user uploaded images, i.e. Resize dimensions and Optimizing file sizes 4. Managing graphic content dinamically in a website i.e. CMS-like basic stuff. I just wish to learn how to allow my website's authorized users to update homepage images themselves 5. Difference and use cases for API Calling VS CRUDs to manage relational database content. i.e. API HTTP Request methods VS CRUD SQL actions (a bit confused here about when to use each) Again, THANK YOU so so much, you really outstand discretely from the crowd, a true Academic man. I really appreciate your 'THE RIGHT WAY TO DO THINGS AND BEST PRACTICES' teaching style. P.S. There are many tutorials about all of this in KZbin, nothing close to what I have learned from you. :)

[@dave-hollingworth]

Thank you so much for your kind words Joel! I've made a note of all your excellent suggestions - I'll let you know when I create some content for them!

[@joel-rg8xm]

@@dave-hollingworth I appreciate that!

[@freddiet23]

I experienced an issue at 12:50 which stumped me for ages, I ended up having to change the line to // Corrected mysqli constructor without named parameters $mysqli = new mysqli($host, $username, $password, $dbname); not sure why but it wouldn't work the other way

[@nursabrinarai1008]

Thanks!

[@dave-hollingworth]

Thank you so much for the super thanks, I really appreciate it! :-)

[@osvaldodiasdossantos6625]

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

[@dewangatheakshana1049]

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

[@alamkhan105]

Excellent, thank you, Dave!!

[@nehalkamal6490]

This channel is amazing

[@tanyidavid2755]

Good teacher. Articulates well and straight to rhe point

[@andy_frank]

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

[@adeelmeer3244]

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

[@chapo8403]

Quick question, how do I make it so that users get force redirected to the login page if they aren't logged in.

[@dave-hollingworth]

Check if the ID is stored in the session, and if not, redirect to the login page (which you can do using the "location" header using the header function)

[@chapo8403]

@@dave-hollingworth Oh alright will do this in couple of hours. I was also wondering have you made a video on a balance system. For example when users deposit a certain balance it shows up in their account (BTC Preferablly)

[@dave-hollingworth]

@@chapo8403 No but I'll consider it!

[@chapo8403]

@@dave-hollingworth Oh and another question, for some reason my JustValidate isn't working but when I use the required tag, the field is required shows up. I am also using my own CSS instead of the classless CSS. I have checked numerous amount of times in the video if I have done something wrong but that isn't the case.

[@dave-hollingworth]

@@chapo8403 Try checking the browser console to see if there are any JavaScript errors in there

[@IslandUncharted]

Great video!!! what error settings are you using in your php.ini? I am running PHP v8.1 and my errors are very different

[@dave-hollingworth]

Which error are you referring to specifically?

[@rabbit6574]

Hey, Dave this video has been helping me a lot but i can't go past minute 34:53 and i have done everything just like you did but i cant seem to make the java script "connect" oto the php file, and it keeps sowing me the normal form message when i dont insert a name. could you please help me.

[@dave-hollingworth]

Are you developing your code in a subfolder? Then you need to include that when you add the JS file in the script tag, eg. src="/subfolder/js/validate.js"

[@rabbit6574]

@@dave-hollingworth hey dave!, thank you for the help but it still doesn't work :(. Is there anyway i can send you a print or something??? Thank you in advance.

[@dave-hollingworth]

@@rabbit6574 You can use pastebin.com for code, imgur.com for images

[@rabbit6574]

@@dave-hollingworth ok, i sure will!

[@rabbit6574]

@@dave-hollingworth hey, dave! where im from i cant seem to use te imgur website :( i did everything you said but it just won't work :(((((

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

[@muhammedhassan9236]

best php channel imo

[@eagle-yq7yw]

Hi Dave! Your tutorial is great! But I have a question: if I'm doing a big project, is it an necessary to put the htdocs folder into the entire project? Or just leave signup.html and others php file following by the project's structure?

[@dave-hollingworth]

The htdocs folder is just the root folder of the web server. So yes, you can put the files wherever you like.

[@eagle-yq7yw]

@@dave-hollingworth Thanks, and one more problem is that if i want to connect the file php with the html file, i can't do like you with action and method, because in my html file it contains Yup, can you recommend any solutions in this case?

[@dave-hollingworth]

@@eagle-yq7yw I'm afraid I'm not sure what you mean - the action attribute is used to connect the form with the file that will be requested when the form is submitted.

[@Shams_]

This video is like a hidden gem!

[@soloelite3995]

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

[@rodelcrisosto499]

Why error details from $mysqli->error not showing up? It still prints the error but ignores $mysqli->error. Im talking about this 18:03

[@dave-hollingworth]

What output do you get? Is it empty or is there an error message? Try comparing your code to the code linked to in the description, see if there's a discrepancy

[@rodelcrisosto499]

There is an error message saying there's mistype in the sql which I purposely did so I could see if the die() would run. I think it would never run because my editor finds out the error before it gets to the die() function. I use VS code btw. This is the error: Fatal error: Uncaught mysqli_sql_exception: Table 'user_account.users' doesn't exist in C:\xampp\htdocs\user\signup-validate.php:35 Stack trace: #0 C:\xampp\htdocs\user\signup-validate.php(35): mysqli_stmt->prepare('INSERT INTO use...') #1 {main} thrown in C:\xampp\htdocs\user\signup-validate.php on line 35 I'm expecting that this will print instead: if(!$stmt->prepare($sql)) { die("SQL ERROR: " . $mysqli->error); }

[@dave-hollingworth]

@@rodelcrisosto499 So the error isn't printed even if you try and run the code (i.e. running it by requesting the page from a browser, not inside the editor)?

[@crod1232]

@@dave-hollingworth This is happening to me too! I am also using visual studio code and I am using the same code as the one you posted in the description. It seems like it can't reach the die() statement because it finds the error first and outputs this in the browser... " Fatal error: Uncaught mysqli_sql_exception: Duplicate entry "

[@dave-hollingworth]

@@crod1232 Are you running it from the browser directly or inside VSCode?

[@好好吃-k1e]

Explanation is very clear, thank you so much!

[@codecr8ive]

You are the best! Thank You for yours tutorials.

[@EricDeBeer4]

Will you have a video that explains how to Require users to confirm their email address before they can login?

[@dave-hollingworth]

Yep, it's on my list!

[@ulti_matt]

For anyone having issues at 18-19 minutes with Fatal error uncaught SQL exception, instead of using if ($mysqli->errno === 1062), you can use a try, catch block like: try { $stmt->execute(); } catch (mysqli_sql_exception $e) { if ($e->getCode() == 1062) { die("email address is already taken"); } }

[@BilalTroll]

This fixed my error, many thanks!

[@crod1232]

Worked for me! Thanks!

[@interstellaa]

super easy to follow. thanks so much for this tutorial!!

[@yatakitombi3965]

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

[@bamboo8212]

I would like to see how to use sessions to only display a page if the user is logged in. Thank you!

[@drorkatzir]

@dave-hollingworth Thank you. This tut is SQLi version, next step i'll convert it to PDO version. then continue to your Password Reset by Email tut. thnx again :)

[@okilulbary1581]

just wow, keep going. ❤

[@CC-rx7kt]

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

[@solange3172]

BEST TUTORIAL EVERRR THANK YOU!

[@davidsondavid4988]

wow awesome, i am part of your new student

[@jamestrey3049]

How can we add email verified OTP, sir?

[@dave-hollingworth]

I'll be adding a video on how to verify the user's email address next

[@jamestrey3049]

thank you, sir. I'm dying to learn

[@biswajitnayak1762]

This page isn’t workinglocalhost is currently unable to handle this request. HTTP ERROR 500 this is the error while running this code AFTER INPUT IN THE SIGNUP PAGE BY CLICKING SIGNUP THIS ERROR IS COMMING.

[@kylymbekmazaripov2246]

Why don't you still have a million+ subscribers yet?

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

[@dimasaldypratama2513]

Jefferson Sales done a few but not there yet

[@alanwilliams8622]

Excellent thanks Dave.