phpNeeds.com

MySQL is the open-source database system.

Database: A database is a collection of tables, with related data.

Table: A table is a collections of related data entries and it consists of columns and rows.

Databases are useful when storing information categorically. A college may have a database with the following tables: “Employees”, “Students” and “Departments”.

MySQL PHP Syntax

MySQL works very well in combination of various programming languages like PERL,JAVA and PHP. Out of these languages, PHP is the most popular one because of its web application development capabilities.

This tutorial focuses heavily on using MySQL in a PHP environment. PHP provides various functions to access MySQL database and to manipulate data records inside MySQL database.

The PHP functions for use with MySQL have the following general format:

mysql_function(arg 01,arg 02,…);