KohanaPHP » Kohana v2.x

By using the following class, database expressions, arithmetic and functions will be possible without modifying any core files.

// librarires/Database_Expr.php
<?php
class Database_Expr
{
    private $_value = NULL;

    public function +construct($value)
    {
        $this->_value = $value;
    }

    public function +toString()
    {
        return $this->_value;
    }
}

for example, the following code:

Database::instance()->update('anime',
  array(
    'episodes' => new Database_Expr('episodes + 1')
  ),
  array('id' => 1)
);

will produce the following SQL:

UPDATE @anime@ SET @episodes@ = episodes + 1 WHERE @id@ = 1

inserting like:

Database::instance()->insert('anime', array(
  'date' => new Database_Expr('NOW()')
));

works as well.