1. Overview
2. Getting started
3. Creating the departments list
4. Creating the Insert Transaction
5. Creating the Update Transaction
6. Creating the Delete Transaction
7. Conclusions

Conclusions

In this tutorial we have created a simple website used to administrate a departments list in an organization. To fulfill this task we have created the "impaktbasics" database and the "departments_dep" and "employees_emp" tables, a main page used to display the departments list ("index.php"), an insert page to add new departments ("insert.php"), an update page ("update.php") to modify an existing one and a delete page used to delete existing departments ("delete.php").

Using tNG we have created a simple database administration tool with ease, a small code signature using OOP design, while preserving a defensive programming style (error checking, user control) and using a simple and maintainable page design.

Future directions

This tutorial can serve as a starting point for you and many extensions can be added to it, especially regarding application logic. You can add triggers to cascade the deletes when deleting a department (to delete all the employees in this department), or to restrict the insert of an employee if the inserted linked department does not exist.

Appendix I - versions

To create this tutorial we have used the following software versions:

Code Generators: Macromedia Dreamweaver MX 6.0

Extensions:

• ImpAKT 2.0-0.2.8
• PHAkt 2.0.73

Database server: MySQL

PHP: PHP 4.2.3

Webserver: Apache Web Server 1.3.27

Operating systems:

Workstation: Microsoft Windows 98

Web server: Redhat Linux 7.2