PHP CRUD Generator is a program developed in pure PHP for building your complete Bootstrap administration panel using a visual UI.
PHPCG is suitable for both non-programmers and advanced PHP programmers, who will have access to a clean and well organized code so they can take advantage of all its potential.
PHPCG is able to analyze your database, extract tables, fields and any type of relationship intelligently.
mb_string extension enabledinstall/index.php - in your browser.generator/generator.php - in your browser. The installer:
Don't change anything here unless you know what you're doing.
This file contains some global settings that can be customized
generator_locked
admin_locked sitename
admin_logo
admin_action_buttons_position
auto_enable_filters
lang
locale_default
datetimepickers_style
datetimepickers_lang
users_password_constraint
collapse_inactive_sidebar_categories
Bootstrap CSS classes for the Admin Panel can be customized using the General Settings form
To protect access to the generator:
Lock the Generator to trueChoose your database in the dropdown list and validate. You will then see the complete panel appear.
Click the "Add Filter" button in the Read Lists generator form to add a new filter.
This will add a new filter to your list.
PHPCG offers you 2 types of filters:
You just have to choose the field to filter in the dropdown list.
Advanced filters are useful:
To use advanced filters it is necessary to enter query parameters with joins.
A help button is available to help you build your query, as well as a preview button that allows you to view the generated drop-down list and check its validity.
Click the Install User Authentification Module button to launch the installer.
The installer will create the users and the users_profiles tables
You will also have enter the main administrator informations.
The main administrator can then manage users and profiles in the admin panel.
The CSS of the Admin Panel can be customized very easily using the general settings form.
You can:
SASS users: all SASS sources are available
Gulp users: Download PHP CRUD Generator Gulp on Github to edit and compile your SCSS source files
If your database structure changes along the way, PHPCG is able to rebuild the data and allows you to regenerate the corresponding CRUD pages.
When generating administration panel pages, PHPCRUD automatically keeps a backup of the previous version.
The file comparison tool integrated with the generator allows you to compare side by side your current version and the previous one, and to merge them by choosing the code blocks to be retained.
Administration customizations can thus be retained during version/structure changes.
When a new version is released, you'll see the "New PHP CRUD GENERATOR version is available" message in /generator/generator.php and will just have to click the "Install" button.
PHP CRUD Generator and the generated Bootstrap admin panel are both fully multi-language.
To translate to your own language:
define('LANG', 'en'); with the filename you used previously. PHP Form Builder is included in the package and you can use it without restriction on the same domain as your CRUD.
This means that you can build any form you want on your website/project and use the integrated plugins & functionalities.
To use PHP Form Builder in your project, include the main conf file on your page add this code at the beginning of your file:
use phpformbuilder\Form;
session_start();
include_once include_once rtrim($_SERVER['DOCUMENT_ROOT'], DIRECTORY_SEPARATOR) . 'conf/conf.php';
include_once CLASS_DIR . 'phpformbuilder/Form.php';Then you can build your forms. Documentation is available on the official website: https://www.phpformbuilder.pro
Many thanks to the authors for their great work
Bug Fix:
- Fix the Admin Dropdown Search field cross-browser compatibility
(rebuild your lists to apply)
New Features:
- New live search with Ajax Autocomplete for Bootstrap Admin Panel READ lists
(rebuild your lists to apply)
Improvements:
- Update Material Pickers for compatibility
New Features:
- Admin filters now can deal with JSON array values (select multiple, checkboxes)
- New PHP CRUD Generator Tutorials channel on Youtube: https://www.youtube.com/channel/UCo1PBjNNOWUQrfNRqjLz6LQ
Improvements:
- Array values from database now displayed as comma-separated values instead of raw JSON
- improve the online Documentation & Tutorials
Bug Fix:
- Rewrite code to limit users rights to their own records
(rebuild your lists / forms to apply)
New Features:
- 20+ new Bootstrap themes are now available
- Choose your prefered Bootstrap theme from the General Settings form
- Customize all the main layout Bootstrap CSS classes from the General Settings form
- Compile the SASS files with Gulp using the new PHP CRUD Generator Gulp Github repository - https://github.com/migliori/php-crud-generator-gulp
- New tutorial for Admin Theming & CSS: https://www.phpcrudgenerator.com/tutorials/how-to-customize-the-bootstrap-admin-panel-css
Bug Fix:
- Great, no known bug!
Improvements:
- The General Settings form in the generator now allows to change the Bootstrap admin main body class
Bug Fix:
- the installer was broken by the previous changes. Solved now.
- Edit in place is no more available in Admin READ lists for users with insufficient rights
- the broken "enable/disable" authentication module in the Generator now works again
New Features:
- The date & Time pickers languages can now be defined in the General Settings form
- You can now choose the style of the Bootstrap admin date & Time pickers
(default | Material Design)
- New Italian translation - Many thanks to Alberto
New Features:
- New General Settings form available in the Generator
- The action buttons of the Bootstrap Admin panel can now be on the left or right of the table
- The filters of the Bootstrap Admin panel can now be triggered automatically when selected
- You can change the site title and admin logo using the General Settings form
- You can change the admin language using the General Settings form
- You can change the admin skin using the General Settings form
Improvements:
- Show custom table names in Admin READ lists nested tables
Bug Fix:
- The Validation button in the Generator should now never overlap the forms
New Features:
- Action buttons in the admin panel can now be displayed in the
1st column of the admin READ lists
Improvements:
- Responsive & others in admin CSS
Bug Fix:
- datepicker plugin
- files & images upload
- tooltips
(these bugs were due to the previous update with latest PHP Form Builder)
Bug Fix:
- fix sorting buttons in admin panel READ lists
Bug Fix:
- fix export to excel/csv in admin panel
New Features:
- replace PHP Form Builder with the latest version 4.2.1
Improvements:
- Admin Panel Fast Loading optimization with the new LoadJS features
- PHP CRUD Fast Loading optimization with the new LoadJS features
- rewrite queries for admin restricted users rights
- upgrade Bootstrap to the latest version 4.3.1
- minor various others improvements
New Features:
- add new Export features (print - current view - all records) in admin READ lists
New Features:
Improvements:
- add (very) strong protection for fileuploader plugin uploads
Bug Fix:
- remove some PHP warnings
- solved admin sidebar duplicate items issue
Bug Fix:
- fix navbar issue with empty icons
New Features:
- New "array" field type in generator for checkboxes & select multiple values
will show JSON decoded values in the READ lists
Improvements:
- better admin navbar content management ("Organize Navbar")
- improve array values management in the generator
Bug Fix:
- fix non-working select multiple with "set" & "enum" field types
- fix changelog url in auto-update success message
New Features:
- License system now accepts domain with multiple extensions
ie: domain.com, domain.eu, domain.co.uk are all valid with the same license.
- New button in the Generator to reload fresh database structure
(When you add or remove tables)
Improvements:
Bug Fix:
- admin filters now accept zero values
- fix queries in admin lists on external tables with direct relation (no intermediate table)
New Features:
- external records from relational tables can now be managed
from the READ LISTS & the CREATE/UPDATE forms (!)
- add self-referential foreign keys management
- tables can now be removed/re-enabled from the admin navbar
- add Spanish admin translation (Thanks to Sergio)
Improvements:
- export buttons (csv/xls[x]) now export the exact filtered list items
- align single fields on the left in admin panels
Bug Fix:
- remove phone validation in auth. module installer
- logout from generator/generator.php now does its job as intended
- upgrade PHPMailer to latest 6.0.6 to fix PHP 7.3 warnings
Bug Fix:
- fix inverted label & value in form CREATE/EDIT templates
- protect relation tables SELECT queries in form CREATE/EDIT templates
New Features:
- new "Add New" button in admin READ lists on external nested tables even if no record
Improvements:
- ADMIN panel: register URL query parameters in $_GET (Altorouter ROUTES doesn't deal with these).
- the ADMIN ADD & UPDATE forms now redirect to the correct list if we come from a nested table (external relation)
- move date_default_timezone_set from conf/conf.php to conf/user-conf.php
- add Help & instructions for Microsoft IIS & NGINX servers
Bug Fix:
- "Add New" button in admin READ lists now always targets the right CREATE form
even if there's several external nested tables in the list.
- Fix several warnings & minor issues
New Features:
- add "Add New", "Edit" & "Delete" buttons in READ Lists nested tables for external tables records
Improvements:
- add compatibility for date & time without PHP intl extension
Bug Fix:
- definitely fix the Apache mod_security error on the install process with some misconfigured servers
Warning: If you admin READ lists have date or datetime fields, open the corresponding templates in /admin/templates, find the functions toDate(...) and replace the date PHP format with the corresponding ICU date format.
new online PHP CRUD Tutorials
New Features:
- PHPCG includes now the complete latest PHP Form Builder version with all its features & plugins.
- Add the online knowledge base with numerous tutorials & videos
Improvements:
- improve date & time translations management - https://www.phpcrudgenerator.com/tutorials/how-to-translate-dates-times-in-admin-panel
- add full date & time translation in admin lists & forms
- change admin form action from absolute url to root relative url
- add install/curl-test.php to help with CURL debbuging
Bug Fix:
- the generator now retrieves the correct stored values to be displayed in READ lists for the external fields
- get the correct time value in admin edit forms with datetime fields
- solve plugins URL detection with paths containing uppercase letters
Improvements:
- dates edit in place now get the current field value
- image now crop from the center
Bug Fix:
- fix missing fields in update forms due to previous update error
- fix admin lists bug with fields having uppercase characters
- fix admin edit in place with dates & uppercase table name
Improvements:
Bug Fix:
- fix Generator form create profiles
Notes:
- After this update you may have to reinstall the user authentification module from the Generator page.
Improvements:
- update server-side validation functions to accept empty values,
except for the validators whose internal logic make values required.
Details available here: https://www.phpformbuilder.pro/documentation/class-doc.html#php-validation-methods
- the User Authentification Module now keeps the users & users profiles tables and records when uninstalling.
- the User Authentification Module can now be reinstalled even if the users & users profiles table exist
- improve user profiles management and rights limitations
- the users rights changes now take effect without clearing the session
- the admin sidebar doesn't show empty categories anymore
- the only required fields in users table are now name, firstname, profile ID, email, pass & active
(takes effect on new User Authentification Module installs only)
- add simulate property to Generator.php to simulate when we reset a table structure from generator
- remove several warnings & improve various feedback messages
Bug Fix:
- solve problem with updates & SSL errors on misconfigured servers
Notes:
- After this update you may have to reinstall the user authentification module from the Generator page.
Improvements:
- set default empty value for passwords in UPDATE FORMS
Bug Fix:
- solve CREATE/UPDATE forms generation with custom validation
- solve READ LISTS generation with advanced filders
- solve image path in admin when the field thumbs are not enabled
- remove password validation in UPDATE FORMS if posted value is empty
- correct select values count in generator CREATE/UPDATE forms with custom values
- solve error 500 when adding new users
New Features:
- add an uninstallation process
- add a login module for the generator on the production server
- primary key management in admin forms
Improvements:
- remove the "select database" form in generator & auto select the correct database
- add warnings for non-standard tables & field names (hyphenated)
- improve password fields management in CREATE/UPDATE forms:
better password encryption with Secure class
password are now automatically optional on update forms with an helper text: "Leave blank to keep the current password"
- turn fileuploader debug on for CREATE/UPDATE forms
- improve documentation
- improve auto-validation detection according to forms & database field types
Bug Fix:
- revert Twig template engine to version 1.35.4 to preserve PHP < 7.0 compatibility
- regenerate css & js combined plugin files for CREATE/UPDATE forms when the forms are edited with the generator
- fix generator which failed to validate when custom validators were selected while generating the CREATE/UPDATE forms
- fix password encryption when changes are made in CREATE/UPDATE users table
Improvements:
- add user-conf file to avoid breaking user custom settings with updates
- move the install folder outside the generator folder.
- improve the updater script
- improve url & path management
Bug Fix:
- fix server issues in some special configurations
Warning: if your authentification module is not enabled, after the update open php-crud-generator/conf/admin-lock.php and set ADMIN_LOCKED to false.
Improvements:
- move ADMIN_LOCKED and ADMIN_LOGO to separate files for easier updates
Bug Fix:
- fix several minor bugs
Bug Fix:
- fix authentification module installation (wrong users filters)
New Features:
- add File uploader to Generator + Admin panel
- add version check & auto-updater
Improvements:
- update dependencies & move to vendor with Composer
- improve ROOT path analysis
Bug Fix:
- correct date & time validation
- correct value/display inversion with live-edit custom select
First Release