Choose your database:
MS SQL Server
SQL Anywhere

Subscribe to our news:
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".
Ran / Cole: "We bought the tool last week and want to say how much we love it. We've found it not only powerful, but very user friendly. We have used the tool to create an interface that manages our MySQL DB for different types of users".


Add your opinion

PHP Generator for MySQL online Help

Prev Return to chapter overview Next

View properties

Use the View options to define the way the column data are represented on generated webpages.



Use Display properties to set the type of data representation and format options (text alignment, image size, and so on). The available representations with the corresponding format options are shown in the table below. Format options are specified within the corresponding dialog opened by the ellipsis button next to the Display properties. By default, the format is the same as it is set at the Project options.


Along with available format options you can define your own ones with the Custom attributes option. This option allows you to specify the content of standard HTML style tag applied to the column data. For example, to set the font color and size of the column, enter style="color:red;font-size:20px;" as Custom attributes. To implement more difficult data representation, especially for conditional data formatting, it's recommended to use the OnExtendedCustomDrawRow event.


Available representations

Additional options



It's possible to set such style attributes as text alignment, and font options (bold, italic). The Max length value is the max number of signs to be visible on the generated webpage. You can also allow to replace CR+LF by <BR>, to use HTML and Word wrapping and specify several format options to be applied to the column data depending of data type (Number, Percent, String, Currency).


Select the type of date time format.


If BLOB data will be represented as images, specify the size of all the column images with Resize type and Height and Width fields. Image hints are set with templates.


To resize images, you need to have the appropriate PHP extension installed.

File download

If BLOB data will be represented as file downloads, set a Download file name and a Content type using templates. The Content type value is optional. To change the download image, generate the project and change the download.gif file in the images folder.


There are three display types of boolean data: check box controls, custom images, custom text values. Select the necessary option and specify the custom information (TRUE/FALSE captions or images).

External file, External image

To represent data in such a way, specify the Source prefix and Source suffix.



Suppose there is a 'product' column with such data:




There are image files with the following paths:




To represent these images at the 'product' column on the generated page, Select External Image as View Properties and set

Source prefix=D:\Images\

Source suffix=_62x62.jpg


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.


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


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