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

From Script | Spoken-Tutorial
Jump to: navigation, search
 
(5 intermediate revisions by 2 users not shown)
Line 5: Line 5:
 
|-
 
|-
 
|00:00
 
|00:00
−
|Welcome to the 3rd part of the User Registration tutorial.  
+
|Welcome to the 3rd part of the '''User Registration''' tutorial.  
  
 
|-
 
|-
 
|00:04
 
|00:04
−
| In this part we are going to check for existence of all that was discussed in the last part.  
+
| In this part, we are going to check for existence of all that was discussed in the last part.  
  
 
|-
 
|-
Line 17: Line 17:
 
|-
 
|-
 
|00:14
 
|00:14
−
|We have striped the tags off our  "fullname" and "username".   
+
|We have striped the '''tags''' off our  "fullname" and "username".   
  
 
|-
 
|-
Line 25: Line 25:
 
|-
 
|-
 
|00:23
 
|00:23
−
|Remember this sequence for the  functions, so that we are not striping off our encrypted value.
+
|Remember this sequence for the  functions so that we are not striping off our encrypted value.
  
 
|-
 
|-
 
|00:30
 
|00:30
−
|Here we are going to start our registration process.
+
|Here, we are going to start our registration process.
  
 
|-
 
|-
Line 37: Line 37:
 
|-
 
|-
 
|00:38
 
|00:38
−
|Just before I do that I am going to set the "date".  
+
|Just before I do that, I am going to set the "$date".  
  
 
|-
 
|-
 
|00:43
 
|00:43
−
|Now,  this is using the date function.  
+
|Now,  this is using the '''date()''' function.  
−
 
+
  
 
|-
 
|-
 
|00:47
 
|00:47
−
|Inside we have "Y" for the year, "m" for the month and "d" for the date.
+
|Inside, we have "Y" for the year, "m" for the month and "d" for the date.
  
 
|-
 
|-
 
|00:55
 
|00:55
 
|It's the capital "Y" for  4-digit year. If we use a small "y", it  would be a 2-digit year.
 
|It's the capital "Y" for  4-digit year. If we use a small "y", it  would be a 2-digit year.
−
 
  
 
|-
 
|-
Line 71: Line 69:
 
|-
 
|-
 
|01:40
 
|01:40
−
|Its adjusted into that structure in my database.  
+
|It's adjusted into that structure in my database.  
  
 
|-
 
|-
 
|01:45
 
|01:45
−
|Okay, so "if submit", then we need to check for existence.  
+
|Okay, so '''if''' '$submit' then we need to check for existence.  
  
 
|-
 
|-
Line 87: Line 85:
 
|-
 
|-
 
|01:58
 
|01:58
−
|All we want to do is we have to say is "if" statement and a block the code after that.
+
|All we want to do is, we have to say "if" '''statement''' and a block of code after that.
  
 
|-
 
|-
 
|02:05
 
|02:05
−
|The condition will be "if fullname, username, password and repeat password exist", we have the evidence here.... we will say "if username" followed by "and", so double ampersand symbol.  
+
|The condition will be 'if $fullname, $username, $password and $repeat password exist', we have the evidence here.... we will say '''if''' $username followed by '''AND''', so double ampersand symbol.  
  
 
|-
 
|-
 
|02:24
 
|02:24
−
|Then we will say "password" and then we'll say....  
+
|Then we will say "$password" and then we'll say....  
−
 
+
  
 
|-
 
|-
 
|02:28
 
|02:28
−
|Oh! I forgot the "fullname" here, so I'll add it there.
+
|Oh! I forgot the "$fullname" here, so I'll add it there.
  
 
|-
 
|-
 
|02:33
 
|02:33
−
|Separated these with a double ampersand sign.
+
|Separate these with a double ampersand sign.
  
 
|-
 
|-
 
|02:38
 
|02:38
−
|The last one is "repeat password" so type that.  
+
|The last one is "$repeat password"; so type that.  
  
 
|-
 
|-
Line 116: Line 113:
 
|-
 
|-
 
|02:46
 
|02:46
−
|Else, we will say - echo "Please fill in" and in bold, "all fields".  
+
|Else, we will say - '''echo''' "Please fill in" and in bold, "all", "fields!".  
  
 
|-
 
|-
Line 124: Line 121:
 
|-
 
|-
 
|03:01
 
|03:01
−
|Also let me put a paragraph break before the form so that we don't need to add it to every error message we give.  
+
|Also, let me put a paragraph break before the '''form''' so that we don't need to add it to every '''error''' message we give.  
  
 
|-
 
|-
 
|03:10
 
|03:10
−
|So that's it. Let's just try it.
+
|So, that's it. Let's just try it.
  
 
|-
 
|-
 
|03:13
 
|03:13
−
|I will go back to my "register" page.  
+
|I will go back to my "Register" page.  
  
 
|-
 
|-
 
|03:17
 
|03:17
−
|We got it here.  Lets click in register.  
+
|We got it here.  Let's click in register.  
  
 
|-
 
|-
 
|03:20
 
|03:20
−
|"Please fill in all fields".
+
|"Please fill in all fields!".
  
 
|-
 
|-
 
|03:22
 
|03:22
−
|Lets type a couple of fields here.  
+
|Let's type a couple of '''fields''' here.  
  
 
|-
 
|-
 
|03:25
 
|03:25
−
|Lets choose one of our passwords.  
+
|Let's choose one of our passwords.  
  
 
|-
 
|-
Line 156: Line 153:
 
|-
 
|-
 
|03:30
 
|03:30
−
|Register. Oh!   repeat password....
+
|Register. Oh! repeat password....
  
 
|-
 
|-
 
|03:42
 
|03:42
−
|repeat password.
+
|'$repeat password'.
  
 
|-
 
|-
−
|03.45
+
|03:45
−
|The reason  this is not working at the moment is, an "md5" value of nothing is equal to an "md5" string of text.  
+
|The reason  this is not working at the moment is, an "md5" value of nothing is equal to an "md5" '''string''' of text.  
  
 
|-
 
|-
−
|03.56
+
|03:56
 
|An encrypted string of text.
 
|An encrypted string of text.
  
 
|-
 
|-
 
|04:00
 
|04:00
−
|So, I realise what we need to do is, take out the "md5" function here.
+
|So, I realize what we need to do is, take out the "md5" function here.
  
 
|-
 
|-
−
|04.06
+
|04:06
 
|Make sure you remove the end brackets. I will come down here and check for all of our data.
 
|Make sure you remove the end brackets. I will come down here and check for all of our data.
 
   
 
   
Line 184: Line 181:
 
|-
 
|-
 
|04:17
 
|04:17
−
|Remember it didn't work before when we didn't chose a "repeat password".  
+
|Remember it didn't work before when we didn't chose a "Repeat password".  
  
 
|-
 
|-
 
|04:23
 
|04:23
−
|So if I didn't chose a  repeat or a password we get our error.  
+
|So, if I didn't chose a  repeat or a password we get our error.  
  
 
|-
 
|-
 
|04:30
 
|04:30
−
|If I again choose a value except the repeat password, we still get this error.
+
|If I again choose a value except the "Repeat password", we still get this error.
  
 
|-
 
|-
Line 200: Line 197:
 
|-
 
|-
 
|04:46
 
|04:46
−
|So I will just say "password" is equal to "md5" of password".
+
|So I will just say "$password" is equal to "md5" of "$password".
  
 
|-
 
|-
Line 208: Line 205:
 
|-
 
|-
 
|05:00
 
|05:00
−
|We also need to say "repeat password" equals "md5" and "repeat password".  
+
|We also need to say "$repeat password" equals "md5" and "$repeat password".  
  
 
|-
 
|-
 
|05:08
 
|05:08
−
|Here comment this as "encrypt password". We have encrypted our password.
+
|Here, comment this as "encrypt password". We have encrypted our password.
  
 
|-
 
|-
 
|05:15
 
|05:15
−
|Now we will go ahead and add all our data into our data base.
+
|Now we will go ahead and add all our data into our database.
  
 
|-
 
|-
Line 227: Line 224:
  
 
|-
 
|-
−
|05.50
+
|05:50
−
|So I will say- if the string length of username is bigger or greater than 25.... or....
+
|So, I will say- if the string length of '$username' is bigger or greater than 25.... '''OR'''
  
 
|-
 
|-
−
|06.05
+
|06:05
−
|string length of the fullname is greater that 25
+
|string length of the '$fullname' is greater than 25.
  
 
|-
 
|-
 
|06:15
 
|06:15
−
|Let us look at these individually and say if the length of your username or fullname is too long.
+
|Let us look at these individually and say - if the length of your username or fullname is too long.
  
 
|-
 
|-
Line 244: Line 241:
 
|-
 
|-
 
|06:27
 
|06:27
−
|If each of these values is greater than 25 or bigger than 25.
+
|If each of these values is greater than 25 or bigger than 25,
  
 
|-
 
|-
 
|06:34
 
|06:34
−
| We are going to echo out these values
+
| we are going to '''echo''' out these values
  
 
|-
 
|-
 
|06:40
 
|06:40
−
|  saying "username" or......... no....
+
|  saying "username" or... no...  
−
 
+
  
 
|-
 
|-
Line 269: Line 265:
 
|-
 
|-
 
|07:12
 
|07:12
−
|"If string length of my password is greater than 25.... or.... string length.....
+
|"If string length of my password is greater than 25.. or.. string length...
  
 
|-
 
|-
 
|07:30
 
|07:30
−
|No... um... lets get rid of this, get rid of "else".
+
|No... um... let's get rid of this, get rid of '''else'''.
  
 
|-
 
|-
Line 281: Line 277:
 
|-
 
|-
 
|07:41
 
|07:41
−
|Let me say "if password equals equals to repeat password"  then continue the big block of code.
+
|Let me say "if password equals equals (==)to repeat password"  then continue the big '''block''' of code.
  
 
|-
 
|-
 
|07:53
 
|07:53
−
|Otherwise echo out to the user "Your passwords do not match".  
+
|Otherwise '''echo''' out to the user "Your passwords do not match".  
  
 
|-
 
|-
Line 297: Line 293:
 
|-
 
|-
 
|08:09
 
|08:09
−
|Now to check the character length of "username" and "fullname".   
+
|Now, to check the character length of "username" and "fullname".   
  
 
|-
 
|-
Line 305: Line 301:
 
|-
 
|-
 
|08:18
 
|08:18
−
|And that is going to be what we said before, "if username is greater than 25"  
+
|And that is going to be what we said before, '''if''' "username is greater than 25",
  
 
|-
 
|-
 
|08:25
 
|08:25
−
|Rather if the string length used in this function is greater than 25...  
+
|rather if the '''string''' length used in this function is greater than 25...  
  
 
|-
 
|-
−
|08.31
+
|08:31
−
|Or the string length of fullname is greater than 25, then we echo "Length of username or fullname is too long!".
+
|'''OR''' the string length of fullname is greater than 25, then we '''echo''' "Length of username or fullname is too long!".
  
 
|-
 
|-
Line 325: Line 321:
 
|-
 
|-
 
|08:57
 
|08:57
−
|Here I am going to specify or say "if"... now remember our passwords match...
+
|Here, I am going to specify or say '''if'''... now remember our passwords match...
  
 
|-
 
|-
Line 333: Line 329:
 
|-
 
|-
 
|09:09
 
|09:09
−
|Here I will say - if the string length of the password is greater than 25 or string length of our password is lesser than 6 characters....
+
|Here, I will say - if the string length of the password is greater than 25 or string length of our password is lesser than 6 characters....
  
 
|-
 
|-
−
|09.23
+
|09:23
−
|...then we will echo out an error saying "Password must be between 6 and 25 characters".  
+
|...then we will '''echo''' out an '''error''' saying "Password must be between 6 and 25 characters".  
  
 
|-
 
|-
−
|09.35
+
|09:35
 
|This will work for sure.  
 
|This will work for sure.  
  
Line 349: Line 345:
 
|-
 
|-
 
|09:41
 
|09:41
−
|Before that let me just conclude this with an "else" statement
+
|Before that, let me just conclude this with an '''else''' statement.
−
.
+
 
 
|-
 
|-
 
|09:46
 
|09:46
Line 358: Line 354:
 
|09:51
 
|09:51
 
| Our code to register the user will go here.
 
| Our code to register the user will go here.
−
 
  
 
|-
 
|-
 
|09:56
 
|09:56
−
|In the next tutorial we'll test this out and will learn how to register the user and we will put our code here in that tutorial.
+
|In the next tutorial, we'll test this out and will learn how to register the user and we will put our code here in that tutorial.
  
 
|-
 
|-
 
|10:06
 
|10:06
−
|This is basically for checking a minimum or maximum limit on our password and this block of code here is will be our magical "register the user" piece of code.
+
|This is basically for checking a minimum or maximum limit on our password and this block of code here will be our magical "register the user" piece of code.
  
 
|-
 
|-
 
|10:17
 
|10:17
−
|So join me in the next part. Bye-bye.  This is Mad Madhur dubbing for the Spoken Tutorial project.
+
|So join me in the next part. Bye-bye.  This is Mad Madhur, dubbing for the Spoken Tutorial project.
 +
|}

Latest revision as of 11:25, 28 April 2017

Time Narration
00:00 Welcome to the 3rd part of the User Registration tutorial.
00:04 In this part, we are going to check for existence of all that was discussed in the last part.
00:10 Let us have a quick recap of what was done in the last part.
00:14 We have striped the tags off our "fullname" and "username".
00:19 We have stripped and encrypted our "password".
00:23 Remember this sequence for the functions so that we are not striping off our encrypted value.
00:30 Here, we are going to start our registration process.
00:34 I'll be checking the existence of all these.
00:38 Just before I do that, I am going to set the "$date".
00:43 Now, this is using the date() function.
00:47 Inside, we have "Y" for the year, "m" for the month and "d" for the date.
00:55 It's the capital "Y" for 4-digit year. If we use a small "y", it would be a 2-digit year.
01:02 So, in my database, at the moment, I have my year first, then my month and my day and these are separated by hyphens.
01:15 You can see this when we enter our database here and insert a value into "users".
01:22 We can see that the "date" is in a specific format, if we use this kind of function here.
01:29 When I click today, you can see here that we have got the year in a 4-digit format and our month here and our day here, separated by hyphens.
01:40 It's adjusted into that structure in my database.
01:45 Okay, so if '$submit' then we need to check for existence.
01:51 I will add a comment here "check for existence".
01:55 Now, this is really easy.
01:58 All we want to do is, we have to say "if" statement and a block of code after that.
02:05 The condition will be 'if $fullname, $username, $password and $repeat password exist', we have the evidence here.... we will say if $username followed by AND, so double ampersand symbol.
02:24 Then we will say "$password" and then we'll say....
02:28 Oh! I forgot the "$fullname" here, so I'll add it there.
02:33 Separate these with a double ampersand sign.
02:38 The last one is "$repeat password"; so type that.
02:42 We are going to require all of these.
02:46 Else, we will say - echo "Please fill in" and in bold, "all", "fields!".
02:57 We will put a paragraph break after that.
03:01 Also, let me put a paragraph break before the form so that we don't need to add it to every error message we give.
03:10 So, that's it. Let's just try it.
03:13 I will go back to my "Register" page.
03:17 We got it here. Let's click in register.
03:20 "Please fill in all fields!".
03:22 Let's type a couple of fields here.
03:25 Let's choose one of our passwords.
03:27 We will not repeat our password.
03:30 Register. Oh! repeat password....
03:42 '$repeat password'.
03:45 The reason this is not working at the moment is, an "md5" value of nothing is equal to an "md5" string of text.
03:56 An encrypted string of text.
04:00 So, I realize what we need to do is, take out the "md5" function here.
04:06 Make sure you remove the end brackets. I will come down here and check for all of our data.
04:14 So, let me go back and try this again.
04:17 Remember it didn't work before when we didn't chose a "Repeat password".
04:23 So, if I didn't chose a repeat or a password we get our error.
04:30 If I again choose a value except the "Repeat password", we still get this error.
04:37 That's the problem. What we should say is - if everything exists then we can convert our password and repeat password.
04:46 So I will just say "$password" is equal to "md5" of "$password".
04:53 This will encrypt our original variable value and store a new password code in the same variable.
05:00 We also need to say "$repeat password" equals "md5" and "$repeat password".
05:08 Here, comment this as "encrypt password". We have encrypted our password.
05:15 Now we will go ahead and add all our data into our database.
05:21 I am going to do this. Because we have got our data going to our registration, we are going to set a maximum limit for each data that is input.
05:39 Now we say 25 characters for our fullname, username, password and repeat password. So the maximum value is 25.
05:50 So, I will say- if the string length of '$username' is bigger or greater than 25.... OR
06:05 string length of the '$fullname' is greater than 25.
06:15 Let us look at these individually and say - if the length of your username or fullname is too long.
06:24 Let me put this correctly.
06:27 If each of these values is greater than 25 or bigger than 25,
06:34 we are going to echo out these values
06:40 saying "username" or... no...
06:48 Let me say "Max limit for username or fullname are 25 characters".
06:55 Otherwise I will proceed to check my password length.
07:01 Now I have decided to do this - "check password length" because I want a specific check for this.
07:12 "If string length of my password is greater than 25.. or.. string length...
07:30 No... um... let's get rid of this, get rid of else.
07:36 The first check I want to do is to see if my passwords match.
07:41 Let me say "if password equals equals (==)to repeat password" then continue the big block of code.
07:53 Otherwise echo out to the user "Your passwords do not match".
08:00 Okay?
08:03 So, you can type here and we can keep checking your character length.
08:09 Now, to check the character length of "username" and "fullname".
08:14 So, "check character length of username and fullname".
08:18 And that is going to be what we said before, if "username is greater than 25",
08:25 rather if the string length used in this function is greater than 25...
08:31 OR the string length of fullname is greater than 25, then we echo "Length of username or fullname is too long!".
08:43 So, just to keep it simple and then otherwise we will say
08:51 "check password length".
08:57 Here, I am going to specify or say if... now remember our passwords match...
09:04 So we only need to check this on one of the password variables.
09:09 Here, I will say - if the string length of the password is greater than 25 or string length of our password is lesser than 6 characters....
09:23 ...then we will echo out an error saying "Password must be between 6 and 25 characters".
09:35 This will work for sure.
09:37 We will continue this discussion in the next tutorial.
09:41 Before that, let me just conclude this with an else statement.
09:46 So, otherwise we will say "register the user".
09:51 Our code to register the user will go here.
09:56 In the next tutorial, we'll test this out and will learn how to register the user and we will put our code here in that tutorial.
10:06 This is basically for checking a minimum or maximum limit on our password and this block of code here will be our magical "register the user" piece of code.
10:17 So join me in the next part. Bye-bye. This is Mad 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-3/English-timed&oldid=36809"