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

From Script | Spoken-Tutorial
Jump to: navigation, search
(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…')
 
 
(6 intermediate revisions by 3 users not shown)
Line 1: Line 1:
 
{| border=1
 
{| border=1
−
!Time
+
|'''Time'''
−
!Narration
+
|'''Narration'''
 +
 
 
|-
 
|-
−
|0:00
+
|00: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.
+
|Welcome to the 5th part of the '''User Registration''' tutorial.  
 +
 
 
|-
 
|-
−
|0:11
+
|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.  
 
|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. 
 +
 
|-
 
|-
−
|0:14
+
|00:19
−
|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.
+
|Everything has worked out fine and I am at the login screen here.
 +
 
 
|-
 
|-
−
|0:24
+
|00:24
−
|Lets see if I can login. Let's say username is "alex" and my password is the password that I used.
+
|Let's see if I can login. Let's say '''Username''' is "alex" and my '''Password''' is the password that I used.
 +
 
 
|-
 
|-
−
|0:33
+
|00:34
−
|I can see that when I click in login, again, "Incorrect password".
+
|I can see that when I click in '''Login''', again, "Incorrect password".
 +
 
 
|-
 
|-
−
|0:37
+
|00:40
 
|This doesn't mean that my username hasn't been found.
 
|This doesn't mean that my username hasn't been found.
 +
 
|-
 
|-
−
|0:40
+
|00:44
−
|Let me type this in username and type in my password. It will tell me "That user doesn't exists!".
+
|Let me type this in '''Username''' and type in my password.  
 +
 
 
|-
 
|-
−
|0:50
+
|00:49
 +
|It will tell me "That user doesn't exist".
 +
 
 +
|-
 +
|00:52
 
|But here, it is saying that my username does exist but my password is wrong.  
 
|But here, it is saying that my username does exist but my password is wrong.  
 +
 
|-
 
|-
−
|0:55
+
|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.
 
|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
+
|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.
+
|The way we do this is, we go back to our login page which we covered in the previous tutorial - the '''User Login''' tutorial.
 +
 
 
|-
 
|-
−
|1:18
+
|01:22
−
|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.
+
|At the part where we compare our passwords to check if they match.  
 +
 
 
|-
 
|-
−
|1:34
+
|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".  
 
|We need to check our password.  At the moment, let's say I typed in my password as "slicer u k 1".  
 +
 
|-
 
|-
−
|1:47
+
|01:46
−
|So, this is the password I am typing in here.  Its quite an old one.
+
|So, this is the password I am typing in here.  It's quite an odd one.
 +
 
 
|-
 
|-
−
|1:56
+
|01:53
−
|"slicer u k 1". Okay and this is checking this and this password here is equal to sliceruk1.
+
|"slicer u k 1". Okay, and this is checking this and this password here is equal to slicer u k 1.
 +
 
 
|-
 
|-
−
|2:06
+
|02:02
−
|But this "password" is equal "dbpassword". So we are not getting the comparison.  
+
|But this "password" is equal "dbpassword". So, we are not getting the comparison.  
 +
 
 
|-
 
|-
−
|2:12
+
|02:10
 
|We get to choose this when we encrypt our password.
 
|We get to choose this when we encrypt our password.
 +
 
|-
 
|-
−
|2:19
+
|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".  
+
|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
+
|02:26
−
|So we are comparing an md5 encrypted password to an md5 encrypted password in our database.
+
|So, we are comparing an "md5" encrypted password to an "md5" encrypted password in our database.
 +
 
 
|-
 
|-
−
|2:37
+
|02:35
−
|Let me resubmit this form again and login. Oh! error again!   
+
|Let me resubmit this '''form''' again.   Error again!   
 +
 
 
|-
 
|-
−
|2:42
+
|02:39
−
|Let me try again.  Click on login. No, its not working.
+
|Let me try again.  Click on '''Login'''. No, it's not working.
 +
 
 
|-
 
|-
−
|2:47
+
|02:45
−
|Let's check this. "password" equals to "POST password" so md5 is the password. Let me go back and refresh this.
+
|Let's check this. "$password" equals to "POST password", so "md5" is the password.  
 +
 
 
|-
 
|-
−
|3:01
+
|02:56
 +
|Let me go back and refresh this.
 +
 
 +
|-
 +
|03:00
 
|I type my password. Al-right, I know what the problem is here.  
 
|I type my password. Al-right, I know what the problem is here.  
 +
 
|-
 
|-
−
|3:10
+
|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.
+
|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
+
|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.
+
|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
+
|03:35
−
|So we are going increase the limit for this to, say, 100.   
+
|So we are going to increase the limit for this to, say, 100.   
 +
 
 
|-
 
|-
−
|3:43
+
|03:40
−
|I am not exactly sure how long an md5 string is, but I will say length value = 100.  Save that.
+
|I am not exactly sure how long an "md5" string is, but I will say length value = 100.  '''Save''' that.
 +
 
 
|-
 
|-
−
|3:50
+
|03:50
 
|I am going to browse our table and delete this value. Then I am going to go back and re-register.
 
|I am going to browse our table and delete this value. Then I am going to go back and re-register.
 +
 
|-
 
|-
−
|4.00
+
|03:58
−
|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".
+
|So, register.  Choose your 'username'.  
 +
 
 
|-
 
|-
−
|4:14
+
|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".
 
|"You have been registered. Return to login page".
 +
 
|-
 
|-
−
|4:17
+
|04:18
−
|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.
+
|Now, let's check our database again.
 +
 
 
|-
 
|-
−
|4:27
+
|04:21
−
|So now when I try to log back in and let me type this properly.  
+
| This is looking longer already, it hasn't been cut short because I have changed the length of this.
 +
 
 
|-
 
|-
−
|4:33
+
|04:27
−
|We can login and we are in. Okay so check things like string length.
+
|So, now when I try to log back in and let me type this properly.  
 +
 
 
|-
 
|-
−
|4.43
+
|04:34
 +
|We can login and we are in. Okay, so check things like string length.
 +
 
 +
|-
 +
|04:41
 
|Hopefully you have got this.  
 
|Hopefully you have got this.  
 +
 
|-
 
|-
−
|4.45
+
|04:43
 
|If you want me to expand this tutorial please just let me know.
 
|If you want me to expand this tutorial please just let me know.
 +
 +
|-
 +
|04:48
 +
|And that is '''User Registration'''.
 +
 
|-
 
|-
−
|4:52
+
|04:50
−
|And that is user registration.  
+
|This is followed on from our '''User Login''' tutorial.  
 +
 
 
|-
 
|-
−
|4:55
+
|04:54
−
|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.  
+
|So by putting these together, we have got a fully functional '''user register''' and '''login''' process.
 +
 
|-
 
|-
−
|5:04
+
|05:02
−
|I will be using this in a lot of my project work. Say for example.
+
|I will be using this in a lot of my project work. Say for example,
 +
 
 
|-
 
|-
−
|5:12
+
|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.
 
|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
+
|05:16
−
|So check my projects on user login and registration for more information.  
+
|So, check my projects on '''user login''' and '''registration''' for more information.  
 +
 
 
|-
 
|-
−
|5:28
+
|05:23
 
|If you have any questions or would like me to expand on anything, please just let me know.
 
|If you have any questions or would like me to expand on anything, please just let me know.
 +
 
|-
 
|-
−
|5:35
+
|05:30
−
|Please subscribe for updates in the future. Thanks for watching.  This is _________ dubbing for the Spoken Tutorial project.
+
|Please subscribe for updates in the future. Thanks for watching.  This is Madhur, dubbing for the Spoken Tutorial project.

Latest revision as of 14:45, 10 March 2017

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 Let's 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 exist".
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 User Login 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. It's 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 k 1.
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. Error again!
02:39 Let me try again. Click on Login. No, it's 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 to 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 Please subscribe for updates in the future. Thanks for watching. This is Madhur, dubbing for the Spoken Tutorial project.

Contributors and Content Editors

Gaurav, Gyan, PoojaMoolya, Sandhya.np14

Retrieved from "https://script.spoken-tutorial.org/index.php?title=PHP-and-MySQL/C4/User-Registration-Part-5/English-timed&oldid=33111"