PHP 连接MSSQL2008问题请教

linqfe

1. <?php
   
2. /* Connect to the local server using Windows Authentication and
   
3. specify the AdventureWorks database as the database in use. */
   
4. $serverName = "192.168.104.124";
   
5. $connectionInfo = array("UID"=>"sa", "PWD"=>"0", "Database"=>"southeast");
   
6. $conn = sqlsrv_connect( $serverName, $connectionInfo);
   
7. if( $conn === false )
   
8. {
   
9.      echo "Could not connect.\n";
   
10.      die( print_r( sqlsrv_errors(), true));
    
11. }
    
12. 
    
13. /* Set up and execute the query. */
    
14. $tsql = "select * from Vender";
    
15. $stmt = sqlsrv_query( $conn, $tsql, array());
    
16. if( $stmt === false)
    
17. {
    
18.      echo "Error in query preparation/execution.\n";
    
19.      die( print_r( sqlsrv_errors(), true));
    
20. }
    
21. /* Retrieve each row as an associative array and display the results.*/
    
22. $i =0;
    
23. while( $row = sqlsrv_fetch_array( $stmt))
    
24. {
    
25.       echo $row['ID'].", ".$row['CompanyName']."<br>";
    
26.       $i++;
    
27. }
    
28.       echo $i;
    
29. 
    
30. /* Free statement and connection resources. */
    
31. sqlsrv_free_stmt( $stmt);
    
32. sqlsrv_close( $conn);
    
33. ?>

复制代码

为什么以上只会输出一条，不会循环输出。

通达张建君

您好，联系一下定制开发部门具体的咨询一下：http://www.tongda2000.com/service/dev_ser.php 电话：010-53617864  QQ：2517609862。