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

Subscribe to our news:
Partners
Testimonials
Ananda Theerthan J: "I have been looking for PHP generator for years and now I am happy that I found one. Yes, its the PHP generator for MySQL. I completely rate 10/10 for this product for making life easier. It has lot of features and capabilities especially the CRUD, lookups and data partitioning. I love this product and recommend to others".
Steve Morton: "First let me thank you for making this application Free. Best deal I have ever see for what it does".

More

Add your opinion

PHP Generator for MySQL online Help

Prev Return to chapter overview Next

Configuring datasources

PHP Generator for MySQL creates webpages aimed at interaction with MySQL 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