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.
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:
i) Downloading and installing MySQL server.
ii) Creating Database
iii) Creating Table
iv) Inserting Information
v) Retrieving Values
PHP Create Database
Posted on: October 31, 2009 If you enjoyed this post then why not add us on Google+? Add us to your Circles