使用select下拉输出页数。。。。。。 本帖最后由 phpmyxinshou 于 2010-08-19 14:29:27 编辑 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 <select name=""> <?php for ($i=1;$i<=$maxPage;$i++) { ?> <option value="<?php echo $page."?page=".$i;?>"><?php echo $i."页"?> <?php }?> </select>====================================<option value="<?php echo $page."?page=".$i;?>"><?php echo $i."页";?></option>==============$page."?page=".$i;这里的$page可能有问题,你可以考虑改成当$page==$i的时候,加上selected如果用js跳转,<select name="" onchange="dosomething();">加上一个改变触发事件 这是全页代码$where = "where 1";if(!empty($ziduan) && !empty($txt_sousuo)){ $where .= " and $ziduan like '%{$txt_sousuo}%'"; }$sql = "SELECT count(*) as countnum FROM hotel_activities_2 $where";$result=mysql_fetch_array(mysql_query($sql));$countnum = $result['countnum'];if(!$countnum) die("<script>alert('查询的数据不存在');window.location='chaxun.php';</script>");$rowsPerPage=10; $maxPage=ceil($countnum/$rowsPerPage); $page=isset($_GET['curPage'])?intval($_GET['curPage']):1; $page = $page<1?1:$page;$page = $page>$maxPage?$maxPage:$page;$start=$rowsPerPage*($page-1);$sel1 = "SELECT * FROM hotel_activities_2 $where order by h_id limit $start,$rowsPerPage"; $result=mysql_query($sel1) or die("查询失败"); //循环输出表中各个字段值 echo '<form action="delect_sj.php" method=post>'; while ($row = mysql_fetch_array($result)) { echo '<tr align="center" class="shu">'; echo '<td><input type=checkbox name="hid[]" value="'.$row['h_id'].'"></td>'; echo '<td>'.$row['hotel_id'].'</td>'; echo '<td>'.$row['start_date'].'</td>'; echo '<td>'.$row['end_date'].'</td>'; echo '<td>'.$row['content'].'</td>'; echo '<td>'.$row['source'].'</td>'; echo '<td>'.$row['s_type'].'</td>'; echo '<td>'.' <a href="upedit.php?hid='.$row['h_id'].'" >编辑</a> '.'</td>'; echo '</tr>'; } echo '<input type=submit value="删除所选" onclick="return delconfirm()"></form>'; echo "<div align='left' class='shu'><a href='?ziduan={$ziduan}&txt_sousuo=".rawurlencode($txt_sousuo)."&curPage=1' style='color:#FF0000'>首页</a>"." ";if($page>1) { $prevPage=($page-1)<1?1:$page-1; echo "<a href='?ziduan={$ziduan}&txt_sousuo=".rawurlencode($txt_sousuo)."&curPage=$prevPage'><img src='img/prev.gif'/></a>"; } if ($page<$maxPage) { $nextPage=($page+1)>$maxPage?$maxPage:$page+1; echo "<a href='?ziduan={$ziduan}&txt_sousuo=".rawurlencode($txt_sousuo)."&curPage=$nextPage'><img src='img/next.gif'/></a>"; } echo ""." <a href='?ziduan={$ziduan}&txt_sousuo=".rawurlencode($txt_sousuo)."&curPage=$maxPage' style='color:#FF0000'>尾页</a>"?><select name="" > <?php for ($i=1;$i<=$maxPage;$i++) { ?> <option value="<?php echo $page."?page=.$i";?>"><?php echo $i."页"?> <?php }?> </select><?phpecho "</div>";echo "</table>";echo "<div align='center' class='shu'>"."共".$maxPage."页 当前为第".$page."页"."</div>"; <?phpecho "<table border=1 width=700 cellspacing=0 style=border-collapse:collapse>"; echo "<tr style=background-image:url(img/new_hader_27.jpg) height=30 style=color:#ffffff style=font-size:13px;><th>选择</th><th>酒店id</th><th>开始时间</th><th>结束时间</th><th>内容介绍</th><th>备注</th><th>s_type</th><th>操作</th></tr>"; $ziduan = isset($_POST['ziduan'])?$_POST['ziduan']:(isset($_GET['ziduan'])?$_GET['ziduan']:"");$txt_sousuo = isset($_POST['txt_sousuo'])?$_POST['txt_sousuo']:(isset($_GET['txt_sousuo'])?$_GET['txt_sousuo']:"");$where = "where 1";if(!empty($ziduan) && !empty($txt_sousuo)){ $where .= " and $ziduan like '%{$txt_sousuo}%'"; }$sql = "SELECT count(*) as countnum FROM hotel_activities_2 $where";$result=mysql_fetch_array(mysql_query($sql));$countnum = $result['countnum'];if(!$countnum) die("<script>alert('查询的数据不存在');window.location='chaxun.php';</script>");$rowsPerPage=10; $maxPage=ceil($countnum/$rowsPerPage); $page=isset($_GET['curPage'])?intval($_GET['curPage']):1; $page = $page<1?1:$page;$page = $page>$maxPage?$maxPage:$page;$start=$rowsPerPage*($page-1);$sel1 = "SELECT * FROM hotel_activities_2 $where order by h_id limit $start,$rowsPerPage"; $result=mysql_query($sel1) or die("查询失败"); //循环输出表中各个字段值 echo '<form action="delect_sj.php" method=post>'; while ($row = mysql_fetch_array($result)) { echo '<tr align="center" class="shu">'; echo '<td><input type=checkbox name="hid[]" value="'.$row['h_id'].'"></td>'; echo '<td>'.$row['hotel_id'].'</td>'; echo '<td>'.$row['start_date'].'</td>'; echo '<td>'.$row['end_date'].'</td>'; echo '<td>'.$row['content'].'</td>'; echo '<td>'.$row['source'].'</td>'; echo '<td>'.$row['s_type'].'</td>'; echo '<td>'.' <a href="upedit.php?hid='.$row['h_id'].'" >编辑</a> '.'</td>'; echo '</tr>'; } echo '<input type=submit value="删除所选" onclick="return delconfirm()"></form>'; echo "<div align='left' class='shu'><a href='?ziduan={$ziduan}&txt_sousuo=".rawurlencode($txt_sousuo)."&curPage=1' style='color:#FF0000'>首页</a>"." ";if($page>1) { $prevPage=($page-1)<1?1:$page-1; echo "<a href='?ziduan={$ziduan}&txt_sousuo=".rawurlencode($txt_sousuo)."&curPage=$prevPage'><img src='img/prev.gif'/></a>"; }echo " "." ";if ($page<$maxPage) { $nextPage=($page+1)>$maxPage?$maxPage:$page+1; echo "<a href='?ziduan={$ziduan}&txt_sousuo=".rawurlencode($txt_sousuo)."&curPage=$nextPage'><img src='img/next.gif'/></a>"; } echo ""." <a href='?ziduan={$ziduan}&txt_sousuo=".rawurlencode($txt_sousuo)."&curPage=$maxPage' style='color:#FF0000'>尾页</a>"?><select name="" onChange="window.location.href=''+this.options[this.selectedIndex].value"> <?php for ($i=1;$i<=$maxPage;$i++) { ?> <option value="<?php echo $page."?curPage=$i";?>"><?php echo "第".$i."页"?> <?php }?> </select><?phpecho "</div>";echo "</table>";echo "<div align='center' class='shu'>"."共".$maxPage."页 当前为第".$page."页"."</div>"; do{echo "<option value='".$row["id"]."'>".$row["name"]."</option>"}while($row==mysql_fetch_array($result)) 求解代码中的百分号是什么意思 如何将网站自动生成缩略图 在线等外码约束的问题【急!!!】 php搜索如何优化 mysql的longblob列为什么不能超过15M php日期函数无法直接得到特定一日的星期几吧?中文的 非常简单的问题,但是小弟就是弄不好,请大虾执教 php和mysql的送分问题 windows下php的GD支持(百分相送) setFiled 方法第二个参数是变量要怎么写SQL? 急求一正则,删除字符中的某一段字符 静态成员访问问题
<?php for ($i=1;$i<=$maxPage;$i++)
{
?>
<option value="<?php echo $page."?page=".$i;?>"><?php echo $i."页"?>
<?php }?>
</select>
====================================
<option value="<?php echo $page."?page=".$i;?>"><?php echo $i."页";?></option>==============$page."?page=".$i;这里的$page可能有问题,你可以考虑改成
当$page==$i的时候,加上selected
如果用js跳转,<select name="" onchange="dosomething();">加上一个改变触发事件
$where = "where 1";
if(!empty($ziduan) && !empty($txt_sousuo)){
$where .= " and $ziduan like '%{$txt_sousuo}%'";
}
$sql = "SELECT count(*) as countnum FROM hotel_activities_2 $where";
$result=mysql_fetch_array(mysql_query($sql));
$countnum = $result['countnum'];
if(!$countnum) die("<script>alert('查询的数据不存在');window.location='chaxun.php';</script>");$rowsPerPage=10;
$maxPage=ceil($countnum/$rowsPerPage);
$page=isset($_GET['curPage'])?intval($_GET['curPage']):1;
$page = $page<1?1:$page;
$page = $page>$maxPage?$maxPage:$page;$start=$rowsPerPage*($page-1);
$sel1 = "SELECT * FROM hotel_activities_2 $where order by h_id limit $start,$rowsPerPage";
$result=mysql_query($sel1) or die("查询失败");
//循环输出表中各个字段值
echo '<form action="delect_sj.php" method=post>';
while ($row = mysql_fetch_array($result)) {
echo '<tr align="center" class="shu">';
echo '<td><input type=checkbox name="hid[]" value="'.$row['h_id'].'"></td>';
echo '<td>'.$row['hotel_id'].'</td>';
echo '<td>'.$row['start_date'].'</td>';
echo '<td>'.$row['end_date'].'</td>';
echo '<td>'.$row['content'].'</td>';
echo '<td>'.$row['source'].'</td>';
echo '<td>'.$row['s_type'].'</td>';
echo '<td>'.' <a href="upedit.php?hid='.$row['h_id'].'" >编辑</a> '.'</td>';
echo '</tr>';
}
echo '<input type=submit value="删除所选" onclick="return delconfirm()"></form>';
echo "<div align='left' class='shu'>
<a href='?ziduan={$ziduan}&txt_sousuo=".rawurlencode($txt_sousuo)."&curPage=1' style='color:#FF0000'>首页</a>"." ";
if($page>1) {
$prevPage=($page-1)<1?1:$page-1;
echo "<a href='?ziduan={$ziduan}&txt_sousuo=".rawurlencode($txt_sousuo)."&curPage=$prevPage'><img src='img/prev.gif'/></a>";
}
if ($page<$maxPage) {
$nextPage=($page+1)>$maxPage?$maxPage:$page+1;
echo "<a href='?ziduan={$ziduan}&txt_sousuo=".rawurlencode($txt_sousuo)."&curPage=$nextPage'><img src='img/next.gif'/></a>";
} echo ""." <a href='?ziduan={$ziduan}&txt_sousuo=".rawurlencode($txt_sousuo)."&curPage=$maxPage' style='color:#FF0000'>尾页</a>"
?><select name="" >
<?php for ($i=1;$i<=$maxPage;$i++)
{
?>
<option value="<?php echo $page."?page=.$i";?>"><?php echo $i."页"?>
<?php }?>
</select><?php
echo "</div>";
echo "</table>";
echo "<div align='center' class='shu'>"."共".$maxPage."页 当前为第".$page."页"."</div>";
echo "<table border=1 width=700 cellspacing=0 style=border-collapse:collapse>";
echo "<tr style=background-image:url(img/new_hader_27.jpg) height=30 style=color:#ffffff style=font-size:13px;><th>选择</th><th>酒店id</th><th>开始时间</th><th>结束时间</th><th>内容介绍</th><th>备注</th><th>s_type</th><th>操作</th></tr>";
$ziduan = isset($_POST['ziduan'])?$_POST['ziduan']:(isset($_GET['ziduan'])?$_GET['ziduan']:"");
$txt_sousuo = isset($_POST['txt_sousuo'])?$_POST['txt_sousuo']:(isset($_GET['txt_sousuo'])?$_GET['txt_sousuo']:"");$where = "where 1";
if(!empty($ziduan) && !empty($txt_sousuo)){
$where .= " and $ziduan like '%{$txt_sousuo}%'";
}
$sql = "SELECT count(*) as countnum FROM hotel_activities_2 $where";
$result=mysql_fetch_array(mysql_query($sql));
$countnum = $result['countnum'];
if(!$countnum) die("<script>alert('查询的数据不存在');window.location='chaxun.php';</script>");$rowsPerPage=10;
$maxPage=ceil($countnum/$rowsPerPage);
$page=isset($_GET['curPage'])?intval($_GET['curPage']):1;
$page = $page<1?1:$page;
$page = $page>$maxPage?$maxPage:$page;$start=$rowsPerPage*($page-1);
$sel1 = "SELECT * FROM hotel_activities_2 $where order by h_id limit $start,$rowsPerPage";
$result=mysql_query($sel1) or die("查询失败");
//循环输出表中各个字段值
echo '<form action="delect_sj.php" method=post>';
while ($row = mysql_fetch_array($result)) {
echo '<tr align="center" class="shu">';
echo '<td><input type=checkbox name="hid[]" value="'.$row['h_id'].'"></td>';
echo '<td>'.$row['hotel_id'].'</td>';
echo '<td>'.$row['start_date'].'</td>';
echo '<td>'.$row['end_date'].'</td>';
echo '<td>'.$row['content'].'</td>';
echo '<td>'.$row['source'].'</td>';
echo '<td>'.$row['s_type'].'</td>';
echo '<td>'.' <a href="upedit.php?hid='.$row['h_id'].'" >编辑</a> '.'</td>';
echo '</tr>';
}
echo '<input type=submit value="删除所选" onclick="return delconfirm()"></form>';
echo "<div align='left' class='shu'>
<a href='?ziduan={$ziduan}&txt_sousuo=".rawurlencode($txt_sousuo)."&curPage=1' style='color:#FF0000'>首页</a>"." ";
if($page>1) {
$prevPage=($page-1)<1?1:$page-1;
echo "<a href='?ziduan={$ziduan}&txt_sousuo=".rawurlencode($txt_sousuo)."&curPage=$prevPage'><img src='img/prev.gif'/></a>";
}
echo " "." ";
if ($page<$maxPage) {
$nextPage=($page+1)>$maxPage?$maxPage:$page+1;
echo "<a href='?ziduan={$ziduan}&txt_sousuo=".rawurlencode($txt_sousuo)."&curPage=$nextPage'><img src='img/next.gif'/></a>";
} echo ""." <a href='?ziduan={$ziduan}&txt_sousuo=".rawurlencode($txt_sousuo)."&curPage=$maxPage' style='color:#FF0000'>尾页</a>"
?>
<select name="" onChange="window.location.href=''+this.options[this.selectedIndex].value">
<?php for ($i=1;$i<=$maxPage;$i++)
{
?>
<option value="<?php echo $page."?curPage=$i";?>"><?php echo "第".$i."页"?>
<?php }?>
</select>
<?php
echo "</div>";
echo "</table>";
echo "<div align='center' class='shu'>"."共".$maxPage."页 当前为第".$page."页"."</div>";
echo "<option value='".$row["id"]."'>".$row["name"]."</option>"}
while($row==mysql_fetch_array($result))