Signup and Login with PHP and MySQL

Поділитися
Вставка
  • Опубліковано 9 лют 2025

КОМЕНТАРІ • 826

  • @cosmonautilus1181
    @cosmonautilus1181 2 роки тому +50

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

  • @Oletechiegirl
    @Oletechiegirl 2 роки тому +14

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

  • @samuelrichard4117
    @samuelrichard4117 Рік тому +3

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

  • @EricsWormPlayground
    @EricsWormPlayground 7 місяців тому +1

    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.

  • @nnzzz9581
    @nnzzz9581 2 роки тому +16

    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!

  • @DavidEMunozR
    @DavidEMunozR Рік тому +2

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

    • @kingsleyrams742
      @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

  • @lincolncardines8099
    @lincolncardines8099 Рік тому +3

    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.

  • @TheGreenOfficial
    @TheGreenOfficial Місяць тому +1

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

  • @dannyreg8405
    @dannyreg8405 2 роки тому +12

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

  • @salma-amlas
    @salma-amlas 2 роки тому +6

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

  • @davidrangel7533
    @davidrangel7533 Рік тому +1

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

  • @ayam3330
    @ayam3330 Рік тому +2

    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

  • @dave-hollingworth
    @dave-hollingworth  2 роки тому +22

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

    • @aogunnaike
      @aogunnaike 2 роки тому +5

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

    • @NedumEze
      @NedumEze 2 роки тому +3

      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
      @efbYouTube 2 роки тому +2

      creating an api plz :)

    • @efbYouTube
      @efbYouTube 2 роки тому +2

      ... maybe an example manipulating SQL lite?

    • @fire23hummer
      @fire23hummer 2 роки тому +3

      Video about pagination

  • @emmanuellyons6827
    @emmanuellyons6827 Рік тому +1

    This is the best PHP tutorial on UA-cam!
    ❤️❤️❤️❤️🤜🤛

  • @NetReklam-om3ds
    @NetReklam-om3ds 9 місяців тому

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

  • @retrorusty99
    @retrorusty99 2 роки тому +7

    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.

  • @zbysiu100
    @zbysiu100 2 роки тому +2

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

  • @annemimosa
    @annemimosa 2 роки тому

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

  • @mikeg12345
    @mikeg12345 Рік тому +1

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

  • @saeidvaygani
    @saeidvaygani 2 роки тому

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

  • @frankkaundamukhuni
    @frankkaundamukhuni 10 місяців тому +2

    You are a great lecturer your code helped me

  • @Kigenyi_Rahman
    @Kigenyi_Rahman 5 днів тому

    Nice one so far This is the best with enough descriptions

  • @soniaamari-g8s
    @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
    @DavidHeyManS 2 роки тому

    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!

  • @markprouty5029
    @markprouty5029 2 роки тому

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

  • @TheFuture36520
    @TheFuture36520 Рік тому +1

    I like your style as it is very consistent throughout.

  • @casiangutu545
    @casiangutu545 Рік тому +1

    This tutorial is pure gold

  • @anatolydemianov9270
    @anatolydemianov9270 Рік тому

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

  • @nursabrinarai1008
    @nursabrinarai1008 2 роки тому

    Thanks!

    • @dave-hollingworth
      @dave-hollingworth  2 роки тому

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

  • @nicoschulz4037
    @nicoschulz4037 2 роки тому +3

    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
      @dave-hollingworth  2 роки тому +4

      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
    @dijanamatkovic6136 2 роки тому +2

    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.

  • @dave-hollingworth
    @dave-hollingworth  Рік тому +9

    Part 2: PHP Password Reset by Email is here: ua-cam.com/video/R9bfts9ZFjs/v-deo.html

  • @stingerprime1386
    @stingerprime1386 2 місяці тому

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

  • @sixtusushahemba9419
    @sixtusushahemba9419 2 роки тому +4

    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.

  • @Maja-pf3vp
    @Maja-pf3vp Рік тому +1

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

  • @zb2747
    @zb2747 2 роки тому

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

    • @Unscripted24Hours
      @Unscripted24Hours 2 роки тому

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

    • @dav2108
      @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
      @dav2108 Рік тому

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

  • @errollsipagan4617
    @errollsipagan4617 2 роки тому +1

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

  • @Gelantour
    @Gelantour 11 місяців тому

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

  • @pablofalco
    @pablofalco 2 роки тому

    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
      @dave-hollingworth  2 роки тому

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

  • @shreeyachatterji7972
    @shreeyachatterji7972 Рік тому

    Amazing tutorial loved it

  • @aijiexi
    @aijiexi Рік тому +1

    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!

  • @jacoboferkalfa3476
    @jacoboferkalfa3476 Рік тому +1

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

  • @Shams_
    @Shams_ Рік тому

    Till now the best tutorial I have ever seen 👍

  • @NedumEze
    @NedumEze 2 роки тому +3

    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 UA-cam 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
      @dave-hollingworth  2 роки тому +1

      Thank you for your kind words! I do have a video on that: ua-cam.com/video/9t4MJZvRK78/v-deo.html
      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.

  • @osvaldodiasdossantos6625
    @osvaldodiasdossantos6625 11 місяців тому

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

  • @WesleyInsleyComedy
    @WesleyInsleyComedy Рік тому +1

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

  • @dave-hollingworth
    @dave-hollingworth  Рік тому +1

    This is part 1. Part 2 is here: PHP Password Reset by Email:
    ‣ ua-cam.com/video/R9bfts9ZFjs/v-deo.html
    and part 3 is here: PHP Account Activation by Email:
    ‣ ua-cam.com/video/kC0AIip7Bww/v-deo.html

  • @Hevletica
    @Hevletica 2 роки тому

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

  • @TheFuture36520
    @TheFuture36520 Рік тому +1

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

  • @Pedders-is9th
    @Pedders-is9th Рік тому +1

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

    • @kingsleyrams742
      @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

  • @cortexmap
    @cortexmap Рік тому

    Brilliant, thank you for the free and open education.

  • @farahirdina8804
    @farahirdina8804 Рік тому +1

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

  • @AsicEdits
    @AsicEdits 10 місяців тому

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

  • @Kondwanisimwanza
    @Kondwanisimwanza 2 роки тому

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

  • @efbYouTube
    @efbYouTube 2 роки тому +4

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

  • @alamkhan105
    @alamkhan105 Рік тому +1

    Excellent, thank you, Dave!!

  • @andy_frank
    @andy_frank Рік тому

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

  • @muhammedhassan9236
    @muhammedhassan9236 8 місяців тому

    best php channel imo

  • @1909jaya
    @1909jaya 2 роки тому +1

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

  • @nehalkamal6490
    @nehalkamal6490 Рік тому +1

    This channel is amazing

  • @daria.butterflycookies
    @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!

  • @CanadianGuyPeter
    @CanadianGuyPeter 2 роки тому

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

  • @Suskanna
    @Suskanna 2 роки тому +1

    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!

  • @interstellaa
    @interstellaa 7 місяців тому

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

  • @tanyidavid2755
    @tanyidavid2755 9 місяців тому

    Good teacher. Articulates well and straight to rhe point

  • @bamboo8212
    @bamboo8212 2 роки тому

    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!

  • @rshekhar11
    @rshekhar11 2 роки тому +2

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

  • @bonjr2854
    @bonjr2854 2 роки тому

    Instead of the error code, I get "Fatal error: Uncaught mysqli_sql_exception:". I understand that this mean I should have some sort of try/catch, but I have been following the tutorial and was expecting to get the same results as you. Any idea what my be wrong?

    • @bonjr2854
      @bonjr2854 2 роки тому

      Fatal error: Uncaught mysqli_sql_exception: Duplicate entry 'dan@gmail.com' for key 'email' in ...\process-signup.php:43 Stack trace: #0 ...\process-signup.php(43): mysqli_stmt->execute() #1 {main} thrown in ...\process-signup.php on line 43

    • @dave-hollingworth
      @dave-hollingworth  2 роки тому +1

      @@bonjr2854 It could depend on your local PHP configuration, which could be different to mine - to catch that, you could add a try catch block and check for the 1062 error code

    • @bonjr2854
      @bonjr2854 2 роки тому

      @@dave-hollingworth With a try/catch, how do I then grab the code from the exception?
      try {
      $stmt->execute();
      }
      catch (mysqli_sql_exception $e) {
      die($e);
      }

    • @bonjr2854
      @bonjr2854 2 роки тому

      @@dave-hollingworth If I do a similar call with $mysqli->error . " " . $mysqli->errorno inside the catch, I get the following error:
      Warning: Undefined property: mysqli::$errorno in C:\Users\...\process-signup.php on line 50
      Duplicate entry 'nuages@gmail.com' for key 'email'

    • @dave-hollingworth
      @dave-hollingworth  2 роки тому +1

      @@bonjr2854 The property is called "errno", not "errorno" - so it would be $mysqli->errno

  • @nigelpallatt
    @nigelpallatt 2 роки тому +1

    Very Good! Very well explained and demonstrated.

  • @ryanford516
    @ryanford516 2 роки тому +1

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

  • @fabioto-y7w
    @fabioto-y7w Рік тому +1

    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.

  • @codecr8ive
    @codecr8ive 9 місяців тому

    You are the best! Thank You for yours tutorials.

  • @joel-rg8xm
    @joel-rg8xm 2 роки тому +1

    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 UA-cam, nothing close to what I have learned from you. :)

    • @dave-hollingworth
      @dave-hollingworth  2 роки тому +4

      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
      @joel-rg8xm 2 роки тому

      @@dave-hollingworth I appreciate that!

  • @Shams_
    @Shams_ Рік тому

    This video is like a hidden gem!

  • @okilulbary1581
    @okilulbary1581 Рік тому +1

    just wow, keep going. ❤

  • @好好吃-k1e
    @好好吃-k1e 2 роки тому

    Explanation is very clear, thank you so much!

  • @soloelite3995
    @soloelite3995 Рік тому

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

  • @adeelmeer3244
    @adeelmeer3244 2 роки тому +1

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

  • @alanwilliams8622
    @alanwilliams8622 2 роки тому +1

    Excellent thanks Dave.

  • @CC-rx7kt
    @CC-rx7kt Рік тому +1

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

  • @solange3172
    @solange3172 2 роки тому

    BEST TUTORIAL EVERRR THANK YOU!

  • @segaran
    @segaran Рік тому

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

    • @dave-hollingworth
      @dave-hollingworth  Рік тому

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

    • @segaran
      @segaran Рік тому +1

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

  • @dewangatheakshana1049
    @dewangatheakshana1049 2 роки тому

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

  • @drorkatzir
    @drorkatzir Рік тому +1

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

  • @FromLake
    @FromLake 7 місяців тому

    Perfect video, thank you for making it.

  • @yatakitombi3965
    @yatakitombi3965 Рік тому

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

  • @pivotai525
    @pivotai525 2 роки тому +1

    Thank you very much! Really helpful!

  • @zainkhalid3670
    @zainkhalid3670 Рік тому +1

    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.

  • @KristofferMorad
    @KristofferMorad Рік тому +1

    You are the best!

  • @oneangelartyz1090
    @oneangelartyz1090 Рік тому +1

    thank you very much! really helpful

  • @Muhammad-ZahidAli
    @Muhammad-ZahidAli Рік тому +1

    I really appreciate your work ....

  • @ackinito
    @ackinito Рік тому +1

    Fantastic tutorial!

  • @shibinpj1422
    @shibinpj1422 6 місяців тому +1

    Well explained!

  • @mademen3804
    @mademen3804 Рік тому +1

    wow, simple and precise

  • @onwubikojedidiahsolomon4429
    @onwubikojedidiahsolomon4429 2 роки тому +1

    Thank you dave you helped me

  • @Naxx_
    @Naxx_ 2 роки тому

    you're a freaking genius jsjjsjsjsjs thanks my friend

  • @assiaissou1003
    @assiaissou1003 2 роки тому +1

    This is super informative

  • @kylymbekmazaripov2246
    @kylymbekmazaripov2246 2 роки тому

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

  • @shewmonohoto
    @shewmonohoto Рік тому +1

    Lifesaver! Thank you!!!

  • @jaironaranjo3654
    @jaironaranjo3654 Рік тому +1

    Thank you so much you are great! i did not find the like icon