function genpage(&$sql,$page_size=10)
{
global $pages,$sums,$eachpage,$page; //总页数，总记录，每页数，当前页
$page = $_GET["page"];
if($page ==0)$page =1;
$eachpage = $page_size;
$pagesql = strstr($sql," from ");
$pagesql = "select count(*) as ids ".$pagesql;
$conn = mysql_query($pagesql) or die(mysql_error());
if($rs = mysql_fetch_array($conn))$sums = $rs[0];
$pages=ceil($sums/$eachpage);
if($pages==0)$pages=1;
$startpos = ($page-1)*$eachpage;
$sql .=" limit $startpos,$eachpage ";
} //显示分页
function showpage()
{
global $pages,$page; //总页数，总记录，每页数，当前页，其它参数
$link=$_SERVER['PHP_SELF'];
echo "记录".$sums.":".$eachpage." ";
echo "页数".$page."/".$pages." ";
$p_head=$page-5;
if($p_head<=0)$p_head=1; //页码循环开始数 前5个
$p_end=$page+5;
if($p_end>$pages)$p_end=$pages; //页码循环结束数 后5个
echo "[
首页] ";
for($i=$p_head;$i<=$p_end;$i++)
{
if($i!=$page)
echo "
[$i] ";
else
echo "
[$i] ";
}
echo " [
末页]";
}
?>
