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

Overview

This document's goal is to present the basic tNG features. We'll create a simple site that will be used to manage a company's departments and employees. Users will be able to display the existing departments, to add a new department, to edit or to delete an existing one. The same will apply for the employees.

Prerequisites

Requirements

This tutorial requires basic knowledge of Macromedia Dreamweaver MX development practices.

To use ImpAKT 2, you will have to install the following software programs:

Macromedia Dreamweaver MX http://www.macromedia.com/
PHAkt2 http://www.interakt.ro/products/PHAkt/
ImpAKT2 tNG license http://www.interakt.ro/products/ImpAKT/
Apache/PHP http://www.apache.org/
A MySQL or PostgreSQL database http://www.mysql.com/ ; http://www.postgresql.org/

Please follow the install notes found in each installation kit to configure your workspace. We presume you have a correctly configured platform for PHP development under Dreamweaver MX (the configured Windows or Linux server, share or FTP access, a Dreamweaver MX site).

Typographic conventions

• The notations and text formats used in this tutorial are found below:
• database name will be displayed using bold font "impakt_database"
• database table: using an italic font "employees_emp"
• database field will be displayed using a bold italic font "id_dep"
• site name: underlined font "new site"
• site page: monospaced italic "index.php"
• recordset name: underlined italic "recordset"
• application button, menu or panel: bold font "Button"
• source code : monospaced font "<?php echo "ImpAKT tutorial"?>"

Files

The ImpAKT 2 tutorial also includes the SQL script to create the database and the zip archive of the "impaktbasics" site that is created below. Users can use these files to overcome some technical difficulties they might have or to compare the results.

The database generation script: impaktbasics_mysql.sql/impaktbasics_pgsql.sql

The "impaktbasics" website: impaktbasics_site.zip (created for MySQL)

Note: These files are available only for registered users.