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/PostgreSQL

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

Table view


Cards view with 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

Calendar Report ("dayGridMonth" view)

Context menu

Popover with matching style

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)

Drill Down Reports and Charts

Drill down reports


Drill down charts


Chart with trend line

Dashboard Report

Grouping Intervals for Reports

Datetime Field Filters for Reports

Linked Tables from Multiple Databases

Responsive Layout with Bootstrap and AdminLTE

• 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)

RTL

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

Mobile Menu

Bootstrap Toast

Load JavaScript asynchronously and Automatic Page Load Progress Bar

Show progress bar 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, Multi-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 with Dropzone and Cropper (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/Azure/SAML 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

Enable notifications

Receive notifications

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

Server Events and Client Scripts

Custom Template

Code Editor

Browser-based code editor with rich features (Requires WebView2)

Auto-complete field names

Better Find and Replace

Indentation by Tab and Ctrl+Tab

Many more other commands

Column Visibility

Show/Hide table columns in List page during runtime

Code repository

Multi-Language Property Editor

Fixed Header Table

Query Builder

Internationalization (i18n) by PHP and JavaScript

• Auto locale settings (customizable) by native PHP Intl extension and JavaScript Intl object
• Format and parse by ICU number, currency and date/time formats

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

English

Chinese

Arabic (RTL)

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

Modify page content automatically on page load.

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
  
• Consent and privacy page
  
  
• Download and delete personal data page
  
  

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

More

• Supports PHP 7.4, 8.0 and 8.1
• Replaces out-dated Composer packages incompatible with PHP 8.1
• 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
• Fully customizable template and extensions