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 View files (9)   DownloadInstall with Composer Download .zip   Reputation   Support forum (1)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings
2018-05-04 (20 days ago) RSS 2.0 feedNot yet rated by the usersTotal: 252 This week: 3All time: 7,613 This week: 168Up
Version License PHP version Categories
crud-class 3GNU 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:

- 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

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: 2631101 in Italy Italy
Week rank: 85 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)
Plain text file crudClass2.php Class Updated CRUDclass
Plain text file crudClass3.php Class new version master->detail

  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:252
This week:3
All time:7,613
This week:168Up