PHP-and-MySQL/C3/MySQL-Part-6/English

From Script | Spoken-Tutorial
Revision as of 12:18, 29 November 2012 by Chandrika (Talk | contribs)

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

Contributors and Content Editors

Chandrika