DEV Community: Gilles Migliori

Create your CRUD Application in PHP

Gilles Migliori — Tue, 09 Dec 2025 06:58:25 +0000

Create, Read, Update, Delete - manage your MySQL / PDO Database

Introduction & Prerequisites

PHP CRUD Generator is a powerful web application that allows to build Bootstrap CRUD Admin dashboards in PHP using an online User Interface.

What you need to get started:

A project based on a MySQL / PDO database
A PHP Server (PHP 7.x, PHP 8.x)
Buy PHP CRUD Generator at a ridiculous price that will save you weeks of hard work

This startup tutorial will teach you the basics, and allows you to quickly create your Bootstrap CRUD Admin Dashboard without programming.

Once you have understood the basics and started using PHP CRUD Generator, you will see that it is still simple and intuitive and will probably discover its wide range of features by yourself:

how to display dates and times?
how to use file and image uploads?
how to protect access to the admin with a login and password?
how to manage users and rights?
how to customize and organize the sidebar?
etc.

Although all these operations are always easy to achieve (usually just select your options in the generator, or click on the button corresponding to what you are looking for), you will find a tutorial for each step in creating your Bootstrap CRUD Admin.

Here's an overview of the type of CRUD Admin Dashboard that PHP CRUD Generator will build from your database:

Bootswatch themes are included and the user interface can be customized as desired.

How to create your PHP CRUD Application

Upload the required* folders on your server as described in the documentation
Open the installer - /install/do-install.php in your browser and follow the install process.
You'll need to enter your purchase code and your database connection informations.
Open the CRUD Generator - /php-crud-generator/generator/generator.php in your browser

The application has automatically detected your database and all its components: tables, fields, field types and relationships.
You can therefore see your tables in the drop-down list

Choose the 1st table for which you want to create CRUD operations in the drop-down list and validate your choice.
Select **one of the three available tabs to generate the pages and forms of your Bootstrap CRUD Admin**
- Build READ List: Generates the paginated data table
- Build Create / Update Forms: Generates the add / edit forms for the records
- Build Delete Forms: Generates the deletion form
The pages and forms of your administration are available and functional as you create them.

You can go to your Admin Panel at any time, test the features, then return to the generator and modify again the options of your choice if you want to make any changes.

php crud generator makes your bootstrap admin 100% scalable.

The smart system stores all your settings.

You can rebuild each element of your Admin Dashboard at will.

You can also modify the structure of your database, add or delete tables, fields, relationships, and then regenerate the different parts of your Bootstrap Dashboard.
Your CRUD Admin Dashboard is ready

You can now use your Admin Dashboard to manage your database using the available CRUD operations.

The necessary plugins and functionalities have been automatically integrated:
- calendars
- date translation
- sorting functions
- filters and data search
- export to Excel or CSV format
- printing
- file upload
- images with resizing and thumbnails
- etc...

A demo and full documentation are available on the PHP CRUD website.

Fast, efficient support guaranteed.

Reviews on major platforms

PowerLite PDO: A Powerful PHP Database Abstraction Layer

Gilles Migliori — Mon, 15 Apr 2024 17:17:18 +0000

PowerLite PDO is a PHP library that provides an efficient way to interact with multiple types of databases

Why this project?

PHP's PDO (PHP Data Objects) extension is a powerful tool for interacting with databases. However, its syntax can be verbose and cumbersome, especially for complex queries. While popular PHP frameworks like Laravel and Symfony offer their own Database Abstraction Layers (DBAL), these are often tightly coupled with the rest of the framework. If you're not using these frameworks, or if you prefer a more lightweight solution, you're left to deal with PDO's verbosity.

There are many standalone DBAL packages available, but finding a high-quality, well-maintained library can be a challenge. That's where PowerLite PDO comes in.

Introducing PowerLite PDO

PowerLite PDO is a PHP library that provides a lightweight and powerful abstraction layer for PDO. It's designed with a clear separation of concerns in mind, and it uses Dependency Injection (DI) to manage dependencies between different parts of the system.

The library is organized into three main components:

Db: The main interface for interacting with the database. It handles connection management, query execution, and result processing.
QueryBuilder: Used to build SQL queries in a flexible and extensible way.
Pagination: Handles pagination of query results.

Getting Started

To start using PowerLite PDO, you first need to enter your database connection parameters in the connection.php file. Then, you load the Dependency Injection (DI) container, which will provide you with instances of Db, QueryBuilder, and Pagination.

use Migliori\PowerLitePdo\Db;

$container = require_once __DIR__ . '/../src/bootstrap.php';

$db = $container->get(Db::class);

Now you can start using the Db, QueryBuilder, and Pagination classes to interact with your database.

Using the Db Class

The Db class is your main interface with the database. Here's a simple example of how to use it:

use Migliori\PowerLitePdo\Db;

// Load the DI container
$container = require_once __DIR__ . '/../src/bootstrap.php';

// Get an instance of the Db class from the container
$db = $container->get(Db::class);

// Set up the query parameters
$from = 'users'; // The table name
$fields = ['id', 'name', 'email']; // The columns you want to select
$where = ['status' => 'active']; // The conditions for the WHERE clause

// Execute the query
$db->select($from, $fields, $where);

// Fetch the results
$records = [];
while ($record = $db->fetch()) {
    $records[] = $record->id . ', ' . $record->name . ', ' . $record->email;
}

The Db class has taken care of preparing and executing the query in a safe and efficient way, using PDO's prepared statements. It has also fetched the results and returned them to you in a convenient format.

Others methods are available in the Db class for executing different types of queries, such as insert, update, and delete.

Here are a few quick examples:

// Insert a new record
$db->insert('users', ['name' => 'John Doe', 'email' => 'john@doe.email.com']);

// Update an existing record with id = 1
$db->update('users', ['email' => 'john@doe.email.com'], ['id' => 1]);

// Delete a record with id = 1
$db->delete('users', ['id' => 1]);

Building Queries with QueryBuilder

The QueryBuilder class provides another way to build and execute queries, for those who prefer a fluent and flexible syntax.

Here's an example of how to use the QueryBuilder class:

use Migliori\PowerLitePdo\QueryBuilder;

// Load the DI container
$container = require_once __DIR__ . '/../src/bootstrap.php';

// Get an instance of the QueryBuilder class from the container
$queryBuilder = $container->get(QueryBuilder::class);

// Build and execute a SELECT query
$queryBuilder->select(['id', 'name', 'email'])
    ->from('users')
    ->where('status', 'active')
    ->orderBy('name', 'ASC')
    ->limit(10)
    ->offset(0)
    ->execute();

// Fetch the results
$records = [];
while ($record = $queryBuilder->fetch()) {
    $records[] = $record->id . ', ' . $record->name . ', ' . $record->email;
}

Paginating Results with Pagination

The Pagination class helps you paginate the results of your queries. Here's for instance how you can use it:

use Migliori\PowerLitePdo\Db;

$container = require_once __DIR__ . '/../src/bootstrap.php';

$pagination = $container->get(Pagination::class);

// Set the pagination options for URL rewriting
$pagination->setOptions([
    'querystring' => '',
    'rewriteLinks' => true,
    'rewriteTransition' => '-',
    'rewriteExtension' => '.html'
]);

$from = 'users'; // The SELECT FROM clause
$fields = ['id', 'username', 'email']; // The columns you want to select
$where = ['status' => 'active']; // The conditions for the WHERE clause

$pagination->select($from, $fields, $where);

$records2 = [];
while ($record = $db->fetch()) {
    $records2[] = $record->id . ', ' . $record->username . ', ' . $record->email;
}

$url = '/examples/pagination-examples'; // The URL for the pagination links
echo $pagination->pagine($url);

The Pagination class will take care of paginating the results and generating the pagination links for you.

It generates the HTML markup for the pagination links, which you can then output in your view. Of course, you can customize the pagination markup (which is built with a simple unordered list) to fit your needs.

Key Features of PowerLite PDO

The examples above show just a few of the features of PowerLite PDO, but there's much more you can do with this library.

Here are some of the main features:

Dependency Injection (DI): The library uses DI to manage dependencies between different parts of the system, making it easy to swap out components or extend functionality.
Safe Query Execution: The Db class uses PDO's prepared statements to execute queries safely, protecting against SQL injection attacks.
Query Building: The QueryBuilder class provides a fluent and flexible way to build SQL queries, making it easy to construct complex queries with ease.
Pagination: The Pagination class helps you paginate the results of your queries, generating pagination links and handling the logic of fetching the correct subset of results.
Customization: The library is designed to be extensible and customizable, so you can easily add new features or modify existing ones to fit your needs.
Performance: PowerLite PDO is designed for performance, with efficient query execution and result processing to minimize overhead and maximize speed.
Security: The library follows best practices for database security, using prepared statements and other techniques to protect against common security vulnerabilities.
Flexibility: The library is designed to be flexible and adaptable, so you can use it with different types of databases and adapt it to your specific requirements.
Ease of Use: The library is designed to be easy to use, with a simple and intuitive API that makes it easy to get started and start building queries right away.
Debugging: The library provides a global and a local debug mode that allow to see the queries that are being executed and the parameters that are being passed to them.
Error Handling: The library provides detailed error messages and exceptions to help you debug and troubleshoot any issues that arise.
Documentation: The library comes with comprehensive documentation and examples to help you get started and learn how to use its features effectively.
Active Development: The library is actively maintained and updated, with new features and improvements added regularly.

Learn More

For more detailed information and examples, visit the PowerLite PDO website and check out the GitHub repository.

Create your CRUD Application in PHP

Gilles Migliori — Fri, 08 Dec 2023 11:38:50 +0000

Create, Read, Update, Delete - manage your MySQL / PDO Database

Introduction & Prerequisites

PHP CRUD Generator is a powerful web application that allows to build Bootstrap CRUD Admin dashboards in PHP using an online User Interface.

What you need to get started:

A project based on a MySQL / PDO database
A PHP Server (PHP 7.x, PHP 8.x)
Buy PHP CRUD Generator at a ridiculous price that will save you weeks of hard work

This startup tutorial will teach you the basics, and allows you to quickly create your Bootstrap CRUD Admin Dashboard without programming.

Once you have understood the basics and started using PHP CRUD Generator, you will see that it is still simple and intuitive and will probably discover its wide range of features by yourself:

how to display dates and times?
how to use file and image uploads?
how to protect access to the admin with a login and password?
how to manage users and rights?
how to customize and organize the sidebar?
etc.

Here's an overview of the type of CRUD Admin Dashboard that PHP CRUD Generator will build from your database:

Bootswatch themes are included and the user interface can be customized as desired.

How to create your PHP CRUD Application

Upload the required* folders on your server as described in the documentation
Open the installer - /install/do-install.php in your browser and follow the install process.
You'll need to enter your purchase code and your database connection informations.
Open the CRUD Generator - /php-crud-generator/generator/generator.php in your browser

The application has automatically detected your database and all its components: tables, fields, field types and relationships.
You can therefore see your tables in the drop-down list

Choose the 1st table for which you want to create CRUD operations in the drop-down list and validate your choice.
Select **one of the three available tabs to generate the pages and forms of your Bootstrap CRUD Admin**
- Build READ List: Generates the paginated data table
- Build Create / Update Forms: Generates the add / edit forms for the records
- Build Delete Forms: Generates the deletion form
The pages and forms of your administration are available and functional as you create them.

You can go to your Admin Panel at any time, test the features, then return to the generator and modify again the options of your choice if you want to make any changes.

php crud generator makes your bootstrap admin 100% scalable.

The smart system stores all your settings.

You can rebuild each element of your Admin Dashboard at will.

You can also modify the structure of your database, add or delete tables, fields, relationships, and then regenerate the different parts of your Bootstrap Dashboard.
Your CRUD Admin Dashboard is ready

You can now use your Admin Dashboard to manage your database using the available CRUD operations.

The necessary plugins and functionalities have been automatically integrated:
- calendars
- date translation
- sorting functions
- filters and data search
- export to Excel or CSV format
- printing
- file upload
- images with resizing and thumbnails
- etc...

A demo and full documentation are available on the PHP CRUD website.

Fast, efficient support guaranteed.

Reviews on major platforms

Universal Icon Picker

Gilles Migliori — Sun, 06 Mar 2022 05:21:47 +0000

https://github.com/migliori/universal-icon-picker

Javascript Icon Picker for any icon library

Main Features

Load any icon library from a single JSON file
Load the icon fonts stylesheets from local files or CDNs
Autoload the icon fonts (JSON + stylesheets) or load them only on request
Add as many icon libraries as you like to each instance of the plugin
Create multiple instances and triggers on the same page
Change the icon libraries attached to an instance whenever you want
Group icons of the same family by categories
Load one or more styles from the same icon family individually
Search / Filter icons
Built-in onSelect() and onReset() callback functions
Attach the Icon Picker to any HTML element
Add your favourite icon libraries very easily

Integrated icon libraries

Font Awesome

All
Solid
Regular
Brands

Material Icons

Filled
Outlined
Round
Sharp
Two-tone

Other icon libraries

Bootstrap Icons
Elegant Icons
Feather Icons
Foundation Icons
Happy Icons
Icomoon
Open-iconic
Tabler Icons
Weather Icons
Zondicons

Universal Icon Picker is free and open-source - License GNU GPLv3

New Universal Icon Picker Javascript plugin on Github

Gilles Migliori — Fri, 25 Feb 2022 08:16:38 +0000

Universal Icon Picker Vanilla JS plugin

This plugin can load any icon library and comes with many popular ones like Fontawesome, Material icons, Bootstrap icons, Iconic, Tabler icons and many others.

Online demo: https://www.universal-icon-picker.miglisoft.com

Github repo: https://github.com/migliori/universal-icon-picker

Main features

Load any icon library from a single JSON file
Load the icon fonts stylesheets from local files or CDNs
Autoload the icon fonts (JSON + stylesheets) or load them only on request
Add as many icon libraries as you like to each instance of the plugin
Create multiple instances and triggers on the same page
Change the icon libraries attached to an instance whenever you want
Group icons of the same family by categories
Load one or more styles from the same icon family individually
Search / Filter icons
Built-in onSelect() and onReset() callback functions
Attach the Icon Picker to any HTML element
Add your favourite icon libraries very easily

Comments & suggestions are always welcome

Tinymce Bootstrap plugin now for Tinymce 5 + Bootstrap 4

Gilles Migliori — Thu, 02 Jan 2020 17:45:33 +0000

Bootstrap 4 toolbar for tinymce 5

Transform Tinymce into a complete Bootstrap 4 content editor.

The Bootstrap toolbar provides the ability to add/edit bootstrap components and code snippets:

Button
Icon
Image
Table
Template
Breadcrumb
Pagination
Badge
Alert
Card
Any Custom Snippet

The plugin demo is available here: https://www.tinymce-bootstrap-plugin.com/demo/index

Database Admin Panel Generator

Gilles Migliori — Tue, 25 Jun 2019 10:35:08 +0000

Hi everybody,

Here's a revolutionary web application to manage your CRUD operations

PHP CRUD Generator is an easy-to-use graphical web application that consists of two main parts:

The CRUD Generator, that analyzes your MySQL database and lets you build your administration panel with a very simple and convenient user panel.
The Admin Panel, a fully featured administration system built with Bootstrap, jQuery, PHP and MySQL that lets you manage your content from your database. PHP CRUD Generator provides you with powerful administration tools for all types of projects: e-commerce websites, portfolios, products and data management, as well as presentation of all types of data.

The official site offers a CRUD Tutorial page, where you can find the guides to get started quickly

PHP CRUD Generator builds the Bootstrap control panel for your website from your MYSQL database using a simple and easy-to-use UI.

This CRUD/PHP system will allow you to save enormous amounts of time and build a fully featured and powerful Bootstrap / jQuery administration panel for you in a couple of clicks from your MySQL database.

PHP CRUD Generator is intended for any website owner or web administrator using a MySQL database.
It is not essential to know how to code, it is a graphical application that has a user interface.