Index of Examples

PHP-MySql Example : EMP DEPT Database

This example implements the familiar Emp-Dept-Salgrade database. You can use this interface to execute queries used in the SQL workbook. This database is installed on MySQL5.

Here are the Data base tables and some of the basic data used to create the database.

• EMP table
• DEPT table
• SALGRADE table
• Script to define and load test data

Interactive Query interface.

A web interface allows SELECT statements to be executed agianst this database. Query the Database

When using this web interface:

• the terminating ";" is not required
• use single quotes around strings

This initerface is an example of a three tier architecture using:

• HTML to display input forms and the output of results from queries
• MySQL database engine for the back end data base
• PHP for the intermediate layer to interface between SQL and HTML
• The PHP script