Choose your database:
MS SQL Server
SQL Anywhere

Subscribe to our news:
Manu Gupta: "What I can say about it is that its simply awesome. I just used it for a day only, and explored a lot of things in it. Wow, its great. Thanks for such a nice tool. My wishes are with you".
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".


Add your opinion

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

PHP Generator released

Jun 10, 2015

Prev Next
PHP Generator

SQL Maestro Group is happy to announce the next minor update of PHP Generator, 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.

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

  • Brand new Autocomplete and Multi-level autocomplete editors have been implemented. The following new features are now at your disposal:
    • Enhanced look and feel. New editors look much more stylishly than their previous versions. In particular they allow end users to clear the selected value using special button (for the multilevel editor this action also clears the selection for all underlying controls).
      Autocomplete Editor in actionPicture 1. Autocomplete Editor in action
      It is also possible to specify minimal amount of symbols to start the search (makes sense for large lookup datasets where short search terms are not very useful).
      Autocomplete Editor: Minimum input lengthPicture 2. Autocomplete Editor: Minimum input length
    • Formatting functions. New editors provide you with an unprecedented flexibility for formatting search results and the selection. For example, it is possible to use fonts, colors, images, and so on. All you need is to specify two functions in JavaScript each of which accepts the current item as a parameter and returns the HTML code to represent search results and the selected item accordingly. In the example below search results are displayed in italic and the selected item is displayed in bold.
      Listing 1. formatResult function
      return '<i>' + item.text + '</i>';
      Listing 2. formatSelection function
      return '<b>' + item.text + '</b>';
      The editor now looks as follows:
      Autocomplete EditorPicture 3. Autocomplete Editor
      For the Multi-level editor formatting functions can be specified at the level basis. The screenshot below is from our demo application:
      Multi-level Autocomplete EditorPicture 4. Multi-level Autocomplete Editor
      Another good news is that formatting functions can be assigned via JavaScript API. Here is a simple example for the Multi-level editor:
      Listing 3. OnEditFormLoaded event handler example
                          function(item) {return "<b>" + item.text + "</b>";})
                          function(item) {return "<i>" + item.text + "</i>";})
      Of course it is also possible to define these functions in the User JavaScript window and then use them in event handlers.
    To localize these controls, translate the appropriate strings in the language files. Please don't forget to send us the updated translations. :)
  • Multiselect editor has been implemented. It provides the same functionality as Checkbox Group (i.e. allows you to select several options for a single field) but looks much different and requires less space in the forms.
    Multiselect Editor in actionPicture 5. Multiselect Editor in action
    The "Maximum selection size" property allows you to restrict number of items that can be selected simultaneously.
    Multiselect Editor: Maximum selection sizePicture 6. Multiselect Editor: Maximum selection size
    To add/remove items to the editor in runtime, use the appropriate functions from the JavaScript API.
  • A new Lightbox component has been incorporated. The old one looked ugly.
    New Lightbox componentPicture 7. New Lightbox component
  • HTML filter becomes available for Text, Text area, and WYSIWYG editors. Use it to strip unwanted HTML tags and attributes from user input. By default all tags and attributes are stripped out, so you have to define allowed items explicitly.
    HTML filter settingsPicture 8. HTML filter settings
    Settings on the screenshot above are to allow the <a> tag (optionally with the href attribute as well as the <strong> and <h1> tags. All other tags and attributes will be removed from the user input.
  • Password storing algorithm has been significantly updated. For security reasons, details are not disclosed.

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

Prev Next