php中怎样遍历sqlserver数据？

Question

$serverName="127.0.0.1";$connectionInfo=array("Database"=>"AGGCRMTEST","UID"=>"root","PWD"=>"123456");$conn=sqlsrv_connect($serverName,$connectionInfo);if($conn===false){echo"Couldnotconnect.\n";die(print_r(sqlsrv_errors(),true));}$tsql="exec[GetListByName]'o'";$stmt=sqlsrv_query($conn,$tsql);if($stmt===false){echo"Statement1couldnotbeexecuted.";die(print_r(sqlsrv_errors(),true));}else{$qty=sqlsrv_fetch_array($stmt);sqlsrv_free_stmt($stmt);}怎样一个一个的取到数据啊。。。。。。。。。。。。。。（让数据一个一个的显示出来）

Answer 1

php$result=array();
while($qty=sqlsrv_fetch_array($stmt)){
$result[]=$qty;
}
sqlsrv_free_stmt($stmt);
                            

Answer 2

我插一句，建议你用PDO，之前也是用sqlsrv后来发现有些字符显示不出来而且INPUT/OUTPUT都需要ICONV转换编码，最后换PDO解决了