I am new to Zend but am quite familiar with PHP and other MVC frameworks. A client requires that Zend be used for an application and I am having a little bit of trouble finding a database approach that I like. I am only connecting to one database (MySQL for now, MS SQL in production) and really only interacting with one table. With that said I would like to find a good approach for opening a handle to that database and keeping it open so that it is available in all of my controllers and allows me to use such methods as fetchAll, fetchOne, etc.
Ideally I would like to be able to make calls like the one below from my controllers and pass the results to the views.
$this->db->fetchAll("SELECT * FROM TABLE");
I have followed the tutorials on the Zend site but after using the Zend_Db_Table approach I wasn't able to find the flexibility that I wanted and thus am hoping someone here can point me in a different direction. I seem to be having a tough time wrapping my head around how Zend database models interact w/ Zend controllers but I am sure that there are lots of SO users who can provide some solid input.
Thanks in advance!