Signup and Login with PHP and MySQL
Vložit
- čas přidán 27. 07. 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 - Věda a technologie
This has got to be the best php tutorial on CZcams. 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!
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.
This HAS TO BE the best tutorial I’ve seen on this subject. Excellent and thank you.
i'm a beginner at php and i found this extremely clear and easy to understand! thank you so much!
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!!!
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've been struggling for days on how to setup php on my website and you just made everything clear in 45 minutes. Cheers!
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!
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.
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.
Superb to-the-point video. I especially enjoyed the AJAX + API part, you nailed it under a couple of seconds.
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
Very well explained. Great work, Dave! And thank you very much.
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!!!
I second the vote about being the best php tutorial on CZcams. I'm still confused (born that way) about the validation of the information before being written to the DB.
This is the best PHP tutorial on CZcams!
❤️❤️❤️❤️🤜🤛
Dave, this was exactly what I was looking for, and it's a great, clear & concise tutorial - thanks for making it!
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!
I like your style as it is very consistent throughout.
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.
Man, I thought the thumbnail of your video was a creepypasta, but u really help me to understand the topic.
One of the best tutorials I've ever watched! Keep up the good work and thank you very much!
This is super informative and really explained in simple terms. Thank you!
Amazing tutorial loved it
This is such a great tutorial. You explained everything step by step which is easy to understand.
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.
Thanks for explaining this so well! Each step is so clear. Subscribed :D
This tutorial is pure gold
Till now the best tutorial I have ever seen 👍
Dave, thank you for your tutorial. Very well explained and useful.
Excellent tutorial. Heading to part 2. Thank you very much!!!
Excellent, thank you, Dave!!
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!
Hi Dave, You have been so helpful with this code. Thank You!
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
Very Good! Very well explained and demonstrated.
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! :)
Explanation is very clear, thank you so much!
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!!!
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!
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!
Brilliant, thank you for the free and open education.
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
This is super informative and really explained in simple terms. Thank you
Thank you so much!! Im your fan from now on!
Very bright tutorial and it's so easy to understand the concepts.
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)
Excellent thanks Dave.
You are a great lecturer your code helped me
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
this is gold, best tutorial I've seen so far
Thank you for how so well you taught this, leaving a chance for improvement from ourselves. Much appreciated.
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.
ton of info. Excellent video. thank you!
Thank you very much! Really helpful!
You are the best! Thank You for yours tutorials.
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
THANK YOU SO MUCH FOR THIS, YOU SAVED MY LIFE I LOVE YOU
thank you, you made it very clear for me
BEST TUTORIAL EVERRR THANK YOU!
This video is like a hidden gem!
This channel is amazing
Thank you so much for this awesome tutorial!
super easy to follow. thanks so much for this tutorial!!
I love your videos!
Part 2: PHP Password Reset by Email is here: czcams.com/video/R9bfts9ZFjs/video.html
It's not working for me and am copying thesame
@@ousainoubanja2696In what way isn't it working?
just wow, keep going. ❤
thank you so much for your content! It was great!
thank you very much for this!
Good teacher. Articulates well and straight to rhe point
Thank you dave you helped me
thank you very much! really helpful
This the best tutorial on php. Good and straight to the point explanation
mysqli_report(MYSQLI_REPORT_OFF);
Is this a question ?@@achmaliki8389
Perfect video, thank you for making it.
best php channel imo
Very helpful. Thank you
You are the best!
Thank you so much sir. This helped me a lot.
Thanks a lot sir for this useful video. It helps me a lot for making the mid term project
This is super informative
I really appreciate your work ....
Amazing video,Just in the time
Fantastic tutorial!
I tNice tutorialnk you speak for a good portion of us.
Awesome 🎉 lesson. Cool knowledge.
Lifesaver! Thank you!!!
wow, simple and precise
wow awesome, i am part of your new student
Also thanks for the video it really helps
I like this tutorial because it's will explained on what happening on codes and step by step and simple
Well explained!
very informative, I tNice tutorialnk you raised a lot of softians
you're a freaking genius jsjjsjsjsjs thanks my friend
underrated channel ♥