Bootstrap Admin Dashboard Demo - Sakila database

You are here in the Bootstrap admin Dashboard generated by PHP CRUD generator from the MySQL demo Sakila database.

With PHP CRUD Generator you can build this kind of website admin Dashboard in a few minutes, without programming.


Here you can view and manage all your website content using the CRUD App. functionalities.

Switch to the CRUD Generator

PHPCG uses the SAKILA Database, which is provided with the package for demo purposes.

The SAKILA database is composed of many different types of fields, internal, external, one-to-one, one-to-many relationships, and thus allows in-depth testing of the functionalities offered by PHPCG.

The different tables have been grouped into 3 categories: Customer Data, Inventory and Business.

The various read lists will give you an overview of the power of PHPCG.

They have all been generated natively, without any customization and include:

  • Internal/external filters
  • Nested tables
  • Expandable data
  • Edition in place
  • Sort by columns
  • Excel/CSV export
  • Configurable pagination

The ADD/EDIT/REMOVE forms are also generated using only native PHPCG features and use the best jQuery plugins for a better user experience.

In real life, all this is protected by the authentication and rights/profile management module.

Access to data can be limited for each user: choice of accessible data, authorization to add, modify or delete data.

Each user's access can very simply be limited to their own records.


The dashboard admin is using Bootstrap 4, jQuery and Symphony's TWIG template engine.

Forms are built with PHP Form Builder (which is included in the package), a powerful form generator. This makes it easy to customize your forms if you need some specific functionalities. All security, real-time validation and server-side are integrated.

Source code examples of the admin dashboard lists and forms are available here in the CRUD documentation.

The generator offers many features and options, not all of which are shown in this demo:

  • Customization of the dashboard admin using the Bootstrap 4 themes available
  • Customization of the home page, lists and forms, adding of scripts
  • Creating new entries in the navigation menu
  • Organization of the navigation menu, management of categories for each entry

The Sakila Database illustrates how PHPCG is able to recognize different relationships between tables. This tutorial explains the basics of MySQL relational logic: direct and indirect relations, one-to-many and many-to-many relations.

As your project evolves, when you create new MySQL tables, new fields, or modify in one way or another the existing structure, you just have to update your modifications from the CRUD Generator, then restart the generation of your pages to report your changes in your admin dashboard. Your project is perfectly scalable, the generator keeps all your data and preferences.

For any question, information, do not hesitate to contact us by chat on this website or email. ..