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

PoojaMoolya at 09:15, 10 March 2017

2017-03-10T09:15:29Z

Sandhya.np14 at 18:37, 9 June 2015

2015-06-09T18:37:23Z

Gaurav at 11:41, 2 September 2014

2014-09-02T11:41:09Z

Gaurav at 11:40, 2 September 2014

2014-09-02T11:40:51Z

Gaurav at 11:40, 2 September 2014

2014-09-02T11:40:40Z

Gaurav at 11:39, 2 September 2014

2014-09-02T11:39:35Z

PoojaMoolya at 08:57, 6 February 2014

2014-02-06T08:57:03Z

Show changes

Gyan: 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…'

2013-10-25T11:15:18Z

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…'

New page

{| 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 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.

@@ Line 196: / Line 196: @@
 |-
 |05:30
-|Please subscribe for updates in the future. Thanks for watching.  This is Madhur, dubbing for the Spoken Tutorial project.{| border=1
+|Please subscribe for updates in the future. Thanks for watching.  This is Madhur, dubbing for the Spoken Tutorial project.

@@ Line 5: / Line 5: @@
 |-
 |00:00
-|Welcome to the 5th part of the User registration tutorial.
+|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.
+|We are going to tidy up a few bits and pieces together in our '''registration''' '''login''' process.
 |-
@@ Line 25: / Line 25: @@
 |-
 |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.
 |-
 |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".
 |-
@@ Line 37: / Line 37: @@
 |-
 |00:44
-|Let me type this in username and type in my password.
+|Let me type this in '''Username''' and type in my password.
 |-
 |00:49
-|It will tell me that user doesn't exit.
+|It will tell me "That user doesn't exist".
 |-
@@ Line 53: / Line 53: @@
 |-
 |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.
 |-
@@ Line 69: / Line 69: @@
 |-
 |01:46
-|So, this is the password I am typing in here.  Its quite an odd one.
+|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 k1.
+|"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.
+|But this "password" is equal "dbpassword". So, we are not getting the comparison.
 |-
@@ Line 85: / Line 85: @@
 |-
 |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".
 |-
 |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.
 |-
 |02:35
-|Let me resubmit this form again  Oh! error again!
+|Let me resubmit this '''form''' again.   Error again!
 |-
 |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.
 |-
 |02:45
-|Let's check this. "password" equals to "POST password" so md5 is the password.
+|Let's check this. "$password" equals to "POST password", so "md5" is the password.
 |-
@@ Line 112: / Line 112: @@
 |-
 |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.
 |-
 |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.
 |-
 |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.
 |-
 |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.
 |-
@@ Line 132: / Line 132: @@
 |-
 |03:58
-|So, register.  Choose your username.
+|So, register.  Choose your 'username'.
 |-
@@ Line 152: / Line 152: @@
 |-
 |04:27
-|So now when I try to log back in and let me type this properly.
+|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.
+|We can login and we are in. Okay, so check things like string length.
 |-
@@ Line 168: / Line 168: @@
 |-
 |04:48
-|And that is user registration.
+|And that is '''User Registration'''.
 |-
 |04:50
-|This is followed on from our user login tutorial.
+|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.
+|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.
+|I will be using this in a lot of my project work. Say for example,
 |-
@@ Line 188: / Line 188: @@
 |-
 |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.
 |-
@@ Line 196: / Line 196: @@
 |-
 |05:30
-|Please subscribe for updates in the future. Thanks for watching.  This is Madhur dubbing for the Spoken Tutorial project.{| border=1
+|Please subscribe for updates in the future. Thanks for watching.  This is Madhur, dubbing for the Spoken Tutorial project.{| border=1

@@ Line 149: / Line 149: @@
 |04:21
 | This is looking longer already, it hasn't been cut short because I have changed the length of this.
 |-
@@ Line 179: / Line 178: @@
 |So by putting these together, we have got a fully functional user register and login process.
 |-
 |05:02

@@ Line 22: / Line 22: @@
 |00:19
 |Everything has worked out fine and I am at the login screen here.
 |-

@@ Line 1: / Line 1: @@
 {| border=1
-!Time
+|'''Time'''
-!Narration
+|'''Narration'''
 |-

@@ Line 132: / Line 132: @@
 |-
-|03.58
+|03:58
 |So, register.  Choose your username.
 |-
-|04.02
+|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".
@@ Line 161: / Line 161: @@
 |-
-|04.41
+|04:41
 |Hopefully you have got this.
 |-
-|04.43
+|04:43
 |If you want me to expand this tutorial please just let me know.