User Registration Form with PHP and MySQL Tutorial

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

КОМЕНТАРІ • 344

  • @adamschneider868
    @adamschneider868 6 років тому +1

    This tutorial would be bees knees if this was part 1. Then part 2 stated everything that wasn't best practice in this video. Then part 3-5 was you breaking all this out into classes and doing it the right way. I am new to php and I watched this video for the HTML and CSS, also thank for showing me how to get the POST variables. Super helpful.

  • @patriksamju
    @patriksamju 5 років тому

    newbie here but so easy to learn php with your style of explaining it clearly...

  • @Akurisuwa
    @Akurisuwa 7 років тому +8

    for people having the issue of not being able to display the success msg, the welcome + user's name msg or the picture on welcome.php
    try this:
    replace these lines:
    by these lines:
    or "prior to PHP 5.4 requires short tags be enabled in your php configuration" etc...
    stackoverflow.com/questions/2150238/php-variable-in-html-no-other-way-then-php-echo-var
    stackoverflow.com/questions/2185320/how-to-enable-php-short-tags

  • @switluvsangel
    @switluvsangel 6 років тому +12

    I love you pattern of coding, you made php look very simple. i'm a big fan. keep the good work on.

  • @michelrwekaza3907
    @michelrwekaza3907 6 років тому

    Hi Clever...Thanks! This is really well structured and I will give myself good minutes to dive into all these vids...but also try to apply the coding (ideas) to my projects (PHP, MySql etc...)

  • @vishalm1600
    @vishalm1600 7 років тому

    Great tutorial CleverTechie! Everything i needed to get started with writing actual code in php is in this video. Thanks a lot!

  • @geertmertens8481
    @geertmertens8481 7 років тому +18

    This is a great tut man! Plain, simple and to the point. Hope you have much more of this stuff that I can watch

    • @clevertechie
      @clevertechie  7 років тому +2

      Thank you! :)

    • @BinayaChaudhary
      @BinayaChaudhary 7 років тому

      Please do update the links in the description!!

    • @ApisBull
      @ApisBull 5 років тому

      @@clevertechie I want to download your files. Can they run on a UNIX Apache server?

  • @mattgallant419
    @mattgallant419 8 років тому +49

    finally a english fucking speaking tut

  • @dieprincess7439
    @dieprincess7439 4 роки тому

    wow seen a lot videos discussing about this things but i really like your videos you are a born programmer to entertain :)

  • @caterpilar
    @caterpilar 4 роки тому

    Thanks to this tutorial i was able to build cms *hat off*

  • @TeBateDoamneDoamne
    @TeBateDoamneDoamne 7 років тому

    I don't know you but you are so awesome !!!!!!!!!!!!!!!!! Thank you for being here !!!!!!!!!!!!! Maybe we could meet someday . :)

  • @adoniasmulugeta4163
    @adoniasmulugeta4163 7 років тому +4

    what is the purpose of the exclamation mark '! image !' at the beginning and at the end of the preg_match( 'image' ,$_FILES(. . .)) function?

  • @shegone7760
    @shegone7760 7 років тому +1

    YOU'RE THE BEST! thanks so much for putting this up you have no idea how much you helped me out in only 25 minutes lol

  • @amitpatelpatel144
    @amitpatelpatel144 7 років тому

    Good tutorial. You are PHP teacher on UA-cam. BEST.

  • @fsxnovice6110
    @fsxnovice6110 7 років тому +9

    hi there, very nice and straight to the point video thanks for that. I have noticed on this video one fundamental validation missing. Duplicate entry checking i.e if the username already exist in the database then what happens?
    At current state of your code, you could have multiple accounts with same username, password, email and avatar and only differentiated by the primary key in the database.

    • @alessio.o4396
      @alessio.o4396 6 років тому

      hello zak, i'm a beginner. wher did you insert that code to fix the problem of "username/email already used" ? ty

  • @tonyedward528
    @tonyedward528 5 років тому

    This video is Excellent! I appreciate your knowledge and the detailed way you communicated the information. Thank you.

  • @robertcarter6950
    @robertcarter6950 6 років тому +2

    Love your work!!!! 1 question how do i convert this form into a login system using the same string encryption. thanks

  • @rosenabedin3856
    @rosenabedin3856 7 років тому

    I have been benefited a lot of your tutorial. Please make a log out option in this connection.

  • @khalidQweder
    @khalidQweder 7 років тому

    As usual 1000 stars.

  • @ranggadimaspermadi4978
    @ranggadimaspermadi4978 7 років тому

    Finally i find this purfect tutorial, thanks dude

  • @michatymburski9843
    @michatymburski9843 6 років тому

    Hey clevertechie , i don't want to be rude but i guess you don't buy a microwave with only refroze option right ? could you do a video with functions ( check if already registered) and on login (login only when the user is registered ) ? cause i really cant find my way on fully functional Registration/ Login form . You got us covered with Avatars here so in exception could you make all the PHP for Reg / Log in different file so other files can just include ' file.php ' ?

  • @praisegod7990
    @praisegod7990 6 років тому

    Great tutorial but please how do you check if the email address is a valid email or fake email. Thanks

  • @lanaturehaitienne6652
    @lanaturehaitienne6652 7 років тому

    very good, you've been resolving my prob!

  • @zMaximoGamer
    @zMaximoGamer 7 років тому

    Very good Clever!

  • @snakeite9190
    @snakeite9190 7 років тому

    Hello. This tutorial perfect! thanks. That would be a question for you that create login panel ? not login panel.

  • @alainbriez8382
    @alainbriez8382 6 років тому

    nice tuto. I yet think that verifying the content of variable would be nice to add as a step, as only relying on html5 you give a chance to the user to edit so verfications are better on server side. otherwise, cool tuto. I liked it.

  • @nithikkag4279
    @nithikkag4279 6 років тому

    Thank you! It worked for me.

  • @mohamedalaa6561
    @mohamedalaa6561 7 років тому

    Awesome helpful as much (y) !!
    Which Netbeans version you were using here

  • @VirtualShaft
    @VirtualShaft 7 років тому

    Thank you so much! Exactly what I've been looking for!

  • @Wanish122
    @Wanish122 7 років тому

    Really awesome tutorial! I checked out your channel but I couldn't find any video about AJAX, more specifically a way to show data from a PHP without including the PHP code in the file. Are you planing on making a tutorial for that?

    • @clevertechie
      @clevertechie  7 років тому

      Yes I'm planning on making AJAX tutorials very soon, thank you for your suggestion.

  • @csandreas1
    @csandreas1 5 років тому

    Good tutorial for beginners but lucks important programming practices like prepared statements and bound parameters. Ah not to mention Post/redirect/get design pattern. Not bad but good for start.

  • @dhakprasadupreti6249
    @dhakprasadupreti6249 4 роки тому

    Thank your very much for your help.

  • @floodshot8651
    @floodshot8651 7 років тому

    Can you use Bracets for this tutorial? That would be helpful! Cool vid too!

  • @DanielWeikert
    @DanielWeikert 7 років тому

    Thanks great Tutorial. Hopefully you continue this php tutorial series. Especially security is interesting. One question. It seems that my browser never shows the picture like he's blocking it. Any ideas? Thanks

  • @franci1211
    @franci1211 4 роки тому

    Great Tutorial. Just this.

  • @KumarAnimesh935
    @KumarAnimesh935 8 років тому

    Another great tutorial :) Could you share the mysql queries you used along with the php code? (I found the html css on codepen).
    Also, I wish you also made a tutorial on login logout functionality while also explaining how does sessions exactly work how they keep the user logged in. I know there are tons of tutorials but I've benefited most from your videos.

  • @sniperalex117
    @sniperalex117 7 років тому

    Great tutorial, can you make a video on how to build such a site on wordpress ?
    I mean is it possible to add our own php and use the db on wordpress ?

  • @TeznaMoDz69
    @TeznaMoDz69 7 років тому

    Everything is working atm except for the notifications, for example when I'm on my profile page and go back to login page it is showing me this error -->
    Notice: Undefined variable: _SESSION in C:\xampp\htdocs\sign.php on line 43

  • @filiptimko3666
    @filiptimko3666 7 років тому

    Great tutorial! But what is the name of that editor?

  • @NaomiMisora1000
    @NaomiMisora1000 7 років тому

    Thank you so much for this tutorial!

  • @maxrodriguez815
    @maxrodriguez815 7 років тому +1

    Excuse me, I am lost at the part where you do the line
    mysql = new mysql('localhost', 'root,' 'mypass123')
    like how did you get all those variables? Am I supposed to type the exact same thing as you do? If not then where do I get the information to properly input the fields?

    • @dreker337
      @dreker337 7 років тому

      remove mypass123
      mysql = new mysql('localhost', 'root,' '');

  • @abdullahnadeem4519
    @abdullahnadeem4519 7 років тому

    Excellent work bro

  • @lavinkumar7766
    @lavinkumar7766 7 років тому

    nice one really appreciating 😄

  • @MinhLe-xk5rm
    @MinhLe-xk5rm 7 років тому

    Amazing tutorial! And thank you so much for providing the source code as well!

    • @clevertechie
      @clevertechie  7 років тому +1

      Thank you Cassandra, I'm glad you liked it!

    • @MinhLe-xk5rm
      @MinhLe-xk5rm 3 роки тому

      @@clevertechie Also I know this is 4 year ago, but I watched your video back in freshman year, just thinking of switching my major to CS. I didn't even know how to put together a nested for loop. Just wanting to come back and said I'm graduating this year with a CS degree and had done an internship at Google. You're awesome dude! Keep making videos like this.

  • @christiancastanares3536
    @christiancastanares3536 7 років тому +1

    Man looks so easy to you, hope I can program like that :( .

  • @creative.money_eu
    @creative.money_eu 7 років тому

    How do you get to work with MySQL although the newest version of XAMPP supports MariaDB? Are you using an older version of XAMPP? Don't you run into security issues if so?

  • @clarencehernandez4655
    @clarencehernandez4655 5 років тому

    This tutorial is good, it is really helpful !

  • @dwthai
    @dwthai 7 років тому

    Thank you for this tutorial.

  • @jiehziyang6945
    @jiehziyang6945 6 років тому

    very good stuff to keep!

  • @tehnics-optics4560
    @tehnics-optics4560 4 роки тому +1

    Hello Clever Techie,I got an error on line 25 stating that, Fatal error: Uncaught Error: Call to a member function real_escape_string() on null in C:\wamp64\www\UserRegistration\form.php on line 24 ??? ,please help me .

    • @m6xw
      @m6xw 4 роки тому

      You can remake the script

  • @codechapter6960
    @codechapter6960 6 років тому +1

    im less than 1:30 into the video and iv already spent 2hours installing diferent software!

    • @vaibhavvaidya935
      @vaibhavvaidya935 6 років тому

      bro just install sublime text editor and wamp server..simple!

  • @howtoit3291
    @howtoit3291 6 років тому

    I have a little problem. Even though the registration works, the error messages don't show up. Do you have any idea why?

  • @hokymetallica
    @hokymetallica 7 років тому

    thanks for video bro ! but, why i can't change the style on css ???

  • @jfritz6233
    @jfritz6233 5 років тому

    This video is like Lebron James teaching a bunch of Jr. High School kids how to dunk from the free throw line.

  • @jonnowood8382
    @jonnowood8382 7 років тому

    Saved my fucking ass for an assignment. Thank you so much! Took me a while to get everything working, but it was straight forward and simple. You're a legend!

  • @anooshalii
    @anooshalii 6 років тому

    Amazing tutorial

  • @stiro536
    @stiro536 6 років тому +1

    when i fill in the form and press register it says this: This page does not work
    localhost can not process this request at this time.
    HTTP ERROR 500.
    and it doesn't go into my database. does anyone know a fix?

  • @kjemradio
    @kjemradio 7 років тому +12

    You should not be teaching with MD5 hashing. It is not secure at all, and is easily cracked. A lot of people will probably use this form on their web sites and run a huge risk of this inf being stolen. I get that this is just a lesson, but you should be teaching best practices with something like bcrypt. Sorry to knock your tutorial, but this is 2017. We need to change the mindset when giving lessons on building forms.

    • @clevertechie
      @clevertechie  7 років тому

      Good point kjemradio, I actually meant to add a note about that, but since I'm using youtube's end screens instead there is no way of adding the pop up bubbles anymore....

    • @seddaouiyassine7814
      @seddaouiyassine7814 6 років тому +1

      use password_hash

    • @Nativeunderscore
      @Nativeunderscore 6 років тому

      site/.htaccess
      *deny from all*
      PLEASE ADD OR EDIT THIS CODE INTO YOUR HTACCESS AS THIS WILL DENY ALL FILE SEARCHING FROM OTHERS. thanx

    • @BobAg_
      @BobAg_ 6 років тому

      You should also never pass values directly into your SQL statement. This is what allows SQL Injection attacks.

  • @СергейМаклаков-р9т
    @СергейМаклаков-р9т 5 років тому

    Dear Sir, nice and useful tutorial. Unfortunately i have got interesting problem during test of it. I have wrote down php code and tray to test it. So i have entered differend password to test code but i did not get any Alerts. And also there are no any code mistakes. I have checked code few times, did not find any mistakes. So sorry for the stupid question what could be a problem. I use Notepad++ and XAMPP as localhost.

  • @branchyapple
    @branchyapple 7 років тому

    Nice man! You explained it pretty good :)

  • @omereli1062
    @omereli1062 7 років тому

    your web looks so awesome 😎😎😎

  • @ashmitakunwar8624
    @ashmitakunwar8624 4 роки тому

    Me: wow session, image-path, form validation, I am going to pass my exam.
    Also me: what am I doing here??

  • @afif8488
    @afif8488 7 років тому +1

    wow are you blizzard game fan?
    this is rare... btw thanks for the tutorial bro...

  • @AhteshamAhmed
    @AhteshamAhmed 7 років тому

    Oh man!

  • @OllisLevy
    @OllisLevy 7 років тому

    thank you , you helped me a lot

  • @Nyxi93
    @Nyxi93 3 роки тому

    hi, am gettting array() message after registering? how does a database 'accounts' know you want to put information into table users?

  • @slambodianjones
    @slambodianjones 7 років тому

    I've changed the images folder to image folder but still get file upload failed, when I spit out the path with print_r it shows the path as image/photo.jpg
    I created the database with ubuntu terminal if that makes any difference.

  • @vicikiehm5264
    @vicikiehm5264 5 років тому

    I am very new to this website building, don't know much code. I tried to follow your video and got as far as copying and pasting from your code pen into the two different files that I saved in their own folder. Problem is when I try to look the result in the browser window, on the php page i get a whtie screen with little grey botton up in the left corner. Mine looks nothing like your layout. What am I doing wrong. The html code has been copied so it has all the headers and title page stuff, I have also relinked to the css file, still nothing, I have 2 separate things. Please help me figure out what I am doing wrong. I need to try link a register form to a database. I did downloand the workbench I saw on your video, worked far easier than doing it in my php admin - thanks for that one.

  • @tsvetomir5309
    @tsvetomir5309 5 років тому

    good job man keep going

  • @benzenhorlerkunley6855
    @benzenhorlerkunley6855 6 років тому

    Please i don't understand the how you set up the MySQL workbench....

  • @massecurity404
    @massecurity404 5 років тому

    cant access the variables to be displayed on the welcome page "Undefined index" even though everything else works and code is correct

  • @mauriciodavila2357
    @mauriciodavila2357 6 років тому

    sites like wrodpress allow the building of pages with user registration form do you know any reason why building it this way is preferable

  • @needmemore31
    @needmemore31 6 років тому

    Hello, How can you do it?.
    Create a file add.php witch provide form contain fields first name , last name, and email, image. Using
    post method to submit form and action process_add.php . in process_add.php get all data from form
    then write to files(users.txt) and upload image to server.

  • @zpango2000
    @zpango2000 7 років тому

    in localhost , with xampp, my form doesnt look like that after copying the html and css . What i am doing wrong? Thanks

  • @mediel6378
    @mediel6378 7 років тому

    This is what I call an awesome video!!
    how can we do the same on an online host?

    • @clevertechie
      @clevertechie  7 років тому

      You just upload all the files to an online host

  • @audihanafi2006
    @audihanafi2006 6 років тому +1

    thankyou, it's work

  • @fantasticmrturtle
    @fantasticmrturtle 7 років тому

    so my sign up info is in a drop down box in a pull out side bar. it works great except for the error bar which is always displayed but with no text and if i do get an error the page will reload and you have to click the sign up area again to see the error message. what i want is for the page to reload and instantly display the sign up area with the error message. how would i do that?

  • @softtonysoft4091
    @softtonysoft4091 6 років тому

    Can i edit same code for adding more info like First, Last name, address, account type e.t.c I will need a clarification. Awesome video and please get back

  • @jabamotovlog
    @jabamotovlog 6 років тому

    hi i want to ask a question how i can create modals instead of echo.. thank you.

  • @VarlMuN
    @VarlMuN 3 роки тому

    Sir how can i made auto back in home or register page when message say successfully register on your register site? What is the code and were to put it?

  • @AriannaEuryaleMusic
    @AriannaEuryaleMusic 7 років тому

    Can users be able to for example look at aPDF file, or a jpg file within their own accounts?
    and change their own info like a date or password?
    Great Tutorial by the way..

    • @clevertechie
      @clevertechie  7 років тому

      This is a good suggestion, thanks! I will make a follow up video on this that will go into EDIT account functionality in detail.

  • @BenKopec
    @BenKopec 5 років тому

    How do you get "New" to appear above information_schema?

  • @evanwalt
    @evanwalt 5 років тому

    Do you have a tutorial of php forget password and also account registration verification in php? please?

  • @method6938
    @method6938 6 років тому

    If i did not want people to have to upload avatars, would i just miss out the avatar bits?

  • @waseemgul6839
    @waseemgul6839 6 років тому +2

    wow So Great Work awesome

  • @Mr_Brian
    @Mr_Brian 6 років тому

    Hi there. I am getting a delimiter error that must not be alphanumeric or backslash. Help

  • @samiulshakil
    @samiulshakil 6 років тому

    Nice Tutorial

  • @UmairAli
    @UmairAli 6 років тому

    can't you create a good playlist for these tutorials ?

  • @jedlirio8999
    @jedlirio8999 7 років тому

    I could not connect my registration to the database. What could be the possible problem? it only refresh when I register

  • @rhedondeluna2010
    @rhedondeluna2010 5 років тому

    nice work

  • @mahmoudsouayfan1219
    @mahmoudsouayfan1219 7 років тому

    what is the text editor you are using?

  • @briantodi1489
    @briantodi1489 7 років тому +2

    I keep getting a "file upload failed" error but my code is exactly the same as in the video. Please help

  • @dakilangartist3346
    @dakilangartist3346 7 років тому

    Thanks Man!!!!

  • @p.d.klumpp9853
    @p.d.klumpp9853 7 років тому

    downloaded the code. get error message "file upload failed".
    What can I do?

  • @TheEtsgp1
    @TheEtsgp1 7 років тому

    hey who do you use for hosting im using bluehost and cant connect?

  • @hasnatkabir8903
    @hasnatkabir8903 6 років тому

    What was the text editor ,I liked it

  • @belialmoreno634
    @belialmoreno634 7 років тому

    Thanks!

  • @willweis1386
    @willweis1386 6 років тому

    I am running a local server, but I only see the code once I add php. Is there any way to see the actual page?

  • @kevsrox
    @kevsrox 7 років тому +1

    Please give the link to download those avatars!

  • @VijaySharma-ds6ie
    @VijaySharma-ds6ie 7 років тому

    Is there any video on how to setup net beans for PHP and MySql?