Choose your SQL server:
AnySQL
MySQL
MS SQL Server
PostgreSQL
Oracle
SQL Anywhere
DB2
SQLite
Firebird
MaxDB

Subscribe to our newsletter

DB2 Data Wizard product tour

Features of DB2 Data Wizard:


PHP Generator

PHP Generator Wizard is a powerful tool allowing you to generate PHP scripts for working with DB2 tables and queries through the web.

You can use the wizard even in case you are only a beginner in PHP! All you have to do is to customize the way your pages will look after the operation is completed. The process of creating PHP scripts and customizing the options is easy, since you are guided by the wizard. As a result, you get a ready PHP-oriented interactive site fragment based on your DB2 database.

If you are eager to economize your time and efforts spent for performing customizing operations, using PHP Generator Wizard templates is exactly what you need!

One of PHP Generator Wizard useful features in the process of PHP scripts generation consists in the availability of field lookup options helping you to customize the HTML appearance of your DB2 databases for easy and efficient operating your data in the future.

If you take two tables which are linked by a master-detail relation, you can enable lookup options for the field which represents the foreign key. Bringing the IDs stored in one table field into correlation with the names stored in another table allows the target HTML page to contain all the correlated data. As a result, while working with the site you will only need to select the required names instead of entering the IDs manually.

To make a comparison, you can view an example of the result page generated with lookup options applied and the one generated without lookup options.

Above all, PHP Generator Wizard provides an ability to specify Security Options allowing you to request user name and password when someone attempts to access your script or to execute some of the specific actions: detailed viewing, adding, editing, or deleting of a table/query row.

You can set Global Security parameters provided for authentication of users attempting to access the whole script or some specific security options, e.g. for editing records.

When setting user name and password, you can either enter them manually within the wizard step or use those stored in one of the existing databases.

By default, no security options are applied to the process of PHP scripts generation.

Back Next