Choose your database:
MS SQL Server
SQL Anywhere

Subscribe to our news:
Rickey Steinke: "Folks, I wanted to drop a line and give you a fanatic thank you. I have a project due for my computer application course and without PHP Generator I never would have gotten it done with the professional results your product produced. My sincerest gratitude to each and every team member who brought this program to light".
Kirby Foster: "Nice software. Small, lightweight, works well. I evaluated lots of software before deciding that your software worked the best for what I do. Both Maestro for MySQL and PHP Generator have saved me lots of time".


Add your opinion

PHP Generator for MySQL online Help

Prev Return to chapter overview Next


The Columns tab of Page Editor allows you to customize the way column data is displayed for all the available presentations (like List, Edit, Insert, etc). Details are covered below.



Properties specified in this section are applied to all presentations.



Allows you to specify the caption for the column. To provide different captions for different presentations (for example, you might want to specify a shorter caption for the List view and a more longer caption for Insert/Edit form), click the ellipsis button and specify the appropriate values.


Use lookup

Turn this checkbox ON and set the appropriate options to enable displaying of lookup values instead of the "real" values stored in this column. For example, if a column stores country IDs, you can use this option to display country names instead of their IDs (assuming that there is a table that stores the ID/name combination for each country).



By default, PHP Generator for MySQL enables lookups for columns linked by a foreign key with a single column from another table (if the Setup lookups by foreign key option option is enabled).



Use this section to specify the way column values are displayed on List, View, Print, Export, and Compare pages.




Here you can specify some options that are applied only for the List view.


Show column filter

Turn ON the checkbox to enable the column filtering for the appropriate column. Use Sorting and Number of values to display controls to specify the sort order and number of values to be displayed in the column filter dropdown accordingly. Live Demo.


Minimal visibility

PHP Generator for MySQL provides you with an ability to generate responsive pages that look beautiful on any device from a mobile phone up to an extra-large desktop. This option allows you to select the minimum resolution of devices the column will be visible at. Live Demo.


Available values correspond to the device widths as follows:



The column is displayed on all devices.


The column is displayed on all devices with width greater than 768px.


The column is displayed on all devices with width greater than 992px.

Large desktop

The column is displayed only on devices with width greater than 1200px.


Fixed column width

To set a fixed width for a column, check the Fixed width, specify the Width and select the Units. You can use both relative-length (like px or mm) and absolute-length (em, rem, etc) units. Live Demo. More about CSS units.



This option allows you to enable a grid footer to display summaries (Sum, Average, Count, etc) for the selected column. Live Demo.



Allows you to select a control to be used for the selected column in Edit and Insert forms and customize the control's properties.



Filter Builder

Here you can specify operators to be allowed for the selected column in the Filter Builder dialog. To select the operators, open the drop-down list and select/unselect the corresponding options.

Prev Return to chapter overview Next