|All requests||>||What is the best PHP crud class?||>||Request new recommendation||>||Featured requests||>||No recommendations|
by ahmed aabuzaid - 1 year ago (2016-03-26)
I would like to know how to create CRUD interface with PHP. I want sample code.
1. by Anichandran Ayysamy Ayyanallur - 2 months ago (2017-08-23) Reply
<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>
You can use Crudx php class. These following features are include with this class
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.
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:
The class can also generate HTML to display or update the table records like: