Difference between revisions of "PHP-and-MySQL/C4/User-Registration-Part-5/English-timed"
From Script | Spoken-Tutorial
| 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 |
