Programming the Web with PHP and MySQL Tutoriel

♠ Posted by Unknown in PHP & MySQL at 23:07

According to Article famous O'Reilly Web 2.0, the SQL language was to popularize and become as common as HTML on websites, which seems to happen, few sites currently do not use the language in a script or CMS. Blogs based on Wordpress, for example, record the items in a MySQL database.

So a webmaster should know the language, and this tutorial is intended for that.

Tutoriel SQL

Configure PHP and create the development environment
SQL to learn by doing, it is best to install a local server that can run both PHP scripts and SQL queries.
What is SQL and SQL injection?
Database Language Overview.
The tables in SQL
The first notion to know SQL is addressing the concept of table. A table translates the data in a form usable by the program and by the language database query.
First PHP and MySQL program
All steps in the use of a database are described, from creation to the query through the addition of data. For that one has simple examples in PHP on a MySQL database. These examples work locally or on a web hosting.
Create a SQL command interface
It will perform query directly.
SQL tutorial on one page: User Management
The study SQL commands to create and manage a file registered members can see most of the SQL commands in action.
DESCRIBE TABLE and SHOW commands
Show the structure of a database and its tables.
The commands to change the SQL table structure
List of commands to change the table structure and change the columns.

SQLite

SQLite PHP Tutorial
Alternative to MySQL that can run locally or online.

Applications

FluxBB: Show Titles recent discussions of a forum on the home page.
phpBB: Latest posts of a forum on the home page.
Show titles last Wordpress tickets.

Scripts

How to test the integrity of tables in a MySQL database
Works directly on Wordpress, phpBB and FluxBB.
Generate a table directly from a form.
To facilitate the development phase.