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

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

  
  $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
    What is the difference between unset() and session_destroy()?What is the difference between unset() and session_destroy()?May 04, 2025 am 12:19 AM

    Thedifferencebetweenunset()andsession_destroy()isthatunset()clearsspecificsessionvariableswhilekeepingthesessionactive,whereassession_destroy()terminatestheentiresession.1)Useunset()toremovespecificsessionvariableswithoutaffectingthesession'soveralls

    What is sticky sessions (session affinity) in the context of load balancing?What is sticky sessions (session affinity) in the context of load balancing?May 04, 2025 am 12:16 AM

    Stickysessionsensureuserrequestsareroutedtothesameserverforsessiondataconsistency.1)SessionIdentificationassignsuserstoserversusingcookiesorURLmodifications.2)ConsistentRoutingdirectssubsequentrequeststothesameserver.3)LoadBalancingdistributesnewuser

    What are the different session save handlers available in PHP?What are the different session save handlers available in PHP?May 04, 2025 am 12:14 AM

    PHPoffersvarioussessionsavehandlers:1)Files:Default,simplebutmaybottleneckonhigh-trafficsites.2)Memcached:High-performance,idealforspeed-criticalapplications.3)Redis:SimilartoMemcached,withaddedpersistence.4)Databases:Offerscontrol,usefulforintegrati

    What is a session in PHP, and why are they used?What is a session in PHP, and why are they used?May 04, 2025 am 12:12 AM

    Session in PHP is a mechanism for saving user data on the server side to maintain state between multiple requests. Specifically, 1) the session is started by the session_start() function, and data is stored and read through the $_SESSION super global array; 2) the session data is stored in the server's temporary files by default, but can be optimized through database or memory storage; 3) the session can be used to realize user login status tracking and shopping cart management functions; 4) Pay attention to the secure transmission and performance optimization of the session to ensure the security and efficiency of the application.

    Explain the lifecycle of a PHP session.Explain the lifecycle of a PHP session.May 04, 2025 am 12:04 AM

    PHPsessionsstartwithsession_start(),whichgeneratesauniqueIDandcreatesaserverfile;theypersistacrossrequestsandcanbemanuallyendedwithsession_destroy().1)Sessionsbeginwhensession_start()iscalled,creatingauniqueIDandserverfile.2)Theycontinueasdataisloade

    What is the difference between absolute and idle session timeouts?What is the difference between absolute and idle session timeouts?May 03, 2025 am 12:21 AM

    Absolute session timeout starts at the time of session creation, while an idle session timeout starts at the time of user's no operation. Absolute session timeout is suitable for scenarios where strict control of the session life cycle is required, such as financial applications; idle session timeout is suitable for applications that want users to keep their session active for a long time, such as social media.

    What steps would you take if sessions aren't working on your server?What steps would you take if sessions aren't working on your server?May 03, 2025 am 12:19 AM

    The server session failure can be solved through the following steps: 1. Check the server configuration to ensure that the session is set correctly. 2. Verify client cookies, confirm that the browser supports it and send it correctly. 3. Check session storage services, such as Redis, to ensure that they are running normally. 4. Review the application code to ensure the correct session logic. Through these steps, conversation problems can be effectively diagnosed and repaired and user experience can be improved.

    What is the significance of the session_start() function?What is the significance of the session_start() function?May 03, 2025 am 12:18 AM

    session_start()iscrucialinPHPformanagingusersessions.1)Itinitiatesanewsessionifnoneexists,2)resumesanexistingsession,and3)setsasessioncookieforcontinuityacrossrequests,enablingapplicationslikeuserauthenticationandpersonalizedcontent.

    See all articles

    Hot AI Tools

    Undresser.AI Undress

    Undresser.AI Undress

    AI-powered app for creating realistic nude photos

    AI Clothes Remover

    AI Clothes Remover

    Online AI tool for removing clothes from photos.

    Undress AI Tool

    Undress AI Tool

    Undress images for free

    Clothoff.io

    Clothoff.io

    AI clothes remover

    Video Face Swap

    Video Face Swap

    Swap faces in any video effortlessly with our completely free AI face swap tool!

    Hot Tools

    Notepad++7.3.1

    Notepad++7.3.1

    Easy-to-use and free code editor

    DVWA

    DVWA

    Damn Vulnerable Web App (DVWA) is a PHP/MySQL web application that is very vulnerable. Its main goals are to be an aid for security professionals to test their skills and tools in a legal environment, to help web developers better understand the process of securing web applications, and to help teachers/students teach/learn in a classroom environment Web application security. The goal of DVWA is to practice some of the most common web vulnerabilities through a simple and straightforward interface, with varying degrees of difficulty. Please note that this software

    ZendStudio 13.5.1 Mac

    ZendStudio 13.5.1 Mac

    Powerful PHP integrated development environment

    WebStorm Mac version

    WebStorm Mac version

    Useful JavaScript development tools

    SublimeText3 Mac version

    SublimeText3 Mac version

    God-level code editing software (SublimeText3)