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

Subscribe to our news:
Partners
Testimonials
Fred Hildenbrand: "I have purchased MySQL Maestro and like it very much, it has made it much easier to deal with DBA maintenance and table replication as well as a quick way to create SQL statements with the graphical query tool. Good job on a fine product".
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

Customers
SQL Maestro Group / Products / MySQL / News / PHP Generator 11.12 released

PHP Generators are updated to version 11.12

Dec 22, 2011

Prev Next

SQL Maestro Group is happy to announce the release of PHP Generator 11.12, a GUI frontend that allows you to generate high-quality PHP scripts for the selected tables, views and queries for the further working with these objects through the web. There are versions for MySQL, MS SQL Server, PostgreSQL, Oracle, SQLite, Firebird, DB2, SQL Anywhere and MaxDB.

Top 10 new features:

  • Security enhancements. One of the most important features implemented in this version is a possibility of storing user permissions in a database table. This allows you to manage them without re-generation of the scripts using the special Administration Panel (available only for users with the admin permission).

    Administration panelPicture 1. Administration panel

    The Administration Panel and other security features can be seen in action in our demo application.

  • Powerful data export features. New version provides a completely new PDF export engine with Unicode support and great customization abilities. Also we have added the OnCustomRenderExportColumn event to adjust the output data according to your needs.

    Export to PDFPicture 2. Export to PDF

  • New insertion and editing modes. Starting with this version the Save button in the Insert Record form allows you to post changes to the database and re-open the form for adding another record in a single click (without returning to the List page). Another useful thing is a possibility of continue editing of the record after posting the changes in both Edit and Insert forms.

    Insert modesPicture 3. Insertion modes

  • Advanced control management in Edit and Insert forms. From now on you can use new OnInsertFormControlValueChanged and OnEditFormControlValueChanged events to manipulate with form controls. For example, you can enable/disable a certain control or fill a combo box depending on a value entered in another control.

    Control management eventsPicture 4. Control management events

  • Improved project management. Starting with this version PHP Generator allows you to save previously opened project without entering a file name with the Save command. To save the project to a new location, use the Save As command.

    Saving a projectPicture 5. Saving a project

  • Copying and viewing data in modal windows. From now on you can view and copy individual records without opening a separate webpage. The corresponding abilities can be activated for a whole project or for a concrete page.
  • Lookup filtering. Now it becomes possible to filter the contents of lookup controls. Moreover, all the supported variables are accessible in the filter condition. For example, you can use the following syntax:
    Listing 1.
    user_id = %CURRENT_USER_ID%
  • Command line generator. Did you know that PHP Generator can build ready-to-use web application even without running the UI? Automate your work with a few mouse clicks. The result command line can be copied to Clipboard or saved to a batch file.
  • Bug report sender. Found an occasional bug? Even sending a bug report becomes a pleasure with the new version. Nevertheless we hope you will not use it too often.
  • Speeded up schema refreshing. We have improved the algorithm of the metadata refreshing to save a few moments of your valuable time.

In addition to this, several bugs have been fixed and some other minor improvements and corrections have been made. For more information about a specific tool see the appropriate page:

Prev Next
Back to news archive