PHP-and-MySQL/C4/User-Registration-Part-5/English-timed

From Script | Spoken-Tutorial
Revision as of 14:27, 6 February 2014 by PoojaMoolya (Talk | contribs)

Jump to: navigation, search
Time Narration
00:00 Welcome to the 5th part of the User registration tutorial.
00:04 We are going to tidy up a few bits and pieces together in our registration login process.
00:11 Then we'll give a full test to see if it really works.
00:14 In the last part, you saw that I registered myself in this database.
00:19 Everything has worked out fine and I am at the login screen here.


00:24 Lets see if I can login. Let's say username is "alex" and my password is the password that I used.
00:34 I can see that when I click in login, again, "Incorrect password".
00:40 This doesn't mean that my username hasn't been found.
00:44 Let me type this in username and type in my password.
00:49 It will tell me that user doesn't exit.
00:52 But here, it is saying that my username does exist but my password is wrong.
00:58 Now, the reason my password is wrong is that my plain text password here is being compared to my "md5-encrypted" password inside my data base.
01:11 The way we do this is, we go back to our login page, which we covered in the previous tutorial - the userlogin tutorial.
01:22 At the part where we compare our passwords to check if they match.
01:29 That's checking our username there and this is checking our password.
01:35 We need to check our password. At the moment, let's say I typed in my password as "slicer u k 1".
01:46 So, this is the password I am typing in here. Its quite an odd one.
01:53 "slicer u k 1". Okay and this is checking this and this password here is equal to slicer u k1.
02:02 But this "password" is equal "dbpassword". So we are not getting the comparison.
02:10 We get to choose this when we encrypt our password.
02:15 So now this will actually be equal to this, so this is encrypted "slicer u k 1", which is equal to this "slicer u k 1".
02:26 So we are comparing an md5 encrypted password to an md5 encrypted password in our database.
02:35 Let me resubmit this form again Oh! error again!
02:39 Let me try again. Click on login. No, its not working.
02:45 Let's check this. "password" equals to "POST password" so md5 is the password.
02:56 Let me go back and refresh this.
03:00 I type my password. Al-right, I know what the problem is here.
03:06 The problem here is that our md5 password is absolutely correct but it is being compared to a password which is cut short in our database.
03:19 That's because if we go to our structure and go down to our password field here and edit this, we have currently got a length of 25 as its limit.
03:35 So we are going increase the limit for this to, say, 100.
03:40 I am not exactly sure how long an md5 string is, but I will say length value = 100. Save that.
03:50 I am going to browse our table and delete this value. Then I am going to go back and re-register.
03.58 So, register. Choose your username.
04.02 Let's say "alex", like I said before. Choose a password, let's say "slicer u k 1". And I will click "Register".
04:14 "You have been registered. Return to login page".
04:18 Now, let's check our database again.
04:21 This is looking longer already, it hasn't been cut short because I have changed the length of this.


04:27 So now when I try to log back in and let me type this properly.
04:34 We can login and we are in. Okay so check things like string length.
04.41 Hopefully you have got this.
04.43 If you want me to expand this tutorial please just let me know.
04:48 And that is user registration.
04:50 This is followed on from our user login tutorial.
04:54 So by putting these together, we have got a fully functional user register and login process.


05:02 I will be using this in a lot of my project work. Say for example.
05:07 I might create a project on something that uses a user login and user registration. So I will be using this a lot.
05:16 So check my projects on user login and registration for more information.
05:23 If you have any questions or would like me to expand on anything, please just let me know.
05:30 border=1

Contributors and Content Editors

Gaurav, Gyan, PoojaMoolya, Sandhya.np14