What is the best PHP crud class?: How to create CRUD with PHP

I would like to know how to create CRUD interface with PHP. I want sample code.

by Slavko Srakocic package author 65 - 3 years ago (2021-09-15) Comment

See https: github.com slavkoss fwphp for newest code. On B12phpfw global-shared core code skeleton package (abstract class Config_allsites and trait Db_allsites) are 3 main packages (Oracle Forms modules subgroups in modules group folder glomodul, each module in own folder, no M, V, C folders for all modules-CRUD pages) : 1. Mnu (menus), 2. Mkd (WYSIWYG markdown editor eg Simplemde, or may be HTML editor eg Summernote), 3. Msg (blog based on best blogs I could find in learning sources on Internet).

There are also few packages which show what ideas others have about MVC, namespaces, PDO CRUD...

In my opinion it is bad (beginner), too complicated idea that each table has own CRUD class. Oracle Forms rejected such idea few dozen years ago, but PhpClasses best ranked MVC package makes science of scafolding - automatically generating each table own CRUD class, simmilar like Yii and other "best" PHP fw-s. What wonders me, they do not even mention other possibilities - bad praxis in many things, in many activities (because not explaine life is not worth living).

In my opinion it is bad (beginner), too complicated idea M, V, C folders for all modules-CRUD pages. Yes Oracle Forms has libraries but not used for this purpose (I in 23 years working in Oracle Forms did not used Oracle Forms libraries).

Ideas like PRE-CRUD code (in web programming called adapters) are explained complicated, mistificated, not simply explained like in B12phpfw.

Where best PHP frameworks have dozens megabytes of complicated code, B12phpfw has few kB of simple code.

It seems to me B12phpfw (my "Oracle Forms modules" way in PHP programming) is unique and best idea, and, at least, best for learning PHP.

by Marco Sillano package author 255 - 7 years ago (2018-04-22) Comment

A simple CRUD class. Requires very little code, but you can do stong customization usinng optional callbacks (lookups tables, format fields, radio button entry etc.) Allows master-detail pages, e.g. for invoices management

by Saro Carvello package author 515 - 8 years ago (2017-02-08) Comment

<h1>MySQLReflection</h1> <h2>A useful utility for the Object Relation Mapping of MySQL databases</h2> <p>This package can generate classes to access MySQL as objects.<br> <br> It can access a given MySQL database, retrieve its schema of tables and fields, and generates classes to access the records of tables as objects.<br> <br> The generate classes have setter and getter functions for accessing record field values, as well functions to insert, update and delete table records.</p>

<p>An auto generated MySQL class provides the following services:</p> <ul><li>A constructor for managing a fetched table?s row or for a adding a new one</li> <li>Management for both single or composite Primary Keys</li> <li>Automatic mapping of the different date formats may occurs between application and database</li> <li>Destructor to automatically close database connection</li> <li>Defines a set of attributes corresponding to the table fields</li> <li>Setter and Getter methods for each attribute</li> <li>OO methods for simplify DML select, insert, update and delete operations</li> <li>A facility for quickly updating a previously fetched row</li> <li>Useful methods to obtain table DDL and the last executed SQL statement</li> <li>Error handling of SQL statements</li> <li>Camel/Pascal case naming convention for Attributes/Class used for mapping Fields/Table</li> <li>Useful PHPDOC information about table, fields and the usage of class, attributes and methods</li> </ul> <p>Developers can quickly use these generated classes on their application.</p>

by Nahid Bin Azhar package author 40 - 8 years ago (2017-01-17) Comment

You can use Crudx php class. These following features are include with this class

1. Laravel Eloquent style data save and update
2. Insert with array data.
3. Generate all types of query as method chaining.
4. Joining
5. Deleting
6. Sorting
7. Group
8. Raw query enable
9. Fetch all types of data as objects

by Anthony Amolochitis package author 505 - 9 years ago (2016-04-16) Comment

I built this CRUD class. It reads your database and builds a library of classes that represent your database tables. A field class, data object class, and TableQuery class for each table will be built into a php file. It is designed this way to avoid using loops to generate queries for improved speed. I believe you will like what this class does once you use it. There is sample code on the class page.

by Bharat Parmar package author 455 - 9 years ago (2016-04-11) Comment

This class can perform CRUD operations on MySQL table records.

It can perform several types of operations with records of a given MySQL table like:

• InsertRecord : Insert Record to database
• InsertMultipleRecord : Insert Multiple Records
• GetSingleRecord : Retrieve Single Record for Edit or View Action
• GetRecord: Get All or a limited number of Records with pagination
• UpdateRecord : Edit or Update Record Method
• DeleteRecord : Delete Record Method
• GetCustom : For results for arbitrary queries

The class can also generate HTML to display or update the table records like:

• PagiNation : Pagination Display
• UploadFile : Upload File
• DeleteFile : Delete File
• DateDifference : Date Difference
• RedirectPage : To Redirect Specific Pages
• EditLink : Edit Action Link
• StatusLink : Change active or inactive status Action Link
• DeleteLink : Delete Action Link
• SendMail : Send Mail method
• GetRandomString : Generate Random String