CRUD is an acronym for CREATE READ UPDATE DELETE.
It 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
All companies or people who need to manipulate data use it, in different forms and most of the time without knowing it.
If you use a software to manage a stock of products, the list of your customers, your invoices, ... then it is a CRUD application.
Your software saves your data internally in a database, whatever its format (MySQL, Oracle, Microsoft SQL Server, ...). You can:
This type of application is very common, used by all companies regardless of their sector of activity and size.
Software or web application?
Most of the software specialized according to the sector of activity, management or accounting software are used as software, installed on operating system (OS). However, there are more and more web applications that are capable of performing these tasks. All administrable websites, all programs available on the web in SaaS are actually CRUD web applications.
Whatever your professional activity, a web app. is always necessary to manage your data, present your services, your achievements, manage your clientele or organize your schedule.
Most CRUD applications use PHP functions that the user must program to perform each task:
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:
$data = new CRUD(); $data->getTable('my-table'); $data->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:
These features are commonly provided through PHP basic 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.
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 the crud logic: MySQL queries, PHP objects, forms, data validation, rendering templates,...
The generator is presented as an online application, and allows you to configure your lists and forms.
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.
PHPCG includes an authentication and user profile management module and a complete administration interface ready to host your data.