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

Subscribe to our news:
Partners
Testimonials
Tony Broadbent: "Such a great product! I have been struggling to hand craft pages which, with your PHP Generator, I created beautifully within 5 minutes of downloading it".
Grey: "We're a two-person company, it's just me an my wife. I'm the technical guru, and she handles the business operations. I have to know a lot about MySQL, but that's much too technical for her. I have frequently had to setup CGI scripts (I code in Perl) so she can manage some of our tables (suppliers, manufacturers, etc).

I discovered PHP Generator a couple of days ago, tried the free version,and within a few hours I had purchased the Pro version (as well as SQL Maestro for MySQL).

Today I am completing the conversion of the last of my custom table managers to PHP Generator. This is eliminating several thousand lines of code that I don't have to support any more!

Thanks for this fantastic product".

More

Add your opinion

PHP Generator for MySQL online Help

Prev Return to chapter overview Next

Page

This tab allows you to specify default page options to be applied to all the generated pages in all applications. These settings can be overwritten for a project as well as for a certain page.

 

Common

These options are applied for all generated pages.

 

Content encoding

The default option value is UTF-8 and you must have really good reasons to change it.

 

Page direction

Allows you to select between Left-to-right and Right-to-left page directions.

 

Modal form size

A preferred size (default, small, or large) for View, Edit, and Insert modal windows.

 

Hide sidebar menu by default

If checked, the sidebar menu will be closed until a user opens it manually.

 

List

These options are applied for List views (both grid and card).

 

Page navigator

Allows you to specify the position of the navigational control(s) and the default number of records displayed on the page. This value may be changed by application users in runtime if the Runtime Customization option is enabled.

 

 

To create a custom pagination, use Data Partitioning.

 

View mode

Select whether page data are displayed in a grid or as info cards. The end-user can easily switch from the grid mode to the card one and vice versa using the Page Settings dialog (if the Runtime Customization option is enabled).

 

 

Number of cards in a row

Allows you to specify maximum number of cards displayed in a row for each screen resolution. These values also can be changed by end-users if the Runtime Customization option is enabled. Live Example.

 

Control buttons position        

Select whether the Edit, View, Delete, and Copy buttons to be displayed on the left side of the generated page or on the right side. Live Example.

 

Bordered table

Check this option to add borders on all sides of the table and cells. Live Example.

 

Condensed table

Turn this option 'ON' to make tables more compact by cutting cell padding in half. Live Example.

 

Highlight row at mouse over

Allows you to enable/disable the highlighting of rows at mouse over.

 

Use images for actions

Defines whether images or text captions are used for control buttons (like Edit, View, or Delete).

 

Use fixed grid header

Allows you to make the grid header are non-scrollable. Live Example.

 

Show key columns images

Turn is 'ON' to mark key columns with the 'key' images.

 

 

Show line numbers

Check this option to add row numbering to the grid. Live Example.

 

Edit/Insert

These options are applied to data input forms.

 

Display "Set NULL" checkboxes

Defines whether "Set NULL" checkboxes are displayed for each control in Edit and Insert forms.

 

Display "Set Default" checkboxes

Defines whether "Set Default" checkboxes are displayed for each control in Edit and Insert forms.

 

Error message placement

Allows you to select the placement for error messages. Possible values are "Below the form", "Above the form", and "Below and above the form". Default value is "Below the form".

 

Reload page after Ajax operations

Allows you to reload the page after Inline or Modal editing/inserting.



Prev Return to chapter overview Next