Tag: tables
Dirty Rows and Audit Trails with Zend_Db_Table
There are various ways to update rows in a database table using the Zend_Db_Table components. You can use use Zend_Db_Table::update(), like so:
$table = My_Table();
$table->update(array('age' => 22), 'id = 1');
or retrieve the row, and update it:
$table = My_Table();
$row = $table->find(1)->current();
$row->age = 22;
$row->save();
The big difference between the two approaches is that by first retrieving the row, and […]
Posted: September 27th, 2008 under Database, Development, PHP, Zend Framework.
Tags: audit, columns, Database, db, framework, mysql, PHP, rows, tables, trail, zend
Comments: none
Zend_DB_Select Woes
It's no secret, I'm a fan of the Zend Framework, which I've been using since version 0.15. A lot of components have been added since then, and many of the initial components have been refactored and enhanced, and have matured. And that includes the Zend_Db_Select component, which has been evolving quite nicely, and even Zend_Db_Table_Abstract […]
Posted: July 25th, 2008 under Database, Development, PHP, Zend Framework.
Tags: mixin, mysql, PHP, select, sql, sqlite, tables, zend framework, zf
Comments: none