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.
| Project record: |
phpdtobject |
| Popularity score: |
12.96 |
| Vitality score: |
1.04 |
| There are not enough user ratings to display for this class. |
No application links were specified for this class.
 If you know an application of this package, send a message to the author to add a link here.
| File |
Role |
Description |
 DBConn.php |
Class |
Database connection class |
 index.html |
Doc. |
ReadMe html file |
| PhpDtObject.php |
Class |
Main class |
| PhpDtObject_DB.php |
Class |
Main class, database logic layer |
| 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. |
| ReadMe.txt |
Doc. |
ReadMe file |
| test.php |
Example |
Test & example script |
|
|
ReTweet
Stumble It!
Bookmark in del.icio.us
Support forum
Blog
Latest changes
Groups
User ratings
Advertise on this site
Site map
Statistics
Site tips
Privacy policy
Contact
