housamz/php-mysql-admin-panel-generator
Stars: 126
Forks: 76
Pull Requests: 3
Issues: 15
Watchers: 15
Last Updated: 2021-03-06 14:29:58
PHP MySQL Admin-panel Generator (MAGE), a PHP tool that helps you create a PHP CRUD system for any MySQL database in seconds.
License: Apache License 2.0
Languages: PHP, CSS, HTML, Hack
MAGE :: PHP MySQL Admin Panel Generator
Available for Python also: Python Mage
PHP MySQL Admin Panel Generator (MAGE), a PHP tool that helps you create a PHP Admin Panel for any MySQL database in seconds.
Mage is not PHPMyAdmin; it doesn't contain all your databases. It physically creates an admin panel for a database.
A suggested use-case for the tool would be creating an admin panel for a PHP / MySQL project in seconds, and then you can tweak it before delivery.
You may use this tool for charity or school projects, for commercial use, please contact me.
Name
MAGE is derived from MySql Admin panel GEnerator.
Mage (meɪdʒ): a magician or learned person.
Disclaimer: Always backup your database.
Instructions:
Note: You need to make sure that you have php-mysql package that connects PHP with MySQL, and that you change the generated directory permissions to be 777.
| Step | Thumb | Instructions |
|---|---|---|
| 1 |  |
Start by providing your MySQL Server Info, then click Next Step button. |
| 2 |  |
The tool will scan the server for available databases and list them in a dropdown menu, select the database that you want, then check if you need full HTML editor or not, and then click "Generate Admin Panel" button |
| 3 |  |
After a few seconds, you'll get a success message, with a link to the newly created admin panel, and a report of all the operations that were done. |
| 4 |  |
Click the link to the admin panel. You have to sign in using "admin" as an email and a password. |
You'll get a clean bootstrap interface to control the website, check below screenshots:
Notes
MAGE handles data using htmlentities as well as addslashes to prevent XSS attacks. This means that any HTML tags, especially those generated by the CKEditor, will be encoded.
If you want to display the original HTML code use html_entity_decode() around that specific field.
If you don't need HTML tags at all, you can disable CKEditor by unchecking the checkbox before clicking "Generate Admin Panel".
Debugging:
Nothing happens when you provide credentials on home page
You need to install php-mysql package, the following installs the latest version.
sudo apt install php-mysql
service apache2 restartNothing happens when I click Generate button
Change the generated directory permission to 777
chmod 777 generated