Things to Remember

Thursday, 22 March 2012

RAW MySQL in Zend Framework

Nice n Easy (once you know how)

$sdb = new Zend_Db_Table('table_name');
$select = "SELECT * FROM whatever";

$adapter = $sdb->getAdapter();
$query = $adapter->query($select);
$result = $query->fetchAll();

NOTE - its an array, not an object that gets returned
$result['id]
not $result->id