BrandonK Posted March 11, 2008 Share Posted March 11, 2008 I plan on using the Zend_Framework in my next big project, and I am starting to play around with it. I am currently debating Zend_Db vs the standard PDO and I think that the ZF version is a lot nicer. I plan to extend the class just a little and wrap it in my own namespace. I have created the connection like this: <?php try { $db_config = array( 'host' => $hostname, 'username' => $username, 'password' => $password, 'dbname' => $dbname, 'profiler' => true, 'adapterNamespace' => 'My_Db_Adapter' ); //in the future I may use load from Zend_Config or something $db = Zend_Db::factory('Pdo_Mysql', $db_config); } catch (Exception $e) { throw $e; } This works fine, and I think its fairly straight forward. One problem I have is related to the exceptions, but that's a different post I guess. Then I want to come down and make some queries: <?php $sql = " SELECT name , alpha FROM countries WHERE id < :max_id AND alpha LIKE :alpha"; $stmt = $db->prepare($sql); $stmt->bindValue(':max_id', 5, PDO::PARAM_INT); $stmt->bindValue(':alpha', 'A%'); $stmt->execute(); But this is where I get mixed up as to what I should be doing. Zend_Db::execute() will return false when the query has an error (right?), but it will also throw an exception. Exceptions override a return, so I have to put a try {} catch() {} around every query I make?? Without implementing a Table Data Gateway or other data access pattern, is there a "better" way to use this class? Quote Link to comment https://forums.phpfreaks.com/topic/95659-zend-framework-zend_db-best-practices/ Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.