doing all crud operations: doing all crud operations with one class
| Recommend this page to a friend! |
All requests  |
> | doing all crud operations | > | Request new recommendation | > |  Featured requests |
> |  No recommendations |
doing all crud operations #database crud
by Muddathir Samir - 6 years ago (2019-04-08)
doing all crud operations with one class
  +7 | doing all crud operations with one class like insert , select , delete , update |
- 1 Clarification request
1.
by doberon - 4 years ago (2021-01-05) Replythe example no is clear
2 Recommendations
MySQL Class Generator: Generate classes to access MySQL as objects
It can access a given MySQL database and retrieve schema tables and fields.
For each table, it generates a class that uses object-oriented programming logic to provide methods for accessing, reading, and writing its records.
+1 |
The utility generates automatically PHP classes for any tables of a given database schema. The package is extracted from my personal PHP Web MVC Framework. An auto-generated MySQL class provides the following services: A constructor for managing a fetched table’s row or for adding a new one Management for both single or composite Primary Keys Automatic mapping of the different date formats may occur between application and database Destructor to automatically close database connection Defines a set of attributes corresponding to the table fields Setter and Getter methods for each attribute OO methods for simplifying DML select, insert, update and delete operations A facility for quickly updating a previously fetched row Useful methods to obtain table DDL and the last executed SQL statement Error handling of SQL statements Camel/Pascal case naming convention for Attributes/Class used for mapping Fields/Table Useful PHPDOC information about table, fields and the usage of class, attributes and methods. Read class docs to github.com by searching rcarvello |
by Saro Carvello 
Simple CRUD with MySQL 2: Output SQL and CRUD forms based on remoteDB class
It is a class derived from the original work by Mahboobz. This version was improved in the following ways:
Version 4:
Update: replaced irp_commonSQL.php (obsolete) with common_pdo.php
Version 3:
- Added 2 more callback: before_save(), before_updated()
- Tested on Master-detail tables: see example pages
- Tested on view tables.
Version 3: added 2 new hooks, and master->detail capability
added 2 functions: setEdit() and setDelete() to control buttons
Version 2:
- Added $this->index array to store one or more PK names (in place of one pre-defined PK='id')
- Added get_where(), get_hidden($record) to handle multiple PKs
- Added optional hook and callback to customize the CRUD page:
1) special input fields: select, radio... (crud_get_input)
2) special edit fields: select, radio... (crud_get_edit)
3) special show fields: links, references... (crud_get_show)
4) more actions in table (crud_action_hook)
- Added 3 static utility: make_select, make_radio and make_checkbox for input/edit fields
- Added CONFIRM to delete
- Added $extrasql parameter to renderVertically(), to extend the basic sql: "SELECT * FROM ".$this->table
- Cosmetic minor variations, use of css file (in: remoteDB/css/style.css)
+1 |
This class allows all CRUD operations. Many callback makes it very customizable. Examples for fast use learning. |
by Marco Sillano | Recommend package | |
|
|
