Archive for September, 2008
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: Setting MySQL's timezone per connection
I have a Linux server with a system timezone of ET (US/Eastern). But I also have a web application that needs to run in a timezone of PT (US/Pacific). Of course that's not a problem at all. I just set the timezone in my web application's bootstrap: date_default_timezone_set('America/Los_Angeles'); // Pacific timezone Now I have another […]
Posted: September 16th, 2008 under Development, PHP, Zend Framework.
Tags: date, dates, db, framework, mysql, PHP, timezone, zend
Comments: none
The WSDL Blower: The state of SOAP in Zend Framework 1.6
There are all kinds of ways to expose APIs as web services. SOAP, XML-RPC, REST, JSON-RPC. Out of all of these, SOAP is arguably the most complex, but also one of the oldest ways to expose an API (I remember preliminary SOAP and WSDL support in Delphi 6, circa 2001). Exposing an API as a […]
Posted: September 13th, 2008 under Development, PHP, Zend Framework.
Tags: bug, framework, PHP, soap, web service, wsdl, zend
Comments: none