|
以下是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;
- }
-
- ?>
复制代码
|
|