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

Subscribe to our news:
Partners

Firebird PHP Generator online Help

Prev Return to chapter overview Next

Configuring datasources

Firebird PHP Generator creates webpages aimed at interaction with Firebird tables, views, and queries throw the web. Each webpage contains a grid with data of according datasource supplied with abilities to view, edit, filter, sort, delete, and others.

 

Adding tables and views

To add a table or a view, open the Select object window with the corresponding button.

 

Adding queries

To add a query, type the query text in the Query editor or load it from .sql file with More > Load query from file... Moreover you can use queries stored a single .qrp file (query repository). This feature may be extremely useful if you need to share a set of the same queries between several different projects. To save/load queries to/from a single file, use More > Save all queries as repository / Load query repository items from the More button menu accordingly.

 

Invalid queries

The wizard automatically validates objects and displays names of invalid queries in red. The basic rules of queries usage in PHP Generator projects are covered in the corresponding topic.

 

Primary keys

The wizard automatically inspects all data objects for unique identifiers that are necessary for add, edit, and delete operations. It marks objects without primary key constraints with No key columns label and asks a confirmation on moving to the next step. It's recommended to specify a single column or a set of columns that uniquely identifies each record in the view/query to expedite the work of the generated application. It's optional but preferable.

 

 

 

By default, each script has settings defined by the application options. Of course, you can change them later, but it's useful to setup the generation rules in accordance with settings of the most webpages to reduce further adjustments.



Prev Return to chapter overview Next