Features

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

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

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


Offcanvas


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

Auto-Suggest


With Option Template

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


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




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


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

![maintenance](docs/images/maintenance.png)

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)

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