php连接SQL server 数据库测试php脚本

以下是php7上的测试 sqlsrv扩展

<?php
header("Content-type: text/html; charset=utf-8");
        $serverName = "192.168.0.1"; //数据库服务器地址
        $uid = "site_user"; //数据库用户名
        $pwd = "zkJ1246g"; //数据库密码
        $connectionInfo = array("UID"=>$uid, "PWD"=>$pwd, "Database"=>"db_site");
        $conn = sqlsrv_connect( $serverName, $connectionInfo);
        if( $conn == false)
        {
                echo "连接失败！";
                die( print_r( sqlsrv_errors(), true));
        }else{
                echo "连接成功！";
        }
        #$query = sqlsrv_query($conn, "select * from 数据库表");
        #while($row = sqlsrv_fetch_array($query))
        #{
        #  print_r($row);
        #}
?>

以下是php5上的测试dblib扩展

<?php

 try {
    $hostname = "192.168.17"; 
    $dbname = "lee";
    $username = "le2r"; 
    $pwd = "le52"; 
    $dsn="dblib:host=$hostname;dbname=$dbname;charset=UTF-8";

   $conn = new PDO ($dsn,$username,$pwd);
   $conn->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
   echo "mssql database connnection sucessed!\n";
   } catch (PDOException $e) {
   echo "Failed to get DB handle: " . $e->getMessage() . "\n";
   exit;
   }

?>