訓練家的快寫筆記

The legend of trainer's paper


搜尋:

     關閉     
標題:mssql 在 win php 連線方法
內容:
linux pdo mssql
http://www.phpv.net/html/1586.html

1. 下載 http://www.microsoft.com/downloads/info.aspx?na=41&srcfamilyid=80e44913-24b4-4113-8807-caae6cf2ca05&srcdisplaylang=en&u=http%3a%2f%2fdownload.microsoft.com%2fdownload%2fC%2fD%2fB%2fCDB0A3BB-600E-42ED-8D5E-E4630C905371%2fSQLSRV20.EXE

http://download.microsoft.com/download/C/D/B/CDB0A3BB-600E-42ED-8D5E-E4630C905371/SQLSRV30.EXE


SQLSRV2.0.exe

2.將SQLSRV2.0 安裝到 php 路徑下的 ext 裡

3.修改 php.ini (位址請參考 php.ini)
php5.2:
增加
extension=php_sqlsrv_52_ts_vc6.dll
extension=php_pdo_sqlsrv_52_ts_vc6.dll

php5.3:
增加
extension=php_sqlsrv_53_ts_vc9.dll
extension=php_pdo_sqlsrv_53_ts_vc9.dll

php5.4:
增加
extension=php_sqlsrv_54_ts.dll
extension=php_pdo_sqlsrv_54_ts.dll


4.重啟 appserv httpd
5.連線方法如下
<?
  $DB_HOST="192.168.8.14\3wa_server";
  $DB_LOGIN="sa";
  $DB_PASSWORD="我是密碼";
  $DB_NAME="羽山資料庫";
  $DB_KIND="sqlsrv";
    
  $pdo=new PDO("{$DB_KIND}:Database={$DB_NAME};server={$DB_HOST}",$DB_LOGIN,$DB_PASSWORD);
?>

6.其他同法同 pdo 使用方法 Ya~~~