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

Subscribe to our news:
Partners

Changelog

Every day we are working to improve our software products. Below you can see the (almost) complete history of PostgreSQL PHP Generator changes. Records marked by a plus sign (+) denote the tool improvements, records marked by a minus sign (-) stand for bugfixes, and records marked by an exclamation mark (!) show incompatible changes.

Upgrade policy for PostgreSQL PHP Generator can be found here.

All PHP Generator demos updated

Jul 17, 2017

Version 16.9.0.7

Jun 22, 2017
  • Column Filter has been optimized. Now its values are loaded from the database only when/if a user presses the filter button. Due to this improvement, the initial page loading time is significantly reduced.
  • Support for Inactivity Timeout has been implemented. The value of this option defines the maximum amount of time (in seconds) after that a user is automatically logged out from the application if he/she does not perform any action during this period.
  • From now on it is possible to provide custom functions for encrypting and verifying the passwords. This allows you to use any encryption algorithm API or library you like.
  • A new event editor has been implemented. Now you can edit all server-side (or client-side) event handlers in a single window that should simplify such operations as copy / paste code between different event handlers.
  • OnGetCustomExportOptions event: it is now possible to customize the page size for export to PDF.
  • OnBeforeLogout event has been added. The event fires just before a user logged out from the application by pressing the Logout button or when the inactivity timeout is reached.
  • The "Offline mode" option has been added to the Project settings. Turn this option ON for websites running on web servers without an Internet connection.
  • Number of lookup values displayed in AutoComplete and Multi-level Autocomplete editors can now be customized.
  • For lookup values stored in the database the AutoComplete editor is now used instead of Combobox.
  • The algorithm that detects the HTTPS protocol using has been changed in order to support the IIS web server specifics.
  • It is now possible to use a DateTime column as Display Field in lookup properties.
  • Files and images stored in the database are now inserted correctly.
  • A number of translations have been updated. Thanks to our users.
  • Some other minor fixes and code optimization.

New video: On-the-Fly Adding

May 25, 2017

A new video tutorial is uploaded to our YouTube channel. Learn how to provide lookup editors with an ability to add new items in a modal dialog.

Security Demo updated

Apr 13, 2017
  • Two examples of implementing a role-based permission model have been added. In the first example permissions are hard-coded within the event handler while in the second one they are retrieved from a database table.
  • An example of using custom record permissions has been been added. This page demonstrates how to extend the record-level security functionality with the power of the OnGetCustomRecordPermissions event.
  • How to redirect a user to a certain page? How to block the account of a fired employee? Answers for these and similar questions can be found on a newly added page that illustrates how it is possible to use the OnAfterLogin event.
  • The demo has been rebuilt with the version 16.9.0.5.

Feature Demo updated

Mar 30, 2017

Version 16.9.0.5

Mar 22, 2017
  • OnGetCustomPagePermissions and OnGetCustomRecordPermissions events have been added. Use these events to setup custom permissions at the page and record levels accordingly.
  • The Quick Filter tool has been improved. Now it allows you to select columns to search as well as specify the search condition (Contains, Begins with, etc).
  • It is now possible to print selected records (via the Selection Management button's menu).
  • Multi-level Autocomplete Editor: from now on you can define a filter condition for each level separately. Variables like %CURRENT_USER_ID% are supported.
  • $canLogin and $errorMessage parameters have been added to the OnAfterLogin event.
  • Order of columns in Page Editor is now changed if columns are reordered for all views at once.
  • Support for descriptions of menu groups has been implemented.
  • HTML WYSIWYG editor: added support for changing text and background colors.
  • File-based editors: it is now possible to specify allowed file extensions.
  • OnPageLoaded server-side event has been implemented.
  • Columns not included into the Insert view are now accessible in On[Before|After]InsertRecord event handlers.
  • Links to the index page become correct when a non-default filename for the index page is used.
  • Export to CSV now works fine for detail pages.
  • Variables like %CURRENT_USER_ID% now can be used as default values for columns in the On-the-Fly Adding forms.
  • Oracle: it is now possible to use DATE columns within the record comparison key.
  • Quick Filter now works correctly for detail pages.
  • File-based editors: custom attributes are now rendered as expected.
  • Error messages for Range and Length validators become translatable.
  • An Arabic translation has been added. Now PHP Generator comes with 19 languages on board. Thanks to our users.
  • Some other minor fixes and code optimization.

Security Demo uploaded

Mar 06, 2017

This demo illustrates PostgreSQL PHP Generator security-related features such as application and page level permissions, PUBLIC and guest privileges, record-level security, administration panel, etc.
Enter the demo site.

New video: Custom Form Layouts

Dec 22, 2016

A new video tutorial is uploaded to our YouTube channel. Learn how to define a custom layout for Edit, Insert, and View forms.

Feature Demo updated

Dec 08, 2016

New video: Record Comparison

Dec 1, 2016

A new video tutorial is uploaded to our YouTube channel. This video focuses on the Record Comparison feature. Learn how to compare multiple records and find the difference between their values in a few mouse clicks.

Version 16.9.0.3

Nov 29, 2016
  • It is now possible to rename a group in the Page Groups dialog.
  • Ctrl+Enter shortcut now works in Quick Edit forms.
  • Default language file is now used on detecting invalid lang.php (no error message is displayed).
  • Alignment is no more applied for values in Single Record View forms.
  • Filter Builder and Column Filter now work fine on using the https protocol.
  • Client-side event now fire in On-the-fly Adding forms.
  • Values of text columns with View Properties = File Download are now included into exported files.
  • Inline Editing: validation errors are now handled correctly on pressing the "Save and Continue editing" button.
  • Captions of OK and Cancel buttons become translatable.
  • Some other minor fixes and code optimization.

New video: Customizing Column Filter

Oct 27, 2016

This tutorial learns how to customize Column Filter to make it much more convenient for your users. Watch the video.

New video: Introduction to Column Filter

Oct 24, 2016

A new video tutorial is uploaded to our YouTube channel. This video describes what Column Filter is, how it works, and how to incorporate this feature into your applications.

Demo apps updated

Oct 14, 2016
  • All demos have been rebuilt with version 16.9.0.2. Project files available for downloading have been updated accordingly.
  • Feature Demo: a new group Fine-tuning & Tweaking has been added. Learn how to replace the default set of icons to your own and how to create a custom color theme.
  • NBA Demo: a drop-down menu has been added to the Login button to help lazy users to test the application under different accounts.

Version 16.9.0.2

Oct 12, 2016
  • It is now possible to select a pattern for the Quick Search tool (%term% or term%). The first pattern is more user-friendly while the second one works much faster (if the appropriate index is defined in the database).
  • Using MFU values does not cause syntax error anymore.
  • Download links for BLOBs stored in the database now work as expected.
  • On-the-Fly-Adding could work incorrectly on using in detail pages.
  • The calendar component and some other string resources become translatable.
  • Filter Builder could display incorrect markup if the equality operator (=) is missing in the operator list.
  • Filter Builder: date formats like d/m/Y and m-d-Y are now handled properly.
  • An incorrect code could be generated on using custom partitioning on both master and detail pages.
  • A number of translations have been updated. Thanks to our users.
  • Some other minor fixes and code optimization.

Version 16.9

Sep 15, 2016

Version 16.3.0.5

Jun 15, 2016
  • All cards now have the same height regardless of number of lines they contain.
  • Master/detail views: it becomes possible to provide view mode for the master record and detail grid separately (via viewmode and master_viewmode GET parameters). Example 1. Example 2.
  • A number of translations have been updated. Thanks to our users.
  • Some minor hotfixes.

Version 16.3.0.4

Jun 6, 2016
  • Data source management has been improved. Now you can create multiple pages based on a single data source as well as disable creation of top-level pages for certain data sources.
  • All possible settings are now preserved on changing the editor type in the program UI.
  • Insert, Update, and Delete operations are now disabled for pages based on read-only views.
  • The json PHP extension is no more required by the generated code.
  • The project-level "Thousand separator" option is now applied for integers (not only for floats).
  • Totals are now calculated for a whole dataset, not for the current page.
  • The Sort button is no more displayed if the "Disable custom ordering" option is checked.
  • Export to PDF now works fine under PHP 7.
  • Some other minor fixes and code optimization.

Version 16.3.0.2

Apr 8, 2016
  • Data Export: it is now possible to customize the output filename as well as specify the orientation for PDF export and the library for export to Excel. More info.
  • Sidebar menu usability has been improved. The "Hide Sidebar by default" option has been implemented. Ctrl+[ and Ctrl+] shortcuts have been added (to toggle the sidebar state).
  • Charts: support for number formats has been implemented.
  • Client-side validation: the first invalid control becomes focused on detecting an error when submitting a form.
  • Master record tags (like %field_name%) are now allowed in detail page titles.
  • The "Inline styles" property has been added to all data grid columns.
  • Embedded video lookup columns are now displayed correctly.
  • Client-side API: setValue() and getValue() functions could work incorrectly for checkboxes.
  • Added some missing tooltips for data grid panel buttons.
  • Some other minor fixes and code optimization.

Version 16.3

Mar 21, 2016

A new version of the NBA Demo is uploaded

Dec 28, 2015
  • An inline filter has been added to the Game list page.
  • The game card now represents an example of non-trivial custom template for the View form.
  • A simple custom template for the Teams page has been added (links to detail pages moved from the drop-down menu to the card body).
  • The Players page now uses the card view mode by default (to demonstrate a more or less complex example of custom template).
  • Fixed broken links in the RSS feed.

Version 15.12.0.2

Dec 28, 2015
  • The "Detailed description" property has been added to page settings. If specified, the Help button is displayed on the right of grid's toolbar and the property value is shown in a modal window when the button is clicked.
  • "Condensed table" and "Bordered table" options have been added to the page settings. These options are also available at the project level (in this case they are applied to all pages).
  • An ability of customizing php.ini settings in runtime has been implemented (Project settings | Shared options).
  • The "Select All" checkbox now supports the indeterminate state (if only some but not all records are selected).
  • A warning message is now displayed on detecting incorrect lookup settings.
  • Date formats like d/m/Y and m-d-Y are now recognized correctly by Filter Builder.
  • The "Highlight row at mouse hover" option now works correctly.
  • The last item in the sidebar menu containing a large amount of pages could be inaccessible.
  • Fixed a localization-related issue in the Admin Panel.
  • A number of translations have been updated. Thanks to our users.

Version 14.10.0.10 (freeware)

Dec 14, 2015
  • Some minor improvements and fixes.

Version 15.12

Dec 10, 2015

Version 14.10.0.7

Aug 27, 2015
  • Copy operation is now available in the inline mode.
  • Project options: event management becomes more convenient and user-friendly.
  • On[Edit|Insert]FormLoaded and On[Edit|Insert]FormEditorValueChanged client-side events are now fired in the inline mode.
  • The Save button is blocked when writing data to prevent the addition of the same record twice.
  • SQL Server: support for SQL Azure database has been implemented.
  • A confirmation dialog is displayed on removing a user in admin panel.
  • Inline edit and inline insert modes finally become independent from each other.
  • Partition numbers are not shared anymore between different pages.
  • Symbols '\' and '%' are now allowed to be used in Filter Row.
  • Inline mode: detail management controls are now displayed correctly for newly added records.
  • Time editor works correctly now.
  • Required validation is now supported for the 'Upload image/file' and 'Upload image/file to folder' editors.
  • Custom attributes are now applied to the Multi-level Autocomplete editor.
  • SQL Anywhere: pagination is now supported for pages based on custom queries.
  • Some other minor fixes and code optimization.

Version 14.10.0.6

Jun 4, 2015
  • New editor: Multiple select.
  • Completely rewritten Autocomplete and Multi-level Autocomplete editors.
  • A new Lightbox component.
  • Improved password storing algorithm.
  • Project-level OnBeforePageExecute event handler is now stored and restored correctly.
  • Missing ampersands added to the $rowData parameter in the project-level data manipulation events.
  • The OnPreparePage event now fires on detail page preview.
  • Editors based on input[type=file] could work incorrectly in the inline mode.
  • Empty groups are no more displayed in the page list.
  • The Crypt algorithm is now can be used for password encryption.
  • Template files are no more generated if the "Do not copy system files" option is checked.
  • Connection via SSH tunnel could work incorrectly in some cases.
  • MySQL: BLOB values are now saved correctly in the database.
  • Some other minor fixes and code optimization.

Version 14.10.0.5

Mar 20, 2015
  • HTML filter becomes available for Text, Text area, and WYSIWYG editors. Use it to strip unwanted HTML tags and attributes from user input.
  • Starting from this version PHP Generator "remembers" the URL requested by an unauthorized user and redirects to the appropriate page after successful login.
  • The Cerulean color scheme is now selected by default.
  • The "Page navigator" option (None/Top/Bottom/Both) now also affects the partition list.
  • Value of the "Copy all files / Do not copy system files" option is now stored in the project file.
  • Page filter condition was not saved in the project file for detail pages.
  • The OnPreparePage and OnInsertFormValidate events now fire for detail pages as well.
  • Non-English characters could be displayed incorrectly in Inline modes on using ANSI encoding.
  • Error messages coming from database server are now displayed in the Inline mode too.
  • Values like 0 or empty string are now sent to the server correctly from OnBefore[Insert|Update]Record event handlers.
  • Oracle: SQL scripts for creation user and permission tables have been fixed.
  • Some other minor fixes and corrections.

Version 14.10.0.4

Jan 6, 2015
  • Filter row: it is now possible to define number of items to be displayed in the lookup list. Also this list is now ordered according to general lookup settings.
  • Page options have been divided to several categories.
  • Option "Open search page at first" renamed to "Ask for filter condition before display data".
  • Removed an unnecessary horizontal scrollbar that appeared in some cases.
  • Deprecated mysql_escape_string function is no more used.
  • DB2: a warning message related to GetCastToCharExpression function is no more displayed.
  • WYSIWYG editor could work incorrectly in modal windows.
  • Some other minor fixes and code optimization.

Version 14.10.0.3

Dec 11, 2014
  • The "External audio file" option becomes available in the View properties. This allows you to use the standard HTML5 audio player for your application.
  • The OnPreparePage page-level event has been added. This piece of code is a method of the Page class that is called at the end of the constructor. It allows you to customize all members of the class, for example, add an additional filter to the dataset.
  • The OnBeforePageExecute event becomes available at the application level. This helps you to define a snapshot of PHP code that will be included into all the pages.
  • The SpinEdit control was replaced to one from HTML5.
  • The Step property has been added to the Range control.
  • Lookup filter condition is now applied to Filter Row and Filter Builder tools.
  • Date and datetime controls in Filter Row and Filter Builder now display values in the same format which is used in the corresponding Data Grid columns.
  • Instances of the SMDateTime class used in the data manipulation events now can be converted to strings automatically.
  • JavaScript API: the getCaption() function added to Combobox and RadioGroup editors.
  • The "Save and open details" button could not work correctly on using an autoincrement key in the master table.
  • Autocomplete Editor could work incorrectly in the modal Insert mode.
  • The menu groups now can contain non-English characters.
  • An error message is now displayed on attempt of changing a non-existent record.
  • The "guest" and "Login as guest" strings become translatable.
  • A number of translations have been updated. Thanks to our users.

Version 14.10

Oct 24, 2014

Version 12.8.0.18

Jul 18, 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.

Version 12.8.0.16

Apr 3, 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.

Version 12.8.0.15

Feb 21, 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.

Version 12.8.0.14

Nov 20, 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. Thanks to our users.
  • Some other minor fixes and code optimization.

Version 12.8.0.12

Aug 29, 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. Thanks to Kadri Izer.
  • 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.

Version 12.8.0.11

Jun 14, 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.

Version 12.8.0.10

Mar 21, 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.

Version 12.8.0.9

Jan 22, 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 like =, >=, <= are now displayed as symbols in the filter string in order to save some space ("game_date <= 2008-11-01" instead of "game_date is less than or equal to 2008-11-01").
  • 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.

Version 12.8.0.8

Dec 21, 2012
  • 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.

Version 12.8.0.7

Nov 26, 2012
  • 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

Version 12.8.0.6

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

Version 12.8.0.5

Oct 26, 2012
  • 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.

Version 12.8.0.4

Sep 24, 2012
  • Adding data to the detail pages via modal dialogs becomes possible.
  • Database server based authorization might not work properly.
  • Query-based lookups work fine now.

Version 12.8.0.3

Sep 11, 2012
  • The "Force download" option for opening files from BLOB columns.
  • An ability of adding custom CSS to the project.
  • Current user name and ID become accessible in custom templates (as {$Authentication.CurrentUser.Name} and {$Authentication.CurrentUser.Id}).
  • Links to non-installed PHP drivers are included into the appropriate error messages.
  • Correct order of days of weeks in DateTimePicker control.
  • Values of radio button controls come correctly to client-side event handlers.
  • Headers are displayed in correct color for the SuperHero theme.
  • Missed strings are added to language files.
  • The OnCustomHTMLHeader event now fires correctly.
  • OnCustomRenderColumn event now fires for single record view.
  • Highlighting search results on using Quick Filter.
  • mysql_escape_string function is not used anymore to prevent warnings.
  • Date/Time editor can be displayed incorrectly in the inline mode, modal windows, and Filter Builder.
  • OnEditFormValidate event fired on validating insert forms.
  • Passwords containing the ";" symbol are allowed now.

Version 12.8.0.2

Aug 24, 2012
  • Some small fixes.

Version 12.8

Aug 20, 2012

Version 11.12.0.8

  • Default Format for Edit Properties in date/time editors.
  • Polish and Hungarian translations.
  • Validators string resources become localizable.
  • Default values for detail pages can be applied incorrectly.
  • Permissions are applied correctly for queries containg spaces in their names.

Version 11.12.0.7

  • It becomes possible to use environment variable in filters.
  • "More information and examples" links added to event editors.
  • The Max Length value is set according to column length (e.g. 10 for varhcar(10)).
  • Validation messages can be displayed incorrectly in some cases.
  • Currency symbol can be displayed incorrectly on using the UTF-8 encoding.
  • Detail links are now displayed correctly on inline editing.
  • Editors for columns with XML data type now allow HTML by default.

Version 11.12.0.6

  • Some strange symbols could appear on shortening long text.
  • Page captions might be displayed incorrectly in the admin panel.
  • Viewing in modal dialog was allowed only if a user has an UPDATE privilege.
  • Thumbnails are displayed correctly even if the imageantialias PHP function is not available.
  • Custom attributes for Edit Properties were not taken into consideration.
  • Current partition is restored correctly after the record editing.
  • The character encoding for the login page and admin panel was not specified explicitly.
  • Different radio buttons could have the same id attribute.
  • Aggregates for pages based on a query might be calculated incorrectly.
  • Default values for string columns are now displayed well.
  • OnInsertFormEditorValueChanged/OnEditFormEditorValueChanged event handlers were ignored for MultiLevelAutoComplete controls.
  • Data export engine ignored the selected partition (always exported data from the first partition).
  • Thumbnails could be stored incorrectly on saving BLOBs.

Version 11.12.0.2 - 11.12.0.5

  • Some small fixes.

Version 11.12

Version 11.4.0.14

  • Exporting and printing did not work correctly with some column settings.
  • Some other small fixes

Version 11.4.0.12

  • Column sorting is enabled by default.
  • The "Use same connection options" checkbox was ticked on loading projects with different connection options.
  • Time edit controls interpreted empty value as NULL.

Version 11.4.0.11

  • OnCustomRenderPrintColumn and OnCustomRenderExportColumn events have been added.
  • It becomes possible to forbid users to change the data sorting.
  • The database refresh has been sped up.
  • Current connection and environment variables are now accessible in global events for data modification.
  • The Minimize button in the wizard window works fine now.
  • The Edit command was inaccessible for users those have no privileges on record deletion.
  • Autocomplete editor didn't work in some cases.
  • Totals were not displayed when working with PDO drivers.
  • The Search control sometimes raised the following error message: PHP Fatal error: Call to undefined method SimpleSearch::GetFilteredFields() in /templates_c/%%E3^E33^E336EC2F%%search_control.tpl.php on line 16

Version 11.4.0.10

  • Table name becomes accessible in global event handlers such as OnBeforeUpdateRecord.
  • Grid footers are included into the printable version.
  • The original file extension is keeped on uploading a file with a random name.
  • A possibility of filtering the lookup values.
  • Error on adding several queries with the same name.
  • Security settings were not cleared on loading a project without security settings.
  • Column hints were not displayed on using fixed headers.
  • Query key columns are preserved during query modification if possible.
  • It was impossible to use values with spaces on setting of a lookup editor bound to a custom value list.
  • Algorithm of data export has been significantly improved.
  • The privileges for detail pages and privileges for the 'guest' user are now saved fine in the project file.
  • The directory for uploading files is created if not exist.

Version 11.4.0.9

  • String primary keys are displayed correctly within modal dialoga and in the inline mode.
  • In some PHP versions the warning message "Warning: Failure in /.../libs/smartylibs/Smarty.class.php on line 1934" was displayed.
  • In some cases the warning message "Warning: get_class() expects parameter 1 to be object, null given in C:\wamp\www\Unistrive\components\utils\system_utils.php on line 15" was displayed.

Version 11.4.0.8

  • Editing in modal dialog worked only for the first page.
  • Control buttons at the bottom of the grid didn't work.
  • Advanced Search for lookup columns contained superfluous operators.
  • Date formats now applied to the corresponding controls in the Advanced Search form.
  • MaskEdit properties are now restored correctly from the project file.

Version 11.4.0.7

  • The "number_format() expects parameter 1 to be double, string given" error message for certain PHP versions.
  • Loss of master values on editing data in detail pages in modal dialogs.
  • Multilevel autocomplete could work incorrectly for detail pages.
  • In some cases it was necessary to login twicely.
  • Error on retrieving permissions for users who logged in using incorrect character case.
  • Export of values containing HTML links.
  • A possibility of displaying external images as hyperlinks.

Version 11.4.0.6

  • Non-local symbols could be displayed incorrectly in multilevel autocomplete editor.

Version 11.4.0.5

  • Comboboxes instead of autocomplete editors for lookup controls in Advanced Search form.
  • Uploading files to a webserver folder: option for overwriting existing files.
  • Unsaved values for column settings.
  • Using Is blank in Advanced Search form.
  • Incorrect character encoding in autocomplete editors.
  • Another small glitch in inline editing.

Version 11.4.0.4

  • Incorrect values for $rowData parameter in OnBeforeDeleteRecord/OnBeforeUpdateRecord events.
  • Updating of columns that contain NULL values.
  • Updating of some Date/DateTime columns.

Version 11.4.0.3

  • Fatal error: Call to a member function SetAdditionalAttribute() on a non-object fixed.
  • App sometimes hangs on modal deleting.

Version 11.4.0.2

  • Advanced Search: controls for lookups and dates.
  • OnCustomRenderTotal event.
  • The "Unknown column '' in 'field list'" error on updating
  • Inline Editing in Internet Explorer

Version 11.4.0.1

Version 10.8.0.15

  • The Advanced option tab added to the project options (some debug and compatibility options).
  • The settings.php file renamed to phpgen_settings.php to get the output compatible with databases that have table named 'settings'.
  • The 'function set_magic_quotes_runtime() is deprecated' message is not displayed any more for PHP 5.3.
  • Firebird PHP Generator: table list displayed incorrectly for some databases.

Version 10.8.0.14

  • The algorithm of updating system php files after installing a new version of the software has been improved. This should avoid an accident using of obsolete versions of these files.
  • Multi-statement scripts in updatable queries are now processed correctly.

Version 10.8.0.12

  • open_basedir restriction breaks the generated application.
  • Removed incorrect slashes from include paths.
  • Exports to Excel and Word ignore formatting options.

Version 10.8.0.11

  • An access violation error may occur after saving a project, dropping a field from a table and reopening the project.

Version 10.8.0.10

  • allow changing size of autocomplete editor
  • displaying of Advanced Search form on a separate page