Login   Register  
PHP Classes
elePHPant
Icontem

File: readme.txt

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Sergey Shilko  >  Abstract SQL Table to Object  >  readme.txt  >  Download  
File: readme.txt
Role: Documentation
Content type: text/plain
Description: Simple Readme First File
Class: Abstract SQL Table to Object
Map table rows to objects with Active Record
Author: By
Last change:
Date: 2007-04-10 01:28
Size: 1,730 bytes
 

Contents

Class file image Download
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.