PHP连接sqlserver数据库查询问题

[黑白彩虹SN]

<?php
$serverName = "(local)";//服务器地址

$uid = "labking";//资料库用户名

$pwd = "13621120445";//资料库密码

$db_name = "test";//资料库名

$connectionInfo = array("UID"=>$uid,"PWD"=>$pwd,"Database"=>$db_name);

$conn = sqlsrv_connect($serverName,$connectionInfo);

if($conn == false)
{

echo "Connect error!";

die(print_r(sqlsrv_errors(),true));
}
//执行sql语句
$stmt = sqlsrv_query($conn, "SELECT TOP 1 [PatType],[PatName],[PatSex],[PatAge] FROM [test].[dbo].[patient]",

array(), array("Scrollable" => SQLSRV_CURSOR_KEYSET));

if($stmt == false)
{

echo"Error in executin query.";

die(print_r(sqlsrv_errors(),true));
}
?>

执行查询语句显示空白。。。。有大神看下吗

[xuzuning]

你是查询了，但你并没有读取和输出查询结果

[PF披风]

加这 while($row = sqlsrv_fetch_array($stmt , SQLSRV_FETCH_ASSOC)){ print_r($row); print_r("<br>"); }

[老虎爱代码]

可以看看官方文档！

http://php.net/manual/zh/function.sqlsrv-fetch-array.php

<?php
$serverName = "serverName\instanceName";
$connectionInfo = array( "Database"=>"dbName", "UID"=>"username", "PWD"=>"password");
$conn = sqlsrv_connect( $serverName, $connectionInfo );
if( $conn === false ) {
    die( print_r( sqlsrv_errors(), true));
}

$sql = "SELECT FirstName, LastName FROM SomeTable";
$stmt = sqlsrv_query( $conn, $sql );
if( $stmt === false) {
    die( print_r( sqlsrv_errors(), true) );
}

while( $row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC) ) {
      echo $row['LastName'].", ".$row['FirstName']."<br />";
}

sqlsrv_free_stmt( $stmt);
?>