Login   Register  
PHP Classes
elePHPant
Icontem

PhpDtObject: Database table access classes for php

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  
2004-11-12 (10 years ago) RSS 2.0 feedNot enough user ratingsTotal: 963 All time: 3,479 This week: 1,491Up
Version License Categories  
phpdtobject 1.0GNU Lesser General Publ...Databases, Data types
Description Author  

These classes simplify the process of retrieving, editing, inserting and delete rows from the database table.

PhpDtObject creates an object from a table row or an array of objects if multiple rows are retrieved from the table.

Objects can also be created with init method, that passes primary key value (usually id) to getOne and getMany methods that can take complex searching criteria.

Rows can be updated, deleted and new rows created with a simple method calls.

By extending this class you have basic access to the database tables and you can concentrate to your own class functionality.

These classes are quite similar to DAO (Data Access Objects) but may be used for other purposes.

PhpDtObject requires ADOdb database abstraction layer.

Picture of Marko Tapio Manninen
Name: Marko Tapio Manninen <contact>
Classes: 3 packages by
Country: Finland Finland
Age: 39
All time rank: 3252 in Finland Finland
Week rank: 1169 Down4 in Finland Finland Down

  Files folder image Files  
File Role Description
Plain text file DBConn.php Class Database connection class
Accessible without login HTML file index.html Doc. ReadMe html file
Plain text file PhpDtObject.php Class Main class
Plain text file PhpDtObject_DB.php Class Main class, database logic layer
Plain text file PhpDtObject_native_mysql.php Class - Enhanced PhpDtObject class with a new and performance tuned database table access methods. Database query layer that implements native mysql functions of php is on a same file so this class does not require ADOdb to work. Just include the file and get table contents even without generating separate classes for single tables and without making separate xml / sql configuration files. So "one class works for multiple tables." Extend class for more heavy and complex use. - Basic public methods are: init, getValue, setValue, getOne, getMany,getIndex, save and delete. - Added public methods compairing to former published PhpDtObject class are: initByKey, gv, gvm, sv, getNumRows, getAffectedNumRows, getMixed, getMidexIndex, getLastSelectNumRows, singleUpdate, setMask, clearMask, getErrors and assignArray. - Multiple keys are handled now by calling initByKey method instead of normal init that is used when only one primary key field is found from the database table.
Accessible without login Plain text file ReadMe.txt Doc. ReadMe file
Accessible without login Plain text file test.php Example Test & example script

 Version Control Unique User Downloads Download Rankings  
 0%Total:963All time:3,479
 This week:0This week:1,491Up