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

Subscribe to our news:
Partners
Testimonials
David Lantz: "Thank you, this is by far the simplest, and most friendly utility for building db record system I have ever used. I wish I could get my systems guys at the office to purchase this for our company would be so very helpful and speed up a lot of work. I for one have used it for everything from a simple inventory record of my house, to a members record for my church just little pet projects and a test bed to test my own db builds and theories before having to hand code at the office..... it is a lot of fun to work with".
Peter Robinson: "As a tech savvy company director, I wanted an inexpensive web based database application to manage all aspects of my business. As with most humans I find developing purely by CLI very hard and do not have the will or time to invest in improving my skills. I was looking to find a nice human friendly GUI to design and build my application, which is when I came across PHP Generator for MySQL.

Whilst you still need a great understanding of logic and a small amount of programming ability to get the specific results you require, I am very happy with the speed of progress I have been making with this invaluable tool.

With all the standard libraries included, this product makes normal requirements such as JavaScript form validation, lookup selectors, on click events, auto complete, detailed searches, multiformat exports, rss feeds and username security straight forward and quick.

Having any changes made via the GUI written to the web server at the click of a button makes testing out ideas quick and easy without fear of breaking your application.

To conclude, I couldn't find any other product on the market that came close to offering the amount of options this does, and I do hope that more products like this come out in the future, with the hope of eventually eradicating the need to program all together".

More

Add your opinion

PHP Generator for MySQL online Help

Prev Return to chapter overview Next

Columns

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.

 

Common

Properties specified in this section are applied to all presentations.

 

Caption

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).

 

View

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

 

 

List

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:

 

Phone

The column is displayed on all devices.

Tablet

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

Desktop

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.

 

Totals

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

 

Edit/Insert

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