PHP Connect SQL Server method

1. Download SQL Server Driver for PHP, unzip, copy the Php_pdo_sqlsrv_53_ts_vc9.dll and Php_sqlsrv_53_ts_vc9.dll to the Php-->ext folder

2. Modify the php.ini file,

Extension=php_pdo_sqlsrv_53_ts_vc9.dll

Extension=php_sqlsrv_53_ts_vc9.dll

3. Test whether Setup is successful

Perform a view of Phpinfo () in PHP sqlsrv

4.demo Test

<?PHP$type=$_get["TP"];$param=$_get["PRM"];if(isset($_get["TP"]) &&isset($_get["PRM"]) ){    $userInfo=NewUserInfo (); if($type= = "Select" &&$param= = "All")        Echo $userInfo-SelectAll (); }classuserinfo{ Public functionSelectAll () {$serverName= "192.168.1.8";//Database server address        $uid= "SA";//Database user name        $pwd= "1234?";//Database Password        $connectionInfo=Array("UID" =$uid, "PWD" =$pwd, "Database" = "DB"); $conn= Sqlsrv_connect ($serverName,$connectionInfo); if($conn==false)        {            Echo"Connection Failed! ";  die(Print_r(Sqlsrv_errors (),true)); }                $res=""; $query= Sqlsrv_query ($conn, "SELECT * from UserInfo");  while($row= Sqlsrv_fetch_array ($query))        {          $res.=$row[0]. ",".$row[1]. "|"; }        return $res; }}?>

ok~~~~~