PHP Database


 

PHP Database

PHP Database: In this tutorial you will get to know about databases, tables, query and other related things like how to access databases using PHP etc. This is the first index page of this tutorial

PHP Database: In this tutorial you will get to know about databases, tables, query and other related things like how to access databases using PHP etc. This is the first index page of this tutorial

PHP Database Creation

A simple website is made of the following technologies:

i)    HTML/CSS: HTML & CSS is used to get the user interfaces, and a pretty look for the web site.

ii)    PHP: PHP processes the forms and other dynamic wizardry.

iii)    Database: We need to store several data e.g.- user list, product information etc. There are different databases are available in market, we need to choose any specific database according to our need.

Many more technologies could be used in web site development like: JavaScript etc. for validation checking.

Now in this tutorial you will get to know about databases, tables, query and other related things like how to access  databases using PHP etc.

Database: In general a database is a collection of  logically related files or records. A database could be a pile of structured information, a program (e.g. MySQL, or Oracle) which manages those structured information, or the computer on which the program runs.

Table: Table is a collection of rows and columns. Columns keep only one specific (e.g. First-Name, Last-Name, Age etc. ) data where rows are the collection of columns (e.g. Sachin, Tendulkar, 37 etc.). Tables store data in a grid like pattern of columns and rows.

Query: In database a query is a set of specific words which are collectively used to retrieve the desired information.

In the following PHP Database tutorial we will study various things of PHP Database, like:

A)   MySQL

    i)    Downloading and installing MySQL server.

    ii)    Creating Database

    iii)    Creating Table

    iv)    Inserting Information

    v)    Retrieving Values

 

Ads