在Zend FrameWork中调用mysql的存储过程方法如下:
$db = Zend_Db::factory($sql_DbType,$sql_Config);
$connection=$db->getConnection();
Zend_Registry::set("db",$db);
Zend_Registry::set("connect",$connection);
调用存储过程如下代码所示:
$this->_db = Zend_Registry::get('db');
$connection=Zend_Registry::get("connect");
$connection->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY,true);
$prev_next_rs=$this->_db->query('call moretableSelect();')->fetchAll();