PHPMaker versions

v15.0 [Apr 24, 2019]
New Advanced Settings:
- Database time zone (for SET TIME ZONE).
- Export field images (for export by dompdf/PHPWord/PhpSpreadsheet).
- Use Date/Time without seconds.
- Use lookup cache.
- Lookup cache count.
- Import maximum execution time (seconds).
- Import records by insert only.
- Import records by transaction.
- Import supported file extensions.
- Import from CSV delimiter.
- Import from CSV quote character.
- Encrypt administrator and database user name and password.
- Encryption key for data protection.
- PHPMailer mailer (smtp/mail/sendmail).
- Use cookie policy.
- Use Personal Data Page.
- API JWT signing secret key.
- API JWT signing algorithm.
- API JWT authorization header.
- API access time after login (seconds).
- API expire time after login (seconds).
- API Access-Control-Allow-Origin header.
New Server Events and Client Scripts:
- Server events and client scripts for Add Option page and Detail Grid page.
- PersonalData_Downloading.
- PersonalData_Deleted.
- Page_Importing.
- Row_Import.
- Page_Imported.
More:
- PHP namespaces.
- Improved naming conventions.
- Autoload table and page classes.
- Composer to manage packages.
- Lookup cache to improve lookup field performance.
- Manage user level permissions (partially) by non-admin users (Dynamic User Levels).
- Improve XSS handling by HTML Purifier.
- Optimize synchronizing linked tables with URL connection.
- Show aggregate and detail record count in Master/Detail-View page.
- Support modal links for Preview extension (for registered users only).
- Short time format (AM/PM) for TimePicker extension (registered users only).
- PHPMailer 6.
- Support email address with name like "John Smith<[email protected]>" (for Email_Sending server event).
- JsRender, Moment, jQuery File Upload, TimePicker, CKEditor and tinyMCE updated.
- mobile_detect.php and mobile-detect.js updated.
- PhpSpreadsheet (replaces PHPExcel) and PHPWord updated (registered users only).
- Always use Microsoft PHP Driver for SQL Server (COM functions no longer supported).
- Always use mysqli (old mysql extension no longer supported).
- Many other minor improvements.

v12.0 [Jul 22, 2015]
Now you can add Linked Tables from other databases of different database type
Add custom fields to a table or view with SQL expression.
Option to use Bootstrap table instead of Bootstrap horizontal form for Add/Edit/Search/Update/Register pages (Desktop mode only)
Show the options in dropdown panel (supports SELECT, RADIO and CHECKBOX) with min-width and max-height settings.
Show options in HTML with JsRender template.
Support Option Template, min-width and max-height settings.
Keeps session alive by Ajax or show session timeout countdown to remind users.
Anonymous User becomes a built-in dynamic User Levels so administrators can setup permissions at runtime.
Administrator can now easily do the following tasks in the List page of the User table.
Password Generator and Password Strength Meter
Improved Multi-Page
Add client side events easily and manipulate/validate the fields quickly with PHPMaker's "fields" jQuery plugin.
Set multiple properties of multiple fields at one time.
Import/Export of Theme Settings
Import/Export Feature of Multi-Language Property Editor
Dynamic Selection Lists in Master/Detail-Add/Edit
Saves search criteria in browser local storage.
Cancel button with confirmation dialog if form data has been modified.
Use button group with tooltip.
More Server Events
Language_Load - For customizing the language phrases, fired after the language file is loaded.
AuditTrail_Inserting - For customizing the data to be logged, fired before inserting the audit trail log.
More Advanced Settings
Format project file - Add indentation to XML nodes in the project file
Allow login by session variables - For use with User_CustomValidate server event
Session timeout period (minutes) - Specifies the session time-out period if the user does not refresh or request a page
Session keep alive interval (seconds) - Specifies the interval to send Ajax request to the server for keeping the session alive
Session time out countdown period (seconds) - Specifies the countdown period before session ends
Use ADOdb driver for MySQL - Use the full ADOdb driver for MySQL instead of the lite version (ewmysql.php)
Encrypt file path - Encrypt the file path of uploaded files in URL
Reduce image size only (image resize) - Specifies if enlarging image is preferred (Migrated from previous Image Resize extension)
Always keep aspect ratio (image resize) - Specifies if aspect ratio should be kept (Migrated from previous Image Resize extension)
Check password strength - Specifies if the strength of inputted password for password fields should be checked
Minimum password strength - Specifies the minimum acceptable password strength
Generate password - Specifies if a random password generation button should be added to password field
Password length - The length of the password to be generated
Add plain text version in HTML email - Specifies if text version of email content is required
Use tabular form for desktop - Use Boostrap table instead of Bootstrap horizontal form for Add/Edit/Search/Update/Register pages (Desktop mode only)
More
Use mysqli extension by default
Image resizing functionality (does not require Image Resize extension anymore)
Multi-Language support for email template
Lookup always by ajax ("Use Ajax" setting removed)
Improved Custom Actions
DetailPages property for showing and hiding detail table tabs by server event
Password change by user (for md5 password) as password recovery
Support Custom Attributes as PHP array
SelectLimit() support for MSSQL >= 2005
Global array for passing server side values to client side
"addoption" and "newoption" client side event for lookup fields (supports both lookup fields with lookup table or user values)
JavaScript alerts replaced by Modal dialog
jQuery, JsRender, jQuery File Upload updated
tinyMCE and CKEditor extensions (for registered users only) updated with latest versions
Multi-Language support for reCAPTCHA, JsCalendar, tinyMCE and CKEditor
QRCode/BarCode Custom View Tags combined (Flash Files Custom View Tag removed)
A new built-in "plain" theme
UTF-8 output files if project charset is utf-8
PHPMailer updated
Setting PHPMailer properties in Email_Sending server event
mobile_detect.php updated and mobile-detect.js adopted
Bootstrap 3.3.5
Many other minor improvements

v11.0 [Jul 13, 2014]
What's New in PHPMaker 11
PHPMaker 11 is a major upgrade from 10.x. It is loaded with a bunch of new features, including many frequently requested ones. PHPMaker is probably the most powerful and flexible product of its kind, and yet still easy-to-use as always.
Responsive Layout with Bootstrap 3
Pages fit both desktop and mobile.
New implementations:
Mobile menu by Navbar
Search options by ButtonGroup
Optional Advanced Search form by Modal dialog
AutoSuggest by typeahead.js
Responsive table for main table in List page
Horizontal Form in Add/Edit/Update/Search/Register/Login page
Grid system
Responsive utilities
New Mobile Menu
Enhanced Bootstrap Navbar as mobile menu with multi-level submenu support.
Toolbar and Vector Icons with Tooltip
Compact breadcrumbs, export options, search options and language selection list (if multi-language) in one row to make more room for data. Most buttons come with vector icon and tooltip.
Vertical/Horizontal Menu with Submenu
Enhanced Bootstrap Dropdown as vertical menu and Navbar as horizontal menu with submenu on mouseover.
Vertical menu
Horizontal menu by Horizontal Menu extension (for registered users only)
Improved Theme with Bootstrap Variables
Allow customizing all Bootstrap variables right in the UI.
Advanced Search Modal Dialog
Optionally shows Advanced Search page in modal dialog.
Enhanced Quick Search
New "Auto" mode supporting "OR" operator and double quoted phrase for "Exact Match". Dropdown search options.
Improved Detail Preview Extension (for registered users only)
Add/Copy/Edit/Delete/View links for detail records in the preview page.
Colorbox
View full size images without leaving the page. Images for the fields allowing multiple upload will be displayed as groups.
Timepicker Extension (for registered users only)
Allows selecting time easily for Time fields.
PHPWord Extension (for registered users only)
Allows exporting data in native Word 2007 (.docx) format.
Export to Excel/Word/PDF/Email by Custom Template
Previously Custom Template can only used by Printer-Friendly, now it can also be used by Export to Excel/Word/PDF/Email (NOT including PHPExcel/PHPWord).
Improved Google Maps (Custom View Tags)
Supports showing multiple markers (from records in the page) in one single map.
Custom Files
Previous only one "blank page" is supported, now you can add multiple Custom Files to your project.
More Server Events
Grid_Inserting - For use with Grid-Add for a table and Master/Detail-Add for a detail table, fired before inserting records.
Grid_Inserted - For use with Grid-Add for a table and Master/Detail-Add for a detail table, fired after inserting all records.
Grid_Updating - For use with Grid-Edit for a table and Master/Detail-Edit for a detail table, fired before updating records.
Grid_Updated - For use with Grid-Edit for a table and Master/Detail-Edit for a detail table, fired after updating all records.
Page_Exporting - Fired before the page is exported.
Row_Export - Fired when a row is exported for exporting the row in custom code.
Page_Exported - Fired after the page is exported.
More Advanced Settings
Generate database helper - Generate a database helper for including in current or other project for simple access to the database and retrieving data
Use handlebars.js - For Custom Templates of typeahead.js
Export detail records in Master/Detail-View
Export detail records for CSV in Master/Detail-View
Oracle charset - For setting Oracle's NLS_COMP parameter
Oracle sort - For setting Oracle's NLS_SORT parameter
Auto-fill original value - For Auto-Fill by original (database) value instead of looked up value
Multiple file upload separator - Specify the file upload separator used to separate the file names
Use Colorbox for images
Use responsive layout
Use dropdown for button group in mobile - Use button dropdown instead of button group to save more spaces for data in mobile mode

v10.0 [Jul 3, 2013]
Tooltip by Tooltip and Popover
Search Panel by Collapse
Numeric Pager by Pagination
NextPrev Pager by Button groups and Icons
Add Option Dialog, Export to Email Dialog and JavaScript Popup Message by Modal
Server side message by Alert
AutoSuggest by Typeahead
Vertical Menu by Dropdown

v9.1 [Nov 27, 2012]
1.New Table Setup Page
A new Table Setup page is added next to Field Setup page for quick access to current table settings.
2.Improved Dynamic Selection Lists
Now supports up to 4 pairs of parent field and filter field.
3.Improved Add Option Form
Supports JavaScript features such as DHTML editor, JSCalendar, Dynamic Selection Lists, etc.
4.Improved Preview Row Extension (for registered users only)
Shows detail tables in TabView.
5.Custom Template
Allows showing fields with your own template.
6.Default Search Values
Lets you specify default search criteria when there is no user inputted criteria.
7.Scripts without Header and Footer
Lets you include PHPMaker generated scripts in your own PHP scripts more easily.
8.IIS Express
Test generated site without the need to to configure web server. (Requires IIS Express installed on the same machine as PHPMaker.)
9.Improved Advanced Security
Allow View All option for User ID Security, allow users to view other users' records
Separate permissions for List/View/Search in both Static and Dynamic User Level Security
Allow selecting tables to show in User Level Permission Setup page
10.Improved Auto-Fill
Allows auto-filling a child field by different parent fields (previously one parent field only)
Allows filling lookup fields
Clears target fields if parent field selects a blank option
11.More Advanced Settings
JavaScript message
Disables submit buttons on form submission
Auto-Suggest searches Display Field #2 to #4 also
Allows login by URL
Time limit for exporting all records
Project name and project ID
Include jQuery library (for user's own use)
12.More
Faster script generation (by JScript engine)
Multi-Language Lookup Table Display Fields
Export to native Excel5/2007 (PHPExcel extension for registered users only)
Different locale settings and time zone for Multi-Language
Custom View Tag for overriding View Tag setting and display field value with custom code
Supports date fields for Quick Search
Supports SMTP servers using TLS/SSL
Supports formatted decimal values in Add/Edit page
Option to hide unused menu items in menu editor
Option to open project file without AutoSync
More helper functions for server events and client Scripts
Allow specifying start page for project
Simplified User Code by JavaScript
Detects project changes when closing project
Extensions (tinyMCE and CKEditor) updated with latest versions
Icons for messages
Many other minor improvements

v9.0 [Apr 21, 2012]
A new Table Setup page is added next to Field Setup page for quick access to current table settings. Now supports up to 4 pairs of parent field and filter field. Supports JavaScript features such as DHTML editor, JSCalendar, Dynamic Selection Lists, etc. Shows detail tables in TabView. Allows showing fields with your own template. Lets you specify default search criteria when there is no user inputted criteria. Lets you include PHPMaker generated scripts in your own PHP scripts more easily. Test generated site without the need to to configure web server. Separate permissions for List/View/Search in both Static and Dynamic User Level Security. Allow selecting tables to show in User Level Permission Setup page.
- Allows auto-filling a child field by different parent fields (previously one parent field only)
- Allows filling lookup fields
- Clears target fields if parent field selects a blank option
- Faster script generation (by JScript engine)
- Multi-Language Lookup Table Display Fields
- Export to native Excel5/2007 (PHPExcel extension for registered users only)
- Different locale settings and time zone for Multi-Language
- Custom View Tag for overriding View Tag setting and display field value with custom code
- Supports date fields for Quick Search
- Supports SMTP servers using TLS/SSL
- Supports formatted decimal values in Add/Edit page
- Option to hide unused menu items in menu editor
- Option to open project file without AutoSync
- More helper functions for server events and client Scripts
- Allow specifying start page for project
- Simplified User Code by JavaScript
- Detects project changes when closing project
- Extensions (tinyMCE and CKEditor) updated with latest versions
- Icons for messages
- Many other minor improvements

v8.0 [Feb 10, 2011]
PHPMaker 8 is a major upgrade from 7.x. It is loaded with a bunch of new features, including many frequently requested ones. PHPMaker 8 is probably the most powerful and flexible product of its kind, and yet still easy-to-use as always.
In additional to MySQL, PostgreSQL, Microsoft Access and Microsoft SQL Server, PHPMaker now supports Oracle also.
Support adding/deleting rows to/from the grid during Grid-Add/Edit.
Allows inserting/updating a master record with multiple detail records of a detail table in the same page. Supports adding/deleting rows to/from the detail grid.
A new extension for export to PDF is provided.
To encourage use of database views instead of Custom Views (which was designed for old versions of MySQL that did not support views), PHPMaker now support creating, altering and dropping database views in user interface.
In addition to vertical and horizontal menu, the graphical extension now uses YUI menu and support grouping.
The field hint (entered in the "Title" column of the Field Setup page) is now displayed like tooltip, you can now use HTML for the hint.
More Server Events:
- Page_Head - Fired before ending the <head> section. Allows adding your own code (e.g. adding external JavaScript and stylesheet) to the section.
- User_CustomValidate- Fired before default user validation. Allows custom user validation.
- Menu_Rendering - Fired before the menu is rendered. Allows manipulating all menu items.
- Page_DataRendering - Fired after the header.php is included. Allows adding content at the top of page content.
- Page_DataRendered - Fired before the footer.php is included. Allows adding content at the bottom of page content.
Many More:
- PHP 5 (PHP 4 is no longer supported)
- More than one field per row in the Extended Quick Search panel
- More display fields (up to 4) for selection lists
- Copy file upload fields also on copying a record