Categories	Resources
Photo Gallery	Contact

DB_DataObject

By Bee

Last updated: September 14, 2005

Configuration - A simple example
Using common sql commands - select, insert, update, delete
Joins - Linking related tables
SQL Casting
Debug queries
Other usefull features

Source code: Using common sql commands

Casting Dates

Let's say we have a field in our database, 'date_insert', that we want to set each time a user is insert.
We can do this thing easly by using DB_DataObject_Cast::date() method.

$user = DB_DataObject::factory( 'users' );
$user->name = 'Test User';
//set date_insert to 10 january 2005
$user->date_insert = DB_DataObject_Cast::date( 2005, 01, 10 );
$user->insert();

Casting Blobs

DB_DataObject_Cast::blob() method should be used if we want to store images into database, or large amount of binary data.

$user = DB_DataObject::factory( 'users' );
$user->name = 'Test User';
//insert picture for this user
$user->picture = DB_DataObject_Cast::blob( file_get_contents( 'myimage.jpg' ) );
$user->insert();

Casting SQL

And finally, how do you set a field using a raw sql query? DB_DataObject_Cast::sql() method is the solution.

$user = DB_DataObject::factory( 'users' );
$user->name = 'Test User';
//sql casting
$user->date_insert = DB_DataObject_Cast::sql( "now()" );
$user->insert();