Categories

Archives

Did You Know?

When it comes to coding standards, I prefer the Allman indentation style; opening and closing braces should be in the same column for maximum readability. This goes back to my background in Pascal where the function's begin and end statements are aligned in the same column. But for consistency's sake, I'm trying to adopt the Zend Framework coding standards. It's still a bit of a struggle.

Recent Comments

Tags

asp audio browser bug business coalesce code crash Database db debian extension framework imap internet legions linux metaverse mysql obscurity patch PHP postgresql properties release scp Second Life second life security session social media sound sql ssh subversion tables tortoisesvn tribes ubuntu virtual world web windows zend zend framework zf

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 […]

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 […]

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 […]