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>
<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>
《sql简单便捷的分页技术》
你只传递了值,没有传递键!
后续的程序如何知道怎样处理呢?
何况引号也有点问题
<span class="STYLE3">结果共计<?php echo $total1 ?>条, 当前第<?php echo $page1 ?>页/共<?php echo $pagecount1 ?>
页</span> : <a href="?page1=<?php echo ($page1 > 1)?($page1 - 1):1;s?>"class="word_orange">上一页</a> <a href="?page1=<?php echo ($page1 < ($pagecount1 - 1))?
($page1+1):$pagecount1;?>" class="word_orange">下一页</a>
function fy($x)
{
$fid=$_GET['fid'];
$sql = "SELECT * FROM `xa_post` WHERE `fid` = '$fid'";
$sql = mysql_query($sql);
$row = mysql_num_rows($sql);
$row = ceil($row/$x);
if($row>1)
{
echo '<ul class="fy">';
for($i=1;$i<=$row;$i++)
{
if($fid==$i)
{
echo '<li class="pid_hover"><a href="class.php?fid='.$fid.'&pid='.$i.'">'.$i.'</a></li>';
}
else
{
echo '<li><a href="class.php?fid='.$fid.'&pid='.$i.'">'.$i.'</a></li>';
}
}
echo '</ul>';
}
}