CRUD Admin Generator
What is CRUD Admin Generator?
CRUD Admin Generator (http://crud-admin-generator.com) is a tool to generate a complete backend from a MySql database where you can create, read, update and delete records in a database.
The backend is generated in seconds without configuration files where there is a lot of "magic" and is very difficult to adapt to your needs.
The generated code is fully customizable and extensible.
It has been programmed with the Silex framework, so the resulting code is PHP.
Clone the repository
git clone https://github.com/jonseg/crud-admin-generator.git admingenerator cd admingenerator
curl -sS https://getcomposer.org/installer | php
php composer.phar install
You need point the document root of your virtual host to /path_to/admingenerator/web
Generate CRUD backend
Edit the file /path_to/admingenerator/src/app.php and set your database conection data:
$app->register(new Silex\Provider\DoctrineServiceProvider(), array( 'dbs.options' => array( 'db' => array( 'driver' => 'pdo_mysql', 'dbname' => 'DATABASE_NAME', 'host' => 'localhost', 'user' => 'DATABASE_USER', 'password' => 'DATABASE_PASS', 'charset' => 'utf8', ), ) ));
Set your username and password (foo by default) data:
.. 'admin' => array('ROLE_ADMIN', '5FZ2Z8QIkA7UTZ4BYkoC+GsReLf569mSKDsfods6LYQ8t+a8EW9oaircfMpmaLbPBh4FOBiiFyLfuZmTSUwzZg=='), ...
You can obtain your password encoded with the following code:
echo (new \Symfony\Component\Security\Core\Encoder\MessageDigestPasswordEncoder())->encodePassword('foo', '');
You need to set the url of the resources folder.
Change this line:
$app['asset_path'] = '/resources';
For the url of your proyect, for example:
$app['asset_path'] = 'http://domain.com/crudadmin/resources';
Now, execute the command that will generate the CRUD backend:
php console generate:admin
This is it! Now access with your favorite web browser.
The command generates one menu section for each database table. Now will be much easier to list, create, edit and delete rows!
Customize the result
The generated code is fully configurable and editable, you just have to edit the corresponding files.
- The controller you can find it in /web/controllers/TABLE_NAME/index.php
- The views are in /web/views/TABLE_NAME
It has generated a folder for each database table.
If you want to contribute code to CRUD Admin Generator, we are waiting for your pull requests!
Some suggestions for improvement could be:
- Different form fields depending on data type.: datetime, time...
- Create admin user with a login and logout page.
- Generate CRUD for tables with more than one primary key.
- Any other useful functionality!