HOME and CODE

PHP & MySQL Home
secure.php
nav.php
notes.php
Download Tutorial

DATABASE

Create Database
Drop Database
Re-Create All

TABLE

Create Table
Drop Table
Add Record
Update Record
Delete Record
Search
View all Records

MORE PHP

PHP Console Apps
PHP Web Apps

PHP and MySQL - Home

A Complete Tutorial Example in One Place

These pages demonstrate

  • The use of PHP with MySQL
  • Creating a database
  • Dropping a database
  • Creating a table
  • Dropping a table
  • Adding records to a table
  • Altering a selected record
  • Deleting records from a table
  • Every page has its full source code made visible
  • There are links to view all the source code of included/required files.

These example pages are as simple as possible and do not implement strong security.

Visiting the "Re-Create All" page will reset the database to its default values. This is also the default start page for visitors to this site so they get a sensible (not hacked) database to work with.