Web Database Tutorial (PHP & MySQL)

Author:	Marcus Kazmierczak
Version:	Version: 1.2
Created On:	September 1, 1999
Last Modified:	November 25, 2002

This is a tutorial on how to create a web database application using PHP and MySQL on a Unix platform (Linux or Mac OS X). The example used is a database to manage web site links. The same ideas used in this tutorial can be expanded to most web applications like phone directories, personalization, survey polls, etc... All are based on inserting, displaying and managing data in a database.

This tutorial assumes that you already have your system running with the Apache web server, PHP scripting language, and MySQL database server all installed and working properly. You do not have to be running this setup, the web and database concepts are the same, the syntax will be different depending on what you change.

Installation Tutorials

• How to Setup Apache+PHP+MySQL (Mac OS X)
• How to Setup Apache+PHP+MySQL (Linux)

You do not need to know the Structured Query Language (SQL) before hand. You will learn some simple SQL statements with this tutorial, but this is not a complete SQL tutorial (see related links). The four major things you will really want to do with data is covered: (read, insert, edit, and delete)

The tutorial is setup to explain the general concepts and show code examples and then provides the actual PHP pages that implement these concepts. So you can learn by example and seeing how it is implemented. NOTE: All of these pages may download as .phps, they should be renamed to .php

Related Links:

(BOOK) Web Database Applications with PHP & MySQL
How to use the PHP server-side scripting language and the MySQL database engine to underlie dynamic Web sites. Tutorials in both subjects begin with the basics and proceed through moderately complicated stuff. Buy Now from Amazon.com.