php中怎樣遍曆sqlserver資料？

$serverName = "192.168.135.211";$connectionInfo = array( "Database"=>"AGGCRMTEST", "UID"=>"sa", "PWD"=>"123213");$conn = sqlsrv_connect( $serverName, $connectionInfo);if( $conn === false ){    echo "Could not connect.\n";    die( print_r( sqlsrv_errors(), true));}$tsql = "exec [GetListByName] 'o'";$stmt = sqlsrv_query( $conn, $tsql);if( $stmt === false ){    echo "Statement 1 could not be executed.
";    die( print_r( sqlsrv_errors(), true));}else{   $qty = sqlsrv_fetch_array( $stmt);   sqlsrv_free_stmt( $stmt);}

怎樣一個一個的取到資料啊。。。。。。。。。。。。。。（讓資料一個一個的顯示出來）

回複內容：

$serverName = "192.168.135.211";$connectionInfo = array( "Database"=>"AGGCRMTEST", "UID"=>"sa", "PWD"=>"123213");$conn = sqlsrv_connect( $serverName, $connectionInfo);if( $conn === false ){    echo "Could not connect.\n";    die( print_r( sqlsrv_errors(), true));}$tsql = "exec [GetListByName] 'o'";$stmt = sqlsrv_query( $conn, $tsql);if( $stmt === false ){    echo "Statement 1 could not be executed.
";    die( print_r( sqlsrv_errors(), true));}else{   $qty = sqlsrv_fetch_array( $stmt);   sqlsrv_free_stmt( $stmt);}

怎樣一個一個的取到資料啊。。。。。。。。。。。。。。（讓資料一個一個的顯示出來）

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

我插一句，建議你用PDO，之前也是用sqlsrv 後來發現有些字元顯示不出來而且INPUT/OUTPUT都需要ICONV轉換編碼，最後換PDO解決了

