我是通过表单,获取关键字,表单名字是sel_key
模糊查询后内容分页显示,显示下一页的那条语句要传递什么参数,点击下一页才会有内容显示,求帮忙
<?php
if (isset($_POST[sel_key]))
{
$key=$_POST[sel_key];
// echo"$key";
$sql=mysql_query("select * from tb_wishes where wishsort like '%".$key."%' or id like '%".$key."%' or QQ like '%".$key."%' or Picker like '%".$key."%' or content like '%".$key."%'order by id desc limit ".($page_num-1)*$row_per_page." ,$row_per_page",$conn);
while($result=mysql_fetch_array($sql))
{
?>
<td><?php echo $result['id']; ?></td>
<td><?php echo $result['content']; ?></td>
<td><?php echo $result['Picker']; ?></td>
<td><?php echo $result['wishsort']; ?></td>
<td><a target="_blank" href="http://wpa.qq.com/msgrd?v=3&uin=455367066&site=qq&menu=yes"> <?php echo $result['QQ']; ?></a></td>
<td><?php echo $result ['sendTime']; ?></td>
</tr>
<?php }?>
<?php }?>
<a href="u.php?page_num=1"> 第一页</a>
<a href="u.php?page_num=<?php echo ($page_num-1) ?>">上一页</a>
<a href="u.php?page_num=<?php echo ($page_num+1) ?>">下一页</a>
<a href="u.php?page_num=<?php echo $page_count ?>">最后一页</a>
模糊查询后内容分页显示,显示下一页的那条语句要传递什么参数,点击下一页才会有内容显示,求帮忙
<?php
if (isset($_POST[sel_key]))
{
$key=$_POST[sel_key];
// echo"$key";
$sql=mysql_query("select * from tb_wishes where wishsort like '%".$key."%' or id like '%".$key."%' or QQ like '%".$key."%' or Picker like '%".$key."%' or content like '%".$key."%'order by id desc limit ".($page_num-1)*$row_per_page." ,$row_per_page",$conn);
while($result=mysql_fetch_array($sql))
{
?>
<td><?php echo $result['id']; ?></td>
<td><?php echo $result['content']; ?></td>
<td><?php echo $result['Picker']; ?></td>
<td><?php echo $result['wishsort']; ?></td>
<td><a target="_blank" href="http://wpa.qq.com/msgrd?v=3&uin=455367066&site=qq&menu=yes"> <?php echo $result['QQ']; ?></a></td>
<td><?php echo $result ['sendTime']; ?></td>
</tr>
<?php }?>
<?php }?>
<a href="u.php?page_num=1"> 第一页</a>
<a href="u.php?page_num=<?php echo ($page_num-1) ?>">上一页</a>
<a href="u.php?page_num=<?php echo ($page_num+1) ?>">下一页</a>
<a href="u.php?page_num=<?php echo $page_count ?>">最后一页</a>
如果写法正确的话,只需要传一个页数 就可以了实现了。页数你还是要初例化一下吧,每一页分多条数据,你还是要设置一下啥,我看你
$page_num$row_per_page都没有初使数据
$page_num=$_GET['page_num'];
<table width="800" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td> <form name="myform" method="post" action="">
<table width="800" border="1" align="center" cellpadding="3" cellspacing="1" bordercolor="#D6E7A5">
<tr>
<td width="100%" height="28" align="center" class="i_table"><p>查询条件:
<input name="sel_key" type="text" id="sel_key" size="30" value="">
<input type="submit" name="Submit" value="检索" >
<p> 可输入:id,祝福对象,QQ,许愿类型,许愿内容 </p></td>
</tr>
</table>
</form></td>
</tr>
</table>
<?php
if (isset($_POST[sel_key]))
{
$key=$_POST[sel_key];
//echo"$key"; if($_GET){
//得到要提取的页码
$page_num = $_GET['page_num']? $_GET['page_num']: 1;
}
else{
//首次进入时,页码为1
$page_num = 1;
}
//得到总记录数
$numq=mysql_query("select * from tb_wishes where wishsort like '%".$key."%' or id like '%".$key."%' or QQ like '%".$key."%' or Picker like '%".$key."%' or content like '%".$key."%'",$conn);
$num = mysql_num_rows($numq);
//echo"$num"; //每页记录数,可以使用默认值或者直接指定值
$row_per_page =2 ;
//总页数
$page_count = ceil($num/$row_per_page);
//判断是否为第一页或者最后一页
$is_first = (1 == $page_num) ? 1 : 0;
$is_last = ($page_num == $page_count) ? 1 : 0;
//查询起始行位置
$start_row = ($page_num-1) * $row_per_page;
//为SQL语句添加limit子句
$sql .= " limit $num,$row_per_page";
//执行查询
//结果集行数
$rows_count=count($row);?> <table width="800" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#D6E7A5">
<tr>
<td bgcolor="#FFFFCC">爱墙号</td>
<td bgcolor="#FFFFCC">祝福内容</td>
<td bgcolor="#FFFFCC">祝福对象</td>
<td bgcolor="#FFFFCC">类别</td>
<td bgcolor="#FFFFCC">许愿人QQ号</td>
<td bgcolor="#FFFFCC">发送时间</td>
</tr>
<tr>
<?php
$sql=mysql_query("select * from tb_wishes where wishsort like '%".$key."%' or id like '%".$key."%' or QQ like '%".$key."%' or Picker like '%".$key."%' or content like '%".$key."%'order by id desc limit ".($page_num-1)*$row_per_page." ,$row_per_page",$conn);
while($result=mysql_fetch_array($sql))
{
//$rst = mysql_query($sql);?> <td><?php echo $result['id']; ?></td>
<td><?php echo $result['content']; ?></td>
<td><?php echo $result['Picker']; ?></td>
<td><?php echo $result['wishsort']; ?></td>
<td><a target="_blank" href="http://wpa.qq.com/msgrd?v=3&uin=<?php echo $result['QQ']; ?>&site=qq&menu=yes"> <?php echo $result['QQ']; ?></a></td>
<td><?php echo $result ['sendTime']; ?></td>
</tr>
<?php }?>
<?php }?>
</table>共[<strong><?php echo $num;?></strong>]条 每页[<strong><?php echo $row_per_page;?></strong>]条/共[<strong><?php echo $page_count;?></strong>]页
<!-- 分页显示控制链接 -->
<?php
if(!$is_first){
?>
<a href="u.php?page_num=1"> 第一页</a>
<a href="u.php?page_num=<?php echo ($page_num-1) ?>&sel_key=<?php echo $key;?>">上一页</a>
<?php
}
else{
?>
第一页 上一页
<?php
}
if(!$is_last){
?>
<a href="u.php?page_num=<?php echo ($page_num+1) ?>&sel_key=<?php echo $key;?>">下一页</a>
<a href="u.php?page_num=<?php echo $page_count ?>">最后一页</a>
<?php
}
else{
?>
下一页 最后一页
<?php
}
?>
<tr>
<td> <form name="myform" method="post" action="">
<table width="800" border="1" align="center" cellpadding="3" cellspacing="1" bordercolor="#D6E7A5">
<tr>
<td width="100%" height="28" align="center" class="i_table"><p>查询条件:
<input name="sel_key" type="text" id="sel_key" size="30" value="">
<input type="submit" name="Submit" value="检索" >
<p> 可输入:id,祝福对象,QQ,许愿类型,许愿内容 </p></td>
</tr>
</table>
</form></td>
</tr>
</table><?php
$key=$_POST[sel_key];//得到总记录数
$numq=mysql_query("select * from tb_wishes where wishsort like '%".$key."%' or id like '%".$key."%' or QQ like '%".$key."%' or Picker like '%".$key."%' or content like '%".$key."%'",$conn);
$num = mysql_num_rows($numq);//echo"$num";//每页记录数,可以使用默认值或者直接指定值
$row_per_page =2 ;
//总页数
$page_count = ceil($num/$row_per_page);
//判断是否为第一页或者最后一页
$page = (empty($_GET['page'])||$_GET['page']>$page_count)? 1 :$_GET['page'];
//$is_last = ($page_num == $page_count) ? 1 : 0;
//查询起始行位置
$start_row = ($page-1) * $row_per_page;
//为SQL语句添加limit子句
$sql .= " limit $start_row,$row_per_page";
//执行查询
//结果集行数
$rows_count=count($row);?> <table width="800" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#D6E7A5">
<tr>
<td bgcolor="#FFFFCC">爱墙号</td>
<td bgcolor="#FFFFCC">祝福内容</td>
<td bgcolor="#FFFFCC">祝福对象</td>
<td bgcolor="#FFFFCC">类别</td>
<td bgcolor="#FFFFCC">许愿人QQ号</td>
<td bgcolor="#FFFFCC">发送时间</td>
</tr>
<tr>
<?php
$sql=mysql_query("select * from tb_wishes where wishsort like '%".$key."%' or id like '%".$key."%' or QQ like '%".$key."%' or Picker like '%".$key."%' or content like '%".$key."%'order by id desc limit ".($page_num-1)*$row_per_page." ,$row_per_page",$conn);
while($result=mysql_fetch_array($sql))
{
//$rst = mysql_query($sql);?> <td><?php echo $result['id']; ?></td>
<td><?php echo $result['content']; ?></td>
<td><?php echo $result['Picker']; ?></td>
<td><?php echo $result['wishsort']; ?></td>
<td><a target="_blank" href="http://wpa.qq.com/msgrd?v=3&uin=<?php echo $result['QQ']; ?>&site=qq&menu=yes"> <?php echo $result['QQ']; ?></a></td>
<td><?php echo $result ['sendTime']; ?></td>
</tr>
<?php }?>
<?php }?>
</table>共[<strong><?php echo $num;?></strong>]条 每页[<strong><?php echo $row_per_page;?></strong>]条/共[<strong><?php echo $page_count;?></strong>]页
<!-- 分页显示控制链接 -->
<?php?>
<a href="u.php"> 第一页</a>
<a href="u.php?page_num=<?php echo ($page-1) ?>&sel_key=<?php echo $key;?>">上一页</a>
<a href="u.php?page_num=<?php echo ($page+1) ?>&sel_key=<?php echo $key;?>">下一页</a>
<a href="u.php?page_num=<?php echo $page_count ?>">最后一页</a>给你改了一下 你看能用不?