PHP Classes

Table Maintenance: Manage forms for CRUD MySQL table records

Recommend this page to a friend!
  Info   Screenshots   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
Not enough user ratingsTotal: 952 All time: 3,782 This week: 455Up
Version License PHP version Categories
tablemaintenance 1.0.0GNU General Publi...5HTML, PHP 5, Databases, Logging
Description 

Author

This package can manage forms for CRUD MySQL table records.

It can display, validate and process forms to create, read, update, and delete records for MySQL tables.

Forms and listings are generated automatically using HTML templates given the name of the database table of the records to be managed.

Record listings may appear paginated with navigation links.

Automatic validation of form inputs is performed depending on the type of database table record. Additional custom validations may also be performed.

Actions to create, update and delete records require confirmation of the user in a page that displays a preview of the changes.

Database record changes are logged to an audit trail database table.

The record listing mode, the form input labels for each table column, and the order of presentation of the table column values are configurable parameters.

Picture of Prakash Khanchandani
Name: Prakash Khanchandani <contact>
Classes: 2 packages by
Country: India India
Age: ???
All time rank: 2023126 in India India
Week rank: 178 Up21 in India India Up

Recommendations

Dynamic class for CRUD with MySQL database
Form processing to MySQL database storage

Screenshots (2)  
  • lstBloFrm.png
  • tblMntUpd.png
  Files folder image Files (31)  
File Role Description
Accessible without login Plain text file authRules.php Example 6th level example
Accessible without login Plain text file bnkCrncy.php Example 7th level example
Accessible without login Plain text file bnkMstr01.php Example 4th level example
Accessible without login Plain text file bnkMstr02.php Example 5th level example
Accessible without login Plain text file brnchMstr.php Example 1st level, basic, example
Accessible without login Image file bt-left-icon.png Icon left button
Accessible without login Image file bt-right-icon.png Icon right button
Accessible without login Plain text file buttons.tpl Data PEAR HTML Template file
Accessible without login Plain text file classes.php Aux. requires, defines, and some functions
Accessible without login Plain text file crncy.php Example 3rd level example
Accessible without login Plain text file css.css Data css file
Accessible without login Plain text file demoNotes.php Doc. notes displayed for the demos
Accessible without login HTML file demoPrgLst.txt Doc. menu file
Plain text file header.php Class PEAR HTML Template i/f
Accessible without login Plain text file header.tpl Data basic template
Accessible without login Plain text file index.php Example index script
Accessible without login Plain text file indexFileHelp.htm Doc. system description
Accessible without login Plain text file list.tpl Data template for records list
Accessible without login Plain text file mnuItm.php Example 2nd level example
Accessible without login Plain text file mstrB.tpl Data template for list below form
Plain text file mstrFH.php Class main form handler
Plain text file mstrScripts.php Class SQL scripts
Plain text file mstrTable.php Class the main class file
Accessible without login Plain text file mstr_S.tpl Data template for form and list side by side
Accessible without login Plain text file mstr_S_Tbl.tpl Data additional template for side by side layout
Accessible without login Plain text file nmProperties.fl Data label replacement examples
Accessible without login Plain text file prodTypes.php Example 8th level example
Accessible without login Plain text file testData.sql Data test data
Accessible without login Plain text file user.php Example 9th level example

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:952
This week:0
All time:3,782
This week:455Up