With PHP, you can connect to and manipulate databases.

MySQL is the most popular database system used with PHP.

What is MySQL?

  • MySQL is a database system used on the web
  • MySQL is a database system that runs on a server
  • MySQL is ideal for both small and large applications
  • MySQL is very fast, reliable, and easy to use
  • MySQL supports standard SQL
  • MySQL compiles on a number of platforms
  • MySQL is free to download and use
  • MySQL is developed, distributed, and supported by Oracle Corporation
  • MySQL is named after co-founder Monty Widenius’s daughter: My

The data in MySQL is stored in tables. A table is a collection of related data, and it consists of columns
and rows.

Databases are useful when storing information categorically. A company may
have a database with the following tables:

  • Employees
  • Products
  • Customers
  • Orders


  • PHP combined with MySQL are cross-platform (you can develop in
    Windows and serve on a Unix platform)


A query is a question or a request.

We can query a database for specific information and have a
recordset returned.

Look at the following query (using standard SQL):

SELECT LastName FROM Employees

The query above selects all the data in the “LastName” column from the “Employees”

To learn more about SQL, please visit our SQL

Download MySQL Database

If you don’t have a PHP server with a MySQL Database, you can download MySQL
for free here:

Facts About MySQL Database

One great thing about MySQL is that it can be scaled down to support embedded
database applications. Maybe it is because of this many people
think that MySQL can only handle small and medium-sized systems.

The truth is that MySQL is the de-facto standard database system for web sites
with HUGE volumes of both data and end users (like Friendster, Yahoo,
and Google).


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s