Recommend this page to a friend! |
Download .zip |
Info | View files (5) | Download .zip | Reputation | Support forum | Blog | Links |
Last Updated | Ratings | Unique User Downloads | Download Rankings | |||||
2007-04-10 (9 years ago) | 50% | Total: 3,207 This week: 2 | All time: 1,066 This week: 591 |
Version | License | PHP version | Categories | |||
parentdbtoclass 1.1 | Freeware | 4.3 | Databases, Design Patterns |
Description | Author | |||||||||||||
This package uses the Active Record design pattern to map database table records to objects. |
|
coredb.class.php - DB OBJECT HANDLER (REQUIRE ADODB) (include dirname(__FILE__)."/adodb/adodb.inc.php";) j-coredb.class.php - JOOMLA CMS DB OBJECT HANDLER WRAPPER parent.dbtoclass.php - Database Table handler sample.php - Sample handler of table 'catalog'; ------------------------------------------------------------------- Handler Usage >>> ------------------------------------------------------------------- For example we have mysql table 'catalog', with fields 'id','title','price': What we do is : 1)Create Child class of parent.dbtoclass.php (class Foo extends dbtoclass ...) see sample.php 2)Make same fields in class as in db i.e.: see sample.php 3)you can call parent:::makeGetSetMethods() to get All get*,set* methods for all your class fields (title,price...) 4)Also you may get the list of changed values from parent class (value/field that waws realy cchanged, for logging) /* Update existing >>> */ $foo = new Foo($db); #Initialize object with DB object $foo->checkout(25); #load item details to class $foo->setNewValues($hash_array); #update class with new values $foo->commit(); #Commit all changes to db and write log $foo->finish(); #Finish work with the class. /* <<< */ /* Create new >>> */ $foo = new Foo($db); #Initialize object with DB object $foo->create($hash_array); #Commit all changes to db and write log $foo->finish(); #Finish work with the class. /* <<< */ /* Delete record */ $foo = new Foo($db); #Initialize object with DB object $foo->delete(25); #Delete item $foo->finish(); #Finish work with the class. |
Files |
File | Role | Description |
---|---|---|
coredb.class.php | Class | DatabaseHandler |
j-coredb.class.php | Class | Joomla CMS 1.0.12 Databasehandler Wrapper |
parent.dbtoclass.php | Class | Parent Database to Class handller |
readme.txt | Doc. | Simple Readme First File |
sample.php | Example | Sample child of main class |
Version Control | Unique User Downloads | Download Rankings | |||||||||||||||
0% |
|
|
User Ratings | ||||||||||||||||||||||||||||||
|
Applications that use this package |
If you know an application of this package, send a message to the author to add a link here.