PHP Generator for MySQL Changelog

What's new in PHP Generator for MySQL 22.8.0.12

Dec 20, 2023

Added PHP 8.3 support.
Upgraded SSH client. Now it supports more secure key exchange algorithms.

New in PHP Generator for MySQL 22.8.0.11 (Nov 21, 2023)

New in PHP Generator for MySQL 22.8.0.10 (Nov 21, 2023)

New in PHP Generator for MySQL 22.8.0.5 (Nov 21, 2023)

New in PHP Generator for MySQL 22.8.0.3 (Nov 7, 2022)

New in PHP Generator for MySQL 14.10.0.7 (Aug 28, 2015)

New in PHP Generator for MySQL 14.10.0.6 (Aug 28, 2015)

New in PHP Generator for MySQL 14.10.0.5 (Mar 21, 2015)

New in PHP Generator for MySQL 14.10.0.4 (Jan 6, 2015)

New in PHP Generator for MySQL 14.10.0.3 (Dec 13, 2014)

New in PHP Generator for MySQL 14.10.0.2 (Nov 11, 2014)

New in PHP Generator for MySQL 14.10.0.1 (Nov 11, 2014)

New and updated controls. Starting from this version PHP Generator allows you to use some new HTML5 controls in Insert and Edit forms. Also we have added some new properties to already existing controls:
Support for the range input (so-called slider) has been implemented. This editor is useful for imprecise number input. It is possible to indicate the allowed range of values in the appropriate dialog window (default values are 0 and 100 for bottom and top limits accordingly).
Starting from this version it is possible to edit values of columns storing HTML color codes with a native-browser Color Picker (it is assumed that a string data type is used for storing such values in the database).
From now on all items in radio and checkbox groups may be displayed on the same line. This can be customized in Edit properties | Additional | Display mode (possible values are Stacked and Inline).
Enabled, Readonly, and Visible properties have been added to all editors. They allow you to setup initial state of controls that can be later changed with the JavaScript API. The key difference between readonly and disabled elements is that the first ones are just not editable, but get sent when the form submits while disabled elements aren't editable and aren't sent on submit.
The Placeholder property has been added to Text and Text area editors. Also we have implemented support for prepended and appended inputs.
The Time Edit control has been updated. A new spinner helps you to quickly change the editor's value as well as reset its value to the current time.
Starting from this version it is possible to provide all editors with custom attributes. Such attributes can be later handled in client-side events.
Enhanced JavaScript API. A number of functions have been added to the editors API (a programming interface that allows you to extend functionality of Insert and Edit forms of generated applications). Some of implemented functions are as follows:
setVisible(true|false) — shows or hides the appropriate editor.
setReadonly(true|false) — switches the editor to the readonly/normal state.
addItem(value, caption) — adds a new item to a Combobox, Radio Group, or Checkbox Group editor.
New security-related features. The following security-related things are now at your disposal:
Support for user-defined authorization has been added. This feature requires you to define your own function that takes entered username and password and returns true or false depending on their validity. This means you can use any possible storage for user credentials and any encryption algorithm you like.
Support for a number of new algorithms for password encryption has been implemented. From now on our software allows you to encrypt passwords with crypt() and hash() PHP functions (all algorithms provided by your PHP installation are allowed).
Now end-users can change their passwords themselves (on using table-based authorization). The appropriate button is located in the top right corner of the window.
Template management. New version introduces a number of new features related to customization of generated web pages with user-defined templates:
From now on it is possible to define your own templates for the print version of pages. For example, you can add a logo of your company, place a copyright notice, or even add a column that is missed in the common version of the page (the appropriate example can be found in our demo application).
The Login page now also can be customized; moreover, there are separate options to modify the whole page or only the login form. As usual, an example of such a page is available in the demo app.
A possibility of passing additional parameters to custom templates has been implemented. Values of such parameters should be provided within the OnGetCustomTemplate event handler.
Multi-group menu:
The new version version allows you to group items in the page list according to your needs. It is also possible to add a separator between items. By default all the pages are placed to a single group named "Page List" (as in the previous versions).
New application-level events:
Two new application-level (AKA project-level) events have been introduced. The OnCustomHTMLHeader event allows you to define the contents of the HEAD section (like meta tags or favicon) for all pages of the generated websites and the OnGetCustomTemplate event helps you to override certain templates for all or certain pages at once. All application-level events can be defined in the Project Options dialog.
Custom CSS and JavaScript:
Starting from this version you can provide custom CSS and JavaScript code that will be included into all the generated pages. This is the optimal place to define, for example, JavaScript functions that are called from several event handlers (in order to avoid duplicate code).
Usability improvements. The new version features a lot of usability improvements. The most useful of them seem to be as follows:
The generated app now displays a warning message if the templates_c directory does not exist or is not writable.
A dialog window is now displayed on loading a project file containing pages that are linked to non-existing data sources. This window allows you to either remove these pages from the project or re-link them to valid data sources.
The software now warns you if you forget to define key columns for a data source. Also it tries to detect query key columns automatically.
Size of the project files has been decreased up to 5 times. Size of the generated PHP files has been decreased up to 2 times, and the generated code becomes cleaner and understandable.
A more informative message is now displayed on entering an invalid query. Also invalid queries are now loaded from the project file (though remain invalid).
A more informative message is now displayed when trying to open a non-existing project file (More | Recent projects).
A warning message is displayed on possibly incorrect script connection settings at the first step of the wizard.
Less compiler errors (if any) are now displayed in the Preview window after theme customization. For example, on the screenshot below we missed a semicolon after #000 and got the corresponding compiler error.
Computed columns are now excluded from the edit and insert forms by default (where applicable).
A more informative message is now displayed if the generated app cannot connect to the database.
Links to non-installed PHP drivers are included into the appropriate error messages.
PHP Generator UI enhancements:
The Page Properties window has been completely redesigned.
Now it is possible to include/exclude all columns to/from a certain presentation with a single click.
Ability to specify several output paths for a project is added (useful if you want to test the generated app under several local webservers).
A handy editor has been added for entering ComboBox and Radio Group values.
Page titles and menu labels for detail pages can be edited now directly in the Page List.
A modal editor for lookup conditions becomes available (useful for lengthy and complex conditions).
Editors for entering file name templates (for example, in the Upload file to folder properties dialog) become more convenient.
Core features:
This version has been successfully tested with all PHP version up to 5.6. The minimum required version is still 5.1 (while version 5.3 or higher is recommended).
A new implementation of HTTP tunnel based on the MySQLi PHP extension has been added.
Support for SQL Server Express LocalDB databases has been added. To access such databases, use SQL Server 2012 Native Client (SQLNCLI11) and SQL Server Driver for PHP.
Support for keyboard interactive SSH authentication has been added (when applicable).
Support for the SQLite3 database extension has been implemented.
Other new features:
Page Navigator is improved to help users to estimate total number of records in the data set.
Brazilian, Czech, Serbian, Slovenian, and Turkish translations are added. Many thanks to our users.
Filter row: the "Apply filter automatically" option is added. Also it becomes possible to specify the timer interval.
Now it is possible to reset quick filter by entering an empty string and pressing Enter.
The comparison operators are now displayed as symbols in the filter string in order to save some space.
The "Force download" option for opening files from BLOB columns has been added.
In addition to above, several bugs have been fixed and some other minor improvements and corrections have been made.

New in PHP Generator for MySQL 12.8.0.18 (Jul 19, 2014)

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

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

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

New in PHP Generator for MySQL 12.8.0.12 (Aug 30, 2013)

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

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

New in PHP Generator for MySQL 12.8.0.9 (Jun 14, 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 12.8.0.8 (Jun 14, 2013)

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

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

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

New in PHP Generator for MySQL 12.8.0.4 (Jun 14, 2013)

New in PHP Generator for MySQL 12.8.0.3 (Jun 14, 2013)

New in PHP Generator for MySQL 12.8.0.2 (Aug 28, 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. We hope you and your end-users will like the new UI. As usual, all the new features can be seen in action in our demo application.
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 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 11.4.0.2 (Apr 28, 2011)

New in PHP Generator for MySQL 10.8.0.1 (Aug 26, 2010)

Key enhancements:
Inline Insert and Inline Edit features have been implemented. Use them to insert/edit a record without having to open a new page.
Support for RSS feeds to publish frequently updated works (such as blog entries, news headlines, etc) in a standardized format has been implemented. All the required fields can be customized within the Page Properties dialog.
The Advanced Search form can now be displayed on a separate page. Moreover, this form now can substitute by itself the list page, so it becomes possible to display page data only after entering values to search.
The Advanced Search formPicture 2. The Advanced Search form
Support for using some environment variables (such as CURRENT_USER_ID, CURRENT_USER_NAME, UNIQUE_ID) in events and templates has been implemented. The variables also can be used for specifying a column default value.
The following example demonstrates how to use variables within the OnBeforeInsertRecord event.
rowData['ip_address'] = $this->GetEnvVar('REMOTE_ADDR');
userName = $this->GetEnvVar('CURRENT_USER_NAME');
if ($userName != 'admin')
rowData['changed_by'] = $userName;
To obtain a complete list of supported variables, uncomment the define('SHOW_VARIABLES', 1); line in the generated settings.php file.
Page-level permissions have been implemented. Such permissions allow you to customize access to individual pages in the generated app. To setup record-level permissions, use the "Customize user permissions..." button in the Permission Manager dialog.
Event handling extensions:
Now it is possible to change values posted to the database with OnBeforeInserRecord/OnBeforeUpdateRecord events.
OnInsertFormValidate/OnEditFormValidate client-side events have been implemented. Use these events to write a custom JavaScript code for checking values entered by the user.
Listing 2.
if (fieldValues['percents'] < 0 || fieldValues['percents'] > 100)
errorInfo.SetMessage('Percent value should be between 0 and 100');
return false;
Two other client side events have been added. These are OnBeforePageLoad and OnAfterPageLoad. The first event occurs before page loading and allows you to declare functions and global variables while the second one fires after the page has been fully rendered.
Frontend improvements:
Page Editor: the Reset column command has been added to the General tab's popup menu.
An easy access to recently used projects has been implemented.
Recent projectsPicture
Image combo box is now used for selecting a lookup source. Using different images for tables, views, and queries helps you to easily select the required object.
The Send report menu item will allow you to send us a detailed bug report in a single click. We hope this command will not be used so often.
Other new features:
The UI for column reordering has been improved: now it is possible to reorder columns for all the presentations at once.
Now it is possible to setup width for each column as well as the whole grid width.
An ability of changing the number of records displayed at a page during application runtime has been implemented.
Page list, Print, and Export blocks become collapsible.
Starting with this version it is possible to exclude a page from the left menu as well as reorder pages in the page list.
Now it is possible to print a single record in the view form.
Most-frequently used values can now be specified for a combo box editor. Such values are always displayed at the top of the list.
Advanced Search: the "is blank" and "is not blank" conditions have been added to the search criteria.
Values in lookup combo boxes are now sorted.
The PHPass algorithm can now be used for the password encryption

New in PHP Generator for MySQL 10.3.0.5 (Apr 7, 2010)

New in PHP Generator for MySQL 9.12.0.4 (Dec 23, 2009)