php+mysql最好使用的分页函数。 不好,还是用limit来得简便来得快 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 limit和order在mysql里不能合用~~ limit和order在mysql里不能合用~~为什么不能合用? limit和order在mysql里不能合用~~我的mysql怎么可以 limit和order在mysql里不能合用~~4242,我的也可以收藏! 我也经常用这个,比较方便。www.gflight.com 见笑/*// ------------------------------ -------- ------------------------------ //by Kit$setid - 起始记录数$num - 记录总数$page_url - 页面链接,如 list.php?type=1$list_num - 每页记录数$list_page_num - 每列页数$fontcolor - 链接字体颜色格式:1 2 3 4 5 > >> - 151 - << < 6 7 8 9 10 > >> - 15// ------------------------------ -------- ------------------------------ //*/// ------------------------------ function LIST_PAGES ------------------------------ //function list_pages($setid=0,$num,$page_url,$list_num=10,$list_page_num=5,$fontcolor=ffffff){// get pages$pages = ceil($num/$list_num);$page = ceil($pages/$list_page_num);// get setpageif ($setid > 0): $setpage1 = ceil($setid/$list_num); $setpage = ceil(($setpage1+1)/$list_page_num);else: $setid = 0; $setpage = 1;endif;if ($pages > $list_page_num): $pagenum = $list_page_num;else: $pagenum = $pages;endif;// [1]if ($setpage > 1): echo "<a title='第一页' href='$page_url&setid=0'><font color=$fontcolor>1</font></a> - \n";endif;// [<<]if ($setpage > 1): $lastsetid = ($setpage-2)*$list_page_num*$list_num; echo "<a title='上一列' href='$page_url&setid=$lastsetid'><font color=$fontcolor><<</font></a>\n";endif;// [<]if ($setid > 0): $presetid = $setid-$list_num; echo "<a title='上一页' href='$page_url&setid=$presetid'><font color=$fontcolor><</font></a>\n";endif;// [...]$i1 = ($setpage-1)*$list_page_num;for ($i=$i1; $i<($i1+$pagenum) && $i<$pages; $i++){$newsetid=$list_num*$i;if (($setid/$list_num) == $i): echo "<b><u><font color=$fontcolor>".($i+1)."</font></u></b>\n";else: echo "<a href='$page_url&setid=$newsetid'><font color=$fontcolor>".($i+1)."</font></a>\n";endif;}// [>]if ($pages!=0 && ($setid/$list_num+1)!=$pages && ($setid/$list_num+1)<=$pages||$setid==1): $newsetid = $setid+$list_num; echo "<a title='下一页' href='$page_url&setid=$newsetid'><font color=$fontcolor>></font></a>\n";endif;// [>>]if ($pages!=0 && $pages>$list_page_num && $setpage<$page): $nextsetid = $setpage*$list_page_num*$list_num; echo "<a title='下一列' href='$page_url&setid=$nextsetid'><font color=$fontcolor>>></font></a>\n";endif;// [num]if ($pages>$list_page_num && $setpage<$page): $lastsetid = $list_num*($pages-1); echo " - <a title='最后一页' href='$page_url&setid=$lastsetid'><font color=$fontcolor>$pages</font></a>\n";endif;} // end list_pages// ------------------------------ -------- ------------------------------ // 显示页面<?if (empty($_GET[setid]) || $_GET['setid'] < "0") $_GET['setid'] = 0;$sql = "SELECT COUNT(id) AS num FROM tablename";$result = mysql_db_query($dbname, $sql);$num = mysql_result($result,0,"num");$sql = "SELECT * FROM tablename ORDER BY id DESC LIMIT $_GET[setid], 10";$result = mysql_db_query($dbname, $sql);while ($row = mysql_fetch_array($result)){// list records...}$page_url = $_SERVER['PHP_SELF']."?type=1";list_pages($_GET['setid'],$num,$page_url,10,5,"000000");?> http://www.gzlight.com/gallery/show.php这种效果的分页如何写啊?是图片分页,要求每行2张图,一页4张图,剩下的开始分页!!请大家帮忙~~ 顶级PHP大师的开发原则 插入不重复记录~~~求一mysql语句~~~ 难题请教 - iframe的跨域高度调节问题 php 往xml添加节点问题!!!!!!!!! 问一个读文本的脚本问题 很奇怪...关天列表框 请问我这样在PHP中访问MS Sql Server为什么会出错 以前用得好好的程序,现在连不上数据库了。 求救,我要气死了,请大家一定帮忙,谢谢! session问题 关于检测IP的迷惑 已经第五天了,在WIN2000下屡装PHP+MYSQL+APACHE都不成功,极其郁闷啊,也查了很多资料,真想炸了机子,对PHP的学习打击太大了,那个大哥
/*
// ------------------------------ -------- ------------------------------ //
by Kit$setid - 起始记录数
$num - 记录总数
$page_url - 页面链接,如 list.php?type=1
$list_num - 每页记录数
$list_page_num - 每列页数
$fontcolor - 链接字体颜色格式:
1 2 3 4 5 > >> - 15
1 - << < 6 7 8 9 10 > >> - 15// ------------------------------ -------- ------------------------------ //
*/// ------------------------------ function LIST_PAGES ------------------------------ //function list_pages($setid=0,$num,$page_url,$list_num=10,$list_page_num=5,$fontcolor=ffffff){
// get pages
$pages = ceil($num/$list_num);
$page = ceil($pages/$list_page_num);// get setpage
if ($setid > 0):
$setpage1 = ceil($setid/$list_num);
$setpage = ceil(($setpage1+1)/$list_page_num);
else:
$setid = 0;
$setpage = 1;
endif;if ($pages > $list_page_num):
$pagenum = $list_page_num;
else:
$pagenum = $pages;
endif;
// [1]
if ($setpage > 1):
echo "<a title='第一页' href='$page_url&setid=0'><font color=$fontcolor>1</font></a> - \n";
endif;// [<<]
if ($setpage > 1):
$lastsetid = ($setpage-2)*$list_page_num*$list_num;
echo "<a title='上一列' href='$page_url&setid=$lastsetid'><font color=$fontcolor><<</font></a>\n";
endif;// [<]
if ($setid > 0):
$presetid = $setid-$list_num;
echo "<a title='上一页' href='$page_url&setid=$presetid'><font color=$fontcolor><</font></a>\n";
endif;// [...]
$i1 = ($setpage-1)*$list_page_num;
for ($i=$i1; $i<($i1+$pagenum) && $i<$pages; $i++){$newsetid=$list_num*$i;
if (($setid/$list_num) == $i):
echo "<b><u><font color=$fontcolor>".($i+1)."</font></u></b>\n";
else:
echo "<a href='$page_url&setid=$newsetid'><font color=$fontcolor>".($i+1)."</font></a>\n";
endif;}// [>]
if ($pages!=0 && ($setid/$list_num+1)!=$pages && ($setid/$list_num+1)<=$pages||$setid==1):
$newsetid = $setid+$list_num;
echo "<a title='下一页' href='$page_url&setid=$newsetid'><font color=$fontcolor>></font></a>\n";
endif;// [>>]
if ($pages!=0 && $pages>$list_page_num && $setpage<$page):
$nextsetid = $setpage*$list_page_num*$list_num;
echo "<a title='下一列' href='$page_url&setid=$nextsetid'><font color=$fontcolor>>></font></a>\n";
endif;// [num]
if ($pages>$list_page_num && $setpage<$page):
$lastsetid = $list_num*($pages-1);
echo " - <a title='最后一页' href='$page_url&setid=$lastsetid'><font color=$fontcolor>$pages</font></a>\n";
endif;
} // end list_pages
// ------------------------------ -------- ------------------------------ //
$result = mysql_db_query($dbname, $sql);
$num = mysql_result($result,0,"num");$sql = "SELECT * FROM tablename ORDER BY id DESC LIMIT $_GET[setid], 10";
$result = mysql_db_query($dbname, $sql);while ($row = mysql_fetch_array($result)){// list records...}$page_url = $_SERVER['PHP_SELF']."?type=1";
list_pages($_GET['setid'],$num,$page_url,10,5,"000000");?>
是图片分页,要求每行2张图,一页4张图,剩下的开始分页!!
请大家帮忙~~