windows系統(tǒng)IIS下php.X連接并啟用sqlserver擴(kuò)展（php_sqlsrv）

第四步：下載 ODBC Driver；

PS：注意這里的x86與x64是根據(jù)電腦系統(tǒng)判斷的，不是根據(jù)php版本

Microsoft? ODBC Driver 11 for SQL Server? - Windows （支持Sql Server? 2005） ?https://www.microsoft.com/zh-CN/download/details.aspx?id=36434

Microsoft? ODBC Driver 13 for SQL Server? - Windows + Linux （支持最新的SQL Server? 2016） ?https://www.microsoft.com/zh-CN/download/details.aspx?id=50420

這里安裝，只需要下一步下一步即可完成安裝...

建議 安裝ODBC Driver，根據(jù)自己的需要選擇上面的地址下載并安裝。

如果上面的ODBC版本太高,那么用這個(gè)低一點(diǎn)的 ODBC Driver 本站有下載 https://pan.baidu.com/s/1bkkArys7xBaJ9GUc9aDf9g? 提取碼：b6yo

現(xiàn)在可以使用phpinfo() 來(lái)查看是否成功加載了?pdo_sqlsrv 模塊。

PS：延伸閱讀：

PHP5.4連接sqlserver

1.下載微軟的php連接驅(qū)動(dòng)：SQLSRV30.EXE（5.4對(duì)應(yīng)，后面的native client要用2012）/SQLSRV20.EXE（5.3對(duì)應(yīng)，native client要用2008）/SQLSERV31.EXE對(duì)應(yīng)5.5

2.解壓SQLSERV30.EXE，拷貝對(duì)應(yīng)extension到php的ext目錄

3.配置php.ini

extension=php_sqlsrv_54_ts.dll（54為5.4版本，ts為線(xiàn)程安全，nts為非線(xiàn)程安全，帶pdo的是用pdo方式連接，sqlsrvxx.exe里都有）

mssql.secure_connection?=?Off改為on?很多教程沒(méi)寫(xiě)這個(gè)

4.重啟IIS/Apache

5.在sqlserver服務(wù)器配置TCP/IP連接

6.在php服務(wù)器下載安裝sqlserver native client(win8下裝上這玩意http://www.microsoft.com/en-us/download/details.aspx?id=20098)

測(cè)試代碼

連接sqlserver

?前提是sqlserver可以外網(wǎng)連接。

$database = "數(shù)據(jù)庫(kù)名稱(chēng)";
$uid = "sa";
$pwd = "123";
$Server = "192.168.0.152";
$conInfo=array('Database'=>$database,'UID'=>$uid,'PWD'=>$pwd);
$link=sqlsrv_connect($Server,$conInfo);

if( $link ){
// echo "Connection established.\n";
$query = 'SELECT * FROM T_Sys_UserInfo';

/* Set parameter values. */
$params = array(75123, 5, 741, 1, 818.70, 0.00);

/* Prepare and execute the query. */
$stmt = sqlsrv_query( $link, $query, $params);
while( $row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC))
{
echo $row['UseName'].", ".$row['RealName']."\n";
}

}
else{
//echo "Connection could not be established. ";
print_r( sqlsrv_errors(), true);
if( ($errors = sqlsrv_errors() ) != null) {
foreach( $errors as $error ) {
echo "SQLSTATE: ".$error[ 'SQLSTATE']."<br />";
echo "code: ".$error[ 'code']."<br />";
echo "message: ".$error[ 'message']."<br />";
}
}
die("");
}

PDO方式連接:

<?php
header("Content-Type: text/html;charset=utf-8");

class mssql{
private $host;
private $username;
private $password;
private $database;
private $handle;
private function __construct (Array $config){
$this -> host = $config['host'];
$this -> username = $config['username'];
$this -> password = $config['password'];
$this -> database = $config['database'];
$this -> init();
}
private function init() {
$dsn = 'sqlsrv:server = '.$this -> host.';database = '.$this->database;
$this -> handle = new PDO($dsn,$this -> username, $this -> password);
}
public static function GetInstance(array $config = null) {
if (null == $config) {
return NULL;
}
static $db = null;
if (null == $db) {
$c = __CLASS__;
$db = new $c($config);
};
return $db -> handle;
}
}

$config = array(
'host' => '192.168.0.152,1433',
'database' => '數(shù)據(jù)庫(kù)名稱(chēng)',
'username' => 'sa',
'password' => '123'
);
$mssql = mssql::GetInstance($config);
$result = $mssql->query('SELECT * FROM T_Sys_UserInfo');
foreach($result as $row){
echo $row[2];
}
?>