What is CRUD?
PHP CRUD Tutorial

CRUD is an acronym for CREATE READ UPDATE DELETE and stands for an online application that displays the contents of a database in list form, allows you to modify or delete each record and add new ones. It's called CRUD Operations


Most CRUD applications use PHP functions that the user must program to perform each task:

  • Add records to the database
  • Update some existing records
  • Delete records

These tasks are called "CRUD operations".

For example, to retrieve the contents of a database table and display the list of records, you will need to use this type of code:

    $CRUD = new CRUD();
    $crud->getTable('my-table');
    $crud->showList();

This basic example shows that it is easy to create and display a record list with the most common CRUD apps.

But most of the time you will need more complex features to build your lists:

  • display readable field names
  • filter and sort results
  • display relational table fields
  • format dates
  • display images
  • group some fields in nested tables
  • edit some fields "in place" rather than with the update form
  • hide some fields that you don't want to show to the admin end-user
  • convert some values
  • ...

These features are commonly provided through PHP functions that you will need to program & configure according to your needs, for each table and field.

All these operations can quickly become complex to program, it will be necessary to take the time to check each table, each field to use the relevant functions.

This is where PHP CRUD Generator can help you!

What makes PHPCG different from most other CRUD PHP applications?

PHP CRUD Generator is a smart application.

PHPCG performs an intelligent analysis of your database and generates all the code for you.

It analyzes your entire database and detects tables, direct and indirect relationships, fields, field types and expected values

From there, the application will generate everything you need: MySQL queries, PHP objects, forms, data validation, rendering templates,...

PHP CRUD Generator provides a simple and user-friendly GUI (graphical user interface)

The generator is presented as an online application, and allows you to configure your lists and forms.

  1. 1Choose the table of your database to use
  2. 2Choose your preferences for each field
  3. 3 Validate to generate the CRUD PHP app.

The Bootstrap Admin Panel is Highly customizable

The Generator provides a simple settings form that allows to customize the most important things: Languages, Project settings, skin and various others options.

The Bootstrap Admin Panel code is well-organized, clean and customizable by anyone who understand PHP, HTML, CSS, jQuery, Bootstrap.

the structure and logic are detailed in the different parts of this documentation and the tutorials

PHP CRUD & Bootstrap Admin Panel Authentication, Users and Profiles management

PHPCG includes an authentication and user profile management module and a complete administration interface ready to host your data.

Back to the PHP CRUD Tutorials