Signup and Login with PHP and MySQL
HTML-код
- Опубликовано: 6 июн 2024
- 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 
Наука
This has got to be the best php tutorial on RUclips. I really appreciate your work Dave! keep going.
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!
This HAS TO BE the best tutorial I’ve seen on this subject. Excellent and thank you.
I've been struggling for days on how to setup php on my website and you just made everything clear in 45 minutes. Cheers!
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.
i'm a beginner at php and i found this extremely clear and easy to understand! thank you so much!
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!
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!!!
I've looked at a number of other login and register tutorials. This is the easiest to work with! THANKS
It's the best and most complete video i saw on that topic to create a register and login form. Thank you Dave !!
I have just discovered this wonderful tutorial of PHP. Incredible. Thank you very, very much!!!
I never found someone who explains the way you do. Thank you very much.
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
Thank you Dave. I've been brushing up my php skills and your video helped me a lot.
Very well explained. Great work, Dave! And thank you very much.
Dave, this was exactly what I was looking for, and it's a great, clear & concise tutorial - thanks for making it!
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
I like your style as it is very consistent throughout.
This is the best PHP tutorial on RUclips!
❤️❤️❤️❤️🤜🤛
Superb to-the-point video. I especially enjoyed the AJAX + API part, you nailed it under a couple of seconds.
I think this video is one of the best tuturial of creating the registration form in youtube.
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!!!
One of the best tutorials I've ever watched! Keep up the good work and thank you very much!
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!
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.
Thanks for explaining this so well! Each step is so clear. Subscribed :D
This is super informative and really explained in simple terms. Thank you!
Dave, thank you for your tutorial. Very well explained and useful.
Excellent, thank you, Dave!!
Amazing tutorial loved it
This is such a great tutorial. You explained everything step by step which is easy to understand.
Excellent tutorial. Heading to part 2. Thank you very much!!!
Till now the best tutorial I have ever seen 👍
Very Good! Very well explained and demonstrated.
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.
Explanation is very clear, thank you so much!
Thank you so much!! Im your fan from now on!
Man, I thought the thumbnail of your video was a creepypasta, but u really help me to understand the topic.
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!
Thank you very much for the feedback!
Brilliant, thank you for the free and open education.
Hi Dave, You have been so helpful with this code. Thank You!
This tutorial is pure gold
Very bright tutorial and it's so easy to understand the concepts.
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!!!
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!
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
I second the vote about being the best php tutorial on RUclips. I'm still confused (born that way) about the validation of the information before being written to the DB.
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.
You are a great lecturer your code helped me
Excellent thanks Dave.
this is gold, best tutorial I've seen so far
This is super informative and really explained in simple terms. Thank you
You are the best! Thank You for yours tutorials.
Thank you for how so well you taught this, leaving a chance for improvement from ourselves. Much appreciated.
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!
Thank you very much! Really helpful!
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!
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! :)
Good teacher. Articulates well and straight to rhe point
ton of info. Excellent video. thank you!
THANK YOU SO MUCH FOR THIS, YOU SAVED MY LIFE I LOVE YOU
thank you, you made it very clear for me
Thank you so much for this awesome tutorial!
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.
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.
Check the browser console to see if there are any network errors loading the justValidate library
BEST TUTORIAL EVERRR THANK YOU!
Very nicely done and basically just saved my bacon, great tutorial and added a lot of security measures which are always important :)
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
Simple and clear! As long as PHP has been around it’s quite difficult to find solid tutorials - thank you!
My code stops at $stmt->execute() doesn't go to else plz answer me
@@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);
4 strings, 4 lots of s (as opposed to 3 lots of s in the video)
This channel is amazing
What other topics would you like to see a video on? Please let me know!
I would say OOP concepts in general , Solid principle, Phpunit
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.
creating an api plz :)
... maybe an example manipulating SQL lite?
Video about pagination
Thank you dave you helped me
thank you so much for your content! It was great!
thank you very much for this!
I love your videos!
thank you very much! really helpful
Thank you so much sir. This helped me a lot.
You are the best!
Thanks a lot sir for this useful video. It helps me a lot for making the mid term project
Very helpful. Thank you
This video is like a hidden gem!
This the best tutorial on php. Good and straight to the point explanation
mysqli_report(MYSQLI_REPORT_OFF);
Is this a question ?@@achmaliki8389
just wow, keep going. ❤
This is super informative
I really appreciate your work ....
wow, simple and precise
Fantastic tutorial!
Lifesaver! Thank you!!!
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.
Amazing video,Just in the time
Also thanks for the video it really helps
I tNice tutorialnk you speak for a good portion of us.
Well simplified
BEST TUTORIAL
I like this tutorial because it's will explained on what happening on codes and step by step and simple
Very good. Thank you!
Awesome 🎉 lesson. Cool knowledge.
just one word for this video: awesom, by the way dave could you please add forgot password and email verification process if possible.
Part 2: PHP Password Reset by Email is here: ruclips.net/video/R9bfts9ZFjs/видео.html
It's not working for me and am copying thesame
@@ousainoubanja2696In what way isn't it working?
this guy is the goat
Amazing really!
ty this video really helpful
thank you a lot!