<?php
/*
 '頁(yè)面闡明：
*/
$link=mssql_connect("MYSQL2005","sa","123456") or die("db link error!".mssql_error());
mssql_select_db("edu_dzk",$link) or die("db open error!".mssql_error());
//mssql_query("set names 'utf8'");
$sqlstrcount="SELECT count(1) FROM reguser";
$page = $_GET["page"];
if(!is_numeric($page)){
 $page="1";
}
$pagesize="30";
//$sql=mysql_query($sqlstr);
//$totalnum=mysql_num_rows($sql);
$sql=mssql_query($sqlstrcount);
list($totalnum)=mssql_fetch_row($sql);
$pagecount=ceil($totalnum/$pagesize);
$offset=($page-1)*$pagesize;
$sqlstr="Select top ".($pagesize)." * from reguser where id not in (select top ".(($page-1)*$pagesize)." id from reguser order by id desc) order by id desc";
$sql=mssql_query($sqlstr);
$result="";
while($result=mssql_fetch_array($sql)){
 echo $result["id"].'<br>';
}
showpageinfo2($totalnum,$pagecount,$page,"&z=".$z);
mssql_Close($link);
function showpageinfo2($totalnum,$pagecount,$page,$filster)
{
 echo "共計(jì): $totalnum 條記錄,共 $pagecount 頁(yè),當(dāng)前是第 $page 頁(yè) ";
 if($page!=1)
 {
 echo "<a href=?page=1$filster>首頁(yè)</a> ";
 echo "<a href=?page=".($page-1)."$filster>上一頁(yè)</a> ";
 }
 if($page<$pagecount)
 {
 echo "<a href=?page=".($page+1)."$filster>下一頁(yè)</a> ";
 echo "<a href=?page=$pagecount$filster>尾頁(yè)</a>??";
 }
}
?>