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 […]
Posted: September 27th, 2008 under Database, Development, PHP, Zend Framework.
Tags: audit, columns, Database, db, framework, mysql, PHP, rows, tables, trail, zend
Comments: 1
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