我的代码
<?php//连接数据库$db=mysql_connect("$mysqlhost","$mysqluser","$mysqlpsw");mysql_select_db("$mysqldb",$db);//初始化数据库定义//设定每一页显示的记录数$pagesize=8;//取得记录总数,计算总页数用$res=mysql_query("select count(*) from gbook " ,$db);$myrow = mysql_fetch_array($res);$numrows=$myrow[0];//计算总页数$pages=intval($numrows/$pagesize);if ($numrows%$pagesize)$pages++;//判断页数设置与否,如无则定义为首页if (!isset($page))$page=1;//判断转到页数if (isset($ys))if ($ys>$pages)$page=$pages;else$page=$ys;//计算记录偏移量$offset=$pagesize*($page-1);//取记录$res=mysql_query("select * from gbook order by id desc limit $offset,$pagesize" ,$db);//循环显示记录if ($myrow = mysql_fetch_array($res)){$i=0;?><div align="center"> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="58" background="image/left.gif"> </td> <td width="522"> <div align="left"><?echo "<div align='center'><br>总共有<b>$numrows</b>条留言,每页显示<b>8</b>条留言,共有<b>$pages</b>页,当前页第<b>$page</b>页:";
$first=1;$prev=$page-1;$next=$page+1;$last=$pages;if ($page>1){echo "<a href='index.php?page=".$first."'>首页</a> ";echo "<a href='index.php?page=".$prev."'>上一页</a> ";}if ($page<$pages){echo "<a href='index.php?page=".$next."'>下一页</a> ";echo "<a href='index.php?page=".$last."'>尾页</a></div> ";}echo "<hr style=\"border: 1 solid #0099FF\" color=\"#0099FF\"></div>";?><?do {$i++;?>
<?php//连接数据库$db=mysql_connect("$mysqlhost","$mysqluser","$mysqlpsw");mysql_select_db("$mysqldb",$db);//初始化数据库定义//设定每一页显示的记录数$pagesize=8;//取得记录总数,计算总页数用$res=mysql_query("select count(*) from gbook " ,$db);$myrow = mysql_fetch_array($res);$numrows=$myrow[0];//计算总页数$pages=intval($numrows/$pagesize);if ($numrows%$pagesize)$pages++;//判断页数设置与否,如无则定义为首页if (!isset($page))$page=1;//判断转到页数if (isset($ys))if ($ys>$pages)$page=$pages;else$page=$ys;//计算记录偏移量$offset=$pagesize*($page-1);//取记录$res=mysql_query("select * from gbook order by id desc limit $offset,$pagesize" ,$db);//循环显示记录if ($myrow = mysql_fetch_array($res)){$i=0;?><div align="center"> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="58" background="image/left.gif"> </td> <td width="522"> <div align="left"><?echo "<div align='center'><br>总共有<b>$numrows</b>条留言,每页显示<b>8</b>条留言,共有<b>$pages</b>页,当前页第<b>$page</b>页:";
$first=1;$prev=$page-1;$next=$page+1;$last=$pages;if ($page>1){echo "<a href='index.php?page=".$first."'>首页</a> ";echo "<a href='index.php?page=".$prev."'>上一页</a> ";}if ($page<$pages){echo "<a href='index.php?page=".$next."'>下一页</a> ";echo "<a href='index.php?page=".$last."'>尾页</a></div> ";}echo "<hr style=\"border: 1 solid #0099FF\" color=\"#0099FF\"></div>";?><?do {$i++;?>
<?php
session_start();
require 'fucktion.php';
include 'common.inc.php';$db=mysql_connect($db_server,$db_user,$db_passwd);
mysql_select_db($db_databases,$db);
?>
<?php
if ($chick_cook){
$result_every=mysql_query("select * from $dbname_book where title='$chick_cook'",$db);
$temp_title="这可是一本好书啊,看看,<<".$chick_cook.">>....推荐.....";
html_title($temp_title,$user_info[online],$user_info[nike_name]);
html_left_start();
echo "<br>";
$i=0;
$picture=mysql_result($result_every,$i,"picture");
$title=mysql_result($result_every,$i,"title");
$author=mysql_result($result_every,$i,"author");
$number==mysql_result($result_every,$i,"count_number");
$quick_know=mysql_result($result_every,$i,"quick_know");
$price=mysql_result($result_every,$i,"price");
$star=mysql_result($result_every,$i,"star");
$selled=mysql_result($result_every,$i,"selled");
$tuijian=mysql_result($result_every,$i,"if_tuijian");
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_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<20)){
echo "<center><a href='book_list.php?chick_cook=$myrow1[title]'>".$myrow1[title]."</a></center><br>";
}
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>";
html_foot();
exit();}
?>
<?php
if ("selledok"==$action){
$result_selledok=mysql_query("select * from $dbname_book order by selled desc",$db);
$row_number=mysql_num_rows($result_selledok); //$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_2($shang_page,$next_page,'book_list.php?action=selledok',$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_selledok,$i,"picture");
$title=mysql_result($result_selledok,$i,"title");
$author=mysql_result($result_selledok,$i,"author");
$number==mysql_result($result_selledok,$i,"count_number");
$quick_know=mysql_result($result_selledok,$i,"quick_know");
$price=mysql_result($result_selledok,$i,"price");
$star=mysql_result($result_selledok,$i,"star");
$tuijian=mysql_result($result_selledok,$i,"if_tuijian");
$selled=mysql_result($result_selledok,$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_2($shang_page,$next_page,'book_list.php?action=selledok',$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<20)){
echo "<center><a href='book_list.php?chick_cook=$myrow1[title]'>".$myrow1[title]."</a></center><br>";
}
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();
exit();
}
?>
<?php
if ("tuijian"==$action){
$result_tuijian=mysql_query("select * from $dbname_book where if_tuijian='yes'",$db);
$row_number=mysql_num_rows($result_tuijian); //$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_2($shang_page,$next_page,'book_list.php?action=tuijian',$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_tuijian,$i,"picture");
$title=mysql_result($result_tuijian,$i,"title");
$author=mysql_result($result_tuijian,$i,"author");
$number==mysql_result($result_tuijian,$i,"count_number");
$quick_know=mysql_result($result_tuijian,$i,"quick_know");
$price=mysql_result($result_tuijian,$i,"price");
$star=mysql_result($result_tuijian,$i,"star");
$tuijian=mysql_result($result_tuijian,$i,"if_tuijian");
$selled=mysql_result($result_tuijian,$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_2($shang_page,$next_page,'book_list.php?action=tuijian',$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<20)){
echo "<center><a href='book_list.php?chick_cook=$myrow1[title]'>".$myrow1[title]."</a></center><br>";
}
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();
exit();
}
?>
<?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();
?>
<?php
?>