Choose your database:
MS SQL Server
SQL Anywhere

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

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


Add your opinion

SQL Maestro Group / Products / MySQL / PHP Generator for MySQL / News / PHP Generator released

PHP Generator released

May 8, 2018

PHP Generator

SQL Maestro Group is happy to announce a release of PHP Generator, a GUI frontend that allows you to build high-quality and feature-rich data-driven web applications for your database in minutes. There are versions for MySQL, MS SQL Server, PostgreSQL, Oracle, SQLite, Firebird, DB2, SQL Anywhere and MaxDB.

Please find below a detailed description of the most interesting features added in this version. Other new features, corrections, and fixes can be found in the Changelog.

  • A possibility of adding pre-defined options for quick record selection has been added (for example, you can select all countries from Europe or all completed projects in two mouse clicks).
    Selection filtersPicture 1. Selection filters
    To specify such options, use the new OnGetSelectionFilters event.

    Code sample (click to show/hide)

    Listing 1. OnGetSelectionFilters event handler example
    $result = array(
        'Completed' => new FilterCondition(
        'Uncompleted' => new FilterCondition(
        'Important & In progress' => new FilterGroup(FilterGroupOperator::OPERATOR_AND,
                new FilterCondition($columns['priority'],
                        FilterConditionOperator::EQUALS, array('Important')),
                new FilterCondition($columns['state'],
                        FilterConditionOperator::EQUALS, array('In progress'))

  • "Show selected only", "Show unselected only", and "Show all" commands have been added to the selection management button's drop-down menu.
    New selection management commandsPicture 2. Selection filters
  • From now on it is possible to generate thumbnails on uploading multiple images. To enable thumbnail generation and specify the thumbnail properties, specify the corresponding options in the multi upload settings.
    Multiple upload settingsPicture 3. Multiple upload settings
  • Image upload control has been improved. Now it uses File API from HTML 5 that allows to always display "actual" images even if an image has not been uploaded to the webserver yet.
    Improved image upload controlPicture 4. Improved image upload control
  • Two new options have been added to Page Properties, Project Options and Application Options dialogs.
    • The "Reload page after Ajax operations" option allows you to reload the page after Modal and Inline editing/inserting as well as after deleting the record(s).
    • A possibility of choosing the placement for error messages in data input forms has been added. Possible values are "Below the form" (default), "Above the form", and "Below and above the form".
    Newly added optionsPicture 5. Newly added options
  • From now on it is possible to choose whether all or none fields are selected when the multi-edit command is executed.
    Multi-edit settingsPicture 6. Multi-edit settings

For more information about a specific tool see the appropriate page: