到我的论坛去看看,php编程专区有关于分页原理的贴子,很经典。
在数据库专区有关于分页的类。希望对你有帮助。
==========================================
我的论坛:www.chinesehis.com/starry/index.php
在数据库专区有关于分页的类。希望对你有帮助。
==========================================
我的论坛:www.chinesehis.com/starry/index.php
$result=mysql_query("select * from $dbname_book order by item_no desc",$db);$row_number=mysql_num_rows($result); //$row_number是取出的总的行数;
$total_page=$row_number/5; //$total_page是总的页数;
settype($total_page,"integer");
$total_page+=1;
//防止减为负数;
if ($page==0){
$page=1;
}
//防止超过最大页数;
if ($page>$total_page) {
$page=$total_page;
}
$shang_page=$page-1; //上一页;
$next_page=$page+1; //下一页;html_title('书本检索',$user_info[online],$user_info[nike_name]);
html_left_start();
echo "<br>";
html_goto_banner($shang_page,$next_page,'book_list.php',$page,$total_page);
echo "<br>";
if ($row_number<>0){
for($ipage=0;$ipage<5;$ipage++){
$i=($page-1)*5+$ipage; //$i是取出第$i行的数据;
if ($i < $row_number) {
$picture=mysql_result($result,$i,"picture");
$title=mysql_result($result,$i,"title");
$author=mysql_result($result,$i,"author");
$number==mysql_result($result,$i,"count_number");
$quick_know=mysql_result($result,$i,"quick_know");
$price=mysql_result($result,$i,"price");
$star=mysql_result($result,$i,"star");
$tuijian=mysql_result($result,$i,"if_tuijian");
$selled=mysql_result($result,$i,"selled");
if ("yes"==$tuijian){
$item_type="精品图书";
}else{
$item_type="优质图书";
}
html_book_table($picture,$title,$author,$item_type,$number,$quick_know,$price,$star,$tuijian,$selled);
echo "<br>";
}
}
}
html_goto_banner($shang_page,$next_page,'book_list.php',$page,$total_page);html_left_end();
html_right_start();
html_table_start('今日推荐');
echo "<br>";
$result1=mysql_query("select title from $dbname_book where if_tuijian='yes'",$db);
$i=0;
while (($myrow1=mysql_fetch_array($result1))&&($i<5)){
echo "<center><a href='book_list.php?chick_cook=$myrow1[title]'>".$myrow1[title]."</a></center><br>";
$i++;
}
echo "<div align=right><a href='book_list.php?action=tuijian'>更多>>>>>></a></div>";
html_table_end();
html_table_start('前五排行');
echo "<br>";
$result2=mysql_query("select title from $dbname_book order by selled desc",$db);
$i=0;
while (($myrow1=mysql_fetch_array($result2))&&($i<5)){
echo "<center><a href='book_list.php?chick_cook=$myrow1[title]'>".$myrow1[title]."</a></center><br>";
$i++;
}
echo "<div align=right><a href='book_list.php?action=selledok'>更多>>>>>></a></div>";
html_table_end();
html_right_end();
echo "<br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br>";
html_foot();
mysql_close($db);
exit();
?>
拆开看看吧,这个有点麻烦就是了
xinxin1982(新新) 你的代码我还没有看懂,不过也非常感谢你!