请教关于PHP对搜索结果进行分页,不能翻页问题(点击下一页会显示全部记录,而不是搜索出来的记录)
form name="form1" method="GET" action="">
<table width="98%" height="38" border="1" cellpadding="1" cellspacing="0" bordercolor="#FFFFFF"
bgcolor="#9ECFEE" class="tableBorder_gray">
<tr>
<td align="center">
<img src="Images/search.gif" width="37" height="29"></td>
<input name="key1" type="text" id="key1" size="50">
<input name="Submit" type="submit" class="btn_grey" value="查询"></td>
$key1=$_GET[key1];
$pagesize1=10;
$total1=mysql_num_rows(mysql_query("select b.*,c.name as bookcasename,p.pubname,t.typename from tb_bookinfo b left
join tb_bookcase c on b.bookcase=c.id join tb_publishing p on b.ISBN=p.ISBN join tb_booktype t on b.typeid=t.id
where $f like '%$key1%' ORDER BY `id` DESC"));
$pagecount1=ceil($total1/$pagesize1);
if ($total1<=$pagesize1){
$pagecount1=1;
}
if(($total1%$pagesize1)!=0){
$pagecount1=intval($total1/$pagesize1)+1;
}else{
$pagecount1=$total1/$pagesize1;
}
if(($_GET[page1])==""){
$page1=1;
}else{
$page1=intval($_GET[page1]);
}
$sql=mysql_query("select b.*,c.name as bookcasename,p.pubname,t.typename from tb_bookinfo b left join tb_bookcase c
on b.bookcase=c.id join tb_publishing p on b.ISBN=p.ISBN join tb_booktype t on b.typeid=t.id where $f like '%
$_REQUEST[key1]%' ORDER BY `id` DESC limit ".($page1-1)*$pagesize1.",$pagesize1");
$info=mysql_fetch_array($sql);
if($info==true){
do{
?>
输出数据库搜索出来的内容
<?php
}while($info=mysql_fetch_array($sql));
}else{
?>
<table width="100%" height="30" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="36" align="center">您检索的信息不存在,请重新检索!</td>
</tr>
</table>
<?php
}
}
}
?>
</table>
</td>
</tr>
</table>
<table>
<tr>
<td>
<span class="STYLE3">结果共计<?php echo $total1 ?>条, 当前第<?php echo $page1 ?>页/共<?php echo $pagecount1 ?>
页</span> : <a href="?page1=<?php echo ($page1 > 1)?($page1 - 1):1;s?>"&<?php echo $_REQUEST[$key1]; ?>
class="word_orange">上一页</a> <a href="?page1=<?php echo ($page1 < ($pagecount1 - 1))?
($page1+1):$pagecount1;?>"&<?php echo $_REQUEST[key1]; ?> class="word_orange">下一页</a>