PHP Classes

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

Recommend this page to a friend!
  Info   View files Example   View files View files (12)   DownloadInstall with Composer Download .zip   Reputation   Support forum (1)   Blog    
Ratings Unique User Downloads Download Rankings
Not enough user ratingsTotal: 544 All time: 5,528 This week: 284Up
Version License PHP version Categories
crud-class 4GNU General Publi...5HTML, PHP 5, Databases
Description 

Author

This class can generate 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)

Recommendations

What is the best PHP pdo mysql class?
PHP Project using PDO MySQL Class

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

doing all crud operations
doing all crud operations with one class

class for add tags category
i need a add tag when enter article in mysql table

master detail form read create edit delete forms
i want to create add records into a master detail form

Picture of Marco Sillano
  Performance   Level  
Name: Marco Sillano <contact>
Classes: 4 packages by
Country: Italy Italy
Innovation award
Innovation award
Nominee: 3x

Winner: 1x

  Files folder image Files  
File Role Description
Files folder imageexamples (4 files)
Files folder imageremoteDB (2 files, 1 directory)
Accessible without login Plain text file common_pdo.php Aux. Update for commonSQL (obsolete)
Plain text file crudClass2.php Class Updated CRUDclass
Plain text file crudClass3.php Class new version master->detail
Plain text file crudClass4..php Class Update version
Accessible without login Plain text file irp_commonSQL.php Aux. old SQL common

  Files folder image Files  /  examples  
File Role Description
  Accessible without login Plain text file crud_basic.php Example for the user
  Accessible without login Plain text file crud_details.php Example for the user
  Accessible without login Plain text file crud_master.php Example for the user
  Accessible without login Plain text file crud_view.php Example for the user

  Files folder image Files  /  remoteDB  
File Role Description
Files folder imagecss (1 file)
  Accessible without login Plain text file irp_commonSQL.php Aux. mySQL access library
  Accessible without login Plain text file irp_config.php Aux. mySQL access data

  Files folder image Files  /  remoteDB  /  css  
File Role Description
  Accessible without login Plain text file style.css Data CSS file

 Version Control Unique User Downloads Download Rankings  
 0%
Total:544
This week:0
All time:5,528
This week:284Up