Difference between revisions of "PHP-and-MySQL/C4/User-Registration-Part-5/English"
From Script | Spoken-Tutorial
(Created page with '{| border=1 !Time !Narration |- |0:00 |Welcome to the 5th part of the User registration tutorial. We are going to tidy up a few bits and pieces together in our registration login…') |
Pravin1389 (Talk | contribs) |
(No difference)
| |
Revision as of 21:40, 1 December 2012
| Time | Narration |
|---|---|
| 0:00 | Welcome to the 5th part of the User registration tutorial. We are going to tidy up a few bits and pieces together in our registration login process. |
| 0:11 | Then we'll give a full test to see if it really works. |
| 0:14 | In the last part, you saw that I registered myself in this database. Everything has worked out fine and I am at the login screen here. |
| 0:24 | Lets see if I can login. Let's say username is "alex" and my password is the password that I used. |
| 0:33 | I can see that when I click in login, again, "Incorrect password". |
| 0:37 | This doesn't mean that my username hasn't been found. |
| 0:40 | Let me type this in username and type in my password. It will tell me "That user doesn't exists!". |
| 0:50 | But here, it is saying that my username does exist but my password is wrong. |
| 0:55 | 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. |
| 1:07 | The way we do this is, we go back to our login page, which we covered in the previous tutorial - the userlogin tutorial. |
| 1:18 | At the part where we compare our passwords to check if they match. That's checking our username there and this is checking our password. |
| 1:34 | We need to check our password. At the moment, let's say I typed in my password as "slicer u k 1". |
| 1:47 | So, this is the password I am typing in here. Its quite an old one. |
| 1:56 | "slicer u k 1". Okay and this is checking this and this password here is equal to sliceruk1. |
| 2:06 | But this "password" is equal "dbpassword". So we are not getting the comparison. |
| 2:12 | We get to choose this when we encrypt our password. |
| 2:19 | 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". |
| 2:30 | So we are comparing an md5 encrypted password to an md5 encrypted password in our database. |
| 2:37 | Let me resubmit this form again and login. Oh! error again! |
| 2:42 | Let me try again. Click on login. No, its not working. |
| 2:47 | Let's check this. "password" equals to "POST password" so md5 is the password. Let me go back and refresh this. |
| 3:01 | I type my password. Al-right, I know what the problem is here. |
| 3:10 | 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. |
| 3:22 | 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. |
| 3:37 | So we are going increase the limit for this to, say, 100. |
| 3:43 | I am not exactly sure how long an md5 string is, but I will say length value = 100. Save that. |
| 3:50 | I am going to browse our table and delete this value. Then I am going to go back and re-register. |
| 4.00 | So, register. Choose your username. Let's say "alex", like I said before. Choose a password, let's say "slicer u k 1". And I will click "Register". |
| 4:14 | "You have been registered. Return to login page". |
| 4:17 | Now, let's check our database again. This is looking longer already, it hasn't been cut short because I have changed the length of this. |
| 4:27 | So now when I try to log back in and let me type this properly. |
| 4:33 | We can login and we are in. Okay so check things like string length. |
| 4.43 | Hopefully you have got this. |
| 4.45 | If you want me to expand this tutorial please just let me know. |
| 4:52 | And that is user registration. |
| 4:55 | This is followed on from our user login tutorial. So by putting these together, we have got a fully functional user register and login process. |
| 5:04 | I will be using this in a lot of my project work. Say for example. |
| 5:12 | I might create a project on something that uses a user login and user registration. So I will be using this a lot. |
| 5:19 | So check my projects on user login and registration for more information. |
| 5:28 | If you have any questions or would like me to expand on anything, please just let me know. |
| 5:35 | Please subscribe for updates in the future. Thanks for watching. This is _________ dubbing for the Spoken Tutorial project. |
