Login   Register  
PHP Classes
elePHPant
Icontem

Table Data Management: Interface to manipulate data in database tables

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Info   View files View files (7)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Last Updated Ratings Unique User Downloads Download Rankings  
2005-06-23 (9 years ago) RSS 2.0 feedNot yet rated by the usersTotal: 756 This week: 1All time: 4,078 This week: 1,335Up
Version License Categories  
tabledatamanagement 1.0GNU General Public Lice...Databases
Description Author  

The TableDataManagement class is used as an interface to manipulate data in rows of an SQL database table.

Each object of the class can access individual rows of a given table.

How does it work?

On initalization of a class object it obtains information about the table it is interfacing.

After the initialization the class knows:

- what primary keys are defined
- what are the types of the table columns

After the object has been initialized the user can than either load the object with a specific record, or save a new record into the table.

Benefits
- select, update, save, delete records without having to write specific SQL queries
- Keep code clean by passing all needed data trough to the class object and calling the specific methods

Picture of Sasa Radovanovic
Name: Sasa Radovanovic <contact>
Classes: 1 package by
Country: The Netherlands The Netherlands
Age: 38
All time rank: 245170 in The Netherlands The Netherlands
Week rank: 1045 Up27 in The Netherlands The Netherlands Up

  Files folder image Files  
File Role Description
Accessible without login Plain text file example1.php Example Example for usage of the main tabledatamanagement methods (load, delete, save and update)
Plain text file MySQLConnection.class.php Class Database class used by the TableDataManagement object to interact with the database
Accessible without login HTML file MySQLConnection.html Doc. MySQLConnection
Plain text file TableColumn.class.php Class Object used for storing columnspecific data into (used by the TableDataManagement object)
Accessible without login HTML file TableColumn.html Doc. TableColumn
Plain text file TableDataManagement.class.php Class Main class for managing (interfacing) access to a specific table
Accessible without login HTML file TableDataManagement.html Doc. Documentation of the TableDataManagement object

 Version Control Unique User Downloads Download Rankings  
 0%Total:756All time:4,078
 This week:1This week:1,335Up