PHPMaker Changelog

What's new in PHPMaker 2024.9.0.0

Mar 6, 2024
  • Improved: Google Maps (Custom View Tag)
  • Improved: Show deleted file name during folder clearing
  • Improved: Map MySQL tinyint to int or bool according to field settings
  • Fixed: z-index of Date/Time picker
  • Fixed: Condition attributes in control.xml
  • Fixed: Lookup filter for Filter fields
  • Fixed: Filter fields for reports
  • Fixed: Cache folder for API
  • Fixed: Error message for client side regular expression validator
  • Updated: Bootstrap, SweetAlert2, PDFObject, Tabulator and FullCalendar
  • Updated: WebView2 (UI)
  • Other minor fixes and improvements

New in PHPMaker 2024.8.0.0 (Feb 12, 2024)

  • Support SQL Server LocalDB
  • Improved: CSS style for TinyMCE
  • Improved: CSS style for tabular form
  • Improved: Add "focused" event for forms
  • Improved: Default values in entity classes
  • Improved: Check file upload path for temporary files
  • Improved: UpdateTable for ChangePassword/PersonData/Register pages
  • Improved: Add "newmessage.chatify" event (Chatify extension)
  • Improved: Support text alignment on export (PhpSpreadsheet/PhpWord extensions)
  • Fixed: Sending OTP in Register page
  • Fixed: Driver options for pdo_sqlsrv
  • Fixed: AuditTrailHandler for PHP 8.0
  • Fixed: PHP warning for class PersonalData
  • Fixed: Empty row checking for Detail Grid page
  • Fixed: Migrating static user levels to database
  • Fixed: Checking page break classes during export
  • Fixed: Fields with User Values and Table Head Filter enabled
  • Updated: SweetAlert2, Tabulator and date/time picker
  • Updated: WebView2 (UI)
  • Many other minor improvements

New in PHPMaker 2024.7.0.0 (Jan 16, 2024)

  • Improved: Check if PHP xml extension loaded
  • Improved: Change chart label display to "auto"
  • Improved: Check connection isTransactionActive()
  • Improved: Add advanced setting "Format phone number" (for SMS)
  • Improved: Save team encryption keys under HKCUSoftwarePHPMakerTeamEncryptionKeys
  • Fixed: PostgreSQL point type
  • Fixed: Lookup in Calendar Reports
  • Fixed: Default values and bit data type for entity class
  • Fixed: S3 bucket with encrypt file path disabled
  • Fixed: "User" property of class LdapConn
  • Fixed: Button groups in preview pages
  • Fixed: Page breaks in reports
  • Fixed: Card widget maximize/minimize icons
  • Fixed: Migrate static user levels (UI)
  • Updated: SweetAlert2 and date/time picker
  • Updated: WebView2 (UI)
  • Many other minor improvements

New in PHPMaker 2024.5.0.0 (Nov 28, 2023)

  • Improved: Add EventManager()
  • Improved: Use InnoDB for demo project
  • Improved: Add Config("TWO_FACTOR_AUTHENTICATION_CLASS")
  • Fixed: Target PHP version
  • Fixed: Tooltip field in summary report
  • Fixed: API Route for exporting List page
  • Fixed: Drilldown links for Crosstab reports
  • Fixed: Detecting SQLite primary key and view
  • Fixed: .visible() method of jQuery .fields plugin for Extended Search
  • Updated: WebView2 Runtime (v1.0.2151.40)
  • Updated: SweetAlert2, Luxon, Google Maps Marker Clusterer and date/time picker
  • Many other minor improvements

New in PHPMaker 2024.4.0.0 (Nov 1, 2023)

  • Improved: Apply RemoveXss() to "provider" argument
  • Improved: Use global debug setting for social login
  • Improved: Add ew.calendarOptions.popoverViews setting
  • Fixed: setCanXxx() methods
  • Fixed: Tooltip field in summary report
  • Fixed: Printer friendly page for detail grid
  • Fixed: Compiling .scss with non-alphanumeric font name
  • Fixed: Restoring filters for QueryBuilder
  • Fixed: Users table entity class
  • Fixed: Display value separator (client side)
  • Fixed: OtpOnly for hard code admin
  • Updated: SweetAlert2
  • Many other minor improvements

New in PHPMaker 2024.3.0.0 (Nov 1, 2023)

  • Improved: Increase field mapping form size
  • Improved: Check if language file XML is well-formed
  • Improved: Border radius of tables in List and Preview pages
  • Improved: CustomTemplateCard
  • Improved: CSS for chat widget with plain theme
  • Improved: Check session timeout settings better
  • Improved: Set calendar start/end date/time format in Add/Edit pages
  • Improved: Check Preview Field (Preview extension)
  • Fixed: setCan*() methods
  • Fixed: Font name with non-alphanumeric characters
  • Fixed: Alternating row colors in reports
  • Fixed: Sending OTP by email
  • Fixed: Printer friendly page for Master/Detail View
  • Fixed: Timezone and allowed upload file types (Chatify extension)
  • Fixed: ReCaptchaTheme setting not removed (Recaptcha extension)
  • Fixed: Refreshing preivew tabs and detail counts (Preview extension)
  • Updated: SweetAlert2 and date/time picker
  • Many other minor improvements

New in PHPMaker 2024.2.0.0 (Nov 1, 2023)

  • Improved: DatabaseConnectingEvent
  • Improved: Protect log files (.htaccess)
  • Improved: Update composer.json for web push (for PHP 8.0)
  • Improved: HttpErrorHandler for production environment
  • Improved: Table border radius if no upper/lower panels
  • Improved: Allow using Conn() and related global functions in Global Code
  • Improved: Allow extensions with no README.md file (UI)
  • Fixed: Registration page
  • Fixed: Composite unique index checking (for MSSQL)
  • Fixed: Calendar reports (for PostgreSQL/Oracle)
  • Fixed: Using JavaScript for Multi-Page in View/Edit pages
  • Fixed: Calendar year view (dark mode)
  • Fixed: Synchronization with fields with default value
  • Fixed: CSS file name with "Lowercase routes" enabled
  • Fixed: Table name in API routes with "Lowercase routes" enabled
  • Fixed: Accordion for detail tables
  • Fixed: Warning for Maintenance middleware (for PHP 8.2)
  • Fixed: Detecting boolean fields without user values
  • Fixed: Detecting INT data types on Turkish Windows
  • Fixed: Container compilation for production environment
  • Fixed: Checking validation type of field (TimePicker extension)
  • Fixed: Timezone (Chatify extension)
  • Updated: WebView2 v117.0.2045.47 (UI)
  • Updated: FullCalendar, SweetAlert2, Google Maps MarkerClusterer
  • Many other minor improvements

New in PHPMaker 2024.1.0.0 (Sep 18, 2023)

  • Improved: Check PHP and Node.js version
  • Improved: Load team encryption key from old version
  • Improved: Generate entities for views
  • Improved: Handle samesite cookie for social login
  • Improved: Find last modal footer to insert modal page buttons
  • Improved: Style sidebar/navbar-light as dark for dark mode
  • Improved: Add settings for Tiny API key (TinyMCE extension)
  • Fixed: Trusted connection and non default port number (MSSQL)
  • Fixed: Page object not found during lookup
  • Fixed: Plain theme
  • Fixed: SaveUploadFiles()
  • Fixed: Migration of User Level settings to database
  • Fixed: Infinite Scroll with file upload fields
  • Fixed: LDAP connection
  • Fixed: Table striped color (dark mode)
  • Fixed: Registration page
  • Fixed: Calendar report
  • Fixed: Export Master/Detail in View page
  • Fixed: Duplicated Language_Load server event
  • Fixed: Showing file upload error messages for import
  • Fixed: Map on modal View page
  • Fixed: Loading locale settings (UI)
  • Bootstrap v5.3.2
  • Updated: Luxon 3, FullCalendar Luxon 3, Google Maps MarkerClusterer, SweetAlert2, PDFObject, TinyMCE language files
  • Many other minor improvements

New in PHPMaker 2024.0.0.0 (Sep 5, 2023)

  • Bootstrap 5.3.1 and Dark Mode:
  • Supports dark mode (with dark/light mode toggler)
  • Updated AdminLTE 3.2 for Bootstrap 5.3
  • Updated extensions to support dark mode
  • Chart.js 4 and New Chart Types:
  • 100% Stacked Charts
  • Enhanced Calendar Reports:
  • Supports Multi-Month Year View
  • Supports Extended Search
  • Multi-Page for View/Add/Edit pages
  • Custom Templates for Add/Edit/View pages and popover
  • New Event_Adding server event to show/hide an event or change the event data
  • Supports setting FullCalendar options by server event
  • SSH Connection for MySQL and PostgreSQL
  • Improve List Actions:
  • Add custom actions simply by Page_Load server event only (no need for Row_CustomAction), e.g.
  • Multiple Language Files:
  • Supports multiple language files for each language
  • Supports separate language files for extensions
  • Email templates detached from main template and handled similar to language files
  • Supports editing email templates in code editor
  • Doctrine ORM:
  • Currently supports Basic Mapping
  • Using the EntityManager to insert, update, delete and find objects in the database without writing SQL
  • Great for using with server events
  • Works with FieldEncryption and RemoveXSS extensions
  • Maintenance Mode:
  • Puts site under maintenace
  • Allows setting retry time
  • Chat Extension (for Registered Users):
  • One-to-one chatting system (Group chat is NOT supported)
  • Pusher API account required
  • Extension supports altering user table and creating new tables for the feature
  • User selected avatar and messenger color
  • Supports dark mode
  • Improved Preview Extension (for Registered Users):
  • Nested preview
  • Refresh after modal actions
  • Client Script and Startup Script (Preview page)
  • Progress Window with Text Color and Color Schemes:
  • Supports text color and color scheme like Windows terminal.
  • Improved User Sessions Management:
  • Active user sessions
  • Logout concurrent users
  • Force logout user
  • New/Improved Server Events:
  • Namespace_Use - For aliasing/importing namespaces
  • Event_Adding - Show/Hide a calendar event or change the event data
  • MenuItem_Adding and Menu_Rendering - Support $this to reference the menu object
  • Lookup_Selecting - UserFilter supports {v1} to {v4} (selected values of parent fields)
  • Event Listeners - Support multiple listeners for some global events
  • New Advanced Settings:
  • Target PHP version - 8.0, 8.1 or 8.2
  • Microsoft SQL Server driver - pdo_sqlsrv or sqlsrv
  • Progress window color scheme
  • Auto close progress window
  • AES encryption key (base64 encoded)
  • JWT signing algorithm
  • Maintenance mode
  • Maintenance retry after (seconds)
  • Use element-internals-polyfill
  • More:
  • Supports PHP >= 8.0.2
  • Supports more data types (Note that these fields are not searchable):
  • MySQL - binary, geometry
  • PostgreSql - timetz, timestamptz, enum, geometry, geography
  • Microsoft SQL Server - binary, hierarchyid, geometry, geography
  • PHP 8 attributes for route definitions
  • PHP enums
  • Bootstrap 5.3 nav underline option for Multi-Page
  • Expand/Collapse report groups using server event
  • Options to clear project folder first (re-generate all files)
  • Improved control tag "cond" attribute (supports complex conditions)
  • Two factor authentication supports login by 2nd factor only
  • Query Builder supports saving search criteria
  • Custom Template for Add Option page
  • REST API always uses JWT token for user authentication
  • Custom View Tag as ReadOnly fields
  • Support {ProjectNamespace} placeholder for Custom Files (for generating classes)
  • Autofill for lookup fields
  • Supports .svg as brand logo
  • Regeneration by CLI commands
  • New extension for removing XSS
  • New @googlemaps/markerclusterer replaces old @googlemaps/markerclustererplus
  • FileManager extensions (for registered users) supports TinyMCE
  • New Symfony Notifier extension (for registered users) for sending SMS (replaces AWSSNS extension)
  • Many other minor improvements

New in PHPMaker 2023.13.0.0 (May 8, 2023)

  • Improved: Pass master keys directly to preview page
  • Fixed: Row custom action checking
  • Fixed: Selection list with native select-one enabled
  • Fixed: Error message for file upload fields
  • Fixed: Remove XSS for lookup fields
  • Fixed: CSS for card widget
  • Fixed: Export links after refresh
  • Fixed: Grid-Edit with server side validation only
  • Fixed: Stylesheet URLs for error page
  • Fixed: Required validation for multi-select field in Multi-Update page
  • Fixed: Both Date/Time picker and time picker generated when using custom format pattern
  • Updated: Font Awesome, Date/Time picker, SweetAlert2 and element-internals-polyfill
  • Other minor improvements

New in PHPMaker 2023.12.0.0 (Apr 11, 2023)

  • Improved: Log import database error
  • Improved: Allow PostgreSQL timetz/timestamptz fields and MySQL char/varchar fields with *_bin collation
  • Fixed: Hidden required field checking
  • Fixed: Table body hover color
  • Fixed: Add blank row with checkboxes or radio buttons
  • Fixed: Grid form (for detail table) validation
  • Fixed: Grid update foreign key
  • Fixed: Clearing messages after import
  • Updated: jQuery, JsRender, Popper, date/time picker, chartjs-plugin-annotation and element-internals-polyfill
  • Other minor improvements

New in PHPMaker 2023.11.0.0 (Mar 7, 2023)

  • Improved: Add "Messages" to keyword.xml
  • Fixed: Modal lookup with lookup filter
  • Fixed: "Export CSS Styles" advanced setting
  • Fixed: Add Option dialog with lookup fields
  • Fixed: Setting TableClass property (PHP 8.2)
  • Fixed: Execute() function with callback
  • Fixed: AdjustSql() function for PostgreSQL
  • Fixed: Extended search panel after row custom action
  • Fixed: Synchronization checking for reports with custom fields
  • Updated: SweetAlert2, tabulator and element-internals-polyfill
  • Other minor improvements

New in PHPMaker 2023.10.0 (Feb 6, 2023)

  • Fixed: Create upload files on copy
  • Fixed: Query builder page without advanced search
  • Fixed: Lookup filter for Add page
  • Fixed: Lookup fields for enum/set types
  • Fixed: Updating selection lists for detail grid
  • Fixed: Detail grid Delete permission checking
  • Fixed: Query builder for lookup field with text input
  • Fixed: Export reports/email error message
  • Fixed: Parent field in Add Option dialog
  • Fixed: Extended search panel after row custom action
  • Fixed: Setting static permissions for calendar reports (UI)
  • Updated: dompdf, SweetAlert2 and element-internals-polyfill
  • Other minor improvements

New in PHPMaker 2023.8.0.0 (Dec 5, 2022)

  • Improved: Detect field data types better
  • Improved: Handle server side validation error for Use Ajax Actions
  • Fixed: Multi-value search
  • Fixed: Crosstab report year field
  • Fixed: Inline-Add/Edit with dynamic selection lists
  • Fixed: Client side number formatting for CJK
  • Fixed: Field names with lower case characters (Oracle)
  • Fixed: Calendar report Add page permission
  • Fixed: Query builder and Extended Search with default search value
  • Fixed: Comma separated Parent User ID field
  • Fixed: Custom Template for summary report
  • Fixed: Dropdown button with single list option
  • Fixed: Custom Field in crosstab report
  • Fixed: MySQL TINYINT data type as CHECKBOX/RADIO with User Values
  • Fixed: Detail records sorting order in Master/Detail export
  • Fixed: Saving MySQL SSL connection options (UI)
  • Fixed: Showing user level tables after creating tables (UI)
  • Updated: Bootstrap 5.2.3
  • Updated: SweetAlert2 and Leaflet
  • Other minor improvements

New in PHPMaker 2023.7.0.0 (Nov 15, 2022)

  • Project specific User Code
  • Improved: Persisting breadcrumb links
  • Improved: Handling calendar null event group ID
  • Improved: Calendar event popover template
  • Fixed: Fixed header table without responsive table
  • Fixed: Custom Template for Multi-Page
  • Fixed: Year filter for crosstab report (PostgreSQL)
  • Fixed: Container definitions for tables not generated
  • Fixed: Modal login dialog with third party login provider
  • Fixed: Dismissing modal Delete page
  • Fixed: Plain theme cannot be compiled
  • Fixed: Copying record with default values
  • Fixed: Add Option dialog with parent field
  • Fixed: Chart.js beginAtZero option
  • Fixed: Export in project with security disabled
  • Updated: SweetAlert2, JsRender and date/time picker
  • Other minor improvements

New in PHPMaker 2023.6.0.0 (Nov 1, 2022)

  • Improved: Use locale time format for calendar
  • Improved: Show master table in breadcrumbs
  • Improved: Add config setting for Font Awesome .css
  • Improved: Allow setting native select-one for field
  • Improved: Support upper/lower panel for preview page
  • Improved: Avoid strtolower() warnings in Language class (for PHP 8.1)
  • Fixed: Date time picker for Thai
  • Fixed: Searching multi-select field
  • Fixed: Returning to current page after Grid-Edit
  • Fixed: Modal dialog not reset after server side error
  • Fixed: User ID setting for calendar reports (UI)
  • Fixed: Migrating user level primissions for MSSQL table with schema (UI)
  • Updated: SweetAlert2 and date/time picker
  • Other minor improvements

New in PHPMaker 2023.5.0.0 (Oct 25, 2022)

  • Improved: Detect MS SQL client better (UI)
  • Improved: Add global upload path to dompdf chroot (Dompdf extension)
  • Fixed: Handling LIKE operator in SQL (MSSQL)
  • Fixed: Custom template in modal dialog
  • Fixed: Printer friendly in View page
  • Fixed: Hanlding null values for simple charts and TruncateMemo()
  • Fixed: Multiple upload fields
  • Fixed: Add filter with parentheses
  • Fixed: Allow login by URL
  • Fixed: View/Copy pages in Calendar report
  • Fixed: Context menu for events with link in Calendar report
  • Fixed: User level permission for Calendar report
  • Fixed: AllDay/Start/End fields in Calendar report
  • Fixed: AutoSuggest field as parent field in Dynamic Selection List
  • Fixed: View page with Multi-Page enabled
  • Updated: SweetAlert2 and date/time picker
  • Other minor improvements

New in PHPMaker 2023.4.0.0 (Oct 18, 2022)

  • Improved: Add Row_* server events for calendar report
  • Fixed: Lookup filter for LIKE operators
  • Fixed: Inline-Add/Copy without Grid-Add/Edit enabled
  • Fixed: Multiple detail table with same foreign key field name
  • Fixed: Chart.js title and tooltip font settings
  • Fixed: Dashboard charts from normal List page
  • Fixed: RTL (Import preview and user permission page)
  • Fixed: Time zone added by time picker
  • Fixed: "Allow view all" for reports
  • Fixed: Unselected fields generated in View/Add/Edit pages of Calendar report
  • Fixed: Dragging and resizing calendar events
  • Fixed: Custom Template in modal dialog
  • Updated: Time picker, SweetAlert2 and Tabulator
  • Other minor improvements

New in PHPMaker 2023.3.0.0 (Oct 11, 2022)

  • Improved: Allow Add/Copy/Edit/Links in modal View page when using Ajax actions
  • Improved: Add client side "rowadded" and "rowdeleted" event for Grid-Add/Edit
  • Improved: Enable paste action in code editor (UI)
  • Improved: Add CSS class to crosstab values
  • Improved: Add Config("LOG_ERROR_DETAILS")
  • Fixed: Pager when using Ajax actions
  • Fixed: Add records with no existing records when using Ajax actions
  • Fixed: Upload fields in Edit page
  • Fixed: AdminLTE Sidebar Search and Treeview
  • Fixed: Image cropper for non-png images
  • Fixed: CSS file names for RTL languages
  • Fixed: Change code by extension
  • Fixed: Custom actions by post back
  • Fixed: The "ALL" option in page size selector
  • Fixed: Charts exported in View page
  • Fixed: Charts with User ID Security
  • Fixed: Cast field value to stirng for LIKE (PostgreSQL)
  • Fixed: Preview page (Preview extension)
  • Fixed: Error on synchronization with database (UI)
  • Updated: SweetAlert2, Leaflet, date/time picker and element-internals-polyfill
  • Other minor improvements

New in PHPMaker 2023.1.0.0 (Sep 26, 2022)

  • Improved: Allow Add/Copy/Edit/Links in modal View page when using Ajax actions
  • Improved: Add client side "rowadded" and "rowdeleted" event for Grid-Add/Edit
  • Improved: Enable paste action in code editor (UI)
  • Improved: Add CSS class to crosstab values
  • Improved: Add Config("LOG_ERROR_DETAILS")
  • Fixed: Pager when using Ajax actions
  • Fixed: Add records with no existing records when using Ajax actions
  • Fixed: Upload fields in Edit page
  • Fixed: AdminLTE Sidebar Search and Treeview
  • Fixed: Image cropper for non-png images
  • Fixed: CSS file names for RTL languages
  • Fixed: Change code by extension
  • Fixed: Custom actions by post back
  • Fixed: The "ALL" option in page size selector
  • Fixed: Charts exported in View page
  • Fixed: Charts with User ID Security
  • Fixed: Cast field value to stirng for LIKE (PostgreSQL)
  • Fixed: Preview page (Preview extension)
  • Fixed: Error on synchronization with database (UI)
  • Updated: SweetAlert2, Leaflet, date/time picker and element-internals-polyfill
  • Other minor improvements

New in PHPMaker 2023.0.0.2 (Sep 15, 2022)

  • Calendar Report:
  • Calendar report with FullCalendar
  • Modal Add, Edit, Delete, View pages for events
  • Popover for events
  • Context Menu in calendar
  • Predefined CSS classes for styling the events and popovers easily
  • Context menu:
  • Popover with matching style
  • Enhanced Dashboard Report:
  • Paging reports by Ajax
  • Sorting reports and charts by Ajax
  • Supports export
  • Card refresh/maximize/collapse for each report/chart
  • Two Factor Authentication (Email and SMS with Third Party API):
  • In additional to Google Authenticator, the Two Factor Authentication feature now supports:
  • OTP by email
  • OTP by SMS with third party API (e.g. AWSSNS)
  • Fixed Header Table (without Extension):
  • Now built-in
  • Provides predefined CSS classes for setting table height easily
  • Query Builder:
  • Builds complex queries that was not possible with Advanced Search
  • Allows selecting search operators for each field
  • Multiple rules for each field
  • AND/OR condition between fields for each group
  • Multiple groups of rules
  • AND/OR condition between groups
  • NOT condition for groups
  • Multi-Edit for Editing Selected Records:
  • Complementary to Multi-Delete and Multi-Update, this new feature allows selecting records by checkboxes and editing them together like Grid-Edit. Supports modal dialog also.
  • Modal Grid-Add/Edit:
  • Now you can do Grid-Add/Edit and the new Multi-Edit with modal dialog without leaving the List page.
  • Charts for Tables and Views:
  • Not limited to reports anymore, now you can create charts in List page of table/views also.
  • Login Provider for SAML2 and Azure AD:
  • Supports OAuth2 with Azure AD
  • Supports SAML2 Single Sign-On (SSO) and Single Logout (SLO) with Azure AD or SimpleSAMLphp
  • Improved Data Import:
  • Test import with database transaction
  • Server-sent event for import progress
  • Improved server event for adding custom steps before import
  • Export API and Export Log:
  • Export API
  • Allows saving exported file on server
  • Export log table supports retrieval and searching of exported files
  • User permission and expiration time of JWT token for export
  • Supports exporting to HTML with images
  • Supports retrieving multiple exported files as zipped file
  • Ajax Actions without Reloading Page:
  • Enhances user experience
  • Supports searching, paging, and sorting
  • Supports inline and modal Add/Copy/Edit/Update/Delete actions
  • Infinite Scrolling Table (Extension for Registered Users Only):
  • Adds Infinite Scrolling to the main table in List page
  • Use Ajax inline and modal actions without reloading the page
  • Pretty Error Page for Development:
  • Show source code, stack trace of the error and detailed information of the request
  • For debugging during development only, not for production
  • New Advanced Settings:
  • HTML preview - Allow disabling HTML preview in UI
  • Proxy server address
  • Proxy server port
  • Proxy server username
  • Proxy server password
  • Show source code with error (development)
  • Add autocomplete='off' attribute to forms
  • Use Ajax actions (List page)
  • Fall back user level permissions - Fall back Import/Export/Lookup/Push permissions to old List or Administrator permission
  • Lookup cache enabled pages - Sets which pages use lookup cache
  • Import maximum number of failures
  • Use image cropper for file upload
  • Export folder
  • Use fixed header table
  • Fixed header table height (CSS class)
  • LDAP base distinguished name
  • Azure app ID
  • Azure app secret value
  • SAML IdP metadata (XML)
  • SAML SP entity ID
  • SAML SP X.509 certificate file
  • SAML SP private key file
  • New/Improved Server Events and Client Scripts:
  • Table_Load
  • Otp_Sending
  • Server Events and Client Script for Calendar Report
  • Client and Startup Script for User Level Permissions Page
  • Server Events for Import/Export
  • More:
  • Supports PHP 7.4, 8.0 and 8.1
  • Replaces out-dated Composer packages incompatible with PHP 8.1
  • IS EMPTY and IN search operators
  • Uses FIND_IN_SET() for MySQL
  • Show Current Filter for tables/views
  • Custom Message in Add Option page
  • Table name as tooltip in User Permissions Setup page
  • URLs of .js and .css files with version
  • Supports async function in custom validate
  • Language file includes phrases for Tempus Dominus, Select2, jQuery Query Builder and FullCalendar
  • Improved temporary files cleanup
  • Bootstrap 5.2.1, AdminLTE 3.2 and Font Awesome 6
  • Dompdf v2.0.0 (Dompdf extension)
  • Tempus Dominus v6.0.0 (DateTime Picker extension)
  • UI supports working behind proxy server
  • Improved documentation on website
  • Many other minor improvements

New in PHPMaker 2022.12.0 (Apr 25, 2022)

  • Better compatibility with PHP 8.1
  • Fixed: Checking empty row in grid
  • Fixed: Default sorting order
  • Fixed: Multi-Page as Accordion
  • Fixed: ListOptions visibleCount() method
  • Fixed: CHECKBOX Edit Tag without dropdown
  • Fixed: Showing server side error message in Login pages
  • Fixed: $DownloadFileName global variable for BLOB fields without file name field
  • Improved: fetch() method
  • Improved: Check permission for Grid/Inline-Add/Edit
  • Improved: beforesubmit/aftersubmit client side event
  • Improved: Mute video before autoplay for YouTube videos
  • Updated: SweetAlert2, chartjs-plugin-annotation v1.4.0, date/time picker and element-internals-polyfill
  • Other minor improvements

New in PHPMaker 2022.11.0 (Feb 28, 2022)

  • Compatibility with PHP 8.1
  • Fixed: Preview field checking
  • Fixed: Accordion collapsing
  • Fixed: Routes for View pages in groups
  • Fixed: Showing PDF from BLOB field in Preview page
  • Fixed: AutoSuggest with "Auto-Suggest all display fields" disabled
  • Fixed: Auto JS Template not shown in Code repo for server event (UI)
  • Improved: Check User ID field of user table better (UI)
  • Improved: Handle non-varchar fields for Custom Template (PostgreSQL)
  • Improved: Load default values for table without primary key field(s)
  • Updated: SweetAlert2, Chart.js, chartjs-plugin-annotation and element-internals-polyfill
  • Other minor improvements

New in PHPMaker 2022.10.0.0 (Jan 31, 2022)

  • Fixed: Update current values in addRow() and editRow()
  • Fixed: Preview extension 'previewPopoverTrigger' setting
  • Fixed: Audit table set wrongly as Subscription table (UI)
  • Improved: emptyRow() checking
  • Improved: Add language files for TinyMCE
  • Improved: HTML preview for large project (UI)
  • Updated: Chart.js, chartjs-plugin-annotation, chartjs-adapter-luxon, SweetAlert2, Popper and Luxon
  • Other minor improvements

New in PHPMaker 2022.9.0.0 (Jan 11, 2022)

  • Fixed: jQuery plugin .toJsDate() method
  • Fixed: Form object value property not always reset on re-validation
  • Fixed: Invalid feedback for native SELECT tag not reset in Safari
  • Fixed: Active sub-menu item in side menu not highlighted properly
  • Fixed: Report lookup field 'BETWEEN' operator
  • Fixed: Detail List page master record checking
  • Fixed: Chart drilldown for Crosstab reports
  • Fixed: addUserPermission() for new table
  • Fixed: File upload field drop zone width for mobile
  • Fixed: Confirm password field in Custom Template
  • Fixed: Allow View All for lookup fields
  • Fixed: Lookup permission checking for userIDAllow()
  • Fixed: Export to email in View page
  • Fixed: Export S3 images
  • Improved: Handle double byte characters better (PhpSpreadsheet)
  • Improved: Skip 2FA for registration if forced 2FA not enabled
  • Improved: Replace toast by alert on Add Option error
  • Improved: Add "select2" event before initializing Select2
  • Improved: Add CSS classes option for YouTube Custom View Tag
  • Improved: Update package versions in composer.json
  • Improved: Add option to show chart missing series values as zero
  • Improved: Pager in View/Edit pages
  • Updated: Chart.js, chartjs-plugin-annotation and date/time picker
  • Other minor improvements

New in PHPMaker 2022.8.0.0 (Dec 15, 2021)

  • Fixed: Error message HTML-encoded
  • Fixed: Image column width (PhpSpreadsheet)
  • Fixed: Card CSS class in Dashboard reports
  • Fixed: Check duplicate for primary key fields
  • Fixed: Fixed header table in Dashboard reports
  • Fixed: Field max length for numeric fields after sync (UI)
  • Improved: Check project name
  • Improved: Attributes of menu item
  • Improved: Format null as empty string
  • Improved: Skip 'SET DATEFORMAT ymd' (MSSQL)
  • Improved: Custom Template in Modal dialog
  • Improved: Error handling on generating barcode (PHPBarcode)
  • Improved: Allow rendering a field more than once in Custom Template
  • Improved: Column headings as "Date" with DateTime fields (Crosstab)
  • Improved: Allow changing grouping/decimal separators in locale settings
  • Improved: Add ExportFieldCaption property for DbField class
  • Updated: SweetAlert2, luxon, element-internals-polyfill.js, Chart.js and chartjs-plugin-annotation
  • Other minor improvements

New in PHPMaker 2022.7.0.0 (Dec 1, 2021)

  • Display lookup fields in reports and charts (X-axis)
  • Fixed: Search composer packages
  • Fixed: Select2 dropdown position in modal
  • Fixed: Connection to PostgreSQL with SSL
  • Fixed: Captcha in Login and Change Password pages
  • Fixed: ReCaptcha in modal Login page on reload
  • Fixed: Swagger UI for Add/Edit/Register
  • Fixed: Date/Time picker "change" event
  • Fixed: Concurrent user login error (non-modal)
  • Fixed: Invalid feedback not reset for Modal Lookup fields
  • Fixed: Empty string parsed as 0 by PHP 7.x
  • Improved: Handle custom element for Firefox >= 93
  • Improved: Ignore error on calling HtmlToText()
  • Improved: Add global upload options for jQuery File Upload
  • Improved: Remove "Save" button in CKEditor
  • Improved: Add decimal and grouping separators to locale settings
  • Improved: Change form CSS width to max-width
  • Updated: SweetAlert2, dompdf, Chart.js and chartjs-plugin-annotation
  • Other minor improvements

New in PHPMaker 2022.6.0.0 (Nov 15, 2021)

  • Allow setting locale numbering system to 'latn'
  • Add client side PAGE_ID for login and reset/change password pages
  • Fixed: Aggregates for multi-column table layout or preview field
  • Fixed: Button group in Grid page
  • Fixed: Init HTML editors for Custom Template in non-modal pages
  • Fixed: FixedHeaderTable extension generate-time error
  • Fixed: Audit trail for anonymous user
  • Fixed: Detail table in accordion
  • Fixed: Submit button of Custom Template for Extended Search
  • Fixed: Scroll to row after Inline-Edit
  • Fixed: Focus CKEditor dialog in modal pages
  • Improved: Date/Time picker (Edit date only)
  • Improved: Chart labels
  • Improved: CurrentUserEmail() and CurrentUserImageBase64()
  • Updated: SweetAlert2 and session middleware
  • Other minor improvements

New in PHPMaker 2022.5.0.0 (Nov 1, 2021)

  • Fixed: Preview field
  • Fixed: Searching in column filters
  • Fixed: Detect empty form
  • Fixed: Page_Redirecting server event
  • Fixed: Detail record count in multiple Master/Detail-View page
  • Fixed: Export to Excel (.xlsx format)
  • Fixed: Export reports to Word
  • Fixed: Dashboard report page title and breadcrumb
  • Fixed: Quick Search (A OR B) with "Auto" option
  • Fixed: Report with fields using TEXTAREA Edit Tag
  • Fixed: Dual Y charts
  • Fixed: Load database names with URL connection (UI)
  • Improved: Use psr/log if PHP < 8
  • Improved: Show message in Custom File
  • Improved: Submit modal login, password recovery and change password pages by pressing Enter key
  • Improved: Focus modal dialog on show
  • Improved: Handle empty timezone
  • Improved: Log PHPMailer debug messages
  • Updated: Chart.js v3.6.0
  • Other minor improvements

New in PHPMaker 2022.4.0.0 (Oct 18, 2021)

  • Fixed: User profile corrupted error in Multi-Language project
  • Fixed: Client side validation for boolean field
  • Fixed: Autofill boolean checkbox
  • Fixed: Search User ID fields
  • Fixed: Format report summary fields
  • Fixed: ChartScaleBeginWithZero for Line/Area charts
  • Fixed: Expand preview row on clicking row links/buttons (not in dropdown)
  • Fixed: Client side redirect() with port number
  • Fixed: Search filter field
  • Fixed: Hide detail items for dropdown (Preview extension)
  • Fixed: Export in Excel2007 format (PhpSpreadsheet extension)
  • Improved: Allow setting lookup cache by page IDs in Config
  • Improved: Update theme settings (UI)
  • Improved: Import without enabling PhpSpreadsheet extension
  • Improved: Built-in JavaScript plugins in AdminLTE
  • Updated: Bootstrap 5.1.3, SweetAlert2 and Date/Time picker
  • Other minor improvements

New in PHPMaker 2022.3.0.0 (Oct 4, 2021)

  • Fixed: Icon size
  • Fixed: CSS of hidden tabs
  • Fixed: CSS when search panel 'Field per row' = 1
  • Fixed: Check search operator 2
  • Fixed: JavaScript error of search panel buttons
  • Fixed: Warning message on import failure
  • Fixed: Preview extension - SingleRow option
  • Fixed: Custom field format pattern
  • Fixed: 'file' API action for encrypted file path
  • Fixed: Load user extensions (UI)
  • Fixed: control.xml not found (UI)
  • Improved: browser-based code editor (UI)
  • Improved: Preview HTML (UI)
  • Improved: Error handling for AutoFill
  • Improved: Change menu item name attribute to data-name
  • Improved: Add spacing between multiple uploaded files on List/View
  • Updated: SweetAlert2 and Date/Time picker
  • Other minor improvements

New in PHPMaker 2022.2 (Sep 15, 2021)

  • New browser-based code editor (requires WebView2 Runtime)
  • Fixed: Lookup request with mixed types
  • Fixed: CHECKBOX/RADIO selection lists problem in Firefox
  • Fixed: Invalid feedback for CHECKBOX/RADIO selection lists
  • Fixed: Master record User ID checking
  • Fixed: CKEditor dialogs in modal pages
  • Fixed: Chart data labels
  • Fixed: Email_Sending for Multi-Update/Delete
  • Improved: Ignore List page search criteria for modal View/Edit pages
  • Improved: Check lanuguage ID case-insensitively
  • Improved: Check numeric user values of lookup fields better
  • Improved: Reset Password and Register links in modal Login page
  • Improved: Error handling on copying CKEditor/TinyMCE from composer packages to project folder
  • Improved: Error handling on getting Chart advanced settings
  • Improved: Batch size for batch Ajax lookup
  • Updated: Bootstrap 5.1.1, SweetAlert2 and Date/Time picker
  • Other minor improvements

New in PHPMaker 2022.1 (Sep 1, 2021)

  • Fixed: Custom Template with comparison/logical operators
  • Fixed: Default values for (Extended) Quick Search
  • Fixed: Lookup with security disabled
  • Fixed: Multiple colorpickers in tabs
  • Fixed: Server/Client side validation for localized field values
  • Fixed: Custom currency symbol in locale settings
  • Fixed: Unsupported HTMLElement.attachInternals() in Firefox/Safari
  • Fixed: Auto-focus RADIO/CHECKBOX fields
  • Fixed: User image not showing
  • Fixed: Home page link when Start Page is function name
  • Fixed: Extended Search Option AND/OR/AUTO
  • Fixed: Date/Time picker enabled for fields with custom format
  • Fixed: Bootstrap/AdminLTE settings not initiated properly (UI)
  • Fixed: Language file version not checked properly (UI)
  • Improved: Allow all Windows users to use PHPMaker (UI)
  • Improved: HTML preview (UI)
  • Improved: Show locale settings in right-to-left for RTL lauguages (UI)
  • Improved: Create InnoDB tables if MySQL >= 5.6 (UI)
  • Improved: Allow fields with "TEXT" Edit Tag set as Modal Lookup
  • Improved: Search all display fields in Modal Lookup, Select2 and Filter
  • Improved: Add selectMinimumInputLength setting for Select2
  • Improved: Use SPAN tag for read-only lookup fields
  • Updated: SweetAlert2 and Date/Time picker
  • Other minor improvements

New in PHPMaker 2022.0.0 (Aug 16, 2021)

  • Auto locale settings by native PHP Intl extension and JavaScript Intl object
  • Format and parse by ICU number, currency and date/time formats
  • Option to allow anonymous users to receive notifications
  • Generate server public/private keys
  • Users can enable/disable notifications
  • Administrators can send notifications to selected or all subscribers
  • Opt in/out or forced 2FA
  • Backup codes
  • Administrators can reset user secret
  • Multi-column cards by Bootstrap Cards
  • Responsive multi-column layout
  • Improved list options button and 4 positions (top/bottom-left/right)
  • Switchable between regular table view and cards view by Ajax
  • Support Custom Template in both views
  • Support Bootstrap card-* classes
  • New Accordion component
  • New Offcanvas component
  • New File input
  • Remove support for IE 11 and other older browsers, see Browsers and devices
  • RTL
  • With chartjs-adapter-luxon, chartjs-plugin-annotation and chartjs-plugin-datalabels
  • Support formatting by locale
  • Option to show percentage in Pie/Doughnut charts
  • 19 theme colors with Bootstrap 5 and AdminLTE 3
  • User image and user name in sidebar
  • Sidebar search (for searching menu items)
  • Navbar search (as Quick Search input for tables)
  • Excel filter style
  • Work together with other fields in Extended Search
  • Searchable
  • Pagination (Infinite Scrolling)
  • Dropdown positioning by Popper
  • Pagination (Infinite Scrolling)
  • Lookup cache aware
  • Draggable
  • Search npm packages from npmjs.com within UI
  • Generate package.json for project
  • Run npm install after generation
  • Easy update by npm update
  • No more write permission issues
  • Use semantic versioning
  • Developers can publish their templates/extensions to npm registry by npm publish for sharing
  • Support showing README.md written in Markdown
  • Generate route groups - Allow disabling for better performance
  • Use route cache for production - Allow compiling route cache for better performance
  • Lookup page size - Page size for infinite scrolling during Modal lookup
  • Filter page size - Page size for infinite scrolling in table header filter
  • Navbar Quick Search
  • Use native SELECT tag for select-one fields
  • Use drop zone for file upload fields
  • Multi-column List page grid CSS class
  • Multi-column List page card CSS class
  • Multi-column List page card left column CSS class
  • Show percentage in Pie/Doughnut charts

New in PHPMaker 2021.0.15.0 (Jul 5, 2021)

  • Avoid conflicts with Office 365 v2106
  • Fixed: Custom template in modal dialog
  • Fixed: Page_Selecting for crosstab report
  • Fixed: Parent fields in detail grid
  • Fixed: Uploaded file in upload template not removed properly if not multiple
  • Improved: Error handling of charts with empty data
  • Improved: Error handling when custom template not found
  • Improved: Domain and path settings for cookies
  • Improved: Client side showMessage() function
  • Other minor improvements

New in PHPMaker 2021.0.14.0 (May 31, 2021)

  • Fixed: Lookup fields (RADIO/CHECKBOX) without dropdown
  • Fixed: Lookup fields in reports
  • Fixed: Problem with lookup value = 0
  • Fixed: fileDownload() for sweetalert2
  • Fixed: Warnings for thumbnail default width/height
  • Fixed: Client side SSN validation
  • Fixed: RowType property after calling renderViewRow()
  • Fixed: Encoding for loadHTML() when exporting reports
  • Fixed: loadUserID() method of AdvancedSecurity class
  • Fixed: Preview with security disabled
  • Updated: sweetalert2 v10.16.9
  • Updated: sweetalert2-themes (Bootstrap 4) v4.0.5
  • Other minor improvements

New in PHPMaker 2021.0.13.0 (Apr 26, 2021)

  • Improved: Sync field max. length if field size changed (UI)
  • Improved: Avoid false positive by Windows Defender (UI)
  • Improved: Show progress when downloading template or new version (UI)
  • Improved: Replace CR+LF by <br> for memo fields
  • Improved: ScriptName(), SendEmail() and Email class
  • Improved: Use user ID for Audit Trail in Login/Logout pages
  • Fixed: Navbar bottom border
  • Fixed: Sidebar for all Navbar menu items
  • Fixed: Option Template for Select2
  • Fixed: Dynamic Selection List for 2nd search field in summary/crosstab reports
  • Fixed: 'BETWEEN' operator for report dropdown filter
  • Updated: TCPDF 6.4.1
  • Other minor improvements

New in PHPMaker 2021.0.12.0 (Apr 6, 2021)

  • Improved: Set language phrase for client side
  • Improved: Add Options property for DbField class
  • Improved: Trigger "change" event for input element (Date/Time Picker extension)
  • Fixed: Export in iframe
  • Fixed: Generate Custom Template for selected fields
  • Fixed: Format short time in Edit page
  • Fixed: Form action
  • Fixed: Permission for Preview page
  • Fixed: Readonly file input
  • Fixed: Preview PDF file for BLOB field
  • Fixed: Set up current table if security disabled
  • Fixed: Modal dialog submitted twice
  • Fixed: BLOB field in Master page (PostgreSQL)
  • Updated: AdminLTE 3.1.0 (including Select2 4.0.13 and sweetalert2 v10.15.6)
  • Other minor improvements

New in PHPMaker 2021.0.11.0 (Mar 15, 2021)

  • Add package.json for node modules
  • Improved: Use try/catch for insert/update()
  • Improved: CurrentPageUrl() for routes with arguments
  • Improved: Width of search field without second field input
  • Improved: PHPWord and PhpSpreadsheet extensions (for registered users)
  • Improved: Error handling in FixedHeaderTable extension (for registered users)
  • Fixed: Time picker
  • Fixed: Export to PDF
  • Fixed: "Requires search" for SELECT tag in Extended Search
  • Fixed: Escaping random key
  • Updated: jQuery 3.6.0
  • Other minor improvements

New in PHPMaker 2021.0.10.0 (Feb 22, 2021)

  • New advanced setting: "Check new version on start"
  • Improved: Check new version, download and install (UI)
  • Improved: Skip compiling .scss if error occurred (UI)
  • Improved: Check if PHP 7.3 for compatible Composer packages
  • Improved: Error handling for compressing .js file
  • Improved: Error handling of missing User ID field
  • Improved: Do not use @import in .scss for datetime picker
  • Improved: SQL expression for concatenating fields (MSSQL)
  • Improved: Check HTTPS if advanced setting "Cookie Secure" enabled
  • Improved: Show error message on backup failure
  • Fixed: Disable submit button during form submission
  • Fixed: Crosstab report with drilldown
  • Fixed: SELECT Edit Tag with parent field and "requires search" enabled
  • Fixed: PHP warnings when using Dynamic User Level Security
  • Fixed: Breadcrumb for Delete page of detail table
  • Fixed: Can not clear an advanced setting (UI)
  • Fixed: Check User ID field for user table (UI)
  • Fixed: Search multiple value for numeric fields in reports
  • Fixed: Page size selector for reports
  • Fixed: Multi-language field custom message
  • Fixed: Lookup field with parent table in non-Master/Detail pages
  • Updated: Time picker, JsRender, and PDFObject
  • Other minor improvements

New in PHPMaker 2021.0.9 (Jan 25, 2021)

  • Improved: Check PHP 8
  • Improved: Default page for anonymous user
  • Improved: Show stack trace in Error page
  • Improved: Error handling for no permissions after login
  • Improved: Error handling when loading chart parameters
  • Improved: Use @set_time_limit()
  • Improved: Add Config("SAVE_FILE_OPTIONS") for saving file by file_put_contents()
  • Improved: Handle non-Latin alphabets (e.g. Greek) in table/field names
  • Improved: Highlight menu item with custom URL and base path
  • Fixed: GetConnectionId()
  • Fixed: IsSysAdmin() for API
  • Fixed: Printer friendly version
  • Fixed: Custom action by postback
  • Fixed: Master record checking in Add page
  • Fixed: minimumResultsForSearch for Select2
  • Fixed: File API action with User Level Security disabled
  • Fixed: Export to CSV/Excel/Word without extension
  • Fixed: href for "Delete" button (Preview extension)
  • Fixed: Error with IsAdmin() (FileManager extension)
  • Fixed: Repeat code for all fields in Custom Template editor (UI)
  • Updated: Bootstrap 4.6.0, JsRender 1.0.10, and dompdf 1.0.2
  • Other minor improvements

New in PHPMaker 2021.0.8 (Jan 5, 2021)

  • Use Node.js 14
  • Improved: Support HTTPS for URL connection
  • Improved: Server events for Custom Files
  • Improved: Route parameters [/{params:.*}] for Custom Files
  • Improved: Throw error if Custom File content is empty
  • Improved: Go to first page with permission after login
  • Improved: Allow $info["driver"] in Database_Connecting server event
  • Improved: Skip set_time_limit() if EXPORT_ALL_TIME_LIMIT < 0
  • Improved: Sorting in Preview page
  • Improved: Check table name better to avoid conflicts in class names
  • Improved: Make sure menu template ready before rendering
  • Improved: Use __DIR__ in config.php to avoid some path issues
  • Improved: Log email error in SendEmail()
  • Improved: Add client side "beforesubmit" event for forms
  • Fixed: Logging in Lookup class
  • Fixed: CSS for exporting report to PDF
  • Fixed: Order By reset when getting record count
  • Fixed: Server side custom validation using addErrorMessage()
  • Fixed: Wrong syntax for accessing some field objects
  • Fixed: Client side field properties for modal dialog
  • Updated: Overlay Scrollbars
  • Other minor improvements

New in PHPMaker 2021.0.7 (Dec 14, 2020)

  • Improved: Support function name as Start Page
  • Improved: Support returning JSON response in server events
  • Improved: Check empty foreign key value by '===' operator
  • Improved: Add Swagger path for login by URL
  • Improved: Security for upload and permissions actions (API)
  • Improved: Avoid loading Login or List page in modal dialog
  • Improved: Always backup/restore search filters in user profile
  • Fixed: QueryBuilder()
  • Fixed: Route(0) returns wrong value
  • Fixed: Swagger for sites without base path
  • Fixed: "Required" validation for invisible fields
  • Fixed: Empty row checking in Grid-Add
  • Fixed: Get/Set session variable value by Session() in Global Code
  • Fixed: Anonymous user set as logged in
  • Updated: JsRender v1.0.9
  • Other minor improvements

New in PHPMaker 2021.0.5 (Nov 16, 2020)

  • New advanced setting "Treat PHP warnings and notices as errors" for debugging
  • Improved: Sanitize URL in JavaScript
  • Improved: HTML-encode href attributes
  • Improved: Exception in class LdapConn
  • Improved: Check parent table of lookup fields
  • Improved: Create object with Container() by class name
  • Improved: Use table default sorting fields in preview page
  • Improved: Output Custom Template data for visible fields only
  • Improved: Not use global upload path for API CompiledContainer.php
  • Improved: Allow calling terminate() method of page object in Views
  • Fixed: AutoFill JavaScript error
  • Fixed: Log error with Debug enabled
  • Fixed: Lookup without security enabled
  • Fixed: PHP notices in Dashboard reports
  • Fixed: Lookup table with User ID Security
  • Fixed: Error message of invalid master key
  • Fixed: fetchAll() error in Multi-Update page
  • Fixed: Custom Template for master record page
  • Fixed: Detail key field as parent lookup field in Master/Detail-Edit
  • Fixed: Wrongly define class names for Custom File without "Include common files"
  • Fixed: JsRender source map
  • Other minor improvements

New in PHPMaker 2021.0.4 (Nov 2, 2020)

  • Improved: Detect image format
  • Improved: Sanitize search filter name
  • Improved: Check lookup permission in API permission middleware
  • Improved: Make sure allowed file types specified in lowercase
  • Fixed: Checkbox id
  • Fixed: "datetime" validator
  • Fixed: Export Master/Detail data
  • Fixed: DbChart constructor
  • Fixed: FileViewer with encrypted file path enabled
  • Fixed: Polyfill for Array.from (for IE only)
  • Fixed: Custom File (for .php without "Include common files")
  • Updated: JsRender v1.0.8
  • Updated: Composer-Setup.exe
  • Other minor improvements

New in PHPMaker 2021.0.3 (Oct 19, 2020)

  • Routing:
  • PHPMaker 2021 generated applications now use Slim Framework. Slim is a PHP micro framework that helps you quickly write simple yet powerful web applications and APIs. Web servers should be configured to sends all appropriate requests to one "front-controller" PHP file, the index.php, in which the Slim app is instantiated. The Slim app contains routes that respond to specific HTTP requests. Each page in previous versons (e.g. /carsview.php?ID=1) is now a route (e.g. /carsview/1 or /cars/view/1). Each route invokes a callback and must return PSR-7 Response object. With Slim app you can use not only routing but also other advanced features such as middleware and dependency container.
  • Enhanced Validation:
  • Validate all fields before submit
  • Show invalid feedback below the fields
  • Focus the first invalid field
  • Work with server side validation
  • Field Input Help Text (Custom Message):
  • Set up in Edit Tag panel (support Multi-Language), or
  • Set up by server event as CustomMsg property of field objects
  • Enhanced Charts:
  • Up to 4 trend lines
  • chartjs-plugin-annotation.js
  • chartjs-plugin-datalabels
  • Sharing Project with Other Users:
  • Support GitHub (with encryption of GitHub URL, username and password)
  • Git Fetch/Pull/Push/Sync
  • Auto fetch
  • Show changes in status bar
  • Commit changes with message
  • Improved Custom Template:
  • Faster rendering of Custom Template
  • Code Repository supports scripting for fast and complex Custom Template generation
  • mproved Select Tag:
  • Replace HTML Select Element by Select2
  • Bootstrap 4 theme for Select2
  • Tagging with multiple selection
  • Option to require search
  • Search box for large result sets
  • Improved Toasts:
  • AdminLTE Toasts Plugin (activated as a jQuery plugin) with different options and events.
  • Improved Alerts:
  • Replace Bootstrap Modal alerts by SweetAlert2
  • Bootstrap 4 theme for SweetAlert2
  • Alert for export
  • Alert for session timout
  • New Advanced Settings:
  • Log SQL to file
  • Log error to file
  • Environment
  • Generate production config file
  • Compile container for production
  • Add novalidate attribute to form
  • Connection info of production server (JSON)
  • MySQL driver - mysqli or pdo_mysql
  • Sort option - Toggle or Tristate
  • Invalid user name characters
  • Invalid password characters
  • Use Bootstrap switch for boolean fields
  • API custom headers (for Apache/IIS)
  • Git repo URL
  • Git user name
  • Git password
  • Git auto fetch
  • Git auto fetch period (seconds)
  • Prompt for Git commit message
  • New Server Events:
  • Route_Action - For adding user defined routes
  • Api_Action - For adding user defined API actions
  • Container_Build - For adding user defined services
  • More:
  • Require PHP >= 7.2
  • PSR-12 coding standard
  • Load classes by PSR-4
  • Replace ADOdb by DBAL and PDO (Remove support for MS Access)
  • Logger for logging SQL and errors
  • Error handler and error page
  • Development/Production environment (for database connection info, SMTP and JWT settings)
  • User Level Security supports multiple user levels for each user
  • Save locale settings in project
  • New URL connection script to simulate direct connection
  • Handle SQLite INTEGER field with CHECKBOX Edit Tag as boolean field
  • Fixed header table extension supports user permission setup page
  • CAPTCHA extensions supports two CAPTCHAs (one in page, the other in modal dialog)
  • Allow user defined string functions for selecting in View Tag
  • Support accept and capture attributes for file upload fields
  • Clear sorting in List pages by Shift-Clicking table column header
  • Save state of AdminLTE Sidebar
  • Show version in project history
  • Searchbox for table (Database pane)
  • Searchbox for output files (Generate form)
  • Allow unloading loaded table (for "Load tables dynamically")
  • JavaScript compressor with ES6+ support
  • Moment, jQuery File Upload, TimePicker, dompdf, CKEditor and tinyMCE updated
  • Many other minor improvements

New in PHPMaker 2021.0.2 (Oct 5, 2020)

  • Enhanced Validation:
  • Validate all fields before submit
  • Show invalid feedback below the fields
  • Focus the first invalid field
  • Work with server side validation
  • Field Input Help Text (Custom Message):
  • Set up in Edit Tag panel (support Multi-Language), or
  • Set up by server event as CustomMsg property of field objects
  • Enhanced Charts:
  • Up to 4 trend lines
  • chartjs-plugin-annotation.js
  • chartjs-plugin-datalabels
  • Sharing Project with Other Users:
  • Support GitHub (with encryption of GitHub URL, username and password)
  • Git Fetch/Pull/Push/Sync
  • Auto fetch
  • Show changes in status bar
  • Commit changes with message
  • Improved Custom Template:
  • Faster rendering of Custom Template
  • Code Repository supports scripting for fast and complex Custom Template generation
  • Improved Select Tag:
  • Replace HTML Select Element by Select2
  • Bootstrap 4 theme for Select2
  • Tagging with multiple selection
  • Improved Alerts:
  • Replace Bootstrap Modal alerts by SweetAlert2
  • Bootstrap 4 theme for SweetAlert2
  • Alert for export
  • New Advanced Settings:
  • Log SQL to file
  • Log error to file
  • Environment
  • Generate production config file
  • Compile container for production
  • Add novalidate attribute to form
  • Connection info of production server (JSON)
  • MySQL driver - mysqli or pdo_mysql
  • Sort option - Toggle or Tristate
  • Invalid user name characters
  • Invalid password characters
  • Use Bootstrap switch for boolean fields
  • API custom headers (for Apache/IIS)
  • Git repo URL
  • Git user name
  • Git password
  • Git auto fetch
  • Git auto fetch period (seconds)
  • Prompt for Git commit message
  • New Server Events:
  • Route_Action - For adding user defined routes
  • Api_Action - For adding user defined API actions
  • Container_Build - For adding user defined services
  • More:
  • Require PHP >= 7.2
  • PSR-12 coding standard
  • Load classes by PSR-4
  • Replace ADOdb by DBAL and PDO (Remove support for MS Access)
  • Logger for logging SQL and errors
  • Error handler and error page
  • Development/Production environment (for database connection info, SMTP and JWT settings)
  • User Level Security supports multiple user levels for each user
  • Save locale settings in project
  • New URL connection script to simulate direct connection
  • Handle SQLite INTEGER field with CHECKBOX Edit Tag as boolean field
  • Fixed header table extension supports user permission setup page
  • CAPTCHA extensions supports two CAPTCHAs (one in page, the other in modal dialog)
  • Allow user defined string functions for selecting in View Tag
  • Support accept and capture attributes for file upload fields
  • Clear sorting in List pages by Shift-Clicking table column header
  • Save state of AdminLTE Sidebar
  • Show version in project history
  • Searchbox for table (Database pane)
  • Searchbox for output files (Generate form)
  • Allow unloading loaded table (for "Load tables dynamically")
  • JavaScript compressor with ES6+ support
  • Moment, jQuery File Upload, TimePicker, dompdf, CKEditor and tinyMCE updated
  • Many other minor improvements

New in PHPMaker 2021.0.1 (Sep 21, 2020)

  • Improved: DomainUrl() for HTTPS without port number in server variables
  • Improved: Show page number as disabled in pager for modal page (Preview)
  • Improved: Add "RewriteBase directive" advanced setting for .htaccess
  • Improved: Handle UNC path as project folder when compiling .scss
  • Improved: Check upload path for compiling container definitions
  • Improved: Throw error if PhpEncrypt() failed
  • Improved: Handle numbers in lookup field display value
  • Improved: Return unauthorized for invalid token for API
  • Fixed: Concatenate string in SQL according to database type
  • Fixed: Tables with name starting with digit
  • Fixed: "updatedone" event
  • Fixed: Update encrypted password
  • Fixed: BasePath() for sites without base path
  • Fixed: Save current filter
  • Fixed: "for" attribute for checkbox
  • Fixed: Duplicate namespace for Custom File
  • Fixed: Write audit trail to database
  • Fixed: Default sort order
  • Fixed: Encrypt user name and password
  • Fixed: Routes with "Lowercase output file name" disabled
  • Fixed: Execute scripts in templates (in code repo) for Custom Template
  • Fixed: Custom Template for Multi-Page
  • Fixed: Render upload files if insert/update cancelled
  • Fixed: Output languages to JSON
  • Many other minor improvements

New in PHPMaker 2021.0.0 (Sep 7, 2020)

  • PHPMaker 2021 is another huge upgrade from previous version. 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.
  • Routing:
  • PHPMaker 2021 generated applications now use Slim Framework. Slim is a PHP micro framework that helps you quickly write simple yet powerful web applications and APIs. Web servers should be configured to sends all appropriate requests to one "front-controller" PHP file, the index.php, in which the Slim app is instantiated. The Slim app contains routes that respond to specific HTTP requests. Each page in previous versons (e.g. /carsview.php?ID=1) is now a route (e.g. /carsview/1 or /cars/view/1). Each route invokes a callback and must return PSR-7 Response object. With Slim app you can use not only routing but also other advanced features such as middleware and dependency container.
  • Enhanced Validation:
  • Validate all fields before submit
  • Show invalid feedback below the fields
  • Focus the first invalid field
  • Work with server side validation
  • Field Input Help Text (Custom Message):
  • Set up in Edit Tag panel (support Multi-Language), or
  • Set up by server event as CustomMsg property of field objects
  • Enhanced Charts:
  • Up to 4 trend lines
  • chartjs-plugin-annotation.js
  • chartjs-plugin-datalabels
  • Encrypted Connection with MySQL/PostgreSQL:
  • Sharing Project with Other Users:
  • Support GitHub (with encryption of GitHub URL, username and password)
  • Git Fetch/Pull/Push/Sync
  • Auto fetch
  • Show changes in status bar
  • Commit changes with message
  • Improved Custom Template:
  • Faster rendering of Custom Template
  • Code Repository supports scripting for fast and complex Custom Template generation
  • Improved Select Tag:
  • Replace HTML Select Element by Select2
  • Bootstrap 4 theme for Select2
  • Tagging with multiple selection
  • Improved Dropdown for Radio/Checkbox Tag:
  • Improved Toasts:
  • AdminLTE Toasts Plugin (activated as a jQuery plugin) with different options and events.
  • Improved Alerts:
  • Replace Bootstrap Modal alerts by SweetAlert2
  • Bootstrap 4 theme for SweetAlert2
  • Alert for export
  • Alert for session timout
  • New Advanced Settings:
  • Log SQL to file
  • Log error to file
  • Environment
  • Generate production config file
  • Compile container for production
  • Add novalidate attribute to form
  • Connection info of production server (JSON)
  • MySQL driver - mysqli or pdo_mysql
  • Sort option - Toggle or Tristate
  • Invalid user name characters
  • Invalid password characters
  • Use Bootstrap switch for boolean fields
  • API custom headers (for Apache/IIS)
  • Git repo URL
  • Git user name
  • Git password
  • Git auto fetch
  • Git auto fetch period (seconds)
  • Prompt for Git commit message
  • New Server Events:
  • Route_Action - For adding user defined routes
  • Api_Action - For adding user defined API actions
  • Container_Build - For adding user defined services
  • More:
  • Require PHP >= 7.2
  • PSR-12 coding standard
  • Load classes by PSR-4
  • Replace ADOdb by DBAL and PDO (Remove support for MS Access)
  • Logger for logging SQL and errors
  • Error handler and error page
  • Development/Production environment (for database connection info, SMTP and JWT settings)
  • User Level Security supports multiple user levels for each user
  • Save locale settings in project
  • New URL connection script to simulate direct connection
  • Handle SQLite INTEGER field with CHECKBOX Edit Tag as boolean field
  • Fixed header table extension supports user permission setup page
  • CAPTCHA extensions supports two CAPTCHAs (one in page, the other in modal dialog)
  • Allow user defined string functions for selecting in View Tag
  • Support accept and capture attributes for file upload fields
  • Clear sorting in List pages by Shift-Clicking table column header
  • Save state of AdminLTE Sidebar
  • Show version in project history
  • Searchbox for table (Database pane)
  • Searchbox for output files (Generate form)
  • Allow unloading loaded table (for "Load tables dynamically")
  • JavaScript compressor with ES6+ support
  • Moment, jQuery File Upload, TimePicker, dompdf, CKEditor and tinyMCE updated
  • Many other minor improvements

New in PHPMaker 2020.0.16 (Jun 1, 2020)

  • Improved: Handle zero values for master keys
  • Improved: Add Lookup permission for "Allow View All" (User ID Security)
  • Improved: Handle autoincrement user level ID field
  • Improved: Secruity for "permission" action (REST API)
  • Improved: Handle invalid JWT token (REST API)
  • Fixed: Registration if user already exists (REST API)
  • Fixed: Security for Anonymous Access (REST API)
  • Fixed: Default extensions not enabled for new project
  • Fixed: Captcha in change password page
  • Updated: jQuery v3.5.1
  • Updated: Bootstrap v4.5.0
  • Updated: AdminLTE v3.0.5
  • Many other minor improvements

New in PHPMaker 2020.0.15 (May 11, 2020)

  • New Advanced Settings:
  • Use Bootstrap Toast message
  • Use Bootstrap responsive tables
  • Responsive table class
  • AdminLTE layout class
  • Use Font Awesome v4 shims
  • Embed PDF documents
  • Use URL rewrite
  • Use JsViews
  • Web root relative path
  • For report or chart:
  • Show current filters
  • Show blank series for chart
  • Show zero values in stacked chart
  • Use popup panel for drill down
  • Show drill down filters
  • Chart column CSS class (left or right)
  • Chart column CSS class (left and right)
  • Chart color palette
  • New Server Events for Report or Chart
  • Chart_Rendered
  • Page_FilterLoad
  • Page_FilterValidated
  • Page_Filtering
  • Page_Breaking
  • Cell_Rendered
  • More:
  • Requires PHP >= 5.6
  • Import reports from PHP Report Maker project to PHPMaker project
  • Bootstrap 4 and AdminLTE 3 updated
  • Overlay Scrollbars extension (for adding scrollbars to pages with content wider than screen)
  • "Lookup" permission for lookup tables
  • Allow editing non-autoincrement primary keys
  • Always reset password on password recovery for better security
  • Encrypt SMTP server username and password
  • Skip encrypted password field on removing XSS (allow characters like "&")
  • Allow disabling Remove XSS for some fields by server event
  • Sanitize internal redirect URL (e.g. changing language ID)
  • Allow overriding Custom Template by overriding helper function getTemplate()
  • Simplified template and extensions
  • Global Config() function to get/set configuration easily
  • Support MySQL and PostgreSQL BIT data type (requires PHP >= 7.1.11)
  • Support MySQL and PostgreSQL JSON data type as string type
  • Generate .htaccess and web.config for URL Rewrite (REST API)
  • Allow editing/copying default permissions of User Levels (PHPMaker UI)
  • Use global 64-bit Node.js automatically if available (PHPMaker UI)
  • FileManager extension updated (using Rich Filemanager, for registered user only)
  • JsRender, Moment, jQuery File Upload, TimePicker, dompdf, CKEditor and tinyMCE updated
  • Many other minor improvements

New in PHPMaker 2020.0.14 (Apr 6, 2020)

  • Support connection to Azure Database for MySQL
  • ScrollbarMode advanced setting (UI)
  • Advanced settings for cookie
  • Improved: Set up lookup setting for Date Interval
  • Improved: Skip updating selection lists in Confirm page
  • Improved: HTML-encode foreign key hidden values
  • Improved: Consent page cookie expiry time
  • Fixed: Save current filters for report (Server side)
  • Fixed: Date/Time picker
  • Fixed: REST API with security disabled
  • Fixed: REST API file access without User Level security
  • Fixed: Custom field setting on copying field settings
  • Fixed: YouTubeVideos Custom View Tag
  • Fixed: Siderbar for top navigation
  • Updated: ADOdb v5.20.17
  • Updated: AdminLTE v3.0.4
  • Updated: OverlayScrollars 1.12.0
  • Many other minor improvements

New in PHPMaker 2020.0.13 (Mar 24, 2020)

  • Improved: Add DOWNLOAD_PDF_FILE configuration setting
  • Improved: UnFormatDateTime() supports format in "hh:mm AM/PM"
  • Improved: Import records to table without primary key
  • Improved: Add Option dialog with textarea
  • Improved: Set textarea (with HTML editor) value by .value() of .fields() jQuery plugin
  • Improved: Hide tooltip when datetime/time picker shows
  • Improved: REST API login action returns more info
  • Improved: REST API edit action for editing primary key
  • Fixed: ADOdb MSSQL driver
  • Fixed: View file if security not enabled
  • Fixed: Checkbox id for boolean fields in Modal dialog
  • Fixed: Error on copying file during generation
  • Fixed: Check duplicate (for Oracle)
  • Fixed: Color palette setup form for charts (UI)
  • Many other minor improvements

New in PHPMaker 2020.0.12 (Mar 3, 2020)

  • Improved: Allow manual input of database name and schema for PostgreSQL (UI)
  • Improved: Page number selector width
  • Improved: Error handling of invalid Custom Field expression
  • Improved: Handle incorrect upload settings
  • Improved: Handle empty field format type for highlighting search result
  • Improved: insertSql() method
  • Improved: JSON encode for data in Custom Template
  • Fixed: Missing header in export to CSV (View page)
  • Fixed: Export numeric lookup field (PhpSpreadsheet)
  • Fixed: API user level security
  • Updated: UploadHandler.php
  • Updated: OverlayScrollars 1.11.0
  • Updated: JsRender 1.0.6
  • Many other minor improvements

New in PHPMaker 2020.0.11.0 (Feb 5, 2020)

  • Improved: Skip lookup for readonly fields
  • Fixed: API for multiple file upload
  • Fixed: Connection with PostgreSQL 12 (UI)
  • Fixed: Google maps for report with groups
  • Fixed: Inline-Add lookup for multi column List page
  • Fixed: Row_Import server event
  • Fixed: Export aggregate (PhpSpreadsheet extension)
  • Updated: OverlayScrollars 1.10.3
  • Many other minor improvements

New in PHPMaker 2020.0.10.0 (Jan 21, 2020)

  • Improved: Skip render own lookup
  • Improved: Check "pageno" before "start" for pager
  • Fixed: Lookup display fields in same table
  • Fixed: API with Windows Authentication
  • Fixed: Master/Detail key with Auto-Update Value
  • Fixed: Custom full URL protocols
  • Fixed: Google maps for reports
  • Fixed: Boolean lookup for reports
  • Fixed: Cannot delete report (UI)
  • Fixed: Font error in Firefox
  • Updated: AdminLTE 3.0.2
  • Many other minor improvements

New in PHPMaker 2020.0.9.0 (Jan 7, 2020)

  • Improved: Use encryption key as random key if set
  • Improved: Use TransactionIsolation = SQLSRV_TXN_READ_UNCOMMITTED (MSSQL)
  • Improved: Encrypt session ID in encrypted file path
  • Improved: Handle Custom Field that is a SELECT statement
  • Fixed: Cell_Rendered server event for reports
  • Fixed: function submitAction()
  • Fixed: Export to PDF with Barcode
  • Fixed: Date/Time picker and lookup field text input width (for Bootstrap 4.4)
  • Fixed: Search panel toggle button (for Bootstrap 4.4)
  • Fixed: Reports not shown for Static User Level Security
  • Updated: OverlayScrollars 1.10.2
  • Many other minor improvements

New in PHPMaker 2020.0.8.0 (Dec 10, 2019)

  • IMPORTANT NOTES:
  • Please make sure you read the following before you try the new version:
  • Requires Composer (https://getcomposer.org/download/), make sure you install it first.
  • Requires PHP >= 5.6
  • Read "Migrating to v2020" first: https://phpmaker.dev/doc/migrate2020.htm

New in PHPMaker 2020.0.7.0 (Nov 25, 2019)

  • Requires Composer (https://getcomposer.org/download/), make sure you install it first.
  • Requires PHP >= 5.6
  • Read "Migrating to v2020" first: https://phpmaker.dev/doc/migrate2020.htm

New in PHPMaker 2020.0.6.0 (Nov 4, 2019)

  • Add advanced setting "List page minimum table height (px)"
  • Add FormData polyfill (for IE)
  • Improved: Show Extended Filter for charts if not showing report
  • Improved: CSS styles for User Level Permissions page
  • Improved: Skip "No record found" message for Grid page
  • Fixed: Lazy loading images for modal View page
  • Fixed: Use input with type="text" for TEXTAREA in Confirm page
  • Fixed: Error with Detail grid
  • Fixed: Personal Data page
  • Fixed: Master/Detail-Add/Edit with Confirm page
  • Fixed: "dropdown-toggle" class for delete filter button
  • Fixed: Span tag ID for search value 2
  • Fixed: Default value for date filter
  • Fixed: Column field of date type (Crosstab report)
  • Fixed: Import/Lookup permissions
  • Fixed: File upload with special characters in file name
  • Fixed: Lookup ORDER BY for grouping field
  • Fixed: Brand image CSS style
  • Fixed: Error when changing some settings in "Tables" grid (UI)
  • Updated: AdminLTE 3.0.0 and Chart.js
  • Many other minor improvements

New in PHPMaker 2020.0.3 (Sep 16, 2019)

  • Add server events to index page
  • Allow no grouping fields for summary report
  • Fixed: Include shared file in extension
  • Fixed: Sort direction icon in userpriv.php
  • Fixed: Preview extension with Firefox
  • Fixed: Warnings for cancelAnimationFrame and requestAnimationFrame in Chrome
  • Fixed: Table name field size in user level permission table
  • Fixed: DateTime picker for date formats without seconds
  • Fixed: File upload handler not returning MIME type for PDF files
  • Updated: AdminLTE 3.0.0-rc.1
  • Updated: DateTime picker (Tempus Dominus v5.1.2)
  • Many other minor improvements

New in PHPMaker 2020.0.2 (Sep 3, 2019)

  • Change cookie consent to Toast
  • Right click and repeat selected code for all fields in Custom Template Editor
  • Add GetLinkHtml() method to class ListOption
  • Fixed: Lookup fields in registration page
  • Fixed: Upload icon for file upload input group
  • Fixed: Default language cannot be set
  • Fixed: Replace CR+LF by <BR>
  • Fixed: Master record page hyperlinks
  • Fixed: Default decimal precision for lookup fields
  • Fixed: Confirm password Custom Template in registration page
  • Fixed: Lookup field with Advanced Search enabled but Extended Search disabled
  • Fixed: SendEmail() for plain text email
  • Fixed: Set field properties for multiple fields (UI)
  • Fixed: Upload and barcode with S3
  • Fixed: Support for IE 11
  • Updated: CurrentUserIP()
  • Updated: Use fa-ellipsis-v for list action button
  • Updated: Sample code for Custom Template in code repository
  • Many other minor improvements

New in PHPMaker 2020.0.1 (Aug 19, 2019)

  • Allow update template in trial version
  • Move forgot password and register links in login page
  • Improved: Detect Azure SQL Server for optimizing SELECT statement
  • Improved: Add error handling for CurrentPageID()
  • Fixed: Class names for Font Awesome Free
  • Fixed: Upload field input group icon
  • Fixed: Some code of extensions not generated
  • Fixed: Alignment for crosstab summary field
  • Fixed: Hidden primary key fields (if not selected for the page)
  • Fixed: Maximum call stack size exceeded error during generation
  • Fixed: Security for Custom File with Static User Levels
  • Fixed: Custom File content with special characters
  • Fixed: Search operator LIKE, NOT LIKE, STARTS WITH and ENDS WITH
  • Fixed: Multi-Select Lookup field SQL for LIKE and other operators
  • Fixed: AutoSuggest not closed after blur
  • Fixed: Custom Template not rendered properly
  • Fixed: OtherOptions in List page not rendered properly
  • Fixed: Class ExportEmail for View page
  • Fixed: Lookup field with lookup table filter
  • Fixed: Lookup_Selecting server event
  • Fixed: Hyperlink prefix/suffix
  • Fixed: Function HtmlToText()
  • Fixed: et.json
  • Replace ScrollingTable extension by FixedHeaderTable extension (for registered users)
  • Many other minor improvements

New in PHPMaker 2020.0.0.0 (Aug 19, 2019)

  • Summary report at different levels:
  • Grouping level summary
  • Page Summary
  • Grand Summary
  • JavaScript Charts by Chart.js:
  • Column 2D Chart
  • Bar 2D Chart
  • Pie 2D Chart
  • Line 2D Chart
  • Area 2D Chart
  • Doughnut 2D Chart
  • Multi-series Column 2D Chart
  • Multi-series Line 2D Chart
  • Multi-series Area 2D Chart
  • Multi-series Bar 2D Chart
  • Stacked Column 2D Chart
  • Stacked Area 2D Chart
  • Stacked Bar 2D Chart
  • Multi-series 2D Single Y Combination Chart (Column/Line/Area)
  • Stacked Column 2D + Line Single Y Axis Chart
  • Multi-series 2D Dual Y Combination Chart (Column/Line/Area)
  • View PDF:
  • IMAGE View Tag supports viewing PDF document
  • Show/Hide password:
  • Supports password fields in user table pages, login, registration, change password pages.
  • Fixed Header Table Extension (for registered users):
  • Supports overlay scrollbars.
  • New Advanced Settings:
  • Use Bootstrap Toast message
  • Use Bootstrap responsive tables
  • Responsive table class
  • AdminLTE layout class
  • Use Font Awesome v4 shims
  • Embed PDF documents
  • Use URL rewrite
  • Use JsViews
  • Web root relative path
  • For report or chart
  • Show current filters
  • Show blank series for chart
  • Show zero values in stacked chart
  • Use popup panel for drill down
  • Show drill down filters
  • Chart column CSS class (left or right)
  • Chart column CSS class (left and right)
  • Chart color palette
  • New Server Events for Report or Chart:
  • Chart_Rendered
  • Page_FilterLoad
  • Page_FilterValidated
  • Page_Filtering
  • Page_Breaking
  • Cell_Rendered
  • More:
  • Requires PHP >= 5.6
  • Import reports from PHP Report Maker project to PHPMaker project
  • Bootstrap 4 and AdminLTE 3 updated
  • Overlay Scrollbars extension (for adding scrollbars to pages with content wider than screen)
  • "Lookup" permission for lookup tables
  • Allow editing non-autoincrement primary keys
  • Always reset password on password recovery for better security
  • Encrypt SMTP server username and password
  • Skip encrypted password field on removing XSS (allow characters like "&")
  • Allow disabling Remove XSS for some fields by server event
  • Sanitize internal redirect URL (e.g. changing language ID)
  • Allow overriding Custom Template by overriding helper function getTemplate()
  • Simplified template and extensions
  • Global Config() function to get/set configuration easily
  • Support MySQL and PostgreSQL BIT data type (requires PHP >= 7.1.11)
  • Support MySQL and PostgreSQL JSON data type as string type
  • Generate .htaccess and web.config for URL Rewrite (REST API)
  • Allow editing/copying default permissions of User Levels (PHPMaker UI)
  • Use global 64-bit Node.js automatically if available (PHPMaker UI)
  • FileManager extension updated (using Rich Filemanager, for registered user only)
  • JsRender, Moment, jQuery File Upload, TimePicker, dompdf, CKEditor and tinyMCE updated
  • Many other minor improvements

New in PHPMaker 2019.0.10.0 (May 6, 2019)

  • Requires .NET Framework 4.5
  • Improved: Use CustomMsg in Add Option page
  • Improved: reCAPTCHA extension
  • Fixed: Read-only TEXTAREA fields
  • Fixed: Master/Detail with the same table
  • Fixed: CAPTCHA in Forgot Password page
  • Fixed: Detecting MySQL ENUM/SET values with spaces (URL connection)
  • Updated: composer.json and Composer-Setup.exe
  • Updated: JsRender, jQuery and jQuery Migrate
  • Other minor bug fixes and improvements

New in PHPMaker 2019.0.8.0 (Mar 6, 2019)

  • Support SQLite Databases
  • Import from Excel/CSV
  • Brand-New Layout with Bootstrap 4 and AdminLTE 3:
  • With Font Awesome 4 (replaces Bootstrap 3 Glyphicons)
  • Vertical menu with top navbar menu items
  • All top navbar menu items (vertical menu auto-hidden)
  • Mobile menu (show menu items from top navbar also)
  • Navbar Menu Items:
  • Allow both vertical menu items and top navbar menu items at the same time
  • Auto-hide vertical menu if all items are top navbar items
  • REST API:
  • Allow CRUD actions for tables (with Advanced Security)
  • Support General Data Protection Regulation (GDPR):
  • Field Encryption extension (for registered users only) to encrypt selected fields with personal information
  • Consent and privacy page
  • Download and delete personal data page
  • Paging for Grid-Edit:
  • With Return Page option for going back to List page or Grid-Add/Edit page
  • Date/Time Formats without Seconds:
  • With Date/Time Picker (for all users) and Time Picker (for registered users only) support
  • 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

New in PHPMaker 2019.0.7.0 (Feb 12, 2019)

  • Improved: Clear old error message when opening import dialog
  • Improved: Change Lookup::LookupFilter to public
  • Improved: Set RowType as ROWTYPE_AGGREGATE for aggregate rows in Preview page
  • Improved: Set custom-select width as "auto" in detail grid
  • Improved: Allow setting empty value by .fields() plugin's .value() method
  • Improved: Update Master/Detail sequences before generation
  • Improved: Input group for Auto-Suggest with Add Option
  • Improved: HTML-decode field value in Edit page if Remove XSS enabled
  • Improved: Allow output in Row_CustomAction
  • Fixed: Custom Template with page 0
  • Fixed: Dynamic Selection List with Auto-Fill
  • Fixed: Sort-up icon in Preview page
  • Fixed: Scrolling Table extension for Multiple Master/Detail
  • Fixed: PHPWord/PhpSpreadsheet extensions for field values in HTML
  • Fixed: DOMPDF extension using TCPDF fonts
  • Fixed: Send email on Add
  • Fixed: Custom Grid-Add/Edit return page
  • Fixed: Lookup to own table with different Link Field
  • Fixed: Breadcrumb for detail table Add page
  • Fixed: CSS styles for for Delete Filter button
  • Fixed: Menu item for Custom File with output folder
  • Fixed: Checking default values of fields for MySQL 8
  • Updated: JsRender
  • Other minor bug fixes and improvements

New in PHPMaker 2019.0.6.0 (Feb 12, 2019)

  • Improved: Support "$this" for Lookup Filter
  • Improved: Support unicode for extension settings
  • Improved: Reset slimScroll height
  • Improved: Reset layout height with HTML editor
  • Improved: Highlight active menu items
  • Improved: Add getExportTag() method for use with ExportOptions
  • Improved: Allow URL parameters for return pages
  • Improved: Create Language object in API
  • Fixed: Linked MSSQL database with schema
  • Fixed: Highlight search in List page only
  • Fixed: Autoloader not before Global Code
  • Fixed: Menu URL with hash
  • Fixed: Selected options from Modal Lookup across pages
  • Fixed: Save file upload related fields
  • Updated: Time picker, JsRender, pGenerator and pStrength
  • Other minor bug fixes and improvements

New in PHPMaker 2019.0.5.0 (Dec 11, 2018)

  • Compatibility with PHP Report Maker 12
  • Improved: Api class (REST API)
  • Improved: PhpBarcode class (Custom View Tag)
  • Improved: Add advanced setting "Multi-column List page grid CSS class"
  • Improved: Preview overlay (Preview extension for registered users)
  • Fixed: Anonymous access for lookup
  • Fixed: Global variable "Conn"
  • Fixed: CSS for single column checkbox/radio list
  • Fixed: CSS for icon in input group
  • Fixed: CSS for password strength bar
  • Fixed: CSS for dropdown list clear button
  • Fixed: Unnecessarily check field variable name against table variable name
  • Fixed: Add Option with Auto-Update value
  • Fixed: Lookup_Selecting for detail grid and Add Option
  • Fixed: Dropdown list not showing selected options properly
  • Fixed: Not checking MSSQL schema for linked databases
  • Fixed: Multiple upload fields with non image file and colorbox
  • Fixed: Show messages by JavaScript
  • Fixed: Scrolling Table for Master/Detail View (Scrolling Table extension for registered users)
  • Other minor bug fixes and improvements

New in PHPMaker 2019.0.3.0 (Oct 3, 2018)

  • Improved: HTML markup for input groups with buttons
  • Improved: Security for uploading import file
  • Improved: Use lookup cache for List pages only
  • Improved: Load locale file with different lettercase from language ID
  • Improved: Width of .ew-login-box, .ew-forgot-pwd-box, .ew-change-pwd-box
  • Improved: Handle decimal point of font size for non-English systems
  • Fixed: VARCHAR(MAX)/NVARCHAR(MAX) data types not detected correctly (MSSQL)
  • Fixed: Composer update working directory option
  • Fixed: Linked table class not generated properly
  • Fixed: function submitAction() not sending action name properly
  • Fixed: Constant DELETE_UPLOADED_FILES not generated properly
  • Fixed: AutoSuggest/AutoFill fields
  • Fixed: "glyphicon-warning-sign" not replaced with Font Awesome icon
  • Fixed: Default value of advanced setting "API access time after login"
  • Fixed: Lookup fields with multiple selection
  • Fixed: API custom actions
  • Fixed: Modal lookup field display value not displayed properly
  • Fixed: Email field encrypted by "FieldEncryption" extension
  • Fixed: Synchronization with linked tables from the same table
  • Fixed: Missing CSS class "dropdown-item" for List Options items
  • Fixed: Some server events not generated for some pages
  • Fixed: API response for Add Option
  • Fixed: Modal lookup fields (separator and paging)
  • Fixed: "in-valid" CSS class not removed for fields with Date/Time picker
  • Fixed: Output ew-js-templates for pages without header/footer
  • Fixed: Generate class for non-PHP custom files
  • Updated: PhpSpreadsheet version
  • Other minor bug fixes and improvements

New in PHPMaker 2019.0.2.0 (Sep 3, 2018)

  • 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

New in PHPMaker 2019.0.1.0 (Aug 13, 2018)

  • Improved: Avoid class file name conflicts for table names with suffix same as page ID
  • Improved: Use composer -d for network path destination folder
  • Fixed: Dynamic Selection List in Master/Detail-Add/Edit
  • Fixed: Execute() for unspecified database connection
  • Fixed: Namespace of exception
  • Fixed: "No header/footer" pages
  • Fixed: Handling JavaScript in Custom Template
  • Fixed: Time picker extension (for registered users)
  • Fixed: ReferenceError: i is not defined
  • Fixed: JavaScript error for range validation
  • Fixed: Page_Importing event not generated properly
  • Fixed: Some required pages for unselected table not generated properly
  • Fixed: Some code not supported by PHP 5.5
  • Fixed: Copy table settings to linked table
  • Updated: Bootstrap 4.1.3, mobile-detect.js
  • Other minor bug fixes and improvements

New in PHPMaker 2019.0.0.1 (Jul 30, 2018)

  • PHPMaker 2019 is a major upgrade from v2018. 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.
  • Brand-New Layout with Bootstrap 4 and AdminLTE 3
  • Navbar Menu Items:
  • Allow both vertical menu items and top navbar menu items at the same time
  • Auto-hide vertical menu if all items are top navbar items
  • REST API - Allow CRUD actions for tables (with Advanced Security)
  • Support SQLite Databases
  • Import from Excel/CSV
  • Support General Data Protection Regulation (GDPR)
  • Paging for Grid-Edit
  • Date/Time Formats without Seconds
  • 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

New in PHPMaker 2018.0.8 (Apr 10, 2018)

  • Improved: Prevent repeated submission of Modal dialogs
  • Fixed: Lookup field as hyperlink field
  • Fixed: Saving server side filters without checking Profile field
  • Fixed: Upload filename included in Grid-Add/Edit template row
  • Fixed: Colors for Export to PDF (plain theme)
  • Fixed: Export to HTML for reports
  • Fixed: MySQL CONCAT with null field values
  • Fixed: Class GD for PHP 7.2
  • Fixed: DateTime picker returning localized value
  • Fixed: No header/footer
  • Fixed: Synchronizing deleted linked tables
  • Fixed: Captcha extension
  • Fixed: Debugoutput for PHPMailer
  • Updated: PHPMailer 6.0.5
  • Other minor bug fixes and improvements

New in PHPMaker 2018.0.7.1 (Mar 20, 2018)

  • Always use placeholder for login/changepwd/forgotpwd pages
  • Change EW_EMAIL_TEMPLATE_PATH from constant to variable
  • Remove obsolete login options
  • Fixed: SELECT DISTINCT for Lookup, Modal Lookup or Auto-Suggest fields (MSSQL)
  • Fixed: Data truncated when concatenating lookup display fields (MSSQL)
  • Fixed: Custom Template with list options in List Page
  • Fixed: MSSQL native driver flaw for retrieving the last insert ID
  • Fixed: Switching to Add/Edit page from View page in Modal dialog
  • Fixed: Database_Connected server events in db helper
  • Fixed: Validation with Auto-Suggest
  • Fixed: Sorting pages in Multi-page
  • Fixed: Image loading in Preview page
  • Updated: PHPMailer 6.0.3, PHPWord, Mobile_Detect and Moment
  • System requirements updated to PHP >= 5.5 (required by PHPMailer 6 and reCaptcha)
  • Other minor bug fixes and improvements
  • Webmaster
  • Posts: 10880
  • Joined: Fri Aug 06, 2004 5:59 pm
  • Top

New in PHPMaker 2018.0.6 (Dec 21, 2017)

  • Support Database_Connecting/Connected server events in db helper
  • Add "orientation" setting for PHPWord extension
  • Allow crosstab query in MS Access databases
  • Improved: Initialization of Modal Lookup fields
  • Fixed: Selected value not showing properly in Modal Lookup
  • Fixed: Error on double clicking Modal Lookup button
  • Fixed: Error with AutoFill in detail table
  • Fixed: Error with table without primary key
  • Fixed: Scrollable Table with Inline-Add/Edit
  • Fixed: Field Visibility extension on Add/Edit (List page)
  • Fixed: Unicode characters in display values for searchable lookup fields (List page)
  • Fixed: Encrypted file path
  • Fixed: PHPExcel table level settings for reports
  • Updated: JSRender 0.9.90, dompdf 0.8.2, PHPMailer 5.2.26
  • Other minor bug fixes and improvements

New in PHPMaker 2018.0.5 (Dec 21, 2017)

  • Add Auto-Login failure message (requires updating language file)
  • Unify save button caption (requires updating language file)
  • Fixed: Add button in Master/Detail View
  • Fixed: Auto-Suggest with Option Template
  • Fixed: Float field as unique index not checked properly
  • Fixed: Record count for Custom View
  • Fixed: DateTime picker with short year format
  • Fixed: DateTime picker year selection white-space style in Extended Search
  • Fixed: Modal Lookup page size
  • Fixed: Duplicate display values of Modal Lookup field under some cases
  • Fixed: CSS classes for detail pages as accordion
  • Fixed: "relatedid" attribute not generated correctly in project .xml config file for compatibility
  • Allow Link Tables in MS Access databases
  • Other minor bug fixes and improvements

New in PHPMaker 2018.0.4 (Dec 21, 2017)

  • Improved: IsExport() function
  • Improved: Increase maximum length of extension settings
  • Improved: Remove user ID and password in debug message for native MSSQL driver
  • Fixed: Extended search on virtual lookup field
  • Fixed: Record count not shown in list page if number of records < records per page
  • Fixed: AutoSuggest with Custom Template
  • Fixed: FileManager extension with output filename prefix/suffix
  • Updated: AdminLTE 2.4.2
  • Other minor bug fixes and improvements

New in PHPMaker 2018.0.3 (Sep 27, 2017)

  • It is loaded with a bunch of new features, including many frequently requested ones, please refer to here for more details:

New in PHPMaker 2018.0.2 (Aug 21, 2017)

  • PHPMaker:
  • Home
  • Features
  • Support
  • FAQ
  • Forums
  • Download
  • Purchase
  • What's New in PHPMaker 2018:
  • PHPMaker 2018 is a major upgrade from v2017. 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.
  • Brand-New Layout with AdminLTE
  • Vertical menu
  • Horizontal Menu (Extension for registered users only)
  • Google Sign-In and Facebook Login
  • Search and Sort in User Level Permission Setup Page
  • Custom Edit Tags:
  • Edit field values in your own way with your own Edit Tag.
  • Google Maps - MarkerClusterer
  • AutoSuggest with "More"
  • New DateTime Picker:
  • Replaces out-dated JsCalendar.
  • Project Versioning:
  • Auto create a version of project when you save the project. Easily revert project to any of these versions within PHPMaker.
  • Auto-Render Template:
  • Customize menu, language selector, navbar menu items... anywhere in the layout with your own JsRender templates.
  • Icon for Menu Items:
  • Enter icon CSS class name (glyphicon-* or fa-*) easily for menu items
  • New Advanced Settings:
  • PHP (php.exe) path and web server port
  • Node.js related settings
  • Use project versioning
  • Compress project .js - now minify all uncompressed .js in the project
  • Use jQuery Migrate
  • Use Microsoft PHP Driver for SQL Server (EXPERIMENTAL only)
  • File upload related settings
  • Use password hash - use PHP password hashing functions instead of md5()
  • Form left column CSS class - specify the width of the left (field caption) column
  • LDAP options - for ldap_set_option()
  • Google Sign-In settings
  • Facebook Login settings
  • New Server Events:
  • Page_Foot - for Auto-Render Templates
  • Ldap_Validated - for searching LDAP tree and further validating LDAP users
  • Menu_Rendered - for cleaning up what you created in Menu_Rendering
  • More:
  • Export-to-JSON for use with Ajax
  • Upload folder supports Amazon S3 buckets
  • Generate Password / Password Strength for non user tables
  • F9 and Ctrl+F9 shortcuts for generation
  • Search box for advanced settings
  • More field properties for Multiple Field Update
  • PHP built-in web server as testing server
  • New "dbvalue" tag for Custom Template
  • dompdf 0.8.0
  • PHPMailer 5.2.23
  • jQuery 3.2.1
  • jQuery file download
  • Font Awesome
  • JsRender, Moment, Colorbox, jQuery File Upload, Timepicker, CKEditor and TinyMCE updated
  • mobile_detect.php and mobile-detect.js updated
  • Preview extension supports paging and sorting (registered users only)
  • PHPExcel and PHPWord updated (registered users only)
  • Many other minor improvements

New in PHPMaker 2018.0.1 (Aug 7, 2017)

  • Allow echo in Menu_Rendering/Rendered events
  • Allow text for Site Logo and check image file name better
  • Add ListOptions_Rendering server event
  • Add properties/methods to cField class for cell class
  • Add "Reset layout height" advanced setting
  • Add "Title" (Site Title) option for advanced setting "Page title style"
  • Allow hyperlink for parent menu items
  • Lazy loading of images
  • Improved: ew_ExecuteJson() function
  • Improved: Scrolling Table extension allows width/height in %
  • Improved: Row_Selected() server event
  • Improved: DateTimePicker extension allows debug mode
  • Fixed: ew_SendEmail() function
  • Fixed: Upload path for S3
  • Fixed: Preview extension
  • Fixed: Mouseover dropdown menu for Horizontal Menu extension
  • Fixed: *.js/*.css file name letter case
  • Fixed: Modal lookup with multiple selection
  • Fixed: Menu with absolute URL
  • Fixed: Highlighting search keywords in List page
  • Fixed: Edit page shows pager in debug mode
  • Fixed: Some issues with mssqlnative driver
  • Other minor bug fixes and improvements

New in PHPMaker 2018.0.0 (Jul 25, 2017)

  • HPMaker 2018 is a major upgrade from v2017. 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:
  • Brand-New Layout with AdminLTE
  • Google Sign-In and Facebook Login
  • Search and Sort in User Level Permission Setup Page
  • Custom Edit Tags
  • Google Maps - MarkerClusterer
  • AutoSuggest with "More"
  • New DateTime Picker
  • Project Versioning
  • Auto-Render Template
  • Icon for Menu Items
  • New Advanced Settings:
  • PHP (php.exe) path and web server port
  • Node.js related settings
  • Use project versioning
  • Compress project .js - now minify all uncompressed .js in the project
  • Use jQuery Migrate
  • Use Microsoft PHP Driver for SQL Server (EXPERIMENTAL only)
  • File upload related settings
  • Use password hash - use PHP password hashing functions instead of md5()
  • Form left column CSS class - specify the width of the left (field caption) column
  • LDAP options - for ldap_set_option()
  • Google Sign-In settings
  • Facebook Login settings
  • New Server Events:
  • Page_Foot - for Auto-Render Templates
  • Ldap_Validated - for searching LDAP tree and further validating LDAP users
  • Menu_Rendered - for cleaning up what you created in Menu_Rendering
  • More:
  • Export-to-JSON for use with Ajax
  • Upload folder supports Amazon S3 buckets
  • Generate Password / Password Strength for non user tables
  • F9 and Ctrl+F9 shortcuts for generation
  • Search box for advanced settings
  • More field properties for Multiple Field Update
  • PHP built-in web server as testing server
  • New "dbvalue" tag for Custom Template
  • dompdf 0.8.0
  • PHPMailer 5.2.23
  • jQuery 3.2.1
  • jQuery file download
  • Font Awesome
  • JsRender, Moment, Colorbox, jQuery File Upload, Timepicker, CKEditor and TinyMCE updated
  • mobile_detect.php and mobile-detect.js updated
  • Preview extension supports paging and sorting (registered users only)
  • PHPExcel and PHPWord updated (registered users only)
  • Many other minor improvements

New in PHPMaker 2017.0.7 (Mar 2, 2017)

  • Add advanced settings for auto-hiding page size selector
  • Increase number of recent project files to 10
  • Improved: Hide ewGridLowerPanel/ewGridUpperPanel if empty
  • Improved: Load tables dynamically
  • Improved: Call User_Validated even if user not found
  • Improved: Load default settings for TIME fields
  • Improved: Check HTTP_X_FORWARDED_PROTO/PORT for HTTPS
  • Fixed: Prefix/infix/suffix generated for Custom View Tag files
  • Fixed: Email address not URL-encoded in PrepareRegisterEmail()
  • Fixed: Dynamic Selection Lists in Master-Add/Edit page if master field not selected in List page
  • Fixed: Modal Lookup with parent field in master table
  • Fixed: Generation error if generating List/View page only
  • Fixed: Page labels with HTML tags
  • Fixed: Popup error does not show while in modal dialog
  • Fixed: AddBlankRow when Grid-Edit with no records
  • Fixed: Not always include ewpdf.css when exporting to PDF
  • Fixed: AutoSuggest fields not checked for "Required"
  • Fixed: Audit Trail for Cascade Delete
  • Updated: ar.json
  • Other minor bug fixes and improvements

New in PHPMaker 2017.0.6 (Mar 2, 2017)

  • Compatible with PHP Report Maker 10
  • Get correct record count for modal lookup
  • Update DBHost after synchronization with MSSQL
  • Support callback function for successful row custom action
  • Remove white spaces after Custom Template
  • Support MSSQL bit field as boolean field
  • Updated: PHPMailer 5.2.21
  • Other minor changes and bug fixes

New in PHPMaker 2017.0.5 (Dec 14, 2016)

  • Modal View/Edit/Update/Add/Copy in List Page:
  • In addition to modal Search and Delete (Inline Delete), now you have options to use modal dialog for View/Edit/Update/Add/Copy page in List page also.
  • Modal Lookup Dialog for Searching and Selecting from Lookup Table:
  • Option to replace TEXT/RADIO/CHECKBOX/SELECT Edit Tag with a modal lookup dialog which supports searching, paging and option template.
  • Field Visibility Extension (for registered users only):
  • Easily set Visible property of field object for different pages or actions. Supports permissions by boolean expression, User ID, User Level or combination of them.
  • Auto Update to Latest Template (for registered users only):
  • View/Edit/Add/Copy/Delete links in detail table of Master/Detail View
  • Now the detail grid in Master/Detail View includes links for Add, Copy, Edit, Delete, and View.
  • Locale Files:
  • Locale files for 70 languages
  • Locale settings with date and time separators, date format and time zone by language
  • Locale file editor
  • New Script Engine by Node.js:
  • Faster loading/unloading of large projects
  • Faster script generation
  • New User Code with events for system functions and before/after generation
  • More Advanced Settings:
  • Search filter save option - Option to save search filter on server side in database or on client side by localStorage
  • Hide paging section if single page - Option to hide pager if single page only
  • Page title style - Option to show/hide breadcrumbs or show as page title
  • Authentication mode - Simple Windows/LDAP authentication
  • More:
  • Option to enable/disable fields for sorting
  • Support Add page for tables without primary key
  • Handle client side events in Add Blank Row
  • Preserve spacing for Custom Files
  • Handle Session Keep Alive and Session Timeout when security disabled
  • Disable "Password Strength" and "Generate Password" options in Search page
  • dompdf 0.7.0
  • ADOdb 5.20.4
  • PHPMailer 5.2.16
  • jQuery, JsRender, Moment, Colorbox, typeahead.js, jQuery File Upload, Timepicker updated
  • CKEditor and TinyMCE updated
  • PHPExcel and PHPWord updated (registered users only)
  • mobile_detect.php and mobile-detect.js updated
  • Supports Sass (replaces LESS)
  • Many other minor improvements

New in PHPMaker 2017.0.3 (Oct 8, 2016)

  • Fixed: Modal dialog with client events
  • Fixed: Error CSS class not always reset for dropdown radio buttons or checkbox list
  • Fixed: AutoSuggest not showing all options in some cases
  • Fixed: Save Current Filter with IS/IS NOT NULL
  • Fixed: Multiple Master/Detail with same field names in detail tables
  • Updated: Bootstrap 3.3.7
  • Support AutoSuggest with Modal Lookup
  • Support AutoSuggest for User ID fields
  • ADOdb updated to 5.20.6 with PostgreSQL BLOB fields fixed
  • Other minor changes and bug fixes

New in PHPMaker 2017.0.2 (Oct 8, 2016)

  • Fixed: Password generator and strength not working in modal dialog
  • Fixed: Pager not showing in modal dialog for lookup with ORDER BY clause (SQL Server)
  • Fixed: CSS cannot be compiled with non-English font name
  • Fixed: Custom display value separators ignored by RADIO and CHECKBOX Edit Tags
  • Fixed: New extension advanced settings not saved
  • Fixed: Multi-Language User Values not loaded properly in Multi-Language Property Editor
  • Fixed: FieldVisibility extension with array setting for PHP 5.3
  • Improved: Reset "Multiple" property for non-string type field
  • Show progress at taskbar button
  • Other minor changes and bug fixes

New in PHPMaker 2017.0.1 (Oct 8, 2016)

  • Improved: Show error message if uploaded file cannot be saved
  • Improved: Consider date/time separators in Quick Search with date/time fields
  • Improved: Allow to open project with invalid connection info
  • Improved: Update report source if source table is renamed during synchronization
  • Improved: Fire User_Validated server event for custom user validation
  • Fixed: Modal Lookup with "Text input for search" enabled
  • Fixed: Wrong lookup display fields in Multi-Language project
  • Fixed: Field order not saved properly
  • Fixed: Master/Detail order not saved properly
  • Fixed: Not allowing empty site logo setting
  • Fixed: "No header/footer" option ignored
  • Fixed: Menu items not properly saved
  • Fixed: Not returning all fields from MSSQL in some cases
  • Fixed: Error on drag-and-drop in Field Setup page
  • Fixed: Incorrect fields shown aftering adding new table and synchronization
  • Fixed: Errors with function ew_FormatDateTime()
  • Fixed: JavaScript error with scrollable table
  • Fixed: Field Visibility extension with PHP 5.3 or with "complex" condition
  • Fixed: Dynamic Selection Lists wtih parent field in master table
  • Fixed: Locale file for language "ar"
  • Fixed: Schema ignored for PostgreSQL
  • Use test keys for reCAPTCHA
  • Remove dependency on Visual C++ Redistributable
  • Other minor changes and bug fixes

New in PHPMaker 12.0.7 (Mar 21, 2016)

  • Fixed: Anonymous access with User Level Security disabled
  • Fixed: Add Blank Row with DHTML editor
  • Fixed: Proper handling if Row_Deleting server event returns FALSE
  • Fixed: No color in file upload progress bar
  • Fixed: Oracle CLOB/BLOB fields with related file fields
  • Fixed: Avoid infinit loop if Start Page = List page with querystring parameters
  • Fixed: CKEditor create/save event name not consistent with tinyMCE
  • Fixed: Text field with IMAGE View Tag and [Encrypt File Path] option enabled
  • Improved: Detect Oracle instant client better
  • Improved: Set BODY tag dir attribute based on language ID (for Multi-Language project)
  • Improved: Upload file name extension checking
  • Other minor changes and bug fixes

New in PHPMaker 12.0.6 (Jan 19, 2016)

  • Highlights:
  • Advanced Security
  • User registration system
  • Export to CSV/HTML/Excel/Word/XML/PDF/Email
  • File uploading to database or folder
  • Master/Detail-Add/Edit/View
  • Custom template
  • What's New in PHPMaker 12:
  • PHPMaker 12 is a major upgrade from 11.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.
  • Linked Tables from Multiple Databases:
  • Now you can add Linked Tables from other databases of different database type
  • Custom Fields:
  • Add custom fields to a table or view with SQL expression.
  • Optional Tabular Form for Desktop Mode:
  • Option to use Bootstrap table instead of Bootstrap horizontal form for Add/Edit/Search/Update/Register pages (Desktop mode only)
  • Dropdown Selection Lists:
  • Show the options in dropdown panel (supports SELECT, RADIO and CHECKBOX) with min-width and max-height settings.
  • Option Template for Dropdown Selection Lists:
  • Show options in HTML with JsRender template.
  • Improved AutoSuggest:
  • Support Option Template, min-width and max-height settings.
  • Session Keep Alive and Session Timeout:
  • Keeps session alive by Ajax or show session timeout countdown to remind users.
  • Anonymous User Level:
  • Anonymous User becomes a built-in dynamic User Levels so administrators can setup permissions at runtime.
  • New Actions to Manage User Profile (for Administrators):
  • 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
  • Options:
  • Enable submit button for the last page only
  • Hide disabled submit button
  • Hide inactive pages
  • Set inactive tabs as disabled (for tabs and pills only)
  • Hide tabs (for tabs and pills only)
  • Show pager (Prev/Next buttons) at top and/or bottom
  • Pager template (HTML template of the Prev/Next buttons)
  • Simplified Client Side Events and "fields" jQuery Plugin:
  • Add client side events easily and manipulate/validate the fields quickly with PHPMaker's "fields" jQuery plugin.
  • Multi-Update of Field Settings:
  • 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
  • Local Storage of Search Criteria:
  • Saves search criteria in browser local storage.
  • Cancel Button for Add/Edit/Delete/Update Pages:
  • Cancel button with confirmation dialog if form data has been modified.
  • New Language Selection Buttons:
  • 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

New in PHPMaker 12.0.4 (Nov 9, 2015)

  • Supports PHP 7
  • Fixed: Dynamic Selection Lists in Master/Detail-Edit
  • Fixed: SELECT statement generated incorrectly if Custom Fields not selected
  • Fixed: Crashes when altering views in some cases
  • Fixed: Table schema not considered in Add Linked Table form
  • Fixed: PostgreSQL boolean field as Activated Field
  • Fixed: Non-admin user not properly checked when adding user record
  • Fixed: Microsoft Access database path not built correctly if the path contains parent path
  • Fixed: Required field not validated correctly if "Use Dropdown" enabled
  • Fixed: ADOdb error message not displayed correctly (MSSQL)
  • Improved: Prevents output in server events breaks JSON output of ewlookup.php
  • Improved: Better performance in cleaning up upload temp folders
  • Improved: Check if PHP COM extension installed (MSSQL and MS Access)
  • Improved: Reload user level permission on change (Dynamic User Level Security)
  • Other minor changes and bug fixes

New in PHPMaker 12.0.3 (Nov 9, 2015)

  • Fixed: Auto-Fill not working in multiple master/detail
  • Fixed: Incorrect fields for registration email
  • Fixed: Incorrect Add link for preview
  • Fixed: Multi-Language Property Editor not showing Linked Tables
  • Fixed: JavaScript error in View page printer friendly version
  • Fixed: Dropdown selection list (RADIO/CHECKBOX) not showing in browsers for iOS
  • Fixed: Multiple selection (SELECT MULTIPLE and CHECKBOX) not loaded properly
  • Fixed: JavaScript error in Multi-Page pager
  • Fixed: "$" not escsped in connection info
  • - Fixed: Add Option for AutoSuggest field with Option Template
  • Fixed: Wrong file name of dompdf_config.inc.php if output file name prefix/suffix enabled (PDF extension)
  • Improved: Handle hidden file upload fields
  • Improved: Handle hidden fields in Custom Template
  • Improved: Show read-only file upload fields with colorbox
  • Improved: Session does not timeout if auto-login
  • Improved: Allow synchronous Ajax requests for lookup fields
  • Updated: JsRender, moment.js and Colorbox
  • Other minor changes and bug fixes

New in PHPMaker 12.0.2 (Aug 26, 2015)

  • Fixed: Incorrect User Values for User Level field
  • Fixed: Incorrect letter case of User Level table/field names after creating tables (PostgreSQL only)
  • Fixed: Incorrect redirection if user has no permission to access the Start Page
  • Fixed: JavaScript error of Multi-page in Advanced Search modal dialog (Chrome only)
  • Fixed: Local Storage Filters not working if only Advanced Search enabled
  • Fixed: Incorrect image preview path in file manager (FCKeditorFileManager extension)
  • Fixed: JsCalendar "calendar" event handler cannot be attached by Client Script
  • Improved: Support "Allow Add" in detail table (Master/Detail-Add/Edit)
  • Improved: Allow users of Administrator User Level to use the new actions for user profile
  • Improved: Advanced setting to allow searching keywords in all selected fields (Quick Search)
  • Improved: Prevent saving detail records for master record not belonged to user
  • Updated: JsRender
  • Other minor changes and bug fixes

New in PHPMaker 12.0.1 (Aug 6, 2015)

  • Fixed: Generation error for ewp12.js on some machines
  • Fixed: Forgot password with MD5 password
  • Fixed: Grid-Add/Edit with AutoSuggest field(s) (error on submit)
  • Fixed: Dynamic Selection Lists in Grid/Inline/Master-Add/Edit
  • Fixed: Option Template in Grid/Inline/Master-Add/Edit
  • Fixed: New option not properly selected after adding a new option to lookup field
  • Fixed: Upload file path error if application root destination folder
  • Fixed: Security for hard-coded admin only
  • Fixed: Show Audit Trail table properly in UI after creating Audit Trail table
  • Fixed: Audit Trail not working if *info.php of Audit Trail table not selected to generate
  • Fixed: Incorrect ewscrolltable.min.js (Scrolling Table extension)
  • Fixed: Automatic language code for reCAPTCHA (Captcha extension)
  • Fixed: Oracle BLOB fields cleared when updating other fields
  • Other minor changes and bug fixes

New in PHPMaker 12.0.0 (Jul 20, 2015)

  • PHPMaker 12 is a major upgrade from 11.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.
  • Linked Tables from Multiple Databases:
  • Now you can add Linked Tables from other databases of different database type
  • Custom Fields:
  • Add custom fields to a table or view with SQL expression.
  • Optional Tabular Form for Desktop Mode:
  • Option to use Bootstrap table instead of Bootstrap horizontal form for Add/Edit/Search/Update/Register pages (Desktop mode only)
  • Dropdown Selection Lists:
  • Show the options in dropdown panel (supports SELECT, RADIO and CHECKBOX) with min-width and max-height settings.
  • Option Template for Dropdown Selection Lists:
  • Show options in HTML with JsRender template.
  • Improved AutoSuggest:
  • Support Option Template, min-width and max-height settings.
  • Session Keep Alive and Session Timeout:
  • Keeps session alive by Ajax or show session timeout countdown to remind users.
  • Anonymous User Level:
  • Anonymous User becomes a built-in dynamic User Levels so administrators can setup permissions at runtime.
  • New Actions to Manage User Profile (for Administrators):
  • 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: Options: (To be set up by Client Script):
  • Enable submit button for the last page only
  • Hide disabled submit button
  • Hide inactive pages
  • Set inactive tabs as disabled (for tabs and pills only)
  • Hide tabs (for tabs and pills only)
  • Show pager (Prev/Next buttons) at top and/or bottom
  • Pager template (HTML template of the Prev/Next buttons)
  • Simplified Client Side Events and "fields" jQuery Plugin:
  • Add client side events easily and manipulate/validate the fields quickly with PHPMaker's "fields" jQuery plugin.
  • Multi-Update of Field Settings:
  • 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
  • Local Storage of Search Criteria:
  • Saves search criteria in browser local storage.
  • Cancel Button for Add/Edit/Delete/Update Pages:
  • Cancel button with confirmation dialog if form data has been modified.
  • New Language Selection Buttons:
  • 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

New in PHPMaker 11.0.6 (Mar 30, 2015)

  • Fixed: Export to email failure for View page with no paging section
  • Fixed: Incorrect tooltip for master table in detail table's List page
  • Fixed: Generation error when generating master View page only
  • Fixed: Disallow all file types if no file type is entered for upload field
  • Fixed: Incorrect image src if application root not same as destination folder
  • Improved: Allow using the client side "create" event to change the configurations (CKeditor/TinyMCE extensions)
  • Improved: New row type (EW_ROWTYPE_HEADER) for List page header (for use with ListOptions_Rendered server event)
  • Improved: Speed of synchronization
  • Updated: Bootstrap 3.3.4
  • Updated: jQuery 1.11.2
  • Updated: JsRender
  • Event editor auto-completion disabled (unless pressing Ctrl+Space)
  • Other minor changes and bug fixes

New in PHPMaker 11.0.5 (Jan 7, 2015)

  • Fixed: Scrollbar for main table appeared with button dropdown due to Bootstrap 3.3.1
  • Fixed: Hang during generation if Access database file not found and Dynamic User Level security enabled
  • Fixed: Required field validation for DHTML editor
  • Fixed: Checking for maximum number of upload files
  • Fixed: Incorrect position for Export Options for Master/Detail page
  • Fixed: Detail report column hidden if Preview extension enabled
  • Fixed: Export selected records to email for Custom Template
  • Improved: File upload thumbnail width/height as advanced settings
  • Improved: Colorbox for file upload thumbnails
  • Improved: Hide hyperlink if TooltipValue is empty
  • Improved: Completion list (Ctrl+Space) for Custom Template
  • Improved: Export-to-Email supports QRCode/Barcode Custom View Tags
  • Other minor changes and bug fixes

New in PHPMaker 11.0.4 (Dec 2, 2014)

  • Fixed: Cascade Update with more than one foreign key fields
  • Fixed: Display images for SQL Server binary fields
  • Fixed: Custom Files at application root (output folder is empty) when application root not same as destination folder
  • Fixed: Error in spell check (CKeditor extension)
  • Fixed: TCPDF export problem (DOMPDF extension)
  • Fixed: Preview overlay not displayed next to the detail button group in multi-column List page (Preview extension)
  • Fixed: Button height not some as input in IE (JSCalendar/TimePicker extensions)
  • Fixed: Duplicate dropdown menu items in View page
  • Improved: Add settings for paper size and orientation (PHPExcel extension)
  • Improved: Support Page_Loading/Page_Rendering/Page_Unloaded server events in Custom Files
  • Improved: Handle Heredoc and Nowdoc in server events
  • Improved: Remove icon base for google map so user icons can be specifed
  • Improved: Handle bitmap images (*.bmp) during export
  • Improved: Support validation for password fields
  • Improved: Add DATAMATRIX support for PHP Barcode (Custom View Tag)
  • Updated: Bootstrap 3.3.1
  • Updated: Colorbox 1.5.14
  • Updated: mobile_detect.php and ew_UserAgent()
  • Other minor changes and bug fixes

New in PHPMaker 11.0.3 (Oct 3, 2014)

  • Support exporting QRCode/BarCode as images (PHPExcel/PHPWord/PDF/Email only)
  • Add Advanced Setting "Check token for form post"
  • Add getter/setter for SqlXXX() in table class
  • Improved: Oracle client detection
  • Improved: Support SELECT LIMIT for Oracle
  • Improved: Adjust page footer properly for desktop
  • Improved: Add "for" attribute to label
  • Improved: Check Advanced Security in FCKeditorFileManager extension
  • Improved: Support submitting the modal Add Option dialog and Advanced Search dialog by pressing Enter
  • Improved: Add timer to avoid single google maps OVER_QUERY_LIMIT error
  • Fixed: Incorrect records loaded during Grid-Edit if default search values specified
  • Fixed: AutoFill not working in Master/Detail-Edit
  • Fixed: Custom File with output folder specified
  • Fixed: Mobile menu not hidden on print
  • Fixed: Textarea content not HTML-encoded
  • Fixed: Old upload file deleted if both CreateUploadFileOnCopy and DeleteUploadedFile options enabled
  • Fixed: Charset not properly set up in database helper for Oracle
  • Fixed: Detail columns not hidden properly for PreviewRow (Preview extension)
  • Fixed: AutoSuggest blur event clearing the new value added by Add Option
  • Fixed: Incorrect user table name for MSSQL when saving user profile to database
  • Updated: JsRender, typeahead.js, and mobile_detect.php
  • Other minor changes and bug fixes

New in PHPMaker 11.0.2 (Aug 11, 2014)

  • Improved: Add Visible property to cBreadcrumb class
  • Improved: Allow custom connection info for database helper
  • Improved: Align foreign key fields in Add/Edit page
  • Improved: Set up default theme/css settings for new project
  • Improved: Detect compound trigger in Oracle for autoincrement field
  • Fixed: Hide Search options during Inline-Add/Edit
  • Fixed: Preview extension - "Add" link for detail table with no record
  • Fixed: Missing alternating row color for PDF export
  • Fixed: Incorrect text for Export to Word link
  • Fixed: Missing placeholder for password fields
  • Fixed: Not showing new fields in database pane after synchronizing table/view
  • Fixed: Hidden fields not auto-filled
  • Fixed: Incorrect URL for Custom File in index page
  • Updated: JsRender and Colorbox
  • Other minor changes and bug fixes

New in PHPMaker 11.0.1 (Jul 28, 2014)

  • Add right click menu in code editor
  • Improved: Support no header/footer in Custom Files
  • Improved: Show required indicators for field captions in Custom Template
  • Improved: Use colorbox.min.js instead of colorbox.js
  • Fixed: Missing brand in Horizontal Menu
  • Fixed: Unable to click Home/User icon in Chrome
  • Fixed: Auto fill with two or more than parent fields
  • Fixed: Export wrong records if search with default values
  • Fixed: Advanced search for auto suggest fields
  • Fixed: Show All button not showing if only Advanced Search enabled
  • Fixed: Preview with date key fields
  • Fixed: Multi-Page Custom Template displayed incorrectly
  • Fixed: Missing viewport meta tag if project styles disabled
  • Fixed: Hard code admin only project settings reset
  • Updated: JsRender
  • Other minor changes and bug fixes

New in PHPMaker 11.0.0 (Jul 11, 2014)

  • 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.
  • 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
  • More:
  • jQuery updated (jQuery Mobile removed)
  • jQuery File Upload updated
  • JsRender updated
  • tinyMCE and CKEditor extensions (for registered users only) updated with latest versions (FCKEditor extension not provided any more)
  • DOMPDF extension updated
  • mobile_detect.php updated
  • PHPExcel extension (for registered users only) updated
  • Scrollable Table (for registered users only) uses 100% width in mobile mode
  • Add Option form and Email form as Modal dialog
  • Multi-Column page by grid system
  • Allows more than one sessions for Disallow Concurrent Login
  • Supports using $Security->CanXXX() for projects without User Level Security enabled
  • Supports global and field specific client/server side validation of file extension, file size, and max. number of files (if multiple upload)
  • Synchronizer token for forms with method="post"
  • Support user password in phpass format (encrypted by third-party systems)
  • Improved code editor
  • UI supports >100% Windows system text size
  • Many other minor improvements

New in PHPMaker 10.0.5 (Mar 19, 2014)

  • Improved: Do not show IMG tag for non-image files
  • Improved: Skip update if the input is not changed for auto-suggest
  • Improved: Use font for site title
  • Improved: Skip require validation for upload file field if not changed
  • Improved: Skip loading upload file content if not changed
  • Improved: Error handling for delete temp image folders
  • Improved: Get record count for tables with schema
  • Fixed: Handle Master/Detail relationship key changes properly
  • Fixed: Breadcrumb in List/View page with export
  • Fixed: Breadcrumb for Master/Detail displayed incorrectly after Add Option
  • Fixed: Display page zero form elements correctly for Multi-Page with Custom Template
  • Fixed: Do not skip empty selection list for Ajax
  • Updated: jQuery and JsRender
  • Other minor changes and bug fixes

New in PHPMaker 10.0.4 (Mar 19, 2014)

  • Support new Email SendAttachment method
  • Improved: DO NOT use the phrase stored by Multi-Language Editor if Multi-Language is not enabled
  • Improved: DO NOT reset field default after synchronization if field data type is changed to a compatible type (i.e. Int to BigInt)
  • Improved: Hide delete button for upload field in Add/Edit Confirm page
  • Improved: Improve detection of JPEG image in ew_ContentType()
  • Improved: Use CSS for aggregate caption
  • Improved: HTML-encode login page user name and placeholder
  • Improved: Save Google Map object for later retrieval
  • Improved: Better handling of invalid file name (PHPExcel extension)
  • Improved: Improve performance for Auto-Suggest
  • Fixed: Set up AppCompatVersion correctly for compatibility project
  • Fixed: Handle preview row correctly if UseButtonDropDown is enabled (Preview extension)
  • Fixed: Handle Inline-Add/Edit correctly for float/single/double/currency fields with non-English locale setting
  • Fixed: Display multi-language lookup data correctly during export
  • Fixed: Clear search form for Auto-Suggest field
  • Fixed: Avoid IE browser cache during file upload
  • Fixed: Handle file upload field with file path
  • Fixed: Do not display "Add Blank Row" during grid add/edit if Add is disabled for table
  • Fixed: Handle dynamic selection in search page without parent field properly
  • Fixed: Handle popup calendar time field without seconds (JSCalendar extension)
  • Fixed: Multi page custom template with page zero fields
  • Fixed: Converting MSSQL project schema
  • Updated: JsRender
  • Other minor changes and bug fixes

New in PHPMaker 10.0.3 (Mar 19, 2014)

  • Support database schema for PostgreSQL and MSSQL
  • Support Oracle client without Oracle OLEDB provider and Oracle Timestamp field
  • Fixed: Old files not deleted after deleting a record (Multiple File Upload only)
  • Fixed: PHPBarCode extension not showing the text under barcode
  • Fixed: Search panel not auto-expand when "IS (NOT )NULL" is selected
  • Fixed: File upload fields in detail table not displayed properly in Master/Detail-View
  • Fixed: Field in detail table properly if the detail table is user table
  • Fixed: AutoSuggest not working properly if triggered by onblur
  • Fixed: User Values saved wrongly to the other table
  • Fixed: "File system encoding" setting not used
  • Fixed: Preview overlay not shown if button dropdown is used
  • Updated: JsRender and Mobile Detect
  • QuickUploadPath and QuickUploadAbsolutePath in FileManager extension now points to subfolders in "UserFilesPath"
  • Add "UseCaptchaInLoginPage" option for Captcha extension (use project without Advanced Security)
  • Use style instead of width/height attribute to specify image sizes
  • x-ua-compatible meta tag added for IE
  • Compatible with PHP Report Maker 7
  • Many other minor bug fixes and improvements

New in PHPMaker 10.0.2 (Mar 19, 2014)

  • Improved: Encrypt user table password field during Audit Trail
  • Improved: Advanced Setting to log User ID or User Name during Audit Trail
  • Improved: Not show connection string (MSAccess/MSSQL) on connection error
  • Improved: Handle MSSQL numeric/decimal field values by converting to float
  • Improved: Hide file upload field buttons if set as ReadOnly/Disabled by server event
  • Improved: Recognize custom menu items with URL for the same page but different query string
  • Improved: Override Bootstrap responsive images
  • Fixed: Wrong content type for .docx/.xlsx/.pptx files
  • Fixed: Check Duplicate in Multi-Update page
  • Fixed: Wrong detection of empty row during Grid-Add
  • Fixed: Auto-Suggest field (with "Allow Aort/Search" enabled) cannot be searched
  • Fixed: "Allow Aort/Search" for Oracle
  • Fixed: Auto-Fill not filling fields with DHTML Editor
  • Fixed: Client side arguments for custom validation functions
  • Fixed: Table caption in Breadcrumb not changed after switching language (Multi-Language)
  • Fixed: Custom Template with field names containing spaces
  • Fixed: Compatible project's .xml file not properly loaded
  • Fixed: Mobile menu item without URL not working properly in Opera/IE
  • Fixed: Checkbox column not displayed if Multi-Update only with Security disabled
  • Fixed: Checkbox column not displayed for Custom Action without Multiple-Delete/Update
  • Fixed: Delete button shown in Grid-Edit even with no Delete permission
  • Fixed: Dynamic Selection List with multiple children fields not all updated on change
  • Fixed: Ordering of Master/Detail relationships not saved after change
  • Fixed: Cannot copy field settings for fields with different names
  • Updated: JsRender, PHPMailer and Mobile Detect
  • Many other minor bug fixes and improvements

New in PHPMaker 10.0.1 (Aug 6, 2013)

  • New Website UI with Bootstrap
  • Implementations:
  • 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
  • Multi-Page as Tabs, Pills or Accordion
  • Vertical Menu and Horizontal Menu
  • Enhanced Theme with Bootstrap Variables
  • Breadcrumb
  • Master/Detail View/Edit/Copy with Multiple Detail Tables
  • Referential Integrity
  • Different Styles of Links in List Options, Export Options and Paging Section
  • Enhanced Detail Preview Extension (for registered users only)
  • Multiple File Upload to Folder
  • Custom Locale Settings
  • Custom View Tags:
  • 5 ready-to-use Custom View Tags for you to display your data visually
  • Flash Files
  • Google Maps
  • Barcode
  • QR code
  • YouTube videos
  • LESS - The Dynamic Stylesheet Language
  • Supports LESS which extends CSS with dynamic behavior such as variables, mixins, operations and functions.
  • More Server Events:
  • Lookup_Selecting - Fired before selecting records from the lookup table. For customizing lookup table filter dynamically.
  • Page_Rendering and Page_Render - Fired before outputting HTML of the page. For making some last minute changes to the page before it is outputted.
  • Row_CustomAction - Fired for each selected row (by checkboxes) to process the custom action (similar to Multi-Delete and Mulit-Update)
  • More Advanced Settings:
  • Compress project .css - Compress the project stylesheet (i.e. .css) and output minified .css file
  • Compress project .js - Compress the project JavaScript file (i.e. ewp.js) and output minified .js file.
  • Validate NOT NULL fields - Detect fields declared as NOT NULL in the database (and without default value in database or the project) and force "Required" validation.
  • Use datenumber.js - Include YUI date and number library to operate against Date objects and Number objects.
  • Oracle charset - Set alternative charset (other than the project charset) of connection object for Oracle.
  • Use View Tag number of decimal digits for edit - Neglect original precision of a decimal number and use specified number of decimal digits in Edit page.
  • Replace textarea by text input for search - Use text input in search forms for field with TEXTAREA Edit Tag.
  • Reflow HTML elements for mobile - Stack form elements vertically for mobile
  • Use place holder for text box - Automatically set placeholder attributes of form elements as the field's caption or title
  • More:
  • YUI replaced by jQuery and Bootstrap components
  • Styling by CSS
  • Id and CSS classes added to many HTML elements for easier styling by CSS or jQuery
  • Paging section in Edit page
  • jQuery and jQuery Mobile updated
  • JsRender updated
  • New stylesheet for JsCalendar to match Bootstrap style
  • Sequence number option for List page
  • tinyMCE and CKEditor extensions (for registered users only) updated with latest versions (FCKEditor extension not provided any more)
  • FileManager for CKEditor extension (for registered users only)
  • PHPExcel extension (for registered users only) updated
  • Mobile_Detect.php updated
  • "Ends With" search operator
  • One more font for Captcha extension
  • 100% site height
  • Password Recovery security improved
  • System requirement updated to PHP >= 5.2
  • Many other minor improvements

New in PHPMaker 9.0.1 (May 14, 2012)

  • New Table Setup Page:
  • A new Table Setup page is added next to Field Setup page for quick access to current table settings.
  • Improved Dynamic Selection Lists:
  • Now supports up to 4 pairs of parent field and filter field.
  • Improved Add Option Form:
  • Supports JavaScript features such as DHTML editor, JSCalendar, Dynamic Selection Lists, etc.
  • Improved Preview Row Extension (for registered users only):
  • Shows detail tables in TabView.
  • Custom Template:
  • Allows showing fields with your own template.
  • Default Search Values:
  • Lets you specify default search criteria when there is no user inputted criteria.
  • Scripts without Header and Footer:
  • Lets you include PHPMaker generated scripts in your own PHP scripts more easily.
  • IIS Express:
  • Test generated site without the need to to configure web server. (Requires IIS Express installed on the same machine as PHPMaker.)
  • 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
  • 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
  • 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)
  • 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

New in PHPMaker 8.0.0 (Feb 10, 2011)

  • Oracle Support:
  • In additional to MySQL, PostgreSQL, Microsoft Access and Microsoft SQL Server, PHPMaker now supports Oracle also.
  • Improved Grid-Add and Grid-Edit:
  • Support adding/deleting rows to/from the grid during Grid-Add/Edit.
  • Master/Detail-Add and Master/Detail-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.
  • Export to PDF:
  • A new extension for export to PDF is provided. (Note that this extension is experimental only, read Third Party Tools for more information.)
  • Create, Alter and Drop Views:
  • 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.
  • Menu with Grouping (Graphical Extension):
  • In addition to vertical and horizontal menu, the graphical extension now uses YUI menu and support grouping.
  • Field Hint as Tooltip:
  • 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 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
  • Table synchronization (instead of sychronizing the whole database)
  • Option to show loaded tables only (for use with "Load tables dynamically" option)
  • Improved sortable and searchable lookup fields
  • Hyperlinks for export as cListOptions object. Allows manipulating export links like list options.
  • Improved user interface with Unicode support. Resizes better in 64bit Windows.
  • Multi-Langauge support for user values in Edit Tag panel
  • Advanced setting for maximum number of suggested options in AutoSuggest
  • Selectable font for CAPTCHA extension
  • Updated extensions (CKEditor, TinyMCE)
  • jQuery extensions (includes jquery.js for user's own use only. PHPMaker does NOT use jQuery.)
  • Detect password in simple ':' format (PHPMaker does NOT create salted password.)
  • Convert ASPMaker or ASP.NET Maker project file to PHPMaker project
  • Other minor improvements

New in PHPMaker 7.1.0 (Oct 7, 2010)

  • User_PasswordExpired event fixed
  • $_FILES['userfile']['error'] checked
  • Image Resize extension - AlwaysKeepAspectRatio option added
  • Improved Unicode Property Editor
  • Copy Table Settings
  • Allow converting Custom View to database view
  • setPhrase/setProjectPhrase/setMenuPhrase/setTablePhrase/setFieldPhrase methods added for language class
  • Blank phrases in language file removed
  • Import menu items for charts from PHP Report Maker
  • Compatible with PHP Report Maker 4
  • Other minor improvements and bug fixes

New in PHPMaker 7.0.1 (Mar 2, 2010)

  • utf-8 field names allowed
  • Table filter considered in non List page
  • "AllowNoPager" advanced settings added
  • Custom validation for username and password field allowd in Registration page
  • md5 password change detected
  • Export- to- email in View page without pager fixed
  • "Back to Master List" ignoring paging after search fixed
  • ListOptions properly rendered for PHP 4
  • Aggregate values properly formatted
  • Upload path (relative to application root) properly converted for viewing file
  • Image Resize extension - not keeping aspect ratio allowed
  • Details Preview extenions - tooltip value and multi-language field caption fixed
  • Other minor improvements and bug fixes

New in PHPMaker 7.0 Build 7600 (Jan 11, 2010)

  • In additional to MySQL, PHPMaker 7 supports the following databases also:
  • PostgreSQL
  • Microsoft Access (Windows OS only)
  • Microsoft SQL Server (Windows OS only)
  • Enhanced Record Links
  • Show number of the detail records (optional)
  • Show detail records in the main table by row expansion (Note: Extension for registered users only)
  • Record links (Edit/Copy/Delete/Detail) are now customizable by server events
  • Tooltip Field
  • Enables showing another field value (e.g. a memo field) when the mouse cursor is moved over a field.
  • Email Records (Export to Email)
  • Allow user to email records as URL or HTML. Options to email all pages, or records in the current page, or selected records in the current page.
  • More Control on Files Generation
  • Allow user to select exactly which file to generate. More precise partial regeneration. Much easier to change settings and generate another version of a particular page.
  • More Tools
  • Advanced Settings - More options and flexibility for code generation
  • Copy Field Settings - Fast setup of fields by copying existing field settings from existing table
  • Sort Tables Alphabetically - Sort the display order of tables in the user interface
  • Delete Template Cache - Easier to delete and re-build template cache when template cache get corrupted
  • Languages - Allow selecting languages and default language for Multi-Language project (data in database must be in unicode or utf-8)
  • Unicode Property Editor - Allow using unicode for some text properties such as table/field caption and menu text
  • Improved Server Events and Client Scripts Editor
  • Highlighting implemented events in the treeview
  • Search Dialog
  • Find and Replace Dialog
  • More Server Events
  • Database_Connecting - Fired before database connection. Allow change of connection string.
  • Page_Redirecting - Fired before page redirection. Allows change of URL that the page is redirecting to.
  • Recordset_SearchValidated - Fired after Form_CustomValidate. Allows change of search criteria before searching.
  • Row_UpdateConflict - Fired if conflicts is found before updating a record. Allows resolving conflicts by your own business logic.
  • User_PasswordExpired - Fired in Login page if the user password has expired
  • User_Registered - Fired in Registration page when a new user is successfully registered
  • User_Activated - Fired in Registration page when a new user is successfully activated (if user activation is required)
  • User_RecoverPassword - Fired in Password Recovery page when a password is reset
  • Message_Showing - Fired before message is displayed. Allow rephrasing the error message.
  • More User Login Options
  • Prevent concurrent user login using the same user name
  • Limit failed login attempts and lockout user if limit exceeded
  • Password Expiry
  • Selectable login options (Auto-login/Remember username/Always Ask)
  • Record Conflicts Checking before Update
  • Prevent concurrent record update. The edited record will be checked for changes before being updated.
  • Vertical/Horizontal Menu (Graphical Extension)
  • The graphical extension now supports both vertical and horizontal menu.
  • Many More
  • Custom menu items with option to allow Anonymous User or not
  • Allow adding detail record immediately after adding master record using Return Page
  • Using charset setting during export
  • Maintain scroll position during Inline-Edit
  • Audit trail with database table
  • Optional sortable and searchable lookup fields (without lookup table filter)
  • Validation by regular expression and custom server/client-side validation function with arguments
  • CAPTCHA in Edit page (in addition to Add/Registration pages)
  • Allow changing Multi-Page tab styles in theme
  • Multi-Language project (data in database must be in unicode or utf-8)
  • UTF-8 project file
  • Site icon
  • Updated extensions (CKEditor, TinyMCE)
  • Other minor improvements

New in PHPMaker 6.0.0 (Dec 2, 2008)

  • PHPMaker 6 is a major upgrade from 5.x. It is loaded with a bunch of new features, including many frequently requested ones. PHPMaker 6 is probably the most powerful and flexible product of its kind, and yet still easy-to-use as always.
  • More than a dozen of themes for your selection. You can choose the styles of the grid with matching colors in no time. You can easily tune the theme after choosing one or even create your own themes.
  • With the new Menu Editor you have full control on the menu items. You can re-order the menu items, add your own menu items for external pages or custom URL and use submenus.
  • Complementing the existing Grid-Edit feature, PHPMaker 6 offers Grid-Add feature, now you can add multiple records to a regular table or a detail table for a master record simultaneously in the List page.
  • Previously Auto-Suggest did not support foreign key fields. Now you can also use Auto-Suggest with these fields and type the beginning characters of the lookup values to get suggested values. The selected record's key field value will be properly saved.
  • Much easier to set up fields for Auto-Fill with the new setup form now. Also, previously only textbox fields were supported, now other fields such as textarea are also supported.
  • Now Multi-Page is presented as tabs, you can even change the captions of the pages. In addition to Add/Edit page, Multi-Page can also be optionally applied to the View page as well.
  • Now both server side validation and client side validation are supported. You can use either or both in a project. Custom validation with your own server side and/or client code is also supported by Server Events and Client Scripts (see below).
  • Previously Export-to-HTML is used as printer-friendly version, now you can have separate versions. While printer-friendly will use the same fields as the List/View page, fields for export to other formats can be different now. You can also change the behavior of exporting the records (all records or only records in the current pages) and the field values (looked-up values or original field values) by configuring the config file or using server events.
  • Return page - allows specifying custom return URL after adding/editing/registering
  • MD5 and case-sensitive password
  • Searching multiple selection values (stored as comma separated values) using partial match (previously it must be exact match)
  • Collapsible Quick/Extended Search panel by default
  • Advanced extension settings - allow table/field level settings for extensions
  • Many other minor enhancements

New in PHPMaker 4.3 (Dec 19, 2006)

  • Advanced Security
  • User registration system
  • Export to CSV/HTML/Excel/Word/XML
  • File uploading to database or folder
  • Master/Detail
  • Custom View
  • Report
  • Customizable template
  • Database re-synchronization