Supports 5 database types

• MySQL, PostgreSQL, Microsoft SQL Server, Oracle, SQLite, on Linux or Windows web server
• Support encryption connection with MySQL/PostgreSQL
• URL connection script to simulate direct connection with MySQL
• SSH Connection for MySQL and PostgreSQL
• Doctrine ORM (Basic mapping)

 

---

List, Add/Copy, View, Edit, Delete, Multi-Update and Search pages

 

---

Multi-Column List Page - Table/Cards Views

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

 

---

Modal Dialogs

• Add/Copy, View, Edit, Delete, Multi-Update and Search pages in List page
• Login, Registration, Change Password, Password Recovery page

 

---

Optional Tabular Form for Desktop Mode

 

---

Summary Report

Detail and summary report

Compact summary report

 

---

Crosstab Report

---

Calendar Report

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
Supports dark mode

---

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)
100% Stacked Charts
Polar Area Charts
Radar charts

 

 

---

Drill Down Reports and Charts 

Drill down reports

Drill down charts

 

---

Dashboard Report with Query Builder

 

---

Grouping Intervals for Reports
 

Summary Report			Crosstab Report
Numeric field	Text field	Datetime field	Datetime field (for Column Headings)
Normal (All distinct values) 10s 50s 100s 500s 1000s 5000s 10000s	Normal (All distinct values) 1st Letter 2 Initial Letters 3 Initial Letters 4 Initial Letters 5 Initial Letters	Normal (All distinct values) Quarter Month Week Day Hour Minute	Year Quarter Month Date Date/Time (with optional year filter for "Quarter" and "Month")

 

---

Datetime Field Filters for Reports

Relative Days	Relative Day Periods	Relative Weeks	Relative Months	Relative Years	Past/Future
Yesterday Today Tomorrow	Last 30 days Last 14 days Last 7 days Next 7 days Next 14 days Next 30 days	Last two weeks Last week This week Next week Next two weeks	Last month This month Next month	Last year This year Next year	Past Future

 

---

Linked Tables from Multiple Databases

 

---

Responsive Layout with Bootstrap and AdminLTE

19 theme colors with Bootstrap 5.3 and AdminLTE 3.2
User image and user name in sidebar
Sidebar search (for searching menu items)
Navbar search (as Quick Search input for tables)
Dark mode

 

---

RTL

Detect RTL languages by language ID
Generate and use RTL stylesheets automatically

 

---

Mobile Menu

 

Bootstrap Toast

 

Load JavaScript asynchronously and Bootstrap Spinner

Show spinner when JavaScripts are being loaded asynchonously on page load.

 

---

Toolbar with Breadcrumbs, Vector Icons and Tooltip

 

---

Export to Printer-friendly, HTML, Word, Excel, CSV, XML, Email, PDF

 

---

Links, Button Groups, and Button Dropdowns

 

---

Grid-Add, Grid-Edit, Inline-Add, Inline-Copy, and Inline-Edit

 

---

Master/Detail-Add/Edit/View and Multiple Master/Detail

 

---

Referential Integrity, Cascade Delete and Cascade Update

---

Optional Confirmation Page Before Inserting or Updating Record

---

Pagers in List/Edit/View page

---

View Tag and and Edit Tag Options

---

File Upload to Folder or Database (Supports Mulitple File Upload to Folder)

---

Quick Search, Extended Search and Advanced Search

---

User ID Security and User Level Security

---

User Registration System

---

Password Generator and Password Strength Meter

---

Theme with Bootstrap and AdminLTE Variables

---

Menu Editor (Support Icons)

---

Multiple Master/Detail Relationships

---

Preview Field

---

Detail Preview as Expandable Row, Popover, Modal or Offcanvas (Extension for Registered Users Only)

---

User CSS (Supports Sass)

---

Create, Alter and Drop Database Views and Query Builder

---

User Selectable Page Size

---

Table Row Colors

---

Add New Option to Selection List

---

Dynamic Selection List with Multiple Display and Parent/Filter Fields

---

Dropdown Selection Lists

---

Option Template for Dropdown Selection Lists

---

Modal Lookup Dialog (Supports Searching)
Pagination (Infinite Scrolling)
Draggable

---

Table Header Filter
Excel filter style
Work together with other fields in Extended Search
Searchable
Pagination (Infinite Scrolling)
Dropdown positioning by Popper

---

Auto-Suggest

---

Multi-Page Add/Edit/View Pages (as Tabs/Pills/Accordion)

---

Login Page (Supports Modal Dialog, Google/Facebook Login, and CAPTCHA)

---

Web Push Notifications
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

---

Two Factor Authentication (Google Authenticator, Email and SMS with Third Party API)
Opt in/out or forced 2FA
Backup codes
Administrators can reset user secret
Option to login by 2nd factor only

---

Server Events and Client Scripts

---

Custom Template

---

Code Editor

---

Column Visibility

---

Code repository

---

Multi-Language Property Editor

---

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

---

Fixed Header Table

---

Query Builder

---

 

Colorbox

---

Field Visibility (Extension for Registered Users Only)

---

DateTime Picker
Dropdown positioning by Popper
Support ICU date format
Auto internationalization by native JavaScript Intl object

---

Timepicker (Extension for Registered Users Only)

---

Date/Time Formats without Seconds

---

Export as native Excel/Word with PHPWord and PHPSpreadsheet (Extensions for Registered Users Only)

---

Custom Fields

---

Custom View Tags
Barcode and QR code
YouTube videos
Google Maps (with MarkerClusterer)
Leaflet for OpenStreetMap and Mapbox (with MarkerClusterer, for registered users only)

---

Custom Edit Tag

---

Custom Files

---

Session Keep Alive and Session Timeout

---

Client Side Events and "fields" jQuery Plugin

---

Multi-Update Field Settings

---

Save Search Criteria

---

Cancel Button for Add/Edit/Delete/Update Pages

---

Server-side validation and/or client-side JavaScript validation

---

Auto-Focus
Focus the first field on page fully loaded
Focus first error field after server side validation

---

Field Input Help Text (Custom Message)

---

Template and Extensions as npm Packages
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

---

Auto Update to Latest Template and Extensions

---

Project History

---

Auto JS Template

---

REST API

---

Import from Excel/CSV

---

General Data Protection Regulation (GDPR)
Field Encryption extension (for registered users only) to encrypt selected fields with personal information

---

Check Table and Field Variable Names

---

Composer Package Manager
Search Composer packages from packagists.org within UI
Generate composer.json for project
Run "composer update" after generation

---

npm Packages
Search npm packages from npmjs.com within UI
Generate package.json for project
Run npm install after generation

---

Sharing Project with Other Users (via GitHub)

---

Pretty Error Page for Development

---

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

---

Progress Window with Text Color and Color Schemes
Supports text color and color scheme like Windows terminal.

---

More

Supports PHP >= 8.0.2
Use globally installed Node.js and npm
PSR-12 coding standard
Load classes by PSR-4
Logger for logging SQL and errors
Error handler and error page
Development/Production environment
Synchronize project with database
Field aggregates (sum, average and count)
Single or multiple column sorting
Audit trail with log file or database table
Email notification on Add/Edit/Delete
Dynamic table loading
Composite key
Auto-Fill child fields on selecting an option for the parent selection list
Hashed password and case-sensitive password
XSS removal
JavaScript compressor with ES6+ support
UI supports working behind proxy server
Regeneration by CLI commands
Fully customizable template and extensions

System Requirements

PHPMaker

• Windows 2012R2/2016/2019/8.1/10/11 (Windows 10/11 on ARM is NOT officially supported)
• .NET Framework 4.7.2 Developer Pack (or newer)
• PHP >= 8.0.2
• Composer (v2.5.8 or newer)
• Node.js (includes npm) (LTS >= v18.17.0 or Current >= v20.3.0)
• WebView2 Runtime

 

Server

• Linux or Windows web server
• PHP >= 8.0.2
• mod_rewrite (for Apache only)
• IIS Rewrite (for IIS only)
• Microsoft PHP drivers for PHP for SQL Server >= 5.9 (for Microsoft SQL Server), AND
• Microsoft OLE DB Driver for SQL Server (for Microsoft SQL Server)
• Oracle Client (for Oracle)

 

Browser
Chrome/Edge/Firefox/Safari/Opera (latest)

Also See
Composer
URL Rewrite