Home  >  Article  >  Backend Development  >  麻烦大家帮小弟我检查一上,小弟我的搜索分页哪儿出了有关问题

麻烦大家帮小弟我检查一上,小弟我的搜索分页哪儿出了有关问题

WBOY
WBOYOriginal
2016-06-13 13:25:21885browse

麻烦大家帮我检查一下,我的搜索分页哪儿出了问题?
// 提交过来,获取到的条数和页数是正确的,按下一页的时候,变成了数据库全部信息分页了,帮我改改,谢谢

  
  $city=$_GET[city];
  $quxian= $_GET[quxian];
  $lx= $_GET[lx];
  $gongqiu= $_GET[gongqiu];
  $spmj= $_GET[spmj];
  $cont= $_GET[cont];
 
$sql = 'select * from new '; 

 if ( $spmj != '商铺面积' ){
$sql .= "where mj $spmj" ; 
  }
if ( $city != '' ){
 $sql .= ( preg_match('/where/' , $sql ) ? ' and ': ' where ' ) . ' city like "%'.$city.'%" ';
}
if ( $quxian != '' ){
 $sql .= ( preg_match('/where/' , $sql ) ? ' and ': ' where ' ) . ' quxian like "%'.$quxian.'%" ';
}
if ( $lx != '商铺类型' ){
 $sql .= ( preg_match('/where/' , $sql ) ? ' and ': ' where ' ) . ' lx like "%'.$lx.'%" ';
}

if ( $gongqiu!= '供求方式' ){
 $sql .= ( preg_match('/where/' , $sql ) ? ' and ': ' where ' ) . ' gongqiu like "%'.$gongqiu.'%" ';
}

if ( $cont!= '' ){
 $sql .= ( preg_match('/where/' , $sql ) ? ' and ': ' where ' ) . ' cont like "%'.$cont.'%" ';
}

 $result = mysql_query($sql);
echo $count = mysql_num_rows($result);
 $Page_size=3;
 $page_count = ceil($count/$Page_size);
if(empty($_GET['page'])||$_GET['page']  $page=1;
 }else {
 $page=$_GET['page'];
}

 $page_len= 3;
 $max_p=$page_count;
 $pages=$page_count;

//判断当前页码
 $offset=$Page_size*($page-1);
  echo $result =$sql."limit $offset,$Page_size ";
 $result=mysql_query($result);
 while ($row=mysql_fetch_array($result)) {
 if($result){
 echo "

";
// echo "
";
 //echo " 麻烦大家帮小弟我检查一上,小弟我的搜索分页哪儿出了有关问题 ";
 //echo "
";
 echo "
";
 echo "";
 echo $row[title]."
";
 echo '    '."".$row[ns]."
";
 echo substr($row[cont],0,200)."
"."".$row[quxian]."".$row[lx].'    '.$row[time];
 echo "
";
 echo "
";
 echo "
  • ".$row[q].$row[dw]."
  • ";
     echo "
  • ".$row[mj].┫."
  • ";
     echo "
    "."
    ";
      }
      } 
      ?>
       $page_len = ($page_len%2)?$page_len:$pagelen+1;//页码个数
     $pageoffset = ($page_len-1)/2;//页码个数左右偏移量

     $key='
    Statement:
    The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn