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

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

- 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

Calendar Report ("dayGridMonth" view)

Context menu

Popover with matching style

Year view

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

Chart with trend line

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


  • 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

Links with icons
Button group
Button dropdown
Button group in paging section
Button dropdown in paging section

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

formatted text

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)

Expandable row


Nested preview

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

Multi-column Radio button list

Multi-column Checkbox list

Selection list (select-one)

Selection list (select-multiple)

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


With Option Template

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
  • Option to login by 2nd factor only

Server Events and Client Scripts

Custom Template

Custom Template as table

Custom Template as cards

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

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 ![editor](docs/images/editlangtemplate.png)

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


Field Visibility (Extension for Registered Users Only)

DateTime Picker

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



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


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


Swagger UI

HTTP response

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

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 ![light](docs/images/chatlight.png)    ![dark](docs/images/chatdark.png)

Progress Window with Text Color and Color Schemes

Supports text color and color scheme like Windows terminal. ![progress window](docs/images/progressform.png)


  • 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