PHP-and-MySQL/C3/MySQL-Part-1/English-timed
From Script | Spoken-Tutorial
Time | Narration |
---|---|
00:00 | Hi everyone! |
00:01 | This is a pure My SQL php tutorial. |
00:07 | I will teach you the basics of connecting, retrieving data, handling errors and modifying data. |
00:15 | So that will cover some SQL code and some SQL queries. |
00:21 | Ok! Lets start. |
00:24 | Here I am going to show the directory structure of "mysql" |
00:27 | and we will create a couple of files here. |
00:29 | I will create the first file and call it "connect.php". |
00:34 | I will come here, click on the folder called "mysql" and Save this as "connect.php" |
00:40 | Now here we will create a separate file and include with every page that we use. |
00:46 | This is a lot easier to connect to your database |
00:50 | What we will do is type our "include" function and specify this file. |
00:55 | I will create another file which is my main "mysql" file |
01:02 | with a code that I will show you all. |
01:03 | Ok so I have got my mysql dot php open. |
01:07 | This is php codes and we need the php tags and the same will connect to php |
01:13 | I will explain this "include" function in a minute. |
01:18 | First, I will teach you how to connect to the database. |
01:23 | If you don't know where you have it stored on your webserver, then I suggest you check out an application called phpmyadmin. |
01:38 | It is a database interface php written program or in other words a script. |
01:44 | Here we will look at the inside of my database, my service. |
01:51 | Rather my server, My SQL server. It gives our table information, our database information and information about my server etc etc. |
02:03 | Although, we don't need to know about it, this is a good start to a program, if you are just starting to use a php mysql or just mysql in general. |
02:10 | It is a good way to start interfacing with your database, instead of using the command line to do things. |
02:17 | Using command line could be difficult for the first timers. |
02:21 | Ok, so what we see here are, our databases. |
02:25 | I have got one called "phpacademy" and I have got one called "phplogin" which I mentioned in another tutorial that I have created. |
02:30 | The others are just a standard. |
02:32 | They are just for holding data. |
02:33 | Don't delete them. |
02:36 | All you need to do is create new databases. |
02:39 | To do this, you have got a simple box here. |
02:41 | We are just going to create databases. |
02:43 | I will work within my php academy database for now. |
02:51 | It is a lot easier. |
02:53 | So its creating a database now. |
02:55 | It is simple. |
02:56 | You type in the name and click on "Create". |
02:59 | My php has already been created here. |
03:00 | So I will use this one. |
03:02 | Click on it and you can see that there are several tables inside. |
03:06 | This is denoted by the symbol here when using phpmyadmin. |
03:09 | This is guestbook from my guestbook tutorial. |
03:12 | Now I will create a new table on this database for the specifics of this tutorial and I shall call it "people". |
03:28 | The number of fields is quite important. |
03:31 | You can't leave this blank. |
03:32 | The number of fields on your table is for storing each column of data. |
03:41 | For example, the first one usually when you are dealing with records, you can have an ID which is a numerical value. |
03:47 | So it is a number that is going to increment each time. |
03:50 | It will allow you to reference your records being stored individually by the unique number. |
03:59 | And usually set this to the primary key. |
04:01 | If you are not familiar with the databases, you need to start looking out for terms like primary key. |
04:08 | I will not be dealing with secondary keys because its quite flexible way to do this anyway with mysql database. |
04:16 | Just read up on databases in general, if you have Microsoft access or any other database program. |
04:25 | I suggest you to learn about groups of database. |
04:29 | Ok, so the number of fields depends on how much data you want to store and what data you want to store. |
04:36 | Usually when I am creating fields, I will bring out an usual blank document. |
04:40 | And I will start by typing out the fields that I want. |
04:43 | The first one is always going be ID. |
04:45 | This is a self incrementing value every time I create a new record. |
04:50 | So it will be 1 for the first record, 2,3,4 and the data will be stored after this. |
04:58 | It is a very useful field. |
05:01 | Since my table is called "people", I will store some data about people. |
05:07 | So I will first type in the firstname and then I will type in the lastname and then age and then gender. |
05:16 | We can leave it there for now, to keep it simple. |
05:20 | So here we can see that we have got 5 fields. |
05:23 | I shall go back here and type in 5 and click "Go". |
05:28 | It will also be great to see a pop up here in a minute. |
05:32 | No you won't because we haven't created our field names yet. |
05:35 | Ok! We have a standard here. |
05:37 | There are a lot of options for these. |
05:40 | But, a field is a fieldname. |
05:41 | So the first one is going to be "ID". |
05:43 | The type is the data type, that you want to store this field in. |
05:47 | Anything that goes into it must be added here to this datatype. |
05:50 | "varchar" which stands for variable characters is quite common. It is a very useful one and it requires a length. |
05:57 | We can have 25 characters long here. |
06:00 | You could have 250 characters long. |
06:02 | Or 100 characters long. |
06:04 | Or 1 character long. |
06:06 | Actually we are just storing the type and the length of the data stored. |
06:14 | It helps in storing, for example your firstname. |
06:19 | Lets say our fieldname here is "firstname" and I have a "varchar". |
06:24 | There is no point in typing in 500 characters because we will be using unnecessary amount of data. |
06:33 | A typical firstname will not be more than 25 characters. |
06:37 | Even if it is, it will not be more than 30 or 35 characters. |
06:42 | But for now I will store my "firstname" as 20 or 25 characters, I will put 20 here. |
06:48 | Our "ID" will be an integer because it is a number. |
06:54 | It will be self incrementing. |
06:55 | This will be 1,2,3,4 |
06:56 | The amount of records we use. |
06:57 | And we have some other options here. |
07:02 | Now this here is primary key. |
07:04 | We are going to select it and at extra, we can see that we got "auto underscore increment". |
07:09 | This is an auto increment. |
07:11 | It will give this particular function. |
07:13 | Whenever you enter a new record, this will also automatically go up. |
07:19 | So here we have "firstname". |
07:21 | We have "lastname" and again I will set this as 30. |
07:26 | And what else do we have??? |
07:28 | We have "age" and obviously this is an integer and we have "gender". |
07:34 | Ok. |
07:36 | Now here instead of "age", I will say say "Date of birth". |
07:40 | So this is Date of Birth. |
07:44 | I will set this as date. |
07:46 | Here I am trying to find a date datatype and I will see how this works. |
07:52 | So our length for date doesn't have to be set here. |
07:55 | We have a standard format for this. So we don't have to worry about that. |
08:00 | Now I will set the "gender" as "varchar" of character 1. |
08:07 | Now we can store "M" for male and "F" for female. |
08:12 | Ok. If we go across here, we can see that there are a lots of options. |
08:18 | You can comment this yourself. |
08:19 | You can remind yourself what this field does. |
08:22 | But usually name your fieldname appropriately so you know what data you are saving. |
08:26 | Ok. Here I will click on "Save" and you can see that "people" has appeared here. |
08:35 | This will ask you a query here. |
08:38 | Now when I was talking about command line earlier, this is what you have to type to create that. |
08:41 | However, we have used a graphic user interface to save ours. |
08:45 | We can see down here, we have our fields, our types and our collation attributes, null data for example. |
08:52 | The default value that is stored as.... say for example if you had a field saying "Has the user registered?" |
09:02 | Or anything of your choice. You could use the default here too. |
09:13 | For example if I wanted to store everyone, I have registered here as male by default or female by default, I could type "M" or "F" here. |
09:21 | And we have auto increment here and also some other data that we don't need to know about in this tutorial. |
09:26 | Ok here we have created our table and if you go in part II of this, I will show you how to insert some data and also how to retrieve this data from your database using php. |
09:39 | Join me in part 2. This is Evan Varkey dubbing for the Spoken Tutorial Project. (Script contributed by Juanita Jayakar). |
Contributors and Content Editors
Minal, PoojaMoolya, Pratik kamble, Sakinashaikh, Sandhya.np14, Sneha