Planning for the Internet with PHP and MySQL

Setting up PHP and creating a development environment
To learn SQL in practice, it is best to install a local server that can execute both PHP scripts and SQL queries.

What is SQL and SQL Injection?
Overview of the database language.

Tables in SQL
The first concept that can be recognized by referring to SQL is the concept of a table. The table transfers the data into a form suitable for use by programs and the database query language.

The first PHP and MySQL program
All stages of using the database are described - from creating to querying and adding data. There are simple examples for this in MySQL-based PHP. These examples work locally or on web hosting.

Creating the SQL Command Interface
It will allow you to make requests directly.

One-Page SQL Tutorial: User Management
Examining SQL commands to create and manage a registered participant file allows you to see most of the SQL commands in action.

SHOW TABLE and DESCRIBE commands
View the structure of a database and its tables.

Commands for Changing the SQL Table Structure
Lists commands for changing the structure of a table and modifying columns.

SQLite tutorial in PHP
An alternative to MySQL that can run locally or online.

SQLite 3 на Node.js с async/await
Interface to make each SQLite function synchronous and use them with await, and demonstration.

flowBB: Show the forum's most recent discussion headers on the home page.

flowBB: Remove spammer registrations

phpBB: Latest forum posts on home page.

Show recent WordPress ticket titles.

Checking integrity of MySQL database tables
Works directly on Wordpress, phpBB and flowBB.

Create a table directly from the form.
To facilitate the stage of development.