PHP Pagination with Filter Problem

[PierreL]

I'm in a bit of a flat spin here. I'm putting a gallery together. I've implemented this script for pagination. I also have three filters running on the page to sort image, by drop downs. It works pretty good except when i do filter the images via a drop down the pagination does not display the correct amount of pages or based on the new query.

I hope someone can help out here.

table width="545" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td height="40"><form action="" method="post" name="filter" id="filter">
      <div align="right">
        <?php include(''); ?>
          <select name="setup" id="setup">
            <option value="">Please Select</option>
            <option value="Landscape">Landscape</option>
            <option value="Portrait">Portrait</option>
            <option value="Panoramic">Panoramic</option>
            </select>
          <select name="type" id="type">
            <option value="">Please Select</option>
            <option value="not_free">Not Free</option>
            <option value="free">Free</option>
            </select>
          <select name="category" id="category">
            <option value="">Please Select</option>
            <?php

    $result = mysql_query("SELECT * FROM ''");
     for ($i=0; $i < (mysql_num_rows($result)); $i++)
     {
        $thisrow = mysql_fetch_row($result); 

        print   "<option value='$thisrow[0]'>$thisrow[1]</option>";


    } ?>
        </select>
      <input type="submit" name="Submit" value="Filter" />
  </div>
</form></td>
  </tr>
  <tr>
    <td><?



  //**EDIT TO YOUR TABLE NAME, ECT.

  $t = mysql_query("SELECT * FROM ''");
    if(!$t) die(mysql_error());

  $a                = mysql_fetch_object($t);
  $total_items      = mysql_num_rows($t);
  $limit            = $_GET['limit'];
  $type             = $_GET['type'];
  $page             = $_GET['page'];


  $setup            = getRequestVariable("setup");
  $type             = getRequestVariable("type");
  $category         = getRequestVariable("category");

  //set default if: $limit is empty, non numerical, less than 10, greater than 50
  if((!$limit)  || (is_numeric($limit) == false) || ($limit < 10) || ($limit > 50)) {
      $limit = 4; //default
  }
  //set default if: $page is empty, non numerical, less than zero, greater than total available
  if((!$page) || (is_numeric($page) == false) || ($page < 0) || ($page > $total_items)) {
       $page = 1; //default
  }

  //calcuate total pages
  $total_pages        = ceil($total_items / $limit);
  $set_limit          = $page * $limit - ($limit);

  //query: **EDIT TO YOUR TABLE NAME, ECT.

  $isFirst = true;

  $result = "";
  $selectbase = "SELECT * FROM '' ";

                    if ( $setup==""){                                             


                    }else{

                       if ($isFirst){
                          $result = $result . " WHERE ";
                          $isFirst = false;
                       }else{
                          $result = $result . " AND ";
                       }
                       $result  = "" . $result . " setup = '$setup' ";
                    }

                 /* ======================================================================================================= */

                    if ( $type==""){


                    }else{

                       if ($isFirst){
                          $result = $result . " WHERE ";
                          $isFirst = false;
                       }else{
                          $result = $result . " AND ";
                       }

                       $result = "" . $result . " photo_type  = '$type' ";
                    }

                 /* ======================================================================================================= */

                    if ( $category==""){


                    }else{

                       if ($isFirst){
                          $result = $result . " WHERE ";
                          $isFirst = false;
                       }else{
                          $result = $result . " AND ";
                       }

                       $result = "" .  $result . " category  = '$category' ";
                    }                  

                 /* ======================================================================================================= */


                    $tail = "  LIMIT $set_limit, $limit ";


   $fullquery = $selectbase . $result . $tail;


  $q = mysql_query("$fullquery");
    if(!$q) die(mysql_error());
      $err = mysql_num_rows($q);
        if($err == 0) die("<span class='no_result'><br><br><br><div align='center'>No matches met your criteria.<br>Please try another combination</div></span>");


  print "<table width='545' border='0' cellspacing='0' cellpadding='0'>";

  //show data matching query:
  while($code = mysql_fetch_object($q)) {
      echo("".$code->title."");


        print "  <tr>";
        print "    <td width='273' align='center'><img src=viewThumb.php?id=".$code->id." border='1'><br><br></td>";
        print "   <td width='272'  align='center'>";

           if($thisrow = mysql_fetch_row($q))
           {
              $code->id++;

                 print "<img src=viewThumb.php?id=".$code->id." border='1'><br><br>";
           }

        print "</td>";
        print "  </tr>";

  }


  print "</table>";





  //all done
  ?></td>
  </tr>
  <tr>
    <td height="30">
     <div align="right">
       <?php

     $cat = urlencode($cat); //makes browser friendly

  //prev. page: **EDIT LINK PATH**

  $prev_page = $page - 1;



  if($prev_page >= 1) {
    echo("<span class='next'><b>&lt;&lt;</b> <a href=gallery.php?cat=$cat&amp;limit=$limit&amp;page=$prev_page><b>Prev.</b></a></span>");
  }

  //Display middle pages: **EDIT LINK PATH**

  for($a = 1; $a <= $total_pages; $a++)
  {
     if($a == $page) {
       echo("<span class='next'><b> $a</b> | </span>"); //no link
      } else {
    echo("  <span class='next'><a href=gallery.php?cat=$cat&amp;limit=$limit&amp;page=$a> $a </a> | </span>");
      }
  }

  //next page: **EDIT THIS LINK PATH**

  $next_page = $page + 1;
  if($next_page <= $total_pages) {
     echo("<span class='next'><a href=gallery.php?cat=$cat&amp;limit=$limit&amp;page=$next_page><b>Next</b></a> &gt; &gt;</span>");
  }


   ?>   

    </div></td>
  </tr>
</table>

[dagon]

$type             = $_GET['type'];
$page             = $_GET['page'];

your form with the sort opions is using post, so you need to check post from the form or get from the url for theses vars

if(isset($_GET['type')){
$type =$_GET['type]';
elseif(isset($_POST['type')){
$type =$_POST['type]';
}else{
$type = /*what ever the default is*/
}

[PierreL]

Thanks Dagon

Appreciate your reply. Thanks for pointing that out. It still leaves me with the same problem though. You see the query below calulates the pages

$t = mysql_query("SELECT * FROM ''");
if(!$t) die(mysql_error()); 

The second query i run takes into account the filter and builds a query to return the filtered results. Now after filtering it does not match with the top query. So the amount of pages displayed in the pagination does not match filter query. If I click say on page two i loose the filtered query and i reverts back to total amount of images.

I hope i'm being clear. Somehow there must only be one query. The top one that is build like the second one.

Cheers

[Weedpacket]

PierreL wrote:

I hope i'm being clear. Somehow there must only be one query. The top one that is build like the second one.

So .... um ... build the first query the same way as the second query. The differences between them are that

• the first one will start with "Select Count(*)" instead of "Select title,id" (those being the only fields you actually use - and what is that "if($thisrow=...)" thing supposed to achieve?), and

• the first query will not have the LIMIT clause

. Build the parts of the queries as separate pieces, and then for each query put together the pieces you need.

[rowanparker]

dagon wrote:

if(isset($_GET['type')){
$type =$_GET['type]';
elseif(isset($_POST['type')){
$type =$_POST['type]';
}else{
$type = /*what ever the default is*/
}

Wouldn't this do better?

if (isset($_REQUEST['type'])) {
      $type = $_REQUEST['type'];
} else {
      $type = ""; //Default
}

[dagon]

$_REQUEST could be environment or cookie also; so i would personally prefer to use my more specific code. In practice, in this case, it would work fine (as long as type is validated somewhere).

[PierreL]

HI Guys

Firstly thanks for all the great replies. It really helped me. Filter is sorted. Pagination works great i even added a search function 😃

One more thing. I display 4 images per page. Now at the moment i'm moving to the next id by using ++ after the current id. now thats wrong becuase i need to move to the next row in the query because a photo can be deleted and the id's may not follow after each other. Below is a section of the code. I have tried about anything, but cant get it to work for the life of me.

	$q = mysql_query("$fullquery");
		  if(!$q) die(mysql_error());
			 $err = mysql_num_rows($q);
			   if($err == 0){ print "<span class='no_result'><br><br><br><div align='center'>No matches met your criteria.<br>Please try another combination</div></span>";} ?>


	<table width='545' height='312' border='0' cellspacing='0' cellpadding='0'>

<?php	//show data matching query:
	while($code = mysql_fetch_object($q)) {

		  ?>


			  <tr>
			   <td width='273' height='90' align='center' valign='top'>


	<a href="#"><img src='viewThumb.php?id=<? print "$code->id"; ?>' border='0' onclick="MM_openBrWindow('viewLarge.php?id=<? print "$code->id"; ?>','','scrollbars=yes,resizable=yes,width=500,height=500')" /></a>			 	</td>
			   <td width='272'  height='90' align='center' valign='top'>

 <?php					if($thisrow = mysql_fetch_row($q))
					{
						$code->id++; ?>

	<a href="#"><img src='viewThumb.php?id=<? print "$code->id"; ?>' border='0' onclick="MM_openBrWindow('viewLarge.php?id=<? print "$code->id"; ?>','','scrollbars=yes,resizable=yes,width=500,height=500')" /></a>	




	  <?	} ?>				</td>
			</tr>
			  <tr>
			    <td width='273' height='90' align='center' valign='bottom'>

				<?php if($thisrow = mysql_fetch_row($q))
				{
					$code->id++;


					?>

	<a href="#"><img src='viewThumb.php?id=<? print "$code->id"; ?>' border='0' onclick="MM_openBrWindow('viewLarge.php?id=<? print "$code->id"; ?>','','scrollbars=yes,resizable=yes,width=500,height=500')" /></a>	




	  <?	} ?>					</td>
			    <td  height='90' align='center' valign='bottom'>


				<?php

				if($thisrow = mysql_fetch_row($q))
				{
					$code->id++; ?>

	<a href="#"><img src='viewThumb.php?id=<? print "$code->id"; ?>' border='0' onclick="MM_openBrWindow('viewLarge.php?id=<? print "$code->id"; ?>','','scrollbars=yes,resizable=yes,width=500,height=500')" /></a>	




	  <?	} ?>					</td>
	      </tr>

<?php	} ?>

This where in incremint it.

$code->id++; 

Thanks in advance

[dagon]

you grab the id's from the database