PHP MSSQL 分页实例，刷新

<?php

/*

'页面说明：

*/

$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 "共计: $totalnum 条记录,共 $pagecount 页,当前是第 $page 页 ";

if($page!=1)

{

echo "<a href=?page=1$filster>首页</a> ";

echo "<a href=?page=".($page-1)."$filster>上一页</a> ";

}

if($page<$pagecount)

{

echo "<a href=?page=".($page+1)."$filster>下一页</a> ";

echo "<a href=?page=$pagecount$filster>尾页</a>&nbsp;&nbsp;";

}

}

?>