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