Difference between revisions of "PHP-and-MySQL/C3/MySQL-Part-6/English-timed"

From Script | Spoken-Tutorial
Jump to: navigation, search
(Created page with '{| border=1 !Time !Narration |- |0:01 |Hello Everyone! In the previous tutorial we had selected the data and we successfully displayed the data to our page. |- |0:09 |Let me take…')
 
Line 3: Line 3:
 
!Narration
 
!Narration
 
|-
 
|-
|0:01
+
|00:01
 
|Hello Everyone! In the previous tutorial we had selected the data and we successfully displayed the data to our page.
 
|Hello Everyone! In the previous tutorial we had selected the data and we successfully displayed the data to our page.
 
|-
 
|-
|0:09
+
|00:09
 
|Let me take you back to this page here.We can see that everything is working fine.
 
|Let me take you back to this page here.We can see that everything is working fine.
 
|-
 
|-
|0:15
+
|00:15
 
|We have all our data here.
 
|We have all our data here.
 
|-
 
|-
|0:17
+
|00:17
 
|The next thing we will learn is how to specify somewhere that the user themselves can enter and specify data.  
 
|The next thing we will learn is how to specify somewhere that the user themselves can enter and specify data.  
 
|-
 
|-
|0:24
+
|00:23
 
|To do this, I will delete all the codes in my page except "connect include".
 
|To do this, I will delete all the codes in my page except "connect include".
 
|-
 
|-
|0:29
+
|00:29
 
|If I don't connect to my database, its not going to work.
 
|If I don't connect to my database, its not going to work.
 
|-
 
|-
|0:33
+
|00:33
 
|There is a lot of extracting and some other things to be found.
 
|There is a lot of extracting and some other things to be found.
 
|-
 
|-
|0:42
+
|00:42
 
|I will retain firstname,  lastname, date of birth,  and gender either male or female.  
 
|I will retain firstname,  lastname, date of birth,  and gender either male or female.  
 
|-
 
|-
|0:53
+
|00:53
 
|Below here, I will create a form.  
 
|Below here, I will create a form.  
 
|-
 
|-
|0:56
+
|00:55
 
|This will be an html form, so we need to start and end our tags.  
 
|This will be an html form, so we need to start and end our tags.  
 
|-
 
|-
|1:03
+
|01:03
 
|Our "action" will be "mysql dot php" and our "method" is going to be "POST".
 
|Our "action" will be "mysql dot php" and our "method" is going to be "POST".
 
|-
 
|-
|1:13
+
|01:13
 
|Here we will create a form in which the user can specify a name.
 
|Here we will create a form in which the user can specify a name.
 
|-
 
|-
|1:18
+
|01:18
 
|For the name we will use our "surname".
 
|For the name we will use our "surname".
 
|-
 
|-
|1:22
+
|01:22
|You can use any of them. For example, your date of birth or gender to search.
+
|You can use any one of them. For example, your date of birth or gender to search.
 
|-
 
|-
|1:28
+
|01:28
 
|It is your choice.
 
|It is your choice.
 
|-
 
|-
|1:30
+
|01:30
 
|You could even use 2 fields to search.
 
|You could even use 2 fields to search.
 
|-
 
|-
|1:33
+
|01:33
 
|I will now show you how to use 2 fields so that you know that it is not very complicated but easy.
 
|I will now show you how to use 2 fields so that you know that it is not very complicated but easy.
 
|-
 
|-
|1:40
+
|01:40
 
|Here I will type "firstname" and I will create an "input" box of type "text " and the "name" of this will be "firstname".
 
|Here I will type "firstname" and I will create an "input" box of type "text " and the "name" of this will be "firstname".
 
|-
 
|-
|1:51
+
|01:51
 
|We will create a break here and type "lastname".  
 
|We will create a break here and type "lastname".  
 
|-
 
|-
|1:55
+
|01:55
 
|Next we will create another input box  by copying the previous line and pasting it here.
 
|Next we will create another input box  by copying the previous line and pasting it here.
 
|-
 
|-
|2:03
+
|02:03
 
|So this line is exactly the same  but instead of "firstname", we type in "lastname".  
 
|So this line is exactly the same  but instead of "firstname", we type in "lastname".  
 
|-
 
|-
|2:12
+
|02:11
 
|We will type "input" type equals "submit" and the "value" of that will be "Get data".
 
|We will type "input" type equals "submit" and the "value" of that will be "Get data".
 
|-
 
|-
|2:20
+
|02:21
 
|Hence we have taken the "firstname" and "lastname" and the "submit" button.
 
|Hence we have taken the "firstname" and "lastname" and the "submit" button.
 
|-
 
|-
|2:25
+
|02:25
 
|If I refresh this, we can see "Firstname" and "Lastname" has appeared.
 
|If I refresh this, we can see "Firstname" and "Lastname" has appeared.
 
|-
 
|-
|2:30
+
|02:29
 
|I will delete this for now and to do this I will check if the "submit" button has been pressed.
 
|I will delete this for now and to do this I will check if the "submit" button has been pressed.
 
|-
 
|-
|2:37
+
|02:37
 
|To do this, I will first name the "submit" button as "submit".
 
|To do this, I will first name the "submit" button as "submit".
 
|-
 
|-
|2:42
+
|02:41
 
|Then I will type in an "if" statement - "if dollar underscore POST submit".  
 
|Then I will type in an "if" statement - "if dollar underscore POST submit".  
 
|-
 
|-
|2:51
+
|02:51
 
|If the submit button has been pressed,  start the block.
 
|If the submit button has been pressed,  start the block.
 
|-
 
|-
|2:55
+
|02:55
 
|This is the block of code to be executed and we end our block where we want this to end.
 
|This is the block of code to be executed and we end our block where we want this to end.
 
|-
 
|-
|3:02
+
|03:02
|That is after this curly bracket here because that is a part of our "while" statement here.
+
|This is after this curly bracket here because that is a part of our "while" statement here.
 
|-
 
|-
|3:07
+
|03:07
 
|We don't actually need our while statement for this.  But I will still keep it for the sake of it.
 
|We don't actually need our while statement for this.  But I will still keep it for the sake of it.
 
|-
 
|-
|3:22
+
|03:22
 
|I will now type "grab POST data" and "dollar firstname".
 
|I will now type "grab POST data" and "dollar firstname".
 
|-
 
|-
|3:29
+
|03:29
 
|So this is "dollar underscore POST firstname" and then I will type "lastname".
 
|So this is "dollar underscore POST firstname" and then I will type "lastname".
 
|-
 
|-
|3:35
+
|03:35
 
|I will copy "firstname" and paste it here and change it to "lastname".
 
|I will copy "firstname" and paste it here and change it to "lastname".
 
|-
 
|-
|3:43
+
|03:43
 
|So we have got our "firstname" and "lastname".
 
|So we have got our "firstname" and "lastname".
 
|-
 
|-
|3:49
+
|03:49
 
|I will type "echo" and this message "Record for firstname" . On second thoughts, let us not do this at the moment.
 
|I will type "echo" and this message "Record for firstname" . On second thoughts, let us not do this at the moment.
 
|-
 
|-
|4:02
+
|04:02
 
|I will go straight to my query here.
 
|I will go straight to my query here.
 
|-
 
|-
|4:05
+
|04:05
 
|If you remember, I had mentioned that you can specify what data you want in particular.
 
|If you remember, I had mentioned that you can specify what data you want in particular.
 
|-
 
|-
|4:10
+
|04:10
 
|For this, I will type "SELECT star FROM people WHERE firstname equals Alex and lastname equals Garrett".
 
|For this, I will type "SELECT star FROM people WHERE firstname equals Alex and lastname equals Garrett".
 
|-
 
|-
|4:29
+
|04:29
 
|I had not shown this inside this piece of query where we are selecting.
 
|I had not shown this inside this piece of query where we are selecting.
 
|-
 
|-
|4:40
+
|4:39
 
|I had shown it in the update  where we can update where the firstname equals "Alex" and the lastname equals "Garrett".
 
|I had shown it in the update  where we can update where the firstname equals "Alex" and the lastname equals "Garrett".
 
|-
 
|-
|4:48
+
|04:48
 
|Now we will select everything we want from our table here and we will say select everything where our firstname is Alex to lastname is Garrett.
 
|Now we will select everything we want from our table here and we will say select everything where our firstname is Alex to lastname is Garrett.
 
|-
 
|-
|4:57
+
|04:57
 
|If we look at our database here, we are searching for our firstname and matching it to "Alex", searching the surname and matching it to "Garrett".
 
|If we look at our database here, we are searching for our firstname and matching it to "Alex", searching the surname and matching it to "Garrett".
 
|-
 
|-
|5:07
+
|05:07
 
|We are selecting this whole row of data over here which is highlighted in pink at the moment and we are just selecting the whole data from here.
 
|We are selecting this whole row of data over here which is highlighted in pink at the moment and we are just selecting the whole data from here.
 
|-
 
|-
|5:15
+
|05:15
 
|From the date of birth to gender, my id to my firstname and lastname.
 
|From the date of birth to gender, my id to my firstname and lastname.
 
|-
 
|-
|5:19
+
|05:19
 
|So we have understood that this will select only one record at this time, therefore we don't need to order by the "id".   
 
|So we have understood that this will select only one record at this time, therefore we don't need to order by the "id".   
 
|-
 
|-
|5:27
+
|05:27
 
|But I will keep it like that anyway, since there is only one record.   
 
|But I will keep it like that anyway, since there is only one record.   
 
|-
 
|-
|5:31
+
|05:31
 
|Ordering is not an issue,  so we can just leave it that way.
 
|Ordering is not an issue,  so we can just leave it that way.
 
|-
 
|-
|5:35
+
|05:35
 
|Ok so we are running our loop, we are selecting each part of data here and we are changing our male to "male" and female to "female".  
 
|Ok so we are running our loop, we are selecting each part of data here and we are changing our male to "male" and female to "female".  
 
|-
 
|-
|5:43
+
|05:43
 
|The echoing out our data based on this query because this data based query is specific to my first and surname.
 
|The echoing out our data based on this query because this data based query is specific to my first and surname.
 
|-
 
|-
|5:52
+
|05:52
 
|Then we are only going to echo out the firstname and the lastname over here that has been found, which is my first and lastname but by changing "Alex" here to "firstname" which is here.
 
|Then we are only going to echo out the firstname and the lastname over here that has been found, which is my first and lastname but by changing "Alex" here to "firstname" which is here.
 
|-
 
|-
|6:04
+
|06:04
 
|Now that's a repetition. This is a double variable here.
 
|Now that's a repetition. This is a double variable here.
 
|-
 
|-
|6:08
+
|06:08
 
|We have the "firstname" and so here, I will name this as "firstname underscore form" and "lastname underscore form"  
 
|We have the "firstname" and so here, I will name this as "firstname underscore form" and "lastname underscore form"  
 
|-
 
|-
|6:15
+
|06:15
 
|We will select from where the firstname has been posted equal to this and the lastname that we posted equal to lastname form.
 
|We will select from where the firstname has been posted equal to this and the lastname that we posted equal to lastname form.
 
|-
 
|-
|6:26
+
|06:26
| This is the data that's come from our form.
+
| So This is the data that's come from our form.
 
|-
 
|-
|6:29
+
|06:29
 
|so if I were to type "Alex Garrett" in my html form and submit it then this will equal "Alex" and this will equal "Garrett".
 
|so if I were to type "Alex Garrett" in my html form and submit it then this will equal "Alex" and this will equal "Garrett".
 
|-
 
|-
|6:38
+
|06:38
 
|Our query will return only one result because at the moment we have only one person named "Alex Garrett".  
 
|Our query will return only one result because at the moment we have only one person named "Alex Garrett".  
 
|-
 
|-
|6:44
+
|06:44
 
|So it will take all the data for "Alex Garrett" and check for female or male and then echo out this particular message.
 
|So it will take all the data for "Alex Garrett" and check for female or male and then echo out this particular message.
 
|-
 
|-
|6:51
+
|06:51
 
|So if I come here and refresh at the moment there is nothing because no data has been specified in these form variables here.
 
|So if I come here and refresh at the moment there is nothing because no data has been specified in these form variables here.
 
|-
 
|-
|7:01
+
|07:01
 
|Let me show you. These are empty therefore we are selecting "star" from people under this condition "WHERE the name equals to nothing and the lastname equals to nothing".
 
|Let me show you. These are empty therefore we are selecting "star" from people under this condition "WHERE the name equals to nothing and the lastname equals to nothing".
 
|-
 
|-
|7:12
+
|07:12
 
|That has not returned any data at the moment because what we got in our firstname and lastname are actual peoples names.
 
|That has not returned any data at the moment because what we got in our firstname and lastname are actual peoples names.
 
|-
 
|-
|7:24
+
|07:24
 
|Anyway now I will just type in a completely random name.
 
|Anyway now I will just type in a completely random name.
 
|-
 
|-
|7:29
+
|07:28
 
|So lets say "David Green" and click get data and nothing has happened, ok?
 
|So lets say "David Green" and click get data and nothing has happened, ok?
 
|-
 
|-
|7:36
+
|07:36
 
|If we had an error message at the end over here,  this is our query written over here,  I could say "or die mysql error".
 
|If we had an error message at the end over here,  this is our query written over here,  I could say "or die mysql error".
 
|-
 
|-
|7:50
+
|07:49
 
|I go back here and say "David Green" and click get data and oh! we don't have an error!
 
|I go back here and say "David Green" and click get data and oh! we don't have an error!
 
|-
 
|-
|7:57
+
|07:57
 
|Oh yes that's because the structure of the sql code correct and so we don't get any error.
 
|Oh yes that's because the structure of the sql code correct and so we don't get any error.
 
|-
 
|-
|8:03
+
|08:03
 
|I was just testing that out.  
 
|I was just testing that out.  
 
|-
 
|-
|8:08
+
|08:05
 
|Now lets suppose that we do have a name that's in our database.
 
|Now lets suppose that we do have a name that's in our database.
 
|-
 
|-
|8:10
+
|08:10
 
|Lets say "Alex Garrett" and we click "Get data".
 
|Lets say "Alex Garrett" and we click "Get data".
 
|-
 
|-
|8:13
+
|08:13
 
|We are presented here with alex garrett was bron blah blah blah and is male.
 
|We are presented here with alex garrett was bron blah blah blah and is male.
 
|-
 
|-
|8:19
+
|08:20
 
|Lets type "Dale Garrett" and click "Get data" and we receive that information from the database.
 
|Lets type "Dale Garrett" and click "Get data" and we receive that information from the database.
 
|-
 
|-
|8:27
+
|08:26
 
|So you can see that this is very useful to incorporate forms into our data.
 
|So you can see that this is very useful to incorporate forms into our data.
 
|-
 
|-
|8:32
+
|08:32
 
|I will stop here and go on to the next part where I will be talking about how to update records using this method.
 
|I will stop here and go on to the next part where I will be talking about how to update records using this method.
 
|-
 
|-
|8:40
+
|08:40
 
|Many of you would be able to do that on your own by now but I will take you through it anyways along with a few other useful things.
 
|Many of you would be able to do that on your own by now but I will take you through it anyways along with a few other useful things.
 
|-
 
|-
|8:48
+
|0 8:48
 
|Ok so, see you soon.  This is Evan Varkey dubbing for the Spoken Tutorial Project. (Script contributed by Juanita Jayakar).
 
|Ok so, see you soon.  This is Evan Varkey dubbing for the Spoken Tutorial Project. (Script contributed by Juanita Jayakar).

Revision as of 16:27, 12 July 2013

Time Narration
00:01 Hello Everyone! In the previous tutorial we had selected the data and we successfully displayed the data to our page.
00:09 Let me take you back to this page here.We can see that everything is working fine.
00:15 We have all our data here.
00:17 The next thing we will learn is how to specify somewhere that the user themselves can enter and specify data.
00:23 To do this, I will delete all the codes in my page except "connect include".
00:29 If I don't connect to my database, its not going to work.
00:33 There is a lot of extracting and some other things to be found.
00:42 I will retain firstname, lastname, date of birth, and gender either male or female.
00:53 Below here, I will create a form.
00:55 This will be an html form, so we need to start and end our tags.
01:03 Our "action" will be "mysql dot php" and our "method" is going to be "POST".
01:13 Here we will create a form in which the user can specify a name.
01:18 For the name we will use our "surname".
01:22 You can use any one of them. For example, your date of birth or gender to search.
01:28 It is your choice.
01:30 You could even use 2 fields to search.
01:33 I will now show you how to use 2 fields so that you know that it is not very complicated but easy.
01:40 Here I will type "firstname" and I will create an "input" box of type "text " and the "name" of this will be "firstname".
01:51 We will create a break here and type "lastname".
01:55 Next we will create another input box by copying the previous line and pasting it here.
02:03 So this line is exactly the same but instead of "firstname", we type in "lastname".
02:11 We will type "input" type equals "submit" and the "value" of that will be "Get data".
02:21 Hence we have taken the "firstname" and "lastname" and the "submit" button.
02:25 If I refresh this, we can see "Firstname" and "Lastname" has appeared.
02:29 I will delete this for now and to do this I will check if the "submit" button has been pressed.
02:37 To do this, I will first name the "submit" button as "submit".
02:41 Then I will type in an "if" statement - "if dollar underscore POST submit".
02:51 If the submit button has been pressed, start the block.
02:55 This is the block of code to be executed and we end our block where we want this to end.
03:02 This is after this curly bracket here because that is a part of our "while" statement here.
03:07 We don't actually need our while statement for this. But I will still keep it for the sake of it.
03:22 I will now type "grab POST data" and "dollar firstname".
03:29 So this is "dollar underscore POST firstname" and then I will type "lastname".
03:35 I will copy "firstname" and paste it here and change it to "lastname".
03:43 So we have got our "firstname" and "lastname".
03:49 I will type "echo" and this message "Record for firstname" . On second thoughts, let us not do this at the moment.
04:02 I will go straight to my query here.
04:05 If you remember, I had mentioned that you can specify what data you want in particular.
04:10 For this, I will type "SELECT star FROM people WHERE firstname equals Alex and lastname equals Garrett".
04:29 I had not shown this inside this piece of query where we are selecting.
4:39 I had shown it in the update where we can update where the firstname equals "Alex" and the lastname equals "Garrett".
04:48 Now we will select everything we want from our table here and we will say select everything where our firstname is Alex to lastname is Garrett.
04:57 If we look at our database here, we are searching for our firstname and matching it to "Alex", searching the surname and matching it to "Garrett".
05:07 We are selecting this whole row of data over here which is highlighted in pink at the moment and we are just selecting the whole data from here.
05:15 From the date of birth to gender, my id to my firstname and lastname.
05:19 So we have understood that this will select only one record at this time, therefore we don't need to order by the "id".
05:27 But I will keep it like that anyway, since there is only one record.
05:31 Ordering is not an issue, so we can just leave it that way.
05:35 Ok so we are running our loop, we are selecting each part of data here and we are changing our male to "male" and female to "female".
05:43 The echoing out our data based on this query because this data based query is specific to my first and surname.
05:52 Then we are only going to echo out the firstname and the lastname over here that has been found, which is my first and lastname but by changing "Alex" here to "firstname" which is here.
06:04 Now that's a repetition. This is a double variable here.
06:08 We have the "firstname" and so here, I will name this as "firstname underscore form" and "lastname underscore form"
06:15 We will select from where the firstname has been posted equal to this and the lastname that we posted equal to lastname form.
06:26 So This is the data that's come from our form.
06:29 so if I were to type "Alex Garrett" in my html form and submit it then this will equal "Alex" and this will equal "Garrett".
06:38 Our query will return only one result because at the moment we have only one person named "Alex Garrett".
06:44 So it will take all the data for "Alex Garrett" and check for female or male and then echo out this particular message.
06:51 So if I come here and refresh at the moment there is nothing because no data has been specified in these form variables here.
07:01 Let me show you. These are empty therefore we are selecting "star" from people under this condition "WHERE the name equals to nothing and the lastname equals to nothing".
07:12 That has not returned any data at the moment because what we got in our firstname and lastname are actual peoples names.
07:24 Anyway now I will just type in a completely random name.
07:28 So lets say "David Green" and click get data and nothing has happened, ok?
07:36 If we had an error message at the end over here, this is our query written over here, I could say "or die mysql error".
07:49 I go back here and say "David Green" and click get data and oh! we don't have an error!
07:57 Oh yes that's because the structure of the sql code correct and so we don't get any error.
08:03 I was just testing that out.
08:05 Now lets suppose that we do have a name that's in our database.
08:10 Lets say "Alex Garrett" and we click "Get data".
08:13 We are presented here with alex garrett was bron blah blah blah and is male.
08:20 Lets type "Dale Garrett" and click "Get data" and we receive that information from the database.
08:26 So you can see that this is very useful to incorporate forms into our data.
08:32 I will stop here and go on to the next part where I will be talking about how to update records using this method.
08:40 Many of you would be able to do that on your own by now but I will take you through it anyways along with a few other useful things.
0 8:48 Ok so, see you soon. This is Evan Varkey dubbing for the Spoken Tutorial Project. (Script contributed by Juanita Jayakar).

Contributors and Content Editors

Gaurav, Pratik kamble, Sandhya.np14, Sneha