Difference between revisions of "PHP-and-MySQL/C4/User-Registration-Part-5/English-timed"

From Script | Spoken-Tutorial
Jump to: navigation, search
Line 22: Line 22:
 
|00:19
 
|00:19
 
|Everything has worked out fine and I am at the login screen here.
 
|Everything has worked out fine and I am at the login screen here.
 
  
 
|-
 
|-

Revision as of 17:10, 2 September 2014

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