Signup and Login with PHP and MySQL

แชร์
ฝัง
  • เผยแพร่เมื่อ 24 พ.ย. 2024

ความคิดเห็น • 821

  • @cosmonautilus1181
    @cosmonautilus1181 2 ปีที่แล้ว +50

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

    • @abduljayconteh1858
      @abduljayconteh1858 2 หลายเดือนก่อน

      Exactly you are right @Dave Hollingworth

  • @dannyreg8405
    @dannyreg8405 2 ปีที่แล้ว +12

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

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

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

  • @Oletechiegirl
    @Oletechiegirl 2 ปีที่แล้ว +12

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

  • @EricsWormPlayground
    @EricsWormPlayground 4 หลายเดือนก่อน +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.

  • @salma-amlas
    @salma-amlas ปีที่แล้ว +6

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

  • @nnzzz9581
    @nnzzz9581 ปีที่แล้ว +15

    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

  • @saeidvaygani
    @saeidvaygani 2 ปีที่แล้ว

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

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

  • @NetReklam-om3ds
    @NetReklam-om3ds 7 หลายเดือนก่อน

    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
    @emmanuellyons6827 10 หลายเดือนก่อน +1

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

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

  • @zbysiu100
    @zbysiu100 2 ปีที่แล้ว +2

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

  • @casiangutu545
    @casiangutu545 ปีที่แล้ว +1

    This tutorial is pure gold

  • @davidrangel7533
    @davidrangel7533 ปีที่แล้ว +1

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

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

  • @mikeg12345
    @mikeg12345 9 หลายเดือนก่อน +1

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

  • @frankkaundamukhuni
    @frankkaundamukhuni 8 หลายเดือนก่อน +2

    You are a great lecturer your code helped me

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

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

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

  • @stingerprime1386
    @stingerprime1386 6 วันที่ผ่านมา

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

  • @errollsipagan4617
    @errollsipagan4617 ปีที่แล้ว +1

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

  • @DavidHeyManS
    @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!

  • @Gelantour
    @Gelantour 9 หลายเดือนก่อน

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

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

  • @anatolydemianov9270
    @anatolydemianov9270 11 หลายเดือนก่อน

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

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

  • @Shams_
    @Shams_ ปีที่แล้ว

    Till now the best tutorial I have ever seen 👍

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

  • @shreeyachatterji7972
    @shreeyachatterji7972 ปีที่แล้ว

    Amazing tutorial loved it

  • @TheFuture36520
    @TheFuture36520 ปีที่แล้ว +1

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

  • @Maja-pf3vp
    @Maja-pf3vp ปีที่แล้ว +1

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

  • @jacoboferkalfa3476
    @jacoboferkalfa3476 ปีที่แล้ว +1

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

  • @zb2747
    @zb2747 ปีที่แล้ว

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

    • @Unscripted24Hours
      @Unscripted24Hours ปีที่แล้ว

      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)

  • @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 TH-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: th-cam.com/video/9t4MJZvRK78/w-d-xo.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.

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

  • @cortexmap
    @cortexmap ปีที่แล้ว

    Brilliant, thank you for the free and open education.

  • @osvaldodiasdossantos6625
    @osvaldodiasdossantos6625 9 หลายเดือนก่อน

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

  • @Hevletica
    @Hevletica 2 ปีที่แล้ว

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

  • @WesleyInsleyComedy
    @WesleyInsleyComedy ปีที่แล้ว +1

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

  • @AsicEdits
    @AsicEdits 8 หลายเดือนก่อน

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

  • @Kondwanisimwanza
    @Kondwanisimwanza ปีที่แล้ว

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

    • @achmaliki8389
      @achmaliki8389 ปีที่แล้ว

      mysqli_report(MYSQLI_REPORT_OFF);

    • @Kondwanisimwanza
      @Kondwanisimwanza ปีที่แล้ว

      Is this a question ?@@achmaliki8389

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

  • @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 ปีที่แล้ว

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

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

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

  • @farahirdina8804
    @farahirdina8804 ปีที่แล้ว +1

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

  • @f.t.5859
    @f.t.5859 ปีที่แล้ว +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.

  • @dave-hollingworth
    @dave-hollingworth  ปีที่แล้ว +9

    Part 2: PHP Password Reset by Email is here: th-cam.com/video/R9bfts9ZFjs/w-d-xo.html

    • @ousainoubanja2696
      @ousainoubanja2696 ปีที่แล้ว

      It's not working for me and am copying thesame

    • @dave-hollingworth
      @dave-hollingworth  ปีที่แล้ว

      @@ousainoubanja2696In what way isn't it working?

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

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

  • @Shams_
    @Shams_ ปีที่แล้ว

    This video is like a hidden gem!

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

  • @nehalkamal6490
    @nehalkamal6490 ปีที่แล้ว +1

    This channel is amazing

  • @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 TH-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!

  • @tanyidavid2755
    @tanyidavid2755 7 หลายเดือนก่อน

    Good teacher. Articulates well and straight to rhe point

  • @nigelpallatt
    @nigelpallatt 2 ปีที่แล้ว +1

    Very Good! Very well explained and demonstrated.

  • @andy_frank
    @andy_frank ปีที่แล้ว

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

  • @1909jaya
    @1909jaya 2 ปีที่แล้ว +1

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

  • @alamkhan105
    @alamkhan105 ปีที่แล้ว +1

    Excellent, thank you, Dave!!

  • @ryanford516
    @ryanford516 2 ปีที่แล้ว +1

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

  • @dave-hollingworth
    @dave-hollingworth  ปีที่แล้ว +1

    This is part 1. Part 2 is here: PHP Password Reset by Email:
    ‣ th-cam.com/video/R9bfts9ZFjs/w-d-xo.html
    and part 3 is here: PHP Account Activation by Email:
    ‣ th-cam.com/video/kC0AIip7Bww/w-d-xo.html

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

  • @好好吃-k1e
    @好好吃-k1e 2 ปีที่แล้ว

    Explanation is very clear, thank you so much!

  • @dewangatheakshana1049
    @dewangatheakshana1049 ปีที่แล้ว

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

  • @solange3172
    @solange3172 ปีที่แล้ว

    BEST TUTORIAL EVERRR THANK YOU!

  • @adeelmeer3244
    @adeelmeer3244 2 ปีที่แล้ว +1

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

  • @soloelite3995
    @soloelite3995 ปีที่แล้ว

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

  • @muhammedhassan9236
    @muhammedhassan9236 5 หลายเดือนก่อน

    best php channel imo

  • @interstellaa
    @interstellaa 4 หลายเดือนก่อน

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

  • @yatakitombi3965
    @yatakitombi3965 ปีที่แล้ว

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

  • @alanwilliams8622
    @alanwilliams8622 ปีที่แล้ว +1

    Excellent thanks Dave.

  • @Deadalive1
    @Deadalive1 2 ปีที่แล้ว +1

    Hello,
    I have a suggestion. Could you make a video of how to prevent multiple logins for a single user(because you explain so well). That would be amazing. Thank you for the help as well!

    • @dave-hollingworth
      @dave-hollingworth  2 ปีที่แล้ว

      Ok will add it to my list as a potential video, thank you for the suggestion!

  • @codecr8ive
    @codecr8ive 6 หลายเดือนก่อน

    You are the best! Thank You for yours tutorials.

  • @doso1083
    @doso1083 2 ปีที่แล้ว +1

    BEST TUTORIAL

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

  • @aliadel1723
    @aliadel1723 2 ปีที่แล้ว

    underrated channel ♥

  • @CC-rx7kt
    @CC-rx7kt ปีที่แล้ว +1

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

  • @ulti_matt
    @ulti_matt 2 ปีที่แล้ว +4

    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
      @BilalTroll 2 ปีที่แล้ว +1

      This fixed my error, many thanks!

    • @crod1232
      @crod1232 2 ปีที่แล้ว

      Worked for me! Thanks!

  • @doriomer
    @doriomer ปีที่แล้ว +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 :)

  • @davidsondavid4988
    @davidsondavid4988 10 หลายเดือนก่อน

    wow awesome, i am part of your new student

  • @flavoredtears3898
    @flavoredtears3898 8 หลายเดือนก่อน +1

    this guy is the goat

  • @pivotai525
    @pivotai525 2 ปีที่แล้ว +1

    Thank you very much! Really helpful!

  • @kylymbekmazaripov2246
    @kylymbekmazaripov2246 ปีที่แล้ว

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

  • @EricDeBeer4
    @EricDeBeer4 ปีที่แล้ว +1

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

  • @okilulbary1581
    @okilulbary1581 ปีที่แล้ว +1

    just wow, keep going. ❤

  • @chiang_tzu_hsien
    @chiang_tzu_hsien 2 ปีที่แล้ว +1

    Thanks for the best tutorial!!!
    Thanks for your patience to explain these ideas step by step!!!
    However,I have another question about working this on Vue Cli.
    If I work this on Vue Cli, what are do’s and don’ts or any tips?:)

    • @dave-hollingworth
      @dave-hollingworth  2 ปีที่แล้ว

      I'm afraid I'm not familiar with Vue Cli, but the backend techniques shown in the video should work with whatever front end Vue code you have in the browser.

  • @mademen3804
    @mademen3804 9 หลายเดือนก่อน +1

    wow, simple and precise

  • @eagle-yq7yw
    @eagle-yq7yw 6 หลายเดือนก่อน +1

    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
      @dave-hollingworth  6 หลายเดือนก่อน +1

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

    • @eagle-yq7yw
      @eagle-yq7yw 6 หลายเดือนก่อน

      @@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
      @dave-hollingworth  6 หลายเดือนก่อน +1

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

  • @moraaoo4889
    @moraaoo4889 ปีที่แล้ว +1

    thanks for your great efforts i have learned a lot from this video, and i have a question, are these practices and what you made in this video similar to the real world ?

  • @onwubikojedidiahsolomon4429
    @onwubikojedidiahsolomon4429 2 ปีที่แล้ว +1

    Thank you dave you helped me

  • @paulbawakuno1571
    @paulbawakuno1571 2 ปีที่แล้ว

    If you could do Tutorials on Huawei Cloud Services, your tutorials are very good and that area has got very limited resources. Thank you for your efforts

  • @ackinito
    @ackinito ปีที่แล้ว +1

    Fantastic tutorial!

  • @assiaissou1003
    @assiaissou1003 ปีที่แล้ว +1

    This is super informative

  • @Skilital
    @Skilital ปีที่แล้ว

    Thank you so much for this awesome tutorial!