一个完整的列表分页+多条件限制显示的代码

来源：09-27

 <?php

 
//获取url参数以及设置url参数的字符串
$classid = $_GET["classid"];
$whereand = '';
if($classid){
$urlclassid = "?classid=".$classid;
$classids = $classid;
$result = mysql_query("SELECT * FROM  phome_enewsclass where bclassid = $classid");
while($row = mysql_fetch_array($result))
 {
  $classids = $classids.",".$row["classid"];
 }
}else{
$urlclassid= '';
}
 
if($_GET["areaid"]){
 
$areaid = $_GET["areaid"];
$urlareaid = "&areaid=".$areaid;
 
}else{
 
$areaid = $_COOKIE["areaid"];
$urlareaid = "";
}
 
 
 
setcookie("areaid",$areaid,time()+24*60*60*365,"/e/action/ListInfo/");
setcookie("areaid",$areaid,time()+24*60*60*365,"/");
 
//print_r($_COOKIE);
 
 
//获取当前地区及地区列表
 
if($areaid==''||$areaid==99999){
$addwhere = '';
$areaname = "全部地区";
setcookie("areaid",'', time()+24*60*60*365);
$areaid='';
}else{
//echo "<br>areaid的值：".$areaid;
$result = mysql_query("SELECT id,title FROM phome_ecms_area where id = $areaid");
while($row = mysql_fetch_array($result))  {
$areaidaa = $row["id"];
$areaname =  $row["title"];
$areaids = $row["id"];
$result2 = mysql_query("SELECT id,title FROM phome_ecms_area where bareaid = $areaidaa");
while($row2 = mysql_fetch_array($result2))  {
$areaids = $row2["id"].",".$areaids;
}
 }
 
$whereand = $whereand." and areaid in (".$areaids.")";
}
 
$maxprice=$_GET["maxprice"];
if($maxprice){
$urlmaxprice="&maxprice=".$maxprice;
$whereand = $whereand." and price <= ".$maxprice;
}else{
$urlmaxprice="";
}
 
$minprice=$_GET["minprice"];
if($minprice){
$urlminprice="&minprice=".$minprice;
$whereand = $whereand." and price >= ".$minprice;
}else{
$urlminprice="";
}
 
$maxmianji=$_GET["maxmianji"];
if($maxmianji){
$urlmaxmianji="&maxmianji=".$maxmianji;
$whereand = $whereand." and zongmianji <= ".$maxmianji;
}else{
$urlmaxmianji="";
}
 
$minmianji=$_GET["minmianji"];
if($minmianji){
$urlminmianji="&minmianji=".$minmianji;
$whereand = $whereand." and zongmianji >= ".$minmianji;
}else{
$urlminmianji="";
}
 
//限制条件点击后的样式
$onclickstyle = " style='color:#FF0000; font-weight:bold' ";
 
 
//获取地区列表
$arealist = "<li><a href='".$urlclassid.$urlmaxprice.$urlminprice.$urlmaxmianji.$urlminmianji."&areaid=99999' title=''>全部地区</a></li>";
$result = mysql_query("SELECT id,title FROM phome_ecms_area ");
while($row = mysql_fetch_array($result))  {
$arealist = $arealist."<li><a href='".$urlclassid.$urlmaxprice.$urlminprice.$urlmaxmianji.$urlminmianji."&areaid=".$row["id"]."' title=''>".$row["title"]."</a></li>";
if($row["id"]==$areaid){
$arealinks = $arealinks."<a href=".$urlclassid.$urlmaxprice.$urlminprice.$urlmaxmianji.$urlminmianji."&areaid=".$row["id"].$onclickstyle.">".$row["title"]."</a>";
}else{
$arealinks = $arealinks."<a href=".$urlclassid.$urlmaxprice.$urlminprice.$urlmaxmianji.$urlminmianji."&areaid=".$row["id"].">".$row["title"]."</a>";
}
}
 
//获取栏目
 
if($classid==2){
$strclass = "<a class='cur' href='?classid=2".$urlmaxprice.$urlminprice.$urlmaxmianji.$urlminmianji."'>全部</a><a href='?classid=7".$urlmaxprice.$urlminprice.$urlmaxmianji.$urlminmianji."'>厂房出售</a><a href='?classid=8".$urlmaxprice.$urlminprice.$urlmaxmianji.$urlminmianji."'>厂房出租</a>";
}elseif($classid==7){
$strclass = "<a  href='?classid=2".$urlmaxprice.$urlminprice.$urlmaxmianji.$urlminmianji."'>全部</a><a class='cur' href='?classid=7".$urlmaxprice.$urlminprice.$urlmaxmianji.$urlminmianji."'>厂房出售</a><a href='?classid=8".$urlmaxprice.$urlminprice.$urlmaxmianji.$urlminmianji."'>厂房出租</a>";
}elseif($classid==8){
$strclass = "<a  href='?classid=2".$urlmaxprice.$urlminprice.$urlmaxmianji.$urlminmianji."'>全部</a><a  href='?classid=7".$urlmaxprice.$urlminprice.$urlmaxmianji.$urlminmianji."'>厂房出售</a><a class='cur' href='?classid=8".$urlmaxprice.$urlminprice.$urlmaxmianji.$urlminmianji."'>厂房出租</a>";
}elseif($classid==3){
$strclass = "<a class='cur'  href='?classid=3".$urlmaxprice.$urlminprice.$urlmaxmianji.$urlminmianji."'>全部</a><a  href='?classid=9".$urlmaxprice.$urlminprice.$urlmaxmianji.$urlminmianji."'>土地出售</a><a href='?classid=10".$urlmaxprice.$urlminprice.$urlmaxmianji.$urlminmianji."'>土地出租</a>";
}elseif($classid==9){
$strclass = "<a href='?classid=3".$urlmaxprice.$urlminprice.$urlmaxmianji.$urlminmianji."'>全部</a><a class='cur'   href='?classid=9".$urlmaxprice.$urlminprice.$urlmaxmianji.$urlminmianji."'>土地出售</a><a href='?classid=10".$urlmaxprice.$urlminprice.$urlmaxmianji.$urlminmianji."'>土地出租</a>";
}elseif($classid==10){
$strclass = "<a href='?classid=3".$urlmaxprice.$urlminprice.$urlmaxmianji.$urlminmianji."'>全部</a><a  href='?classid=9".$urlmaxprice.$urlminprice.$urlmaxmianji.$urlminmianji."'>土地出售</a><a class='cur' href='?classid=10".$urlmaxprice.$urlminprice.$urlmaxmianji.$urlminmianji."'>土地出租</a>";
}
 
 
//以下是分页显示用到的参数
if(!$_GET["page"]){        //判断网址中是否含有page=多少
                $page=1;       //如果网址中没有page变量就设置page=1
         }else{
                 $page=$_GET["page"]; //获取页码
        }
$pagesize=12;  //设置图片列表页每页显示信息条数
$pagestart=($page-1)*$pagesize;  //计算列表页信息起始位置 
 
 
 
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>[!--pagetitle--]</title>
<link href="[!--news.url--]index.css" rel="stylesheet" />
<meta name="keywords" content="[!--pagekey--]">
<meta name="description" content="[!--pagedes--]">
</head>
<body>
<!--head-->
<div class="head_top">
<div class="W1">
<div class="logo"><a href="[!--news.url--]"><img src="[!--news.url--]images/logo_02.jpg" /></a></div>
<!--logo end-->
<div class="menu1">
<ul>
<li><a class="hide" href="#"><?php echo $areaname ?></a>
<ul>
<s></s>
<?php echo $arealist; ?>
</ul>
</li>
</ul>
</div>
 
[!--temp.header--]
 
</div>
</div>
<!--head end-->
<!--中间部分-->
<div class="mainPage">
<div class="main_title">当前位置：[!--newsnav--]</div>
<div class="mainbox">
<ul>
<li>区域：<a href="<?php echo $urlclassid.$urlmaxprice.$urlminprice.$urlmaxmianji.$urlminmianji."&areaid=99999"; ?>"><span>不限</span><?php echo $arealinks?></li>
<li>
租金：
<a href="<?php echo $urlclassid.$urlmaxmianji.$urlminmianji; ?>"><span>不限</span></a>
<a href="<?php echo $urlclassid.$urlmaxmianji.$urlminmianji."&maxprice=10"; ?>" <?php if($maxprice==10) { echo $onclickstyle; }?>>10元/平米以下</a>
<a href="<?php echo $urlclassid.$urlmaxmianji.$urlminmianji."&minprice=10&maxprice=15"; ?>"  <?php if(($maxprice==15)&&($minprice==10)) { echo $onclickstyle; }?>>10-15元/平米</a>
<a href="<?php echo $urlclassid.$urlmaxmianji.$urlminmianji."&minprice=15&maxprice=20"; ?>" <?php if(($maxprice==20)&&($minprice==15)) { echo $onclickstyle; }?>>15-20元/平米</a>
<a href="<?php echo $urlclassid.$urlmaxmianji.$urlminmianji."&minprice=20&maxprice=25"; ?>" <?php if(($maxprice==25)&&($minprice==20)) { echo $onclickstyle; }?>>20-25元/平米</a>
<a href="<?php echo $urlclassid.$urlmaxmianji.$urlminmianji."&minprice=25"; ?>" <?php if($minprice==25) { echo $onclickstyle; }?>>25元/平米以上</a>
</li>
<li style="border:none;">
面积：
<a href="<?php echo $urlclassid.$urlmaxprice.$urlminprice; ?>"><span>不限</span></a>
<a href="<?php echo $urlclassid.$urlmaxprice.$urlminprice."&maxmianji=500"; ?>"  <?php if($maxmianji==500) { echo $onclickstyle; }?>>500平米以下</a>
<a href="<?php echo $urlclassid.$urlmaxprice.$urlminprice."&minmianji=500&maxmianji=1000"; ?>" <?php if(($minmianji==500)&&($maxmianji==1000)) { echo $onclickstyle; }?>>500-1000平米</a>
<a href="<?php echo $urlclassid.$urlmaxprice.$urlminprice."&minmianji=1000&maxmianji=1500"; ?>"  <?php if(($minmianji==1000)&&($maxmianji==1500)) { echo $onclickstyle; }?>>1000-1500平米</a>
<a href="<?php echo $urlclassid.$urlmaxprice.$urlminprice."&minmianji=1500&maxmianji=2500"; ?>"  <?php if(($minmianji==1500)&&($maxmianji==2500)) { echo $onclickstyle; }?>>1500-2500平米</a>
<a href="<?php echo $urlclassid.$urlmaxprice.$urlminprice."&minmianji=2500&maxmianji=4000"; ?>"  <?php if(($minmianji==2500)&&($maxmianji==4000)) { echo $onclickstyle; }?>> 2500-4000平米</a>
<a href="<?php echo $urlclassid.$urlmaxprice.$urlminprice."&minmianji=4000&maxmianji=6000"; ?>"  <?php if(($minmianji==4000)&&($maxmianji==6000)) { echo $onclickstyle; }?>>4000-6000平米</a>
</li>
</ul>
</div>
 
 
 
 
 
<?php
$resultpage = mysql_query("SELECT id FROM phome_ecms_info where classid  in ($classids) ".$whereand);
$count=mysql_num_rows($resultpage); //获取信息条数
$pagetotal=ceil($count/$pagesize); //计算尾页是第多少页，总数除以每页显示条数，结果遇到小数就取下一个整数
?>
 
 
 
 
 
<div class="show_bot">
<div class="show_bot_nav">
<?php echo $strclass ?><span>共有<strong><?php echo $count ?></strong>套符合要求的厂房</span>
</div>
 
<div class="show_bot_box">
 
<?php
 
$result = mysql_query("SELECT * FROM phome_ecms_info where classid  in ($classids) ".$whereand." order by id desc limit $pagestart,$pagesize");
 
while($row = mysql_fetch_array($result))
  {
?>
<dl>
<dt><a href="<?php echo $row["titleurl"] ?>"><img src="<?php echo $row["titlepic"] ?>" /></a></dt>
<dd class="dd_left">
<h2><a href="<?php echo $row["titleurl"] ?>"><?php echo $row["title"] ?></a></h2>
<p><span>厂房简介：</span> <?php echo $row["smalltext"] ?></p>
<p>联系人：<?php echo $row["jingjiren"] ?>  <span><?php echo $row["jjrtel"] ?></span></p>
<p>更新时间：<?php echo $row["newstime"] ?></p>
</dd>
<dd class="dd_right">
<p><?php echo $row["areaname"] ?></p>
<p><span><?php echo $row["price"] ?></span>元/m2</p>
<p>面积：<?php echo $row["zongmianji"] ?>m2</p>
<a class="xiangqing" href="<?php echo $row["titleurl"] ?>">查看详情</a>
</dd>
</dl>
<?php
  }
?>
 
<!--page-->
<div class="page">
<div class="leftpage">共<?php echo $count ?>条 每页<?php echo  $pagesize ?>条 页次：<?php echo $page ?>/<?php echo $pagetotal ?></div>
<div class="rightpage">
 
<?php if ($page>1){ ?>
<a href="<?php echo $urlclassid.$urlmaxprice.$urlminprice.$urlmaxmianji.$urlminmianji; ?>">首页</a><a href="<?php echo $urlclassid.$urlmaxprice.$urlminprice.$urlmaxmianji.$urlminmianji; ?>&page=<?php echo $page-1 ?>">上一页</a>          
<?php 
 }else{
?>
<a>首页</a><a>上一页</a>
<?php } ?>            
  
<?php if ($page>3){ ?>
<a href="<?php echo $urlclassid.$urlmaxprice.$urlminprice.$urlmaxmianji.$urlminmianji; ?>&page=<?php echo $page-3 ?>"><?php echo $page-3 ?></a>
<?php } ?>
<?php if ($page>2){ ?>                
<a href="<?php echo $urlclassid.$urlmaxprice.$urlminprice.$urlmaxmianji.$urlminmianji; ?>&page=<?php echo $page-2 ?>"><?php echo $page-2 ?></a>
<?php } ?>              
<?php if ($page>1){ ?>   
<a href="<?php echo $urlclassid.$urlmaxprice.$urlminprice.$urlmaxmianji.$urlminmianji; ?>&page=<?php echo $page-1 ?>"><?php echo $page-1 ?></a>
<?php } ?>    
 
<a style="background:#F60"><?php echo $page ?></a>            
 
<?php if (($pagetotal-$page)>0){ ?>
<a href="<?php echo $urlclassid.$urlmaxprice.$urlminprice.$urlmaxmianji.$urlminmianji; ?>&page=<?php echo $page+1 ?>"><?php echo $page+1 ?></a>
<?php } ?> 
<?php if (($pagetotal-$page)>1){ ?> 
<a href="<?php echo $urlclassid.$urlmaxprice.$urlminprice.$urlmaxmianji.$urlminmianji; ?>&page=<?php echo $page+2 ?>"><?php echo $page+2 ?></a>
<?php } ?>
<?php if (($pagetotal-$page)>2){ ?>   
<a href="<?php echo $urlclassid.$urlmaxprice.$urlminprice.$urlmaxmianji.$urlminmianji; ?>&page=<?php echo $page+3 ?>"><?php echo $page+3 ?></a>
<?php } ?>
 
<?php if ($page>=$pagetotal){ ?> 
<a>下一页</a><a>尾页</a>
<?php }else{ ?>
<a href="<?php echo $urlclassid.$urlmaxprice.$urlminprice.$urlmaxmianji.$urlminmianji; ?>&page=<?php echo $page+1 ?>">下一页</a></span><span><a href="<?php echo $urlclassid.$urlmaxprice.$urlminprice.$urlmaxmianji.$urlminmianji; ?>&page=<?php echo $pagetotal ?>">尾页</a>
<?php } ?>
</div>
</div>
<!--page end-->
</div>
 
</div>
 
 
</div>
<!--中间部分 end-->
 
<!--foot-->
[!--temp.footer--]
<!--foot end-->
</body>
</html>
 
 
上一篇:两个网页cookie的值不一样，cookie如 下一篇:php 把数字拆成一个一个的

相关阅读

·关于我们·免责声明·服务条款·RSS订阅·dede168.com技术支持

Copyright © 1998-2015　　All rights reserved.