SQL Tutorial

Introduction: What is SQL?

Presenting this query language.

Building an SQL Environment

To run the examples, we have to verify that the host supports PHP and MySQL and we will also install a local server.

Tables and files

Data from a file are stored in the database as a table. A table is made of field, the columns, and records, the rows.

Creating a query interface

Model of interface to send requests to a database.

First SQL program with PHP and MySQL

All the step for using a database, from the creation to the reading, and adding data. This tutorial is based on simple PHP example on a MySQL server. These can work locally on remotely.

One page SQL tutorial: User management
The study of SQL commands to create and manage a file of registered members exposes most of the SQL commands in action.

SHOW and DESCRIBE commands
To display the internal structure of a database, and its columns.

PHP and SQL frameworks

Simplifying the use of a database and reusable Web application components.

SQLite tutorial in PHP

Building SQL application without MySQL.

fluxBB : Last threads of a forum on the home page.

phpBB : Displaying titles of lastthreads on the home page.

Displaying title and summary of last post in Wordpress.