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

以下是php7上的测试 sqlsrv扩展

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

<?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扩展

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18

<?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;    }   ?>