PHP 連線 MSSQL 使用sqlsrv

使用環境：

1. 伺服器：Windows7
2. Apache：2.2.22
3. PHP：5.4.3
4. MSSQL Server：SQLSERVER2008

網站伺服器需要安裝：

1. SQLSRV30.EXE
2. SQL Server Native Client ,sqlncli.msi

PHP 需要 extensions 套件：

PHP 登入範例：

<?php
 $DB_HOST1        = "";//IP    
 $DB_LOGIN1       = "";//uid
 $DB_PASSWORD1    = "";//pwd
 $DB_NAME1        = "";//db name 
 
 $serverName = $DB_HOST1;
 $connectionInfo = array("UID"=>$DB_LOGIN1, "PWD"=>$DB_PASSWORD1, "Database"=>$DB_NAME1, "CharacterSet" => "UTF-8" );
 $conn = sqlsrv_connect( $serverName, $connectionInfo); 
 
 $params = array();
 $options =  array( "Scrollable" => SQLSRV_CURSOR_KEYSET );
 $sqlstr = "select * from Users";
 $res = sqlsrv_query($conn,$sqlstr,$params,$options);
 $num = sqlsrv_num_rows($res);
 for($i=0;$i<$num;$i++)
 {
  $r = sqlsrv_fetch_array($res);
  echo $r[0].' '.$r[1].'<br />';
 }
?>