Web programming with PHP and MySQL

Introduction: What is SQL and SQL injection?
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.

All SQL commands to modify a table
List of commands to modify the structure of a table and change the columns..

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

SQLite tutorial in PHP
Building SQL application without MySQL.

SQLite 3 on Node.js with async/await
Interface to turn each SQLite function synchronous and use them with await, and demonstration.

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

fluxBB: Delete all spammers at once.

phpBB : Displaying titles of last threads on the home page.

Displaying title and summary of last post in Wordpress.

How to test the integrity of tables in a MySQL database.
Works directly on Wordpress, phpBB and FluxBB.

Generating an SQL table directly from a form.
Easing the development phase.