PHP MySQL Introduction

MySQL is the most popular open-source database system.

What is MySQL?
MySQL is a database.
The data in MySQL is stored in database [...]

PHP MySQL Create Database and Tables

A database holds one or multiple tables.

Create a Database
The CREATE DATABASE statement is used to create a database in MySQL.
Syntax

[...]

PHP MySQL Insert Into

The INSERT INTO statement is used to insert new records in a table.

Insert Data Into a Database Table
The [...]

PHP MySQL Select

The SELECT statement is used to select data from a database.

Select Data From a Database Table
The SELECT statement [...]

PHP MySQL Order By Keyword

The ORDER BY keyword is used to sort the data in a recordset.

The ORDER BY Keyword
The ORDER BY [...]

PHP MySQL Update

The UPDATE statement is used to modify data in a table.

Update Data In a Database
The UPDATE statement is used to [...]

PHP MySQL Delete

The DELETE statement is used to delete records in a table.

Delete Data In a Database
The DELETE FROM statement [...]

PHP Database ODBC

ODBC is an Application Programming Interface (API) that allows you to connect to a data source (e.g. an [...]