alter pagination script

[bliss322]

hi,

i'm using a pagination script i found here that shows "next" and "previous" links, but the client wants that changed to show all the pages returned as links (i.e. "1 2 3 4 5 6 7 last")

any suggestions on changing this script to represent that?

<?php
// clean up input
$pageid = substr($pageid, 0, 3); // or however big page max is
$pageid = EscapeShellCmd($pageid);

// build query - using 10 recs per page - but we read 11 rows to
// have a way of knowing if we are at end of file so we don't put
// out the 'next page' link
$skiprows = (($pageid - 1) 10); // number of rows to skip in query
$query = "SELECT FROM $table
LIMIT $skiprows, 11";

// connect to the database
if(!($dbh=mysql_connect ("localhost",
"$user",
"$pass")))
die("Cannot connect to the database");

// open the connected database
if (!mysql_select_db("$user",$dbh))
die("Cannot open the database");

// execute the query
if (!($result = @ mysql_query ($query, $dbh)))
die("Cannot execute query against the database");

// if we got some rows back then get some numbers and output page
$numrows = mysql_num_rows($result);
if ($numrows > 0)
{
for ($i = 1; $i <= 10; $i++)
{
// last page may have less than 10 rows
if ($row = @ mysql_fetch_array($result))
{
// do all the stuff to put out the row
} // if there are rows in array
} // for i

// now put out next and previous links
// if not on page 1, then do previous
if ($pageid > 1)
{
$oldpageid = $pageid - 1;
echo "<a href=\"pagescript.php?pageid=$oldpageid\">";
echo "Go Back to Page $oldpageid</a>";
}

// if rowcount less than 11, must be last page otherwise do link
if $(numrows > 10) // there will be a next page
{
$newpageid = $pageid + 1;
echo "<a href=\"pagescript.php?pageid=$newpageid\">";
echo "Go Forward to Page $newpageid</a>";
}
} // if $numrows > 0
?>

[batman]

Here is a script that I use. You can change it to fit your needs, but should be pretty close as is.

// limit value for number of records to be shown per page 
// query database to find total number of records to display 
$limit = 5; 
$query_count = "select * from ".$prefix."store_inventory where (description like '%$search%' or title like '%$search%')"; 
$result_count = mysql_query($query_count); 
$totalrows = mysql_num_rows($result_count); 
if(empty($page)) 
$page = 1; 
$limitvalue = $page * $limit - ($limit); 
$query = "select * from ".$prefix."store_inventory where (description like '%$search%' or title like '%$search%') LIMIT $limitvalue, $limit "; 
$result = mysql_query($query) or die("Error: " . mysql_error()); 
$count_result = mysql_num_rows($result); 

// Display links at the top to indicate current page and number of pages displayed
$numofpages = ceil($totalrows / $limit);
echo"<br><p><b>$totalrows</b> result(s) for: \"$search\"</p>";
$from=$limit*$page-$limit+1;
$to=$from + $count_result-1;

// start 123 next>> table
echo "<table align=\"center\" width=\"90%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">
            <tr><td width=\"50%\" bgcolor=\"$bg_colour\" align=\"left\">";if($numofpages>1){echo"Showing: $from - $to</td><td width=\"50%\" bgcolor=\"$bg_colour\" align=\"right\"><b>Go to page:</b> ";} 

// display previous link if page is not 1
if($page != 1){ 
$pageprev = $page - 1; 
echo("<a href=\"$PHP_SELF?page=$pageprev&search=$search\"><< PREV</a>&nbsp;"); 
} 

// display page nos if not 1 
for($i = 1; $i <= $numofpages; $i++){ 
if($numofpages>1){
if($i == $page) 
echo("&nbsp;".$i."&nbsp;"); 
else
echo("&nbsp;<a href=\"$PHP_SELF?page=$i&search=$search\">$i</a>&nbsp;"); 
}}

// display next page link if there is more than one
if(($totalrows - ($limit * $page)) > 0){ 
$pagenext = $page + 1; 
echo("<a href=\"$PHP_SELF?page=$pagenext&search=$search\">NEXT >></a>"); 
}
// end 123 next>> table
echo"</td></tr></table><br>";

[leatherback]

Hi,

Perhaps not precisely the answer, but here is how I have it in one of my sites:

  $huizenaanbod = mysql_query($query);
  $NumHits = mysql_num_rows($huizenaanbod);
  if ( $NumHits > $maxresult )
    {
      $ResultNavig = "<table width=80% cellspacing=0 class=\"botbor\"><tr><td align=right>More, page: ";    

    $pages = ceil($NumHits/$maxresult);
    //echo $pages;
    for ( $i = 1; $i <= $pages ; $i++)
       {
       $skip = ( ($i-1) * $maxresult ) ;
       //echo $skip ;
       $ResultNavig .= "<a href=\"aanbod.php?zoeken=1&skip=$skip">[$i]</a>";
       }

$ResultNavig .="</td></tr></table>";

I clipped it from a large page, so it may need some brackets here and there. But I suppose you get the idea?

J.