PHP Classes

Table Data Management: Interface to manipulate data in database tables

Recommend this page to a friend!
  Info   View files View files (7)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
Not yet rated by the usersTotal: 765 All time: 4,418 This week: 455Up
Version License Categories
tabledatamanagement 1.0GNU General Publi...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: 47
All time rank: 272369 in The Netherlands The Netherlands
Week rank: 295 Up10 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:765
This week:0
All time:4,418
This week:455Up