PHP Classes

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

Recommend this page to a friend!
  All requests RSS feed  >  What is the best PHP crud class?  >  Request new recommendation  >  A request is featured when there is no good recommended package on the site when it is posted. Featured requests  >  No recommendations No recommendations  

What is the best PHP crud class?

Edit

Picture of ahmed aabuzaid by ahmed aabuzaid - 8 years ago (2016-03-26)

How to create CRUD with PHP

This request is clear and relevant.
This request is not clear or is not relevant.

+15

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

  • 3 Clarification requests
  • 3. Picture of Fransim by Fransim - 2 years ago (2022-01-25) Reply

    Xml

    • 2. Picture of Hariharan Natarajan by Hariharan Natarajan - 6 years ago (2017-10-31) Reply

      It helps a lot

      • 1. Picture of Anichandran Ayysamy Ayyanallur by Anichandran Ayysamy Ayyanallur - 6 years ago (2017-08-23) Reply

        6

        Ask clarification

        6 Recommendations

        B12 PHP FW: Manage database records with a PDO CRUD interface

        This recommendation solves the problem.
        This recommendation does not solve the problem.

        0

        Picture of Slavko Srakocic by Slavko Srakocic package author package author Reputation 60 - 2 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.


        Simple CRUD with MySQL 2: Output SQL and CRUD forms based on remoteDB class

        This recommendation solves the problem.
        This recommendation does not solve the problem.

        -1

        Picture of Marco Sillano by Marco Sillano package author package author Reputation 220 - 5 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

        • 2 Comments
        • 1. Picture of Domenico Casaccia by Domenico Casaccia - 3 years ago (2021-02-20) Reply

          jkjjkljkl

        • 2. Picture of Marco Sillano by Marco Sillano package author package author - 2 years ago (2021-06-16) in reply to comment 1 by Domenico Casaccia Reply

          Qualche problema? Che cosa non hai capito?


        MySQL Class Generator: Generate classes to access MySQL as objects

        This recommendation solves the problem.
        This recommendation does not solve the problem.

        0

        Picture of Saro Carvello by Saro Carvello package author package author Reputation 430 - 7 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>


        Crudx: Store and retrieve objects in MySQL using MySQLi

        This recommendation solves the problem.
        This recommendation does not solve the problem.

        +2

        Picture of Nahid Bin Azhar by Nahid Bin Azhar package author package author Reputation 35 - 7 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


        Database ORM Builder: Generate MySQL Object Relational Mapping classes

        This recommendation solves the problem.
        This recommendation does not solve the problem.

        0

        Picture of Anthony Amolochitis by Anthony Amolochitis package author package author Reputation 445 - 7 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.


        Short Code CRUD: Perform CRUD operations on MySQL table records

        This recommendation solves the problem.
        This recommendation does not solve the problem.

        +8

        Picture of Bharat Parmar by Bharat Parmar package author package author Reputation 410 - 7 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


        Recommend package
        : 
        :