PHPMaker is a powerful automation tool that can generate a full set of PHP scripts quickly from MySQL, PostgreSQL, Microsoft SQL Server, Oracle and SQLite databases. Using PHPMaker you can instantly create web sites that allow users to view, edit, search, add and delete records on the web. PHPMaker can also create summary reports, crosstabs reports and dashboards with jаvascript (HTML5) charts (column, bar, line, pie, area, doughnut, multi-series and stacked chart) to summarize and visualize your data. PHPMaker is designed for high flexibility and has numerous options for generating PHP applications that best suits your needs. The generated code is clean, straightforward and easy-to-customize. The PHP scripts can be run on Windows servers or Linux servers. PHPMaker can save you tons of time and is suitable for both beginners and experienced developers alike.

Pages
List
View
Add/Copy
Edit
Delete
Update
Search
Master/Detail-Add/Edit/View

Reports
Summary
Crosstab
Dashboard
Drilldown

Charts
Bar
Column
Line
Area
Doughnut and Pie
Drilldown
Mixed

What's New in PHPMaker 2021
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

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

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")
jаvascript compressor with ES6+ support
Moment, jQuery File Upload, TimePicker, dompdf, CKEditor and tinyMCE updated
Many other minor improvements

Only for V.I.P