PHP 使用 MSSQL Server 如何分頁

msbeta

<?php
/* Connect to the local server using Windows Authentication and
specify the AdventureWorks database as the database in use. */
$serverName = "sqlserver";
$connectionInfo = array("UID" => $uid, "PWD" => $pwd, "Database"=>"opencourse");
$conn = sqlsrv_connect( $serverName, $connectionInfo);
if( $conn === false )
{
     echo "Could not connect.\n";
     die( print_r( sqlsrv_errors(), true));
}
/* Set up and execute the query. */
$tsql = "select dpt_name, area_name, cur_code, cur_name, tea_name from cur_list";
$stmt = sqlsrv_query( $conn, $tsql,array(),
                     array( "Scrollable" => SQLSRV_CURSOR_STATIC ));
                     
if( $stmt === false)
{
     echo "Error in query preparation/execution.\n";
     die( print_r( sqlsrv_errors(), true));
}
/* Retrieve each row as an associative array and display the results.*/
$i=0;
$offset = 4;
for ($i=0;$i<10;$i++) {
$rs = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC, SQLSRV_SCROLL_ABSOLUTE,$offset+$i);
  echo $rs['dpt_name'].' '.$rs['cur_name']."<br>\n";
}
/* Free statement and connection resources. */
sqlsrv_free_stmt( $stmt);
sqlsrv_close( $conn);
?>