File: DataObject.php

require_once('PEAR.php') [line 94]
The main "DB_DataObject" class is really a base class for your own tables classes

// Set up the class by creating an ini file (refer to the manual for more details [DB_DataObject] database = mysql:/username:password@host/database schema_location = /home/myapplication/database class_location = /home/myapplication/DBTables/ clase_prefix = DBTables_

//Start and initialize...................... - dont forget the & $config = parse_ini_file('example.ini',true); $options = &PEAR::getStaticProperty('DB_DataObject','options'); $options = $config['DB_DataObject'];

// example of a class (that does not use the 'auto generated tables data') class mytable extends DB_DataObject { // mandatory - set the table var $_database_dsn = "mysql://username:password@localhost/database"; var $__table = "mytable"; function table() { return array( 'id' => 1, // integer or number 'name' => 2, // string ); } function keys() { return array('id'); } }

// use in the application

Simple get one row

$instance = new mytable; $instance->get("id",12); echo $instance->somedata;

Get multiple rows

$instance = new mytable; $instance->whereAdd("ID > 12"); $instance->whereAdd("ID < 14"); $instance->find(); while ($instance->fetch()) { echo $instance->somedata; } Needed classes

• we use getStaticProperty from PEAR pretty extensively (cant remove it ATM)

DB_DATAOBJECT_BLOB = 64

DB_DATAOBJECT_BOOL = 16

DB_DATAOBJECT_DATE = 4

DB_DATAOBJECT_ERROR_INVALIDARGS = -1

Theses are the standard error codes, most methods will fail silently - and return false

to access the error message either use $table->_lastError or $last_error = PEAR::getStaticProperty('DB_DataObject','lastError'); the code is $last_error->code, and the message is $last_error->message (a standard PEAR error)

DB_DATAOBJECT_ERROR_INVALIDCONFIG = -3

DB_DATAOBJECT_ERROR_INVALID_CALL = -7

DB_DATAOBJECT_ERROR_NOCLASS = -4

DB_DATAOBJECT_ERROR_NODATA = -2

DB_DATAOBJECT_INT = 1

these are constants for the get_table array user to determine what type of escaping is required around the object vars.

DB_DATAOBJECT_MYSQLTIMESTAMP = 256

DB_DATAOBJECT_NOTNULL = 128

DB_DATAOBJECT_STR = 2

DB_DATAOBJECT_TIME = 8

DB_DATAOBJECT_TXT = 32

DB_DATAOBJECT_WHEREADD_ONLY = true

Used in methods like delete() and count() to specify that the method should build the condition only out of the whereAdd's and not the object parameters.