The Bootstrap Admin Forms are built with PHP Form Builder. They are located in the admin/inc/forms/ folder.
PHP Form Builder is included in PHP CRUD Generator's package.
With all its functionnalities and plugins.
The MySQL queries sent to your database are built with PHP Form Builder's PDO wrapper class.
Documentation and sample codes are available here on PHP Form Builder's website.
All the Admin forms are located in the same folder in admin/inc/forms/.
Each table uses 3 forms:
where "table" is the sanitized name of your table.
All the actions (database recordings) are done in the same files after validation.
From the CRUD generator, two configuration options are available.
The first allows you to display details only when an SQL query fails and an error occurs, while the second systematically displays details of all SQL queries (DEBUG mode).
Activate this option from the CRUD Generator "Configuration" tab.
When a SQL query returns an error, details of the query will be displayed on screen, including the query in PDO format with placeholders, the query generated in SQL format sent to the server, and the error message returned by the database.
Activate the "Debug" mode from the CRUD Generator "Configuration" tab.
When Debug mode is activated, all the queries are displayed in detail on the screen, both in the lists and in the admin forms.
The details of each query are available in PDO with any placeholders, filters and options, and in SQL format as the database receives them.
With the DEBUG mode enabled. The INSERT, UPDATE and DELETE queries are only simulated, allowing to debug without making any change to your records.
You can then copy/paste your SQL queries directly into your database manager (PhpMyAdmin or similar).
You'll see in return if a field has an invalid value, or if there's some other problem in the query.
If the query works in your database manager but not in PHPCG, there can be 2 causes:
To edit the Bootstrap Admin Forms you must beforehand:
The Bootstrap Admin Panel
Files & logic