怎样一个一个的取到数据啊。。。。。。。。。。。。。。(让数据一个一个的显示出来)
回复内容: $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解决了
