PHP Classes
elePHPant
Icontem

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    
Last Updated Ratings Unique User Downloads Download Rankings
2020-02-11 (1 month ago) RSS 2.0 feedNot enough user ratingsTotal: 424 This week: 3All time: 6,256 This week: 128Up
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

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

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

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

  Performance   Level  
Name: Marco Sillano <contact>
Classes: 4 packages by
Country: Italy Italy
Age: ???
All time rank: 225287 in Italy Italy
Week rank: 93 Up4 in Italy Italy Up
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:424
This week:3
All time:6,256
This week:128Up