Expanding on the < Previous | Next >

mabans

I understand how to create how a "Previous" and "Next". I used the following script:

<?php
//The Required Files to access the data base
require("../../../includes/configs/config.cfg");
require("../../../includes/configs/select_db.cfg");
//The Required Files to access the data base

// This sets the offset page so it starts up on page one //
if(!isset($_GET['offset'])) $_GET['offset'] = 0;
// This sets the offset page so it starts up on page one //

// The query for what will be displayed //
$poster_sql = "SELECT * FROM poster WHERE category=" .$_GET['show_cat'] ." ORDER BY code LIMIT ".$_GET['offset'] .", 20";
// The query for what will be displayed //

$poster_results = mysql_query($poster_sql) or die(mysql_error());

//we add this line because we need to know the number of rows//
$poster_rows = mysql_num_rows($poster_results);
//we add this line because we need to know the number of rows//

// The query for what is the total of results //
$total_sql = "SELECT * FROM poster WHERE category=" .$_GET['show_cat'];
// The query for what is the total of results //

//This Query is meant to give the total amount of results given for that given category//
$total_results = mysql_query($total_sql) or die (mysql_error());
//This Query is meant to give the total amount of results given for that given category//

$nrow = mysql_num_rows($total_results);



while ($poster = mysql_fetch_array($poster_results))
{

echo "<br>"
	.$poster['code'];

}
echo"<br>";	
//These are the next and Previous Buttons//
if($_GET['offset'] > 0)
   echo "<a href=\"" . $PHP_SELF . "?show_cat=" .$_GET['show_cat'] ."&offset=" . ($_GET['offset'] - 20) .
        "\">Previous</a> |\n";
if($nrow > ($_GET['offset'] + 10))
   echo "<a href=\"" . $PHP_SELF . "?show_cat=" .$_GET['show_cat'] ."&offset=" . ($_GET['offset'] + 20) .
        "\">Next</a><BR>\n";
//These are the next and Previous Buttons//
?>

You can also see it in action here:

http://69.13.156.225/test/includes/main_stage_items/results/test.php?show_cat=1

I do want to be able to expand on this by having single pages like so:

< previous | 1 | 2 | 3 | etc... | Next >

how can I achieve this? I'm currently working on it, so there will be updates to this post but I also wanted to some more input on this subject from other people. Thanks in advance..

jassh

Here, try and look at the
Collection of solved problem
Look for the keyword: pagination

that oughta get you started 🙂

ednark

Try this and see if it makes sense:

if ( $_GET['results_per_page'] ) {
  $results_per_page = $_GET['results_per_page'];
} else {
  $results_per_page = 10;
}
if ( $_GET['offset'] ) {
  $offset = $_GET['offset'];
} else {
  $offset = 0;
}
if ( $_GET['total_results'] ) {
  $total_results = $_GET['total_results'];
} else {
  $total_results = 100;
}


if ( $offset < $results_per_page ) {
  echo '<br />Previous';
} else {
  echo '<br /><a href="'.$PHP_SELF.'?offset='.($offset-$results_per_page).'&total_results='.$total_results.'&results_per_page='.$results_per_page.'">Previous</a>';
}

for ( $start_result=0, $page=1; $start_result<$total_results; $start_result+=$results_per_page, $page++ ) {
  if ( ($offset >= $start_result) && ( $offset < $start_result+$results_per_page ) ) {
    echo '<br /><b>'.$page.'&nbsp;&lt;&lt;</b>';
  } else {
    echo '<br /><a href="'.$PHP_SELF.'?offset='.$start_result.'&total_results='.$total_results.'&results_per_page='.$results_per_page.'">'.$page.'</a>';
  }
}

if ( $offset >= $total_results-$results_per_page ) {
  echo '<br />Next';
} else {
  echo '<br /><a href="'.$PHP_SELF.'?offset='.($offset+$results_per_page).'&total_results='.$total_results.'">Next</a>';
}

dukegamma

i did something like this for an administrative tool im writing in php. here is the code.. note some of the stuff here is to serve my purpose of the code, and is not necessary, but i figure you can decipher it as its pretty basic


// Retrieve number of records from my tours database
$SQL="SELECT COUNT(*) AS Total FROM tours";
   $SQL_Result=mysql_query($SQL);  // Query it, etc
   $SQL_Result_Array=mysql_fetch_array($SQL_Result);
   $Total=$SQL_Result_Array['Total'];

   $currentDate=date("Y-m-d"); 
   $query="SELECT * FROM tours";
   $orderdescrip="Results ordered by"; // ignore this
   $Per_Page="5"; // set how many db items listed per page
   if($listing=="date")
    {
      $query.=" ORDER BY startDate";    // Here i'm altering the query depending how the user wants to view the data
      $orderdescrip.=" start date ";
    }

   elseif($listing=="groupsize")
   {
     $query.=" ORDER BY groupsize"; // more altering
     $orderdescrip.=" group size ";
   }

   elseif($listing=="price")
   {
     $query.=" ORDER BY price"; // and yet more..
     $orderdescrip.=" price ";
   }

  if($listing=="future")
  {
   $query.=" WHERE startDate >= '$currentDate'"; // you get the idea
   $orderdescrip.=" future tours ";
  }

  if($listing=="past")
  {
   $query.=" WHERE startDate <= '$currentDate'";
   $orderdescrip.=" past tours ";
  }

   if($order=="desc")
   {
    $query.=" DESC"; // arranges items
    $orderdescrip.=" descending."; 
   }
   if($order=="asce")
   {
    $orderdescrip.=" ascending."; // need not alter $query, as it automatically lists ascending.. this other variable is for my own purposes
   }

// Checking to see if the user has specified a page, and if not, sets the result set to zero so as to list the first group of items
  if (empty($_GET['Result_Set']))  

   {
    $Result_Set=0;
    $query.=" LIMIT $Result_Set, $Per_Page";
   }
  else
   {
    $Result_Set=$_GET['Result_Set']; // gets the result set and changes the query accordingly to list the correct items
    $query.=" LIMIT $Result_Set, $Per_Page";
   }


$result=mysql_query($query)
       or die ("couldnt exec query");
$sql_rows=mysql_num_rows($result);            

// PAGINATE

// DRAW LINKS


if ($Total>0) // checks to see records are actually returned
   {
   $Pages=$Total / $Per_Page; // calculates how many pages there will be
   $numPages = ceil($Pages); // rounds fraction up so we have correct number of pages
   $pagenum=$Result_Set / $Per_Page; // calculates the page we are on
   $realpage=$pagenum+1; // since we start at zero we have to add 1

   echo "<font face='verdana' size='1'>Page $realpage of $numPages</font><br>"; // list the page we are on
   echo "<br><font face='verdana' size='1'>current date: $currentDate</br>"; // for fun
   if ($Result_Set<$Total && $Result_Set>0)
      {
      $Res1=$Result_Set-$Per_Page; // calculates previous page
      echo "<font face='verdana' size='2'><A HREF=\"manage.php?m=viewtours&Result_Set=$Res1\">Previous Page</A>  </font> ";
      }
   // calculate the pages and link them accordingly


   if ($Pages>1) // do this only if it is truly necessary!
      {

  // begin loop to number pages and create links
  for ($b=0,$c=1; $b < $Pages; $b++,$c++)
      {
      $Res1=$Per_Page * $b; // calculate the result set we want for each pages link

   /* test to see if we are on the page that the loop is creating a number for, so we dont link to the page we're on.. (ugly redundancy imho) */
    if ($b==$pagenum)        
      {
        echo "<font face='verdana' size='2'>$c  </font> \n";
       }
      else // otherwise, create links accordingly
       {
        echo "<font face='verdana' size='2'><A HREF=\"manage.php?m=viewtours&Result_Set=$Res1\">$c</A>  </font> \n";
       }    

  }
 }
   if ($Result_Set>=0 && $Result_Set<$Total) // if there is still need for a next button
      {
      $Res1=$Result_Set+$Per_Page;
      if ($Res1<$Total)
         {
         echo "<font face='verdana' size='2'><A HREF=\"manage.php?m=viewtours&Result_Set=$Res1\">Next Page</A>  </font>";
         }
      }
   }

hope that was helpful!

-tom