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

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

Mark Worsnop: "By the way I wanted to say thank you for a good software package. It's a pleasure to work with Maestro as it "just works" and makes my job that much easier".

More

Add your opinion

Customers
SQL Maestro Group / News / All company news / PHP Generator 18.3.0.2 released

PHP Generator 18.3.0.2 released

May 8, 2018

Prev Next
PHP Generator

SQL Maestro Group is happy to announce a release of PHP Generator 18.3.0.2, 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(
        $columns['state'],
        FilterConditionOperator::EQUALS,
        array('Completed')
    ),
    'Uncompleted' => new FilterCondition(
        $columns['state'],
        FilterConditionOperator::DOES_NOT_EQUAL,
        array('Completed')
    ),
    'Important & In progress' => new FilterGroup(FilterGroupOperator::OPERATOR_AND,
        array(
            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:

Prev Next
Back to news archive