1、3、5、6、7、8、9 关于分页 一般都是用url传递值,例如http://localhost/test.php?page=4 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 请参考:<?php /* function:break page author: date:2003.7.15 parameter: num=all of your pages; perpage= how many do you want to show; curr_page=current page; mpurl=current url; return: multipage=a string under your page */ function multi($num, $perpage, $curr_page, $mpurl) { if($num > $perpage) { $page = 10; $offset = 2; $pages = ceil($num / $perpage);//得到页数 $from = $curr_page - $offset;//偏移两页 $to = $curr_page + $page - $offset - 1; if($page > $pages) { $from = 1; $to = $pages; } else { if($from < 1) { $to = $curr_page + 1 - $from; $from = 1; if(($to - $from) < $page && ($to - $from) < $pages) { $to = $page; } } elseif($to > $pages) { $from = $curr_page - $pages + $to; $to = $pages; if(($to - $from) < $page && ($to - $from) < $pages) { $from = $pages - $page + 1; } } } $fwd_back .= "<a href=\"$mpurl&page=1\"><<</a> "; for($i = $from; $i <= $to; $i++) { if($i != $curr_page) { $fwd_back .= "<a href=\"$mpurl&&page=$i\">[$i]</a> "; } else { $fwd_back .= "<u><b>[$i]</b></u> "; } } $fwd_back .= $pages > $page ? " ... <a href=\"$mpurl&&page=$pages\"> [$pages] >></a>" : " <a href=\"$mpurl&&page=$pages\">>></a>"; $multipage = $fwd_back; } return $multipage; } //use //分页开始 /* 如果你有一个表叫XXXX,里面有字段叫cid和time,那么可以这样使用。第一次查询出总数num,第二次是进行你所要进行的真正查询,如内容什么的, mpurl是你当前页面的url,multipage是最后得到的一个分页串, */ $table="XXXX"; $sql1 = "SELECT COUNT(*) AS rcnt FROM $table where cid=$cid ORDER BY time DESC"; $result1 = @mysql_query($sql1); $array1 = @mysql_fetch_array($result1); $num = $array1[rcnt]; $mpurl = "XXXX.php?cid=$cid"; if(!empty($page)) { $start_limit = ($page - 1) * $morenum; } else { $start_limit = 0; $page = 1; } $multipage = multi($num,$morenum,$page,$mpurl); $sql="select * from $table where cid=$cid order by time desc limit $start_limit,$morenum"; //分页结束 $result = @mysql_query($sql); while($array = @mysql_fetch_array($result)){ XXXXX; }//至此已取得数组,不用我再写了吧,我得回家了。 ?> php中禁不掉浏览器缓存的问题 关于得到参数问题! 求一 PHP AJAX二级联动-城市地区的问题,在线等 求一解决方案,关于url地址的问题 有关cookies的问题 两个函数之间变量传递的问题 狂急!mysql远程连接突然变慢?不知什么原因? PHP连接MS SQL的问题!! 关于页面及时更新的问题 Apache必须安装在C盘吗 急问,php+iis+mysql的安装文件谁有啊? 我的PHP程序在浏览器中显示中文显示的是乱码,何故?
/*
function:break page
author:
date:2003.7.15
parameter:
num=all of your pages;
perpage= how many do you want to show;
curr_page=current page;
mpurl=current url;
return:
multipage=a string under your page
*/
function multi($num, $perpage, $curr_page, $mpurl)
{
if($num > $perpage)
{
$page = 10;
$offset = 2;
$pages = ceil($num / $perpage);//得到页数
$from = $curr_page - $offset;//偏移两页
$to = $curr_page + $page - $offset - 1;
if($page > $pages)
{
$from = 1;
$to = $pages;
}
else
{
if($from < 1)
{
$to = $curr_page + 1 - $from;
$from = 1;
if(($to - $from) < $page && ($to - $from) < $pages)
{
$to = $page;
}
}
elseif($to > $pages)
{
$from = $curr_page - $pages + $to;
$to = $pages;
if(($to - $from) < $page && ($to - $from) < $pages)
{
$from = $pages - $page + 1;
}
}
}
$fwd_back .= "<a href=\"$mpurl&page=1\"><<</a> ";
for($i = $from; $i <= $to; $i++)
{
if($i != $curr_page)
{
$fwd_back .= "<a href=\"$mpurl&&page=$i\">[$i]</a> ";
}
else
{
$fwd_back .= "<u><b>[$i]</b></u> ";
}
}
$fwd_back .= $pages > $page ? " ... <a href=\"$mpurl&&page=$pages\"> [$pages] >></a>" : " <a href=\"$mpurl&&page=$pages\">>></a>";
$multipage = $fwd_back;
}
return $multipage;
}
//use
//分页开始
/*
如果你有一个表叫XXXX,里面有字段叫cid和time,那么可以这样使用。第一次查询出总数num,第二次是进行你所要进行的真正查询,如内容什么的,
mpurl是你当前页面的url,multipage是最后得到的一个分页串,
*/
$table="XXXX";
$sql1 = "SELECT COUNT(*) AS rcnt FROM $table where cid=$cid ORDER BY time DESC";
$result1 = @mysql_query($sql1);
$array1 = @mysql_fetch_array($result1);
$num = $array1[rcnt];
$mpurl = "XXXX.php?cid=$cid";
if(!empty($page)) {
$start_limit = ($page - 1) * $morenum;
}
else {
$start_limit = 0;
$page = 1;
}
$multipage = multi($num,$morenum,$page,$mpurl);
$sql="select * from $table where cid=$cid order by time desc limit $start_limit,$morenum";
//分页结束
$result = @mysql_query($sql);
while($array = @mysql_fetch_array($result)){
XXXXX;
}//至此已取得数组,不用我再写了吧,我得回家了。
?>