您好,欢迎来到三六零分类信息网!老站,搜索引擎当天收录,欢迎发信息

php中怎样遍历sqlserver数据?

2024/6/25 6:48:05发布32次查看
$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解决了
该用户其它信息

VIP推荐

免费发布信息,免费发布B2B信息网站平台 - 三六零分类信息网 沪ICP备09012988号-2
企业名录 Product