实现“上一页”和“下一页amp;quot;按钮

?php //本例子摘自phpbuilder.com //稍加翻译 //sprming@netease.com
$limit=20; // 每页显示的行数 $numresults=mysql_query(“select * from
TABLE where YOUR CONDITIONAL HERE order by
WHATEVER”);//换成你所需要的sql语句
$numrows=mysql_num_澳门新葡亰网站注册,rows($numresults); // next determine if offset has
been passed to script, if not use 0 if (empty($offset)) { $offset=1; }
// 得到查询结果 $result=mysql_query(“select id,name,phone “. “from
TABLE where YOUR CONDITIONAL HERE “. “order by WHATEVER limit
$offset,$limit”); // 现在显示查询结果 while
($data=mysql_fetch_array($result)) { //
在这里插入您要显示的结果以及样式 } // 显示按钮 if ($offset!=1) { //
bypass PREV link if offset is 1 $prevoffset=$offset-20; print “a
href=”$PHP_SELF?offset=$prevoffset”/a nbsp; “; } // 计算页面数
$pages=intval($numrows/$limit); // $pages now contains int of pages
needed unless there is a remainder from division if ($numrows%$limit) {
// has remainder so add one page $pages++; } for ($i=1;$i=$pages;$i++) {
// 显示页数 $newoffset=$limit*($i-1); print “a
href=”$PHP_SELF?offset=$newoffset”$i/a nbsp; “; } // check to see if
last page if (!(($offset/$limit)==$pages) $pages!=1) { // not last page
so give NEXT link $newoffset=$offset+$limit; print “a
href=”$PHP_SELF?offset=$newoffset”/ap”; } ?