Choose your database:
MS SQL Server
SQL Anywhere

Subscribe to our news:
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".

Dionys Henzen: "Congratulations! Your MySQL PHP Generator is a great tool, that can save a lot of time and money to a developer! I'll evaluate for sure your software products when I need them. Great job".


Add your opinion

PHP Generator for MySQL online Help

Prev Return to chapter overview Next

View controls

The View options define the way the column data is displayed on List, View, Print and Export pages.



Display properties

Select the control to be used to represent column data from the drop-down list. Available controls are:



To set the format to be applied to the column data such as text alignment, image size, and so on, use the dialog opened by the ellipsis button. By default, the format is the same as it is set at the Project options.


Along with available formatting options you can specify any property you want using the Custom attributes option. This option allows you to specify the content of standard HTML style tag applied to the column data.


The Null Label property allows you to customize the representation of NULL values at the column level.


To implement a conditional data formatting, use the OnCustomDrawRow or OnExtendedCustomDrawRow events.


Display as hyperlink

To represent the column's data as hyperlink, check the Display as hyperlink option and specify the HREF Template. Target controls where the new document is displayed when a user follows the link.



opens the new document in a new window.


is used in the situation where a frameset file is nested inside another frameset file. A link in one of the inner frameset documents which uses "_parent" will load the new document where the inner frameset file had been.


puts the new document in the same window and frame as the current document. "_self" works the same as if you had not used TARGET at all.


loads the linked document in the topmost frame... that is, the new page fills the entire window.


Header hint

Use this field to specify the the column caption's hint. By default, it is a comment to the table/view column.


Column filter

Turn ON the checkbox to enable the column filtering for the appropriate column. Use Sorting and Enable search input controls to specify the sort order and allow the search line for the column filter dropdown accordingly.


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.





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 of the grid, check the Fixed width, specify the Width, and select the Units.





The 'font-size' of the relevant font.


(pixels) Relative to the viewing device.


(inches) 1 inch is equal to 2.54 centimeters.






(points) The points used by CSS 2.1 are equal to 1/72nd of an inch.


(picas) 1 pica is equal to 12 points.


The Totals option allows you to enable a grid footer to display summaries (Sum, Average, Count, etc) for all or selected grid columns.

Prev Return to chapter overview Next