What is a CRUD?

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.


Most CRUD applications use PHP functions that the user must program to perform each task. For example, to retrieve the contents of a database table and display the list of records:

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

This basic example shows that it is very easy to create and display record lists with most common CRUDs.

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,...

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

What makes PHPCG different from most other CRUD applications?

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

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

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

The generated code can easily be modified/customized as desired - the structure and logic are detailed in the different parts of this documentation and the video tutorials.

Back to Knowledge Base