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.

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.

SQLite tutorial in PHP

Building SQL application without MySQL.

Last threads of a punBB forum on the home page.

Displaying titles of last phpBB threads on the home page.

Displaying title and summary of last post in Wordpress.