Softpedia >Windows >Internet >Servers >Database Utils >PHP Generator for MySQL Professional >  Changelog

PHP Generator for MySQL Professional Changelog

What's new in PHP Generator for MySQL Professional 12.8.0.18

Jul 20, 2014
  • Ability to specify several output paths for a project is added (useful if you want to test the generated app under several local webservers).
  • Now it is possible to include/exclude all columns to/from a certain presentation with a single click.
  • Editors for entering file name templates (for example, in the Upload file to folder properties dialog) become more convenient.
  • MS SQL: default content encoding is set to ANSI.
  • Some client-side events did not fire for Insert forms in master/detail pages.
  • Changes of column properties at the General tab could be displayed incorrectly for columns excluded from the List view.
  • Headers of "Stored value" and "Display value" columns in Radio/Checkbox group editors are not swapped anymore.
  • Popup hints for "More" links become available for columns of detail rows in master/detail views.
  • Popup hints for "More" links could be displayed for non-english texts even if the text is not truncated.
  • Images stored in the database could be displayed incorrectly in master/detail views if columns in master and detail tables have the same name.
  • Uploading images to the database could cause a PHP warning in the strict mode.
  • MS SQL: national symbols are now inserted and updated correctly even if the database collation does not correspond to the system locale.
  • Code generation from the command line did not work without specifying the -o parameter (output directory). Now this parameter is not required (as it can be obtained from the project file).
  • Some other minor fixes and corrections.

New in PHP Generator for MySQL Professional 12.8.0.16 (Apr 9, 2014)

  • Support for user-defined parameters in custom templates. More information and examples.
  • Ability to use separate custom layout templates for Insert and Edit forms.
  • MS SQL Server: added support for SQL Server Express LocalDB databases. To access such databases, use SQL Server 2012 Native Client (SQLNCLI11) and SQL Server Driver for PHP.
  • Czech localization has been improved. Thanks to Jaromír Adámek.
  • Hopefully the final fix for processing datetime values in formats like m-d-y or d/m/Y. Now should work correctly for all supported versions of PHP.
  • Filter row: filtering on date/datetime values could cause an error.
  • Export to some formats could work incorrectly on using the ANSI encoding.
  • Some other minor fixes and code optimization.

New in PHP Generator for MySQL Professional 12.8.0.15 (Feb 24, 2014)

  • A new implementation of HTTP tunnel based on the MySQLi PHP extension.
  • Smart default values of view/edit properties for pages based on queries.
  • Automatic detection of query key columns.
  • The visible (true|false) method added to the editor's API.
  • A modal editor for lookup conditions becomes available (useful for lengthy and complex conditions).
  • A link to the manual is included into the warning on invalid queries.
  • Less compiler errors (if any) are now dispalyed in the preview window after theme customization.
  • A warning message is displayed in the preview window on detecting an obsolete IE version
  • Command buttons are added to the Details tab of the Page Editor.
  • "More information and examples" link becomes available for global events.
  • Combobox editor could display incorrect value if detail field contains NULL and master table contains a record with id = 0.
  • Datetime values could be processed incorrectly on using some datetime formats like m-d-y or d/m/Y.
  • A warning message is displayed if either .NET framework or dotLess compiler are missing in the system.
  • A missing ampersand is added to the customHTMLHeaderText parameter in the OnCustomHTMLHeader event handler.
  • Some other minor fixes and code optimization.

New in PHP Generator for MySQL Professional 12.8.0.14 (Nov 21, 2013)

  • Filter row: the "Apply filter automatically" option is added. Also it becomes possible to specify the timer interval .
  • Default empty grid height was decreased from 200 to 25 pixels.
  • The login panel is now always visible and right-aligned (even on pages with a large amount of columns).
  • There are no more conflicts between the library and generated files (so it becomes possible to use any file names for output pages).
  • User-defined styles are now applied to the login page.
  • Some markup corrections to simplify applying of user-defined styles.
  • A number of translations have been updated.
  • Some other minor fixes and code optimization.

New in PHP Generator for MySQL Professional 12.8.0.12 (Sep 2, 2013)

  • This version has been successfully tested with PHP 5.5.
  • Support for the SQLite3 database extension has been implemented.
  • MySQL bit(1) columns are now displayed as check boxes.
  • Turkish localization has been added.
  • Fixed some potential security vulnerabilities.
  • PostgreSQL: modal and inline inserts could work incorrectly on using the serial data type.
  • Some other minor fixes and code optimization.

New in PHP Generator for MySQL Professional 12.8.0.11 (Jun 17, 2013)

  • Support for keyboard interactive SSH authentication has been added (when applicable).
  • New program icons designed for up to 256x256 resolution.
  • Now end-users can change their passwords themselves (on using table-based authorization).
  • Record-level security becomes available for the first level detail pages.
  • Admin panel: now to change a user password you need to enter it twice to avoid input mistakes.
  • The inline display mode has been added for checkbox and radio groups (default mode is stacked).
  • A handy editor has been added for editing combobox and radiogroup values.
  • Computed columns are now excluded from the edit and insert forms by default (where applicable).
  • Slovenian localization has been added. Thanks to Marko Bratkovic.
  • No warnings are displayed anymore on opening the generated PHP files in our favorite IDE. :)
  • Record-level security: additional verification of permissions has been added on opening of edit forms and on saving data.
  • Table-based authorization: application and page-level permissions could be incorrectly saved in the database in certain cases.
  • Now all the SpinEdit properties are saved, restored, and processed as expected.
  • Some other minor fixes and code optimization.

New in PHP Generator for MySQL Professional 12.8.0.10 (Jun 17, 2013)

  • The "Set null" checkboxes are not displayed anymore by default.
  • The "Define key columns" button is no more available for invalid queries.
  • Non-English symbols are now displayed correctly when using as True Caption / False Caption for columns with View Properties = Checkbox.
  • MS SQL Server: non-English symbols are now displayed correctly within inline details.
  • The OnCustomRenderTotals event handler code was not saved in the project file for detail pages.
  • A warning message could be displayed in certain cases when there are no columns in the filter row.
  • The extra stars for read-only columns are no more displayed in the Edit/Insert forms.
  • The column captions containing the apostrophe (') could cause some errors in the JavaScript code.
  • An informative message is displayed now when trying to access Admin Panel without the appropriate permissions.
  • Combobox-style partitions makeup has been slightly improved.

New in PHP Generator for MySQL Professional 12.8.0.9 (Jun 17, 2013)

  • Page titles and menu labels for detail pages can be edited now directly in the Page List.
  • Page Navigator is improved to help users to estimate number of records in the data set.
  • Admin panel: the "Page name" column now displays menu labels instead of object names (e.g. Customers.Orders instead of tbl_customer.tbl_order).
  • Now it is possible to reset quick filter by entering an empty string and pressing Enter.
  • Passwords are now stored and transferred encrypted everywhere.
  • The comparison operators are now displayed as symbols in the filter string in order to save some space.
  • The "user_password" column length was increased to 128 characters in order to support some complex encryption algorithms like SHA256.
  • A more informative message is now displayed when trying to open a non-existing project file (More | Recent projects).
  • The software now warns you if you forget to define key columns for a data source.
  • A warning message is displayed on possibly incorrect script connection settings at the first step of the wizard.
  • A more informative message is now displayed if the generated app cannot connect to the database.
  • The generated app now displays a warning message if the templates_c directory does not exist or is not writable.
  • Default ordering is now applied to inline details.
  • The Amelia and SuperHero color schemes are removed from the installation package.
  • The Reset Filter Row button could be displayed incorrectly if the Actions column contains a single button
  • Checkbox group control: unchecking all checkboxes did not clear the field value.
  • Date/time editor: the date value in the popup calendar could be displayed incorrectly in certain cases.
  • Tables and views created in the database after the first invoking of the "Add table or view" dialog could not be selected as data sources.
  • The project was not marked as modified when changing a page title or menu label directly in the Page List.
  • Non-English symbols could be displayed incorrectly in some popup windows.
  • The partition caption could be displayed incorrectly when it contains non-English characters.
  • Simple search is now considered the lookup columns.
  • List and Range partitions might work incorrectly on running the app under PHP 5.4.
  • The inline editing now works properly for columns containing spaces in their names.
  • Autocomplete Editor: the "Item caption template" property could be processed incorrectly in certain cases.
  • The "Enable Guest Access" option was not stored in the project file.
  • Admin Panel becomes translatable. The appropriate strings are added to language files.
  • A few other missing strings are added to the appropriate language files. Hope they are complete now.

New in PHP Generator for MySQL Professional 12.8.0.8 (Jun 17, 2013)

  • Menu labels become accessible directly from Page List.
  • Support for passwords encrypted with crypt() and hash() functions (all algorithms) is added.
  • Key columns for views are now stored fine in the project file.
  • PostgreSQL: record-level security might work incorrectly in certain cases.
  • Filter Row did not accept values containing single quotes.
  • Filter Row enability for a page could be stored incorrectly in some cases.
  • Admin page now includes user-defined styles.
  • "Only variables should be passed by reference..." warning message could be displayed on accessing Admin Page.
  • Filter Builder now displays column captions instead of field names.
  • A string constant for NULL values is added to localization files. Some other strings are added there too.
  • The "Open search page at first" option is now processed correctly.
  • The "Force download" option for "File download" columns now works fine.
  • Columns excluded from the List view did not appear in Filter Builder too independently of the appropriate option.
  • Page Editor: the "Advanced search" column is finally renamed to "Filter builder".
  • Page Editor: the "Quick search" tab was removed as it did not contain any valuable options.
  • Aliases for generated lookup queries are now quoted if necessary.

New in PHP Generator for MySQL Professional 12.8.0.7 (Jun 17, 2013)

  • The OnCustomRenderColumn event did not fire for newly added records in the inline mode.
  • Inline insert/edit: an error message on loading too large pictures was displayed even after pressing Cancel.
  • Loaded pictures are now displayed correctly on editing a record in the inline mode.
  • Data from HTML WYSIWYG are now saved fine in the database in all edit/insert modes.
  • Multi-level autocomplete editor could work incorrectly in the inline mode.
  • Multi-level autocomplete editor now works fine even if the database contains no foreign key constraints.
  • Non-English texts rendered with $this->RenderText() in OnCustomRenderColumn event handlers are now displayed correctly on viewing a record.
  • Custom templates did not apply for modal editors.
  • Page navigators were displayed incorrectly in certain cases
  • Radio buttons looked ugly in some color schemes.
  • The resource image was missing for the External File option.
  • ComboBox editor is now displayed correctly in the inline mode.
  • OnEditFormEditorValueChanged/OnInsertFormEditorValueChanged events did not fire for radio buttons.
  • The Copy button was displayed even if a user has no Insert privilege.
  • The "Use general options" checkbox did not disable certain controls.
  • A detailed description of multi-level autocomplete editor is added to the manual.

New in PHP Generator for MySQL Professional 12.8.0.6 (Jun 17, 2013)

  • A special build to fix the problem with editing date and datetime values on using custom formats.

New in PHP Generator for MySQL Professional 12.8.0.5 (Jun 17, 2013)

  • The "Show page list" option now has 3 possible values (Show expanded, Show collapsed, and Disabled)
  • Brazilian and Serbian translations are added.
  • The rowData array in the OnAfterInsertRecord event now contains values of autoincrement columns.
  • Row Level Security now works fine for queries that contain spaces in their names.
  • The First day of Week option now applied correctly for date and datetime controls.
  • Application level permissions could not apply correctly on storing permissions in the database.
  • The list of available variables is displayed if SHOW_VARIABLES is turned ON.
  • Right-to-left text direction is supported again.
  • Oracle: in some cases data was not inserted or updated.
  • Oracle: date values could be displayed incorrectly.
  • Scrolling bars are now displayed correctly in modal forms.
  • Number of connections opened by PHP Generator has been reduced.
  • Missed strings are added to the appropriate language files.
  • The default ordering now applied to inline master-detail views.
  • CHAR and DECIMAL columns become orderable.
  • SQLite: pagination works correctly for pages based on queries.
  • Custom partitions are now displayed correctly even if pagination is disabled.
  • Expanded inline details were not hidden on deleting the master record.
  • The "No records to display" message was not displayed on deleting the last record from the grid.
  • Pagination hints could be displayed in an incorrect encoding.

New in PHP Generator for MySQL Professional 12.8.0.4 (Oct 2, 2012)

  • New modern look and feel. The main goal of the new version is to provide a capability to construct a modern-look and powerful web applications in the simplest possible way. For this purpose we significantly changed the design for all generated pages and refactored the web code.
  • Enhanced master-detail management. The new version provides some extremely useful features such as inline displaying of nested detail views without limitation on the depth and displaying several detail presentations simultaneously on the tabs.
  • Custom templates. From now on you can customize the design and layout of pages produced by PHP Generator according to your needs. For example, you can change captions, re-arrange controls, or even add a chart diagram for a certain page.
  • Automatic Filter Row. This row is displayed at the top of the data rows and allows you to filter data on the fly by typing text directly into the row. When you type the text within a cell in the row, a filter condition is automatically created based upon the values entered and applied to the column. The filter is updated automatically after 1 second after entering a value or when you press the Enter key.
  • Filter Builder. This control displays filter criteria as a tree structure and allows you to visually build complex filter criteria with an unlimited number of filter conditions combined by logical operators. The Filter Builder window can be invoked by pressing the Create filter link at the bottom of the grid.
  • New visual themes. In this case a picture is worth a thousand words, so please find all of them at the appropriate step of the software.
  • Improved usability. Starting from this version you can access detail pages directly from insert, edit, and view forms. This should be especially useful on adding new records.
  • New Autocomplete and Milti-Level Autocomplete controls. The new versions of these widgets allow you to select a required value as comfortable as possible.
  • New "after action" events. The OnAfterInsertRecord, OnAfterEditRecord, and OnAfterDeleteRecord events are now at your disposal.
  • On-the-fly metadata refreshing. Starting from this version you can synchronize your database schema changes with PHP Generator in a single click.

New in PHP Generator for MySQL Professional 11.12.0.1 (Dec 23, 2011)

  • 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).
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • Speeded up schema refreshing. We have improved the algorithm of the metadata refreshing to save a few moments of your valuable time.

New in PHP Generator for MySQL Professional 11.4.0.14 (Nov 14, 2011)

  • Support for multi-level auto-complete editors has been implemented.
  • Starting with this version it is possible to edit and insert data within modal dialogs.
  • Starting with this version it becomes possible to use a fixed header for data grid as well as display line numbers for grid records.
  • Client side validation has been significantly improved.
  • New version comes with a time edit control (that is now used by default for columns that store time-of-day values) and with a masked edit control that provides restricted data input.
  • Support for grid footers has been added.
  • New version also features a possibility of excluding certain files from the output.
  • The Generate thumbnail option has been added to additional settings of the Upload image to folder editor.