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

!Time

!Narration

|This is a pure My SQL php tutorial.

|So that will cover some SQL code and some SQL queries.

|Ok! Lets start.

|Here I am going to show the directory structure of "mysql"

|I will come here, click on the folder called "mysql" and Save this as "connect.php"

|Now here we will create a separate file and include with every page that we use.

|This is a lot easier to connect to your database

|What we will do is type our "include" function and specify this file.

|Ok so I have got my mysql dot php open.

|This is php codes and we need the php tags and the same will connect to php

|First, I will teach you how to connect to the database.

|If you don't know where you have it stored on your webserver, then I suggest you check out an application called phpmyadmin.

|It is a database interface php written program or in other words a script.

|Here we will look at the inside of my database, my service.

|Rather my server, My SQL server.  It gives our table information, our database information and information about my server etc etc.

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

|It is a good way to start interfacing with your database, instead of using the command line to do things.

|Using command line could be difficult for the first timers.

|Ok, so what we see here are, our databases.

|The others are just a standard.

|All you need to do is create new databases.  

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

|So I will use this one.  

|Click on it and you can see that there are several tables inside.

|This is denoted by the symbol here when using phpmyadmin.

|This is guestbook from my guestbook tutorial.

|The number of fields is quite important.  

|The number of fields on your table is for storing each column of data.

|For example, the first one usually when you are dealing with records, you can have an ID which is a numerical value.

|So it is a number that is going to increment each time.

|And usually set this to the primary key.  

|If you are not familiar with the databases, you need to start looking out for terms like primary key.

|I will not be dealing with secondary keys because its quite flexible way to do this anyway with mysql database.

|Just read up on databases in general, if you have Microsoft access or any other database .  

|The first one is always going be ID.

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

|So I will first type in the firstname and then I will type in the lastname and then the age and the gender.

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

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

|But, a field is a fieldname.

|So the first one is going to be "ID".

|The type is the data type, that you want to store this field in.

|Anything that goes into it must be added here to this datatype.

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

| 50 characters long.

|It helps in storing, for example your firstname.  

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

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

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

|The amount of records we use.  

|That is here is primary key.

|We are going to select it and at extra, we can see that we got "auto underscore increment".

|This is an auto increment.  

|So here we have "firstname".

|Ok.

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

|So this is Date of Birth.

|I will set this as date.  

|Here I am  trying to find a date datatype and I will see how this works.

|So our length for date doesn't have to be set here.

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

|But usually name your fieldname appropriately so you know what data you are saving.

|Ok. Here I will click on "Save" and you can see that "people" has appeared here.

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

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