zend框架实现支持sql server的操作方法

本文实例讲述了zend框架实现支持sql server的操作方法。分享给大家供大家参考，具体如下：
1.修改Zend/Db/Adapter/Pdo/Abstract.php中的connect方法

protected function _connect（）{// if we already have a PDO object, no need to re-connect.if （$this->_connection） {return;}// get the dsn first, because some adapters alter the $_pdoType$dsn = $this->_dsn（）;// check for PDO extensionif （！extension_loaded（"pdo"）） {/** * [url=home.php?mod=space&uid=86763]@see[/url] Zend_Db_Adapter_Exception */require_once "Zend/Db/Adapter/Exception.php";throw new Zend_Db_Adapter_Exception（"The PDO extension is required for this adapter but the extension is not loaded"）;}// check the PDO driver is availableif （！in_array（$this->_pdoType, PDO::getAvailableDrivers（））） {/** * @see Zend_Db_Adapter_Exception */require_once "Zend/Db/Adapter/Exception.php";throw new Zend_Db_Adapter_Exception（"The " . $this->_pdoType . " driver is not currently installed"）;}// create PDO connection$q = $this->_profiler->queryStart（"connect", Zend_Db_Profiler::CONNECT）;// add the persistence flag if we find it in our config arrayif （isset（$this->_config["persistent"]） && （$this->_config["persistent"] == true）） {$this->_config["driver_options"][PDO::ATTR_PERSISTENT] = true;}try {//print_r（$this->_config）;exit;if（$this->_config["pdoType"]=="sqlsrv"）{$this->_connection = new PDO（ "sqlsrv:Server=".$this->_config["host"].";Database = ".$this->_config["dbname"], $this->_config["username"], $this->_config["password"]）;$this->_connection->setAttribute（ PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION ）;$this->_connection->setAttribute（ PDO::SQLSRV_ATTR_ENCODING, PDO::SQLSRV_ENCODING_UTF8 ）;$this->_profiler->queryEnd（$q）;}elseif （$this->_config["pdoType"]=="dblib"） {$this->_connection = new PDO（$dsn,$this->_config["username"],$this->_config["password"],$this->_config["driver_options"]）;$this->_profiler->queryEnd（$q）;}// set the PDO connection to perform case-folding on array keys, or not$this->_connection->setAttribute（PDO::ATTR_CASE, $this->_caseFolding）;// always use exceptions.$this->_connection->setAttribute（PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION）;} catch （PDOException $e） {/** * @see Zend_Db_Adapter_Exception */require_once "Zend/Db/Adapter/Exception.php";throw new Zend_Db_Adapter_Exception（$e->getMessage（））;}}

这里针对linux和windows提供两种连接方式。
2.mssql.php 中的为 protected $_pdoType = "sqlsrv";

protected function _dsn（）{// baseline of DSN parts$dsn = $this->_config;// don"t pass the username and password in the DSNunset（$dsn["username"]）;unset（$dsn["password"]）;unset（$dsn["driver_options"]）;if （isset（$dsn["port"]）） {$seperator = ":";if （strtoupper（substr（PHP_OS, 0, 3）） === "WIN"） {$seperator = ",";}$dsn["host"] .= $seperator . $dsn["port"];unset（$dsn["port"]）;}// this driver supports multiple DSN prefixes// @see http://www.php.net/manual/en/ref.pdo-dblib.connection.php//print_r（$dsn）;exit;if （isset（$dsn["pdoType"]）） {switch （strtolower（$dsn["pdoType"]）） {case "freetds":case "sybase":$this->_pdoType = "sybase";break;case "mssql":$this->_pdoType = "mssql";break;case "sqlsrv":$this->_pdoType = "sqlsrv";break;case "dblib":default:$this->_pdoType = "dblib";break;}unset（$dsn["pdoType"]）;}// use all remaining parts in the DSNforeach （$dsn as $key => $val） {$dsn[$key] = "$key=$val";}$dsn = $this->_pdoType . ":" . implode（";", $dsn）; // print_r（$dsn）;exit;return $dsn;}

3.ZF 的web.xml 数据库配置文件改成：

<db><adapter>PDO_MSSQL</adapter><config><host>localhost</host><username>sa</username><password>123456</password><dbname>testdb </dbname><pdoType>sqlsrv</pdoType></config></db>

期间遇到中文乱码问题

function convert2utf8（$string）{$config = $this->getCfg（）;$pdoType = $config->db->config->pdoType;if（$pdoType == "dblib"）{return iconv（"gbk","utf-8",$string）;}elseif（$pdoType == "sqlsrv"）{return mb_convert_encoding（$string,"UTF-8","auto"）;}}function convert2gbk（$string）{$config = $this->getCfg（）;$pdoType = $config->db->config->pdoType;if（$pdoType == "dblib"）{return iconv（"utf-8","gbk",$string）;}elseif（$pdoType == "sqlsrv"）{return mb_convert_encoding（$string,"GBK","auto"）;}}protected function &getCfg（） {if （$this->cfg_ === null） {$registry = Zend_Registry::getInstance（）;$this->cfg_ = $registry->get（"web_config"）;}return $this->cfg_;}

针对不同的类型，进行不同的处理。
更多关于zend相关内容感兴趣的读者可查看本站专题：《Zend FrameWork框架入门教程》、《php优秀开发框架总结》、《Yii框架入门及常用技巧总结》、《ThinkPHP入门教程》、《php面向对象程序设计入门教程》、《php+mysql数据库操作入门教程》及《php常见数据库操作技巧汇总》
希望本文所述对大家基于Zend Framework框架的PHP程序设计有所帮助。