PHP连接SQL server数据库测试脚本运行实例

欧阳锋

以下是php7上的测试 sqlsrv扩展

1. <?php
   
2. header("Content-type: text/html; charset=utf-8");
   
3.     $serverName = "192.168.0.1"; //数据库服务器地址
   
4.     $uid = "site_user"; //数据库用户名
   
5.     $pwd = "zkJ1246g"; //数据库密码
   
6.     $connectionInfo = array("UID"=>$uid, "PWD"=>$pwd, "Database"=>"db_site");
   
7.     $conn = sqlsrv_connect( $serverName, $connectionInfo);
   
8.     if( $conn == false)
   
9.     {
   
10.         echo "连接失败！";
    
11.         die( print_r( sqlsrv_errors(), true));
    
12.     }else{
    
13.         echo "连接成功！";
    
14.     }
    
15.     #$query = sqlsrv_query($conn, "select * from 数据库表");
    
16.     #while($row = sqlsrv_fetch_array($query))
    
17.     #{
    
18.     # print_r($row);
    
19.     #}
    
20. ?>
    

复制代码

以下是php5上的测试dblib扩展

1. <?php
   
2.   
   
3. try {
   
4.   $hostname = "192.168.17";
   
5.   $dbname = "lee";
   
6.   $username = "le2r";
   
7.   $pwd = "le52";
   
8.   $dsn="dblib:host=$hostname;dbname=$dbname;charset=UTF-8";
   
9.   
   
10.   $conn = new PDO ($dsn,$username,$pwd);
    
11.   $conn->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
    
12.   echo "mssql database connnection sucessed!\n";
    
13.   } catch (PDOException $e) {
    
14.   echo "Failed to get DB handle: " . $e->getMessage() . "\n";
    
15.   exit;
    
16.   }
    
17.   
    
18. ?>

复制代码