Zend中的PHP数据对象

Question

I'm building an API in Zend. The development environment is in MySQL and will likely deploy to an environment that uses MS SQL. I've not used PDO before and I'm still wrapping my head around its implementation. Here's what I have in one of my actions. (I'll clean it up and put it in a proper model when I get this figured out.)

$params=array('host' =>'localhost',
  'username'         => '****',
  'password'         => '****',
  'dbname'           => '****');
$db = new Zend_Db_Adapter_Pdo_Mysql($params);
$db->setFetchMode(Zend_Db::FETCH_OBJ);
$sql = 'Select * from test';
$this->response->data = $db->fetchAssoc($sql);

This gives me the information I want. Am I correct in believing that I can switch out what adapter I'm using when ready to deploy without changing my SQL statement and everything "should" work the same?

I know there's more sophisticated abstraction methods, but seeing how new I am to Zend, I'd like to keep it simple for now.

Answer 1

You have the right idea:

The Zend_Db adapters create a bridge from the vendor-specific PHP extensions to a common interface to help you write PHP applications once and deploy with multiple brands of RDBMS with very little effort.

Reference

As long as you are not doing anything MySQL-specific, you will be able to switch adapters as needed.