PHP-and-MySQL/C4/User-Registration-Part-3/English-timed

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