Did you know?

if you register at Hamid School you can save up to 45% on hosting packages offered by Surreyhost.com .

Don't miss out, every minute counts!

Register now!

Are you Confused? Click here to learn how to use hamid school

PHP MySQL Introduction

MySQL is the most popular open source database server.

What is MySQL?

MySQL is a database. A database defines a structure for storing information.

In a database, there are tables. Just like HTML tables, database tables contain rows, columns, and cells.

Databases are useful when storing information categorically. A company may have a database with the following tables: "Employees", "Products", "Customers" and "Orders".

Database Tables

A database most often contains one or more tables. Each table has a name (e.g. "Customers" or "Orders"). Each table contains records (rows) with data.

Below is an example of a table called "Persons":

The table above contains three records (one for each person) and four columns (LastName, FirstName, Address, and City).

Queries

A query is a question or a request.

With MySQL, we can query a database for specific information and have a recordset returned.

Look at the following query:

SELECT LastName FROM Persons

The query above selects all the data in the LastName column in the Persons table, and will return a recordset like this:

Download MySQL Database

If you don't have a PHP server with a MySQL Database, you can download MySQL for free here: http://www.mysql.com/downloads/index.html

Facts About MySQL Database

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

The truth is that MySQL is the de-facto standard database for web sites that support huge volumes of both data and end users (like Friendster, Yahoo, Google). Look at http://www.mysql.com/customers/ for an overview of companies that use MySQL.

• Introduction to PHP
• PHP Installation
• PHP Syntax
• PHP Variables
• PHP String
• PHP Operators
• PHP If...Else Statements
• PHP Switch Statement
• PHP Arrays
• PHP Looping
• PHP Functions
• PHP Forms and User Input
• PHP $_GET
• PHP $_POST
• PHP Date
• PHP Include File
• PHP File Handling
• PHP File Upload
• PHP Cookies
• PHP Sessions
• PHP Sending E-mails
• PHP Secure E-mails
• PHP Error Handling
• PHP Exception Handling
• PHP Filter
• PHP MySQL Connect to a Database
• PHP MySQL Create Database and Tables
• PHP MySQL Insert Into
• PHP MySQL Select
• PHP MySQL The Where Clause
• PHP MySQL Order By Keyword
• PHP MySQL Update
• PHP MySQL Delete From
• PHP Database ODBC

Did you know?

if you register at Hamid School you can learn web programming and designing for free and also you can save up to 45% on hosting packages offered by Surreyhost.com .

Don't miss out, every minute counts!

Register now!