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

!Time

!Narration

|00:00

|00:01

|This is a pure My SQL php tutorial.

|00:07

|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

|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

|01:02

|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

|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

|02:30

|The others are just a standard.

|02:32

|02:33

|02:36

|All you need to do is create new databases.  

|02:39

|02:41

|02:43

|I will work within my php academy database for now.

|So its creating a database now.

|It is simple.

|You type in the name and click on "Create".

|02:59

|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

|03:28

|The number of fields is quite important.  

|03:31

|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

|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

|04:29

|04:36

|04:40

|04:43

|The first one is always going be ID.

|This is a self incrementing value every time I create a new record.

|04:58

|05:01

|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

|So here we can see that we have got 5 fields.

|I shall go back here and type in 5 and click "Go".  

|05:32

|05:37

|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.

|We can have 25 characters long here.

|You could have 250 characters long.

|06:06

|It helps in storing, for example your firstname.  

|06:19

|Lets say our fieldname here is "firstname" and I have a "varchar".  

|06:33

|A typical firstname will not be more than 25 characters.

|06:37

|06:42

|But for now I will store my "firstname" as 20 or 25 characters, I will put 20 here.  

|Our "ID" will be an integer because it is a number.

|06:54

|06:56

|The amount of records we use.  

|06:57

|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

|07:13

|07:19

|So here we have "firstname".

|07:21

|07:26

|07:28

|Ok.

|Now here instead of "age", I will say say "Date of birth".

|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

|08:00

|Now I will set the "gender" as "varchar" of character 1.

|08:07

|08:18

|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:41

|08:45

|08:52

|09:02

|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: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