Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Rob Allen's Blog:
Metadata from Zend_Db_Table_Abstract
Jun 01, 2009 @ 07:53:14

As a part of his WinPHP Challenge project Rob Allen has come up with a method to combing the Zend_Db_Table component of the Zend Framework with the SuccessSQL tool to extract the table information directly from the database.

Zend_Db_Table provides all this information directly which is quite useful, however the intended use-case for Zend_Db_Table is that you extend Zend_Db_Table_Abstract for each table that you want to interact with. Obviously, SuccesSQL doesn't know in advance the names of the tables, so I created a stub class that allowed me to instantiate a Zend_Db_Table dynamically.

A few code snippets later and he has a working example showing a var_dump of the object's output - complete with full data for the two columns - ID and artist.

tagged: tutorial zenddbtable successql zendframework