Pass search parameters when the links of pagination are clicked

[olinroger]

I am trying to copy some pagination codes into a search result page. The pagination code works fine, but it seems that I could not pass the search parameters from the search page into to page 2, 3, 4, ...... when I click the link of pagination. Any help? Below are the code:

 

<?php
$page = $_GET['page'];
include("../connection.php"); 

     if($s) $sqls.=" and l.state='$s'"; //Specific State
     
     
     if($c)
     {   if ($c[0] != "All Cities"){
        
          $citylist = "'".$c[0]."'"; 
        $int = 1; 
        while($int <count($c))
        {
           $citylist = $citylist.","."'".$c[$int]."'"; 
           $int++;
        }
        $citylist = '('.$citylist.')'; 
            $sqlc.=" and l.city in $citylist"; //Specific City
            }
            }


     
     if($t) $sqlt.=" and l.category = '$t'";  //Category:
     
     if($searchText) $sqlderect .= "and ((l.category = '$searchText') or (l.Directions like '%$searchText%') or (l.street like '%$searchText%') or (l.city like '%$searchText%') or (l.state like '%$searchText%') or (u.sign_phone like '%$searchText%'))";   //Text Search
     
     
//     /Beds / Bath / Square Feet
     if($beds) {$sqlbed .= "and d.bedrooms = '$beds'";
           $sqlbed_base .= "and l.bedrooms = '$beds'";}
      
     if($bath) {$sqlbath .= "and d.bathrooms = '$bath'";
     $sqlbath_base .= "and l.bathrooms = '$bath'";}
       
      if($sfeet) {
          $sqlfeet = "";
          if($sfeet==2){
             $sqlfeet .= " and d.totalquare>3500 ";
             $sqlfeet_base .= " and l.totalquare>3500 ";
          }else{
          $arrayfeet = explode("-",$sfeet);
           $sqlfeet.= " and (d.totalquare between $arrayfeet[0] and $arrayfeet[1])";
           $sqlfeet_base.= " and (l.totalquare between $arrayfeet[0] and $arrayfeet[1])";
          }
      }      
     //Price Range 
     if($p) {                           
          $sqlp = "";
          if($p==1){
             $sqlp .= " and l.price>400000 ";
          }else{
             $p = str_replace(array('$',','),'',$p);
          $price_array = explode("-",$p);
           $sqlp.= " and l.price between $price_array[0] and $price_array[1]";
          }
     }
  
     //feed table control field : default = 2 
     
     if ($rsscontrol){
        $rsscontrol_cond .= "and l.control in ($rsscontrol, 2)";
     }else 
     {
        $rsscontrol_cond .= "and l.control = '2'";
     }
     
     //echo $rsscontrol_cond; 
      
   
   // How many adjacent pages should be shown on each side?
   $adjacents = 3;
   
   /* 
      First get total number of rows in data table. 
      If you have a WHERE clause in your query, make sure you mirror it here.
   */
   $query = "SELECT distinct price, street, city, totalquare, bedrooms, bathrooms,category from rssfeed where website in ($sitenumber) $sqlc $sqlp 
$sqlt $sqlderect $sqlbed_base $sqlbath_base $sqlfeet_base $rsscontrol_cond";
        
   $total_pages = mysql_num_rows(mysql_query($query));


   /* Setup vars for query. */
   $targetpage = "listing_results.php";    //your file name  (the name of this file)
   $limit = 20;                         //how many items to show per page
   
   if($page) 
      $start = ($page - 1) * $limit;          //first item to display on this page
   else
      $start = 0;                        //if no page var is given, set start to 0
   
   /* Get data. */

   $sql = "SELECT distinct price, street, city, totalquare, bedrooms, bathrooms,category from rssfeed where website in ($sitenumber) $sqlc $sqlp 
$sqlt $sqlderect $sqlbed_base $sqlbath_base $sqlfeet_base $rsscontrol_cond order by price LIMIT $start, $limit";
   $result = mysql_query($sql);
   
   /* Setup page vars for display. */
   if ($page == 0) $page = 1;               //if no page var is given, default to 1.
   $prev = $page - 1;                     //previous page is page - 1
   $next = $page + 1;                     //next page is page + 1
   $lastpage = ceil($total_pages/$limit);      //lastpage is = total pages / items per page, rounded up.
   $lpm1 = $lastpage - 1;                  //last page minus 1
   
   /* 
      Now we apply our rules and draw the pagination object. 
      We're actually saving the code to a variable in case we want to draw it more than once.
   */
   $pagination = "";
   if($lastpage > 1)
   {   
      $pagination .= "<div class=\"pagination\">";
      //previous button
      if ($page > 1) 
         $pagination.= "<a href=\"$targetpage?page=$prev\"> previous</a>";
      else
         $pagination.= "<span class=\"disabled\"> previous</span>";   
      
      //pages   
      if ($lastpage < 7 + ($adjacents * 2))   //not enough pages to bother breaking it up
      {   
         for ($counter = 1; $counter <= $lastpage; $counter++)
         {
            if ($counter == $page)
               $pagination.= "<span class=\"current\">$counter</span>";
            else
               $pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";               
         }
      }
      elseif($lastpage > 5 + ($adjacents * 2))   //enough pages to hide some
      {
         //close to beginning; only hide later pages
         if($page < 1 + ($adjacents * 2))      
         {
            for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++)
            {
               if ($counter == $page)
                  $pagination.= "<span class=\"current\">$counter</span>";
               else
                  $pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";               
            }
            $pagination.= "...";
            $pagination.= "<a href=\"$targetpage?page=$lpm1\">$lpm1</a>";
            $pagination.= "<a href=\"$targetpage?page=$lastpage\">$lastpage</a>";      
         }
         //in middle; hide some front and some back
         elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2))
         {
            $pagination.= "<a href=\"$targetpage?page=1\">1</a>";
            $pagination.= "<a href=\"$targetpage?page=2\">2</a>";
            $pagination.= "...";
            for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++)
            {
               if ($counter == $page)
                  $pagination.= "<span class=\"current\">$counter</span>";
               else
                  $pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";               
            }
            $pagination.= "...";
            $pagination.= "<a href=\"$targetpage?page=$lpm1\">$lpm1</a>";
            $pagination.= "<a href=\"$targetpage?page=$lastpage\">$lastpage</a>";      
         }
         //close to end; only hide early pages
         else
         {
            $pagination.= "<a href=\"$targetpage?page=1\">1</a>";
            $pagination.= "<a href=\"$targetpage?page=2\">2</a>";
            $pagination.= "...";
            for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++)
            {
               if ($counter == $page)
                  $pagination.= "<span class=\"current\">$counter</span>";
               else
                  $pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";               
            }
         }
      }
      
      //next button
      if ($page < $counter - 1) 
         $pagination.= "<a href=\"$targetpage?page=$next\">next</a>";
      else
         $pagination.= "<span class=\"disabled\">next</span>";
      $pagination.= "</div>\n";      
   }
  
  
          $display_index = 0;  
      while($page_query_row = mysql_fetch_array($result))
      {
            $display_array[$display_index] = $page_query_row; 
         $display_index++; 
      // Your while loop here
   
      }
   
   
?>      

 

MOD EDIT: code tags added.

[xyph]

You have to pass the search parameters in the link along with the page number.

[jcbones]

You have to pass the search parameters in the link along with the page number.

 

Or, set them in a session variable.

[olinroger]

How? I am new on php (and coding as well) and have no clue on how to do it on either session or links.

[xyph]

Bad idea in the session variable.

 

If a user has two tabs open with two different search results, one will overwrite the other.

 

PHP is stateless, and sessions are an attempt to make it stateful. They don't do a good job though, and have a hard time distinguishing between different request patterns from the same source. Keeping track of access levels is a good use, because that kind of information generally doesn't change between requests.

 

Sessions aren't meant to pass data between pages.

 

If you're new to PHP, you've picked a bad starting point. Your script is quite complex from a beginner level, and sadly any help I give will only complicate the script further. You probably won't understand my code if you don't understand how to implement my solution above. You won't learn.

 

If there's an urgency to get this finished, I'd suggest bringing it over to the PHP Freelance forum, otherwise, start with the basics (google, php.net docs, or a good book) and work your way up to understanding what your script is doing. You'll find my solution is all you need.

[Pikachu2000]

When posting code, enclose it within the forum's

 . . . 

BBCode tags.