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

|Time

|Narration

|Welcome to the Spoken Tutorial on the fourth part of '''MySQL''' and '''php''' tutorials.

|In the last tutorial, I used "mysql_query()" function to insert some values into our '''table'''.  

|I made a mistake here by putting the date as current date which isn't my date of birth.  

|I was able to update here. I was also able to specify where I wanted to update  

|using a unique '''id''' key, I was able to specify exactly where I wanted to update.

|So we've already seen the "update" in '''mysql code'''.

|This '''query''' and '''code''' is the one that is mostly used while working with '''tables''' or if you're working with '''mysql''' in general.

|The next thing I show you is how to get data from your table and how to display it really well.

|So, I will call this "update data" so that we know what that is.  

|Now, again we will say "$extract" and we will create a variable.  

|This again is '''mysql_query''' and here is some code.

|We use '''single line queries''' here but we could have some code after this in order to display properly.

|First I will create another '''record''' in the '''table'''.  

|So, we don't need this "current date" function anymore.  

|I need this "$write" to be shown. Let's create some new value.

|I'll say 'Kyle', 'Headen' and I'll set a date of birth here. This one is month. So that is the 7th and let's say here, 24th.

|So, now we got the date of birth.   

|Now we've got '''male''' and then we've got "Kyle Headen" and we are again inserting this into our database.

|Let's '''refresh'''.

|I'll say 'Emily', 'Headen' and I'll just leave the date of birth as it is, for now.  

|'''Refresh''' this again.

|So, we've created 3 records here.

|I'll '''comment''' this "$write". Backup my database.

|I'll click on '''Browse''' in this specific table and you can see that I've got 3 '''records'''.

|We can see this '''id''' has also automatically incremented.

|Our '''mysql_query''' is going to start with "SELECT".  

|What you could do is type "SELECT firstname".  

|But usually when you have table, you will need most of the data and it'll take longer to do.

|So, you already have a couple of records or '''fields'''.  

|But, for now, I'll say select asterisk (*) which is a star.  

|We can say: '''SELECT''' star and then we say '''FROM'''.  

|Again we say the specified '''table''' which is "people".  

|Here, we can say '''WHERE''' and how can you ummm...... filter for the data you want.

|So, I can say: "SELECT star (*) FROM people WHERE firstname= 'Alex' ".  

|We can do this by using another really useful function called '''mysql_num_rows()''' and what I can do is '''echo''' this out.

|I'll say: '''echo mysql_num_rows()'''. This is the reason we have given these variables here to be stored in.

|Here we can just type '''$extract'''.

|Our '''$extract''' variable holds our '''query''' and our '''function''' here tells us how many rows are there in the query that is given out.

|Presuming that we gave '''firstname''' as "Alex", it'll show when we '''refresh'''.  

|Let's change this. Let's put something that's common to two people in this database.

|So that'll be "Male" or "Female" . Here we can say "WHERE gender = 'M' " and when we refresh, we get two records.

|So, we can tell how many records we are getting out.

|This is really useful for saying how many people in my database are males, for example.

|So, you can store registered information inside here.  

|So, I'll say '''ORDER BY id''' and we can choose descending that is "DESC" and  we can choose ascending, which is "ASC".  

|But, for now, I'll take this out because we haven't actually echoed out our data yet.  

|Now, here I'll say: '''select''' star (*) '''FROM "people" ''' because I want to select all the data from this table here.  

|So, I can manipulate and show it to the user the way I want.

|I'll create something here called "$numrows";  "numrows =" that.

|I'll use a '''while''' loop. This will use a specific '''function''' which is "mysql_fetch_assoc()".

|If you don't know what an associative array is, check out '''Arrays''' tutorial.  

|Coming back,  "WHILE the $row = mysql_fetch_aasoc()" or associative is what I will say and this is inside the "$extract" query.

|We are selecting "$row" as array name and we are selecting this as an array for all the selected data.

|I'll stop here.  In the next tutorial I'll show you how to '''echo''' out all of this data.