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

From Script | Spoken-Tutorial
Jump to: navigation, search
(Created page with '{| border=1 !Time !Narration |- |0:00 |Welcome to part 4 of "User Registration". We are going through these processes thoroughly. We are using security and checks for our "userna…')
 
 
(5 intermediate revisions by 2 users not shown)
Line 2: Line 2:
 
!Time
 
!Time
 
!Narration
 
!Narration
 +
 
|-
 
|-
−
|0:00
+
|00:00
−
|Welcome to part 4 of "User Registration". We are going through these processes thoroughly. We are using security and checks for our "username" and "password",  which is really good.
+
|Welcome to part 4 of '''User Registration'''.  
 +
 
 
|-
 
|-
−
|0:10
+
|00:03
−
|If I am being confusing please let me know. Drop me an email or a comment through "youtube".
+
|We are going through these processes thoroughly.
 +
 
 
|-
 
|-
−
|0:18
+
|00:06
−
|Getting onto "registering our user" process.
+
| We are using security and checks for our "username" and "password"  which is really good.
 +
 
 
|-
 
|-
−
|0:21
+
|00:11
−
|We need to connect to our database first. We are going to open up our table and input our values.
+
|If I am being confusing please let me know. Drop an email or a comment through "youtube".
 +
 
 
|-
 
|-
−
|0:29
+
|00:19
 +
|Getting into "registering our user" process.
 +
 
 +
|-
 +
|00:22
 +
|We need to connect to our database first.
 +
 
 +
|-
 +
|00:25
 +
|We are going to open up our '''table''' and '''input''' our values.
 +
 
 +
|-
 +
|00:29
 
|You might think this is very simple.  
 
|You might think this is very simple.  
 +
 
|-
 
|-
−
|0:33
+
|00:33
 
|So, first of all, I am going to write a message saying "Success".
 
|So, first of all, I am going to write a message saying "Success".
 +
 
|-
 
|-
−
|0:39
+
|00:38
 
|Back to our page. I'll just go back into this and check all our checks that we had created first.
 
|Back to our page. I'll just go back into this and check all our checks that we had created first.
 +
 
|-
 
|-
−
|0:52
+
|00:47
−
|So I will click "Register" and it says "Please fill in all fields".  
+
|So, I will click "Register" and it says "Please fill in all the fields!".  
 +
 
 
|-
 
|-
−
|0:56
+
|00:54
−
|If I fill a variety of fields, then forget one and click register its still saying a message.
+
|If I fill a variety of '''fields''' then forget and click '''Register''', it's still saying a message.
 +
 
 
|-
 
|-
−
|1:01
+
|01:03
−
|So I am going to type "alex" and am going to choose my username. Then type my fullname and I am going to choose a password which is "abc".
+
|So, I am going to type "alex" and I am going to choose my '''username'''.  
 +
 
 
|-
 
|-
−
|1:11
+
|01:09
−
|The next one I will just type a mix of characters. So, when I click register, it should say "Your passwords do not match".
+
|Then type my full name and I am going to choose a password which is "abc".
 +
 
 
|-
 
|-
−
|1:20
+
|01:15
−
|So, go back to square one. We are going to type "Alex Garrett". We will choose a username. We are going to choose a password say "abc".
+
|The next one, I will just type a mix of characters.  
 +
 
 
|-
 
|-
−
|1:29
+
|01:19
 +
|So, when I click '''Register''', it should say "Your passwords do not match".
 +
 
 +
|-
 +
|01:25
 +
|So, go back to square one.
 +
 
 +
|-
 +
|01:28
 +
|We are going to type "Alex Garrett".
 +
 
 +
|-
 +
|01:32
 +
|We will choose a username. We are going to choose a password say "abc".
 +
 
 +
|-
 +
|01:39
 
|Since this is under 6 characters, when I click "Register" - "Passwords must be between 25 and 6 characters".  So  that check works.
 
|Since this is under 6 characters, when I click "Register" - "Passwords must be between 25 and 6 characters".  So  that check works.
 +
 +
|-
 +
|01:52
 +
|Now, what I will type is my fullname as "Alex Garrett" and my 'username' as "alex".
 +
 
|-
 
|-
−
|1:41
+
|02:00
−
|Now what I will type is my fullname as "Alex Garrett" and my username as "alex". The password is going to be just a full length password.
+
|The password is going to be just a full length password.
 +
 
 
|-
 
|-
−
|1:54
+
|02:05
 
|More than 6 characters. I will click "Register".  You can see that - "Length of the username or fullname is too long!".  
 
|More than 6 characters. I will click "Register".  You can see that - "Length of the username or fullname is too long!".  
 +
 
|-
 
|-
−
|2:01
+
|02:15
 
|So you can write these checks if you want. I'll leave it up to you.
 
|So you can write these checks if you want. I'll leave it up to you.
 +
 
|-
 
|-
−
|2:05
+
|02:20
−
|So, at the moment we have now got a successful form validation.
+
|So, at the moment we have now got a successful '''form''' '''validation'''.
 +
 
 
|-
 
|-
−
|2:11
+
|02:26
−
|Now what we will do is continue with registering our user.
+
|Now, what we will do is continue with registering our user.
 +
 
 
|-  
 
|-  
−
|2:17
+
|02:31
−
|Now this form validation isn't good. Every time we get an error, these fields disappear; they are gone.
+
|Now this '''form validation''' isn't good. Every time we get an error, these fields disappear; they are gone.
 +
 
 
|-
 
|-
−
|2:31
+
|02:40
 
|And the user has to retype.  
 
|And the user has to retype.  
 +
 
|-
 
|-
−
|2:33
+
|02:43
 
|So what I am going to say is, we have got our fullname, username and password variables here.
 
|So what I am going to say is, we have got our fullname, username and password variables here.
 +
 
|-
 
|-
−
|2:42
+
|02:50
−
|Considering this is a php page itself, we can incorporate php into this html code over here.
+
|Considering this php page itself, we can incorporate php into this '''html code''' over here.
 +
 
 
|-
 
|-
−
|2:52
+
|02:57
−
|Under your fullname I am going to say "value equal to" a value inside the box and open up a phptag.
+
|Under your fullname, I am going to say '''value''' equal to a value inside the box and open up a '''php tag'''.
 +
 
 
|-
 
|-
−
|2:58
+
|03:06
−
|Close the php tag inside. Here I am going to echo username or rather fullname.
+
|Close the '''php tag''' inside. Here I am going to '''echo''' 'username' or rather '$fullname'.
 +
 
 
|-
 
|-
−
|3:07
+
|03:12
−
|I will do exactly the same with our username. So value equals, open php tags, close php tags and echo out username.
+
|I will do exactly the same with our 'username'.  
 +
 
 
|-
 
|-
−
|3:22
+
|03:16
−
|Make sure the line terminator is in there.  
+
|So value equals open php tags, close php tags and '''echo''' out 'username'.
 +
 
 
|-
 
|-
−
|3:25
+
|03:23
−
|Now what will happen is, let's say I choose this ridiculously long name here and choose a username say "alex".
+
|Make sure that line terminator is in there.  
 +
 
 
|-
 
|-
−
|3:34
+
|03:27
−
|You don't want your passwords to be stored. So just leave that upto the user.  
+
|Now what will happen is, let's say I choose this ridiculously long name here and I choose a username say "alex".
 +
 
 
|-
 
|-
−
|3:41
+
|03:36
 +
|If you don't want your passwords to be stored, so just leave that up to the user.
 +
 
 +
|-
 +
|03:43
 
|I've got a too long username and it should produce this error again.
 
|I've got a too long username and it should produce this error again.
 +
 
|-
 
|-
−
|3"44
+
|03:49
−
|When I click register, this time its kept our fullname and username.
+
|When I click '''Register''', this time it's kept our fullname and username.
 +
 
 
|-
 
|-
−
|3.51
+
|03.54
−
|So it's a rule. If you get an error and you have to retype your username, your fullname, your password or your firstname, middle name, your surname; I don't know how many fields are there in your user form....
+
|So it's a rule. If you get an '''error''' and you have to retype your username, your fullname, your password or your firstname, middle name, your surname; I don't know how many '''fields''' are there in your user '''form'''.
 +
 
 
|-
 
|-
−
|4:04
+
|04:10
 
|It's annoying to type your name over and over again.  
 
|It's annoying to type your name over and over again.  
 +
 
|-
 
|-
−
|4:08
+
|04:13
−
|So using this, your php echo inside php tags, inside the values of your html input type and it so useful and much more convenient for the user and much more user friendly.
+
|So using this, your php '''echo''' inside '''php tags''', inside the values of your '''html input type''' and it is so useful and so much more convenient for the user and much more user friendly.
 +
 
 
|-
 
|-
−
|4.22
+
|04:28
−
|Okay, otherwise echo "Success!!".  I have not actually given a successful form yet.
+
|Okay, otherwise echo "Success!!".  I have not actually given a successful '''form''' yet.
 +
 
 
|-
 
|-
−
|4:29
+
|04:34
−
|So I will type "Alex Garret" and my password is going to be over 6 characters and under 25 characters.
+
|So, I will type "Alex Garret" and my password is going to be over 6 characters and under 25 characters.
 +
 
 
|-
 
|-
−
|4:37
+
|04:43
−
|Click "Register".  Oh! an error messge.  Let's see.  
+
|Click "Register".  Oh! an error message.  Let's see.  
 +
 
 
|-
 
|-
−
|4:40
+
|04:49
−
|We have picked up an error and.... - if string length of the password is greater than 25.....
+
|We have picked up an error and.... - if the string length of the password is greater than 25
 +
 
 
|-
 
|-
−
|4:48
+
|04:55
 
|...or the string length of the password is lesser than 6.... echo password - should be enough.... but we have run into the same problem.
 
|...or the string length of the password is lesser than 6.... echo password - should be enough.... but we have run into the same problem.
 +
 
|-
 
|-
−
|5:03
+
|05:04
−
|I have just realised that we have an encrypted value for our password. And our md5 encrypted string is massive. It's much bigger than 25 characters.
+
|I have just realized that we have an encrypted value for our password and our '''md5''' encrypted string is massive. It's much bigger than 25 characters.
 +
 
 
|-
 
|-
−
|5:14
+
|05:18
−
|So again what I will do is take this block of code, that has been encrypting our password. Cut out that and bring it down underneath "register the user".
+
|So again what I have to do is, take this '''block''' of code that has been encrypting our page. Cut out that and bring it down underneath "register the user".
 +
 
 
|-
 
|-
−
|5:26
+
|05:30
−
|So you can see from experience that order of things are very important. If you get errors like this go through your code.Look at them and realise what are you doing.
+
|So you can see from experience that order of things is very important. If you get errors like this go through your code. Look at them and realize what are you doing.
 +
 
 
|-
 
|-
−
|5:34
+
|05:42
−
|Use echo things out in between your code, just as a sort of debug process.
+
|Use '''echo''' things out in between your code, just as sort of debug process.
 +
 
 
|-
 
|-
−
|5:41
+
|05:48
−
|Now I will go back to my form and I'm going to retype my perfectly acceptable password in.
+
|Now I will go back to my '''form''' and I'm going to retype my perfectly acceptable password in.
 +
 
 
|-
 
|-
−
|5:46
+
|05:55
 
|Click on "Register". We have got our "Success" message.  
 
|Click on "Register". We have got our "Success" message.  
 +
 
|-
 
|-
−
|5:50
+
|06:02
 
|So you see, going through your code helps to see if there are problems.
 
|So you see, going through your code helps to see if there are problems.
 +
 
|-
 
|-
−
|5:56
+
|06:07
−
|I am a bit quick at realising these.  But sometimes I  pause the video, have a look at the code and then resume the video. I don't like to keep the viewers on hold.
+
|I am a bit quick at realizing these.  But sometimes I  pause video, I have a look at the code and then resume the video. I don't like to keep the viewers on hold.
 +
 
 
|-
 
|-
−
|6:02
+
|06:19
−
|You, too, will soon realise your mistakes. So we have got our "Success" and now we will say "open our database".
+
|So, you too will soon realize your mistakes. So we have got our "Success" and now we will say "open our database".
 +
 
 
|-
 
|-
−
|6:13
+
|06:28
−
|To do this, we need our connect variable, no you don't... I am going to say my "sql connect".
+
|To do this, we need our connect variable, no you don't... I am saying my "sql connect()".
 
|-
 
|-
−
|6:20
+
|06:36
−
|And am connecting to my local host server, which is my computer and root and my password is nothing.
+
|And I am connecting to my "local host" server which is my computer and "root" and my password is nothing.
 +
 
 
|-
 
|-
−
|6:31
+
|06:44
−
|I am going to say "mySQL select db". This is going to select our database. So let's say "select data base".
+
|I am going to say "mySQL select db()". This is going to select our database. So let's say "select data base"
 +
 
 
|-
 
|-
−
|6:38
+
|06:55
−
|Even though this is obvious. This is php login and here I am going to say give a query.
+
|even though this is obvious. This is "php login" and here I am going to say give a query.
 +
 
 
|-
 
|-
−
|6:49
+
|07:03
−
|So "query register". This is going to be equal to "mysqlL query".  
+
|So "query register" is going to be equal to "mysql_query()".  
 +
 
 
|-
 
|-
−
|6:54
+
|07:10
−
|This is the important part of this tutorial where we actually input our values and we register our username.  
+
|This is the important part of the tutorial where we actually input our values and we register our username.  
 +
 
 
|-
 
|-
−
|7:02
+
|07:18
−
|Now let me scroll down so you can see. This is "INSERT INTO users". If we go back to here, this is it "php login" is our table that we have selected. So "mySQL select db php login".
+
|Now let me scroll down so you can see this is "INSERT INTO users".  
 +
 
 
|-
 
|-
−
|7:20
+
|07:24
−
|And we are inserting into "users" which is our table into the database.
+
|If we go back to here, this is it "php login" is our table that we have selected. So "mySQL select db php login".
 +
 
 
|-
 
|-
−
|7:28
+
|07:38
−
|And we will say values brackets, each value of the table. So each field that is present into the table.
+
|And we are inserting into "users" which is our '''table''' in the database.
 +
 
 
|-
 
|-
−
|7:40
+
|07:44
−
|So if we go back to here and click on browse or structure - that one - we got id, name, username, password, date. So 1 2 3 4 5.
+
|And we will say "VALUES" brackets, each value of the table. So each field  is present in the table.
 +
 
 
|-
 
|-
−
|7:52
+
|07:51
−
| Here also we need 1 2 3 4 5. The id is auto increment, if you know from the last tutorial.
+
|So, if we go back to here and click on '''Browse''' or '''Structure''' - that one - we got '''id, name, username, password, date'''. So 1, 2, 3, 4, 5.
 +
 
 
|-
 
|-
−
|8:00
+
|08:04
 +
| Here also we need 1, 2, 3, 4, 5. The '''id''' is auto-increment, if you know from the last tutorial.
 +
 
 +
|-
 +
|08:13
 
|So we just need in here; the order is very important.
 
|So we just need in here; the order is very important.
 +
 +
|-
 +
|08:18
 +
|We have got our name, username, password, date. So this is just 'name', 'username'.
 +
 +
|-
 +
|08:24
 +
|This is 'password', no need to repeat password, that was just for check and this is going to be the 'date'.
 +
 
|-
 
|-
−
|8:06
+
|08:33
−
|We have got our name, username, password, date. So this is just name, username. This is password, no need for repeat password, that was just for check and this is going to be the date.
+
|So these variables here, if you are not so sure, are up from here where we have our 'fullname', 'username', 'password' and 'date'.
 +
 
 
|-
 
|-
−
|8:19
+
|08:43
−
|So these variables here, if you are not too sure, are from up here, where we have our fullname, username, password and date.
+
|Let's change this to 'fullname'. Okay, so this should work. After this is done I will say, "You have been registered". In fact, what I am going to do is I say '''die()'''.
 +
 
 
|-
 
|-
−
|8:28
+
|08:56
−
|Lets change this to fullname. Okay, so this should work. After this is done I will say, "You have been registered". In fact what I am going to do is say "die".
+
|"You have been registered. Return to login page".
 +
 
 
|-
 
|-
−
|8:48
+
|09:02
−
|"You have been registered. Click here to return to login page".  Put this as a link back to out index page in which the user could login.
+
|Put this as a link back to out 'index page' in which the user could login.
 +
 
 
|-
 
|-
−
|9:08
+
|09:08
−
|You can see how it executes in a second and here is my previous page.
+
|As you can see how it executes in a second and here is my previous page.
 +
 
 
|-
 
|-
−
|9:14
+
|09:15
−
|Lets say "Alex Garret". Choosing username as "alex" and this as your password. "You have been registered. Return to login page".
+
|Let's say "Alex Garret". Choosing username as "alex" and this as your password. "You have been registered!". Return to login page".
 +
 
 
|-
 
|-
−
|9:32
+
|09:26
−
|I will now check my database in "browse". You can see that I have got "Alex Garret". My id is 3 my username is "alex"
+
|Now, I will now check my database in '''Browse". You can see that I have got "Alex Garret". My "id" is 3, my "username" is "alex",
 +
 
 
|-
 
|-
−
|9:42
+
|09:36
−
|My password is my encrypted password and my date is date.  
+
|my password is my encrypted password and my "date" is this.  
 +
 
 
|-
 
|-
−
|9:45
+
|09:41
−
|That's it. So in the next part I will show you how to tidy a few things out and test the login process.  
+
|That's it. So, in the next part I will show you how to tidy a few things out and test the login process.  
 +
 
 
|-
 
|-
−
|9:52
+
|09:49
−
|So I'll see you there.  This is __________ dubbing for the Spoken Tutorial project.
+
|So I'll see you there.  This is Sidharth, dubbing for the Spoken Tutorial project.

Latest revision as of 18:07, 24 March 2017

Time Narration
00:00 Welcome to part 4 of User Registration.
00:03 We are going through these processes thoroughly.
00:06 We are using security and checks for our "username" and "password" which is really good.
00:11 If I am being confusing please let me know. Drop an email or a comment through "youtube".
00:19 Getting into "registering our user" process.
00:22 We need to connect to our database first.
00:25 We are going to open up our table and input our values.
00:29 You might think this is very simple.
00:33 So, first of all, I am going to write a message saying "Success".
00:38 Back to our page. I'll just go back into this and check all our checks that we had created first.
00:47 So, I will click "Register" and it says "Please fill in all the fields!".
00:54 If I fill a variety of fields then forget and click Register, it's still saying a message.
01:03 So, I am going to type "alex" and I am going to choose my username.
01:09 Then type my full name and I am going to choose a password which is "abc".
01:15 The next one, I will just type a mix of characters.
01:19 So, when I click Register, it should say "Your passwords do not match".
01:25 So, go back to square one.
01:28 We are going to type "Alex Garrett".
01:32 We will choose a username. We are going to choose a password say "abc".
01:39 Since this is under 6 characters, when I click "Register" - "Passwords must be between 25 and 6 characters". So that check works.
01:52 Now, what I will type is my fullname as "Alex Garrett" and my 'username' as "alex".
02:00 The password is going to be just a full length password.
02:05 More than 6 characters. I will click "Register". You can see that - "Length of the username or fullname is too long!".
02:15 So you can write these checks if you want. I'll leave it up to you.
02:20 So, at the moment we have now got a successful form validation.
02:26 Now, what we will do is continue with registering our user.
02:31 Now this form validation isn't good. Every time we get an error, these fields disappear; they are gone.
02:40 And the user has to retype.
02:43 So what I am going to say is, we have got our fullname, username and password variables here.
02:50 Considering this php page itself, we can incorporate php into this html code over here.
02:57 Under your fullname, I am going to say value equal to a value inside the box and open up a php tag.
03:06 Close the php tag inside. Here I am going to echo 'username' or rather '$fullname'.
03:12 I will do exactly the same with our 'username'.
03:16 So value equals open php tags, close php tags and echo out 'username'.
03:23 Make sure that line terminator is in there.
03:27 Now what will happen is, let's say I choose this ridiculously long name here and I choose a username say "alex".
03:36 If you don't want your passwords to be stored, so just leave that up to the user.
03:43 I've got a too long username and it should produce this error again.
03:49 When I click Register, this time it's kept our fullname and username.
03.54 So it's a rule. If you get an error and you have to retype your username, your fullname, your password or your firstname, middle name, your surname; I don't know how many fields are there in your user form.
04:10 It's annoying to type your name over and over again.
04:13 So using this, your php echo inside php tags, inside the values of your html input type and it is so useful and so much more convenient for the user and much more user friendly.
04:28 Okay, otherwise echo "Success!!". I have not actually given a successful form yet.
04:34 So, I will type "Alex Garret" and my password is going to be over 6 characters and under 25 characters.
04:43 Click "Register". Oh! an error message. Let's see.
04:49 We have picked up an error and.... - if the string length of the password is greater than 25
04:55 ...or the string length of the password is lesser than 6.... echo password - should be enough.... but we have run into the same problem.
05:04 I have just realized that we have an encrypted value for our password and our md5 encrypted string is massive. It's much bigger than 25 characters.
05:18 So again what I have to do is, take this block of code that has been encrypting our page. Cut out that and bring it down underneath "register the user".
05:30 So you can see from experience that order of things is very important. If you get errors like this go through your code. Look at them and realize what are you doing.
05:42 Use echo things out in between your code, just as sort of debug process.
05:48 Now I will go back to my form and I'm going to retype my perfectly acceptable password in.
05:55 Click on "Register". We have got our "Success" message.
06:02 So you see, going through your code helps to see if there are problems.
06:07 I am a bit quick at realizing these. But sometimes I pause video, I have a look at the code and then resume the video. I don't like to keep the viewers on hold.
06:19 So, you too will soon realize your mistakes. So we have got our "Success" and now we will say "open our database".
06:28 To do this, we need our connect variable, no you don't... I am saying my "sql connect()".
06:36 And I am connecting to my "local host" server which is my computer and "root" and my password is nothing.
06:44 I am going to say "mySQL select db()". This is going to select our database. So let's say "select data base"
06:55 even though this is obvious. This is "php login" and here I am going to say give a query.
07:03 So "query register" is going to be equal to "mysql_query()".
07:10 This is the important part of the tutorial where we actually input our values and we register our username.
07:18 Now let me scroll down so you can see this is "INSERT INTO users".
07:24 If we go back to here, this is it "php login" is our table that we have selected. So "mySQL select db php login".
07:38 And we are inserting into "users" which is our table in the database.
07:44 And we will say "VALUES" brackets, each value of the table. So each field is present in the table.
07:51 So, if we go back to here and click on Browse or Structure - that one - we got id, name, username, password, date. So 1, 2, 3, 4, 5.
08:04 Here also we need 1, 2, 3, 4, 5. The id is auto-increment, if you know from the last tutorial.
08:13 So we just need in here; the order is very important.
08:18 We have got our name, username, password, date. So this is just 'name', 'username'.
08:24 This is 'password', no need to repeat password, that was just for check and this is going to be the 'date'.
08:33 So these variables here, if you are not so sure, are up from here where we have our 'fullname', 'username', 'password' and 'date'.
08:43 Let's change this to 'fullname'. Okay, so this should work. After this is done I will say, "You have been registered". In fact, what I am going to do is I say die().
08:56 "You have been registered. Return to login page".
09:02 Put this as a link back to out 'index page' in which the user could login.
09:08 As you can see how it executes in a second and here is my previous page.
09:15 Let's say "Alex Garret". Choosing username as "alex" and this as your password. "You have been registered!". Return to login page".
09:26 Now, I will now check my database in Browse". You can see that I have got "Alex Garret". My "id" is 3, my "username" is "alex",
09:36 my password is my encrypted password and my "date" is this.
09:41 That's it. So, in the next part I will show you how to tidy a few things out and test the login process.
09:49 So I'll see you there. This is Sidharth, dubbing for the Spoken Tutorial project.

Contributors and Content Editors

Gyan, PoojaMoolya, Sandhya.np14

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