next previous results, grouping pages

oliver-b

Hi,
I am building a music based online shop, which contains quite a large number of customers, artists, labels.

I am coming to completion of the administration area, where my client can browse, search, edit, delete and create records in those areas.

To display results over many pages (with page links, next, prev etc) I have written a class based on a tutorial I read over at oreilly.net.

However one problem I`m facing is TOO many page links being displayed.

What I`d like to do is display my links like this...
(Prev 20 Pages) 1-2-3-4-5-6-7-8-9-10 (Next 20 Pages)

Or something like that...anyway

I`ve noticed a few people have already asked how this might be done, but got no reply.

So any help would be great,
Cheers, Oliver-b.

bouche

Check this article, it probably tells you all you have to know about the subject ;-)

http://www.phpbuilder.com/columns/rod20000221.php3

oliver-b

Below is an example of the function I use to create an array of links to other pages in the result set.

(Not sure how I`m supposed to put it this small textarea).

My class is functioning fine and dandy, needs some fine tuning here there. However I stumped on how to limit the amount of links to displayed.

In short I don`t want 1000+ links to pages being displayed.

For example I need the first 10 pages, which will display the links...
1,2,3,4,5,6,7,8,9,10 (More Pages-->)

function build_page_array() {
global $pos; // get our current position
$counter = 0; // set counter to zero
for ($i = 0; $i < $this->number_of_pages; $i++){

if ($pos == $i) {
$this->page[$counter++] =
($i > 0 ? ($i + 1) : 1)." \n";
} else {
$this->page[$counter++] =
"<ahref=\"".$this->file."?pos=".$i.$this->query_string."\">".($i + 1)."</a> \n";
}
}
return $this->page; // return the array
}

Anon

Hi!

You ran into a problem with displaying the first record, if I remember reading it right?

I'm fighting the same battle.

I hate to ask you when you are asking for answers, but did you solve that problem?
and...
Did you manage to pass the variables you defined in your search criteria to the "Next" page?

Gerard

Anon

I`m not sure if your problem is the same as mine, but I got round most of my
problems by making sure each variable involved in a SQL query was assigned a default value.

So for example:

<pre>
<?php

//
// This will not print nothing, as the variable is // not set. Which is not what we want.
//
print $page;

?>
</pre>

But if we test that the variable has been set...

<pre>
<?php

//
// If the $page variable is not set, give it
// a default value.
//
if (!isset($page))
{
// The first page.
$page = 0;
}

//
// The $page variable will always contain a
// value of some kind, be it 0 or greater.
//
print "<ahref='$PHP_SELF?page=$page'>Current page = $pos</a>";

?>
</pre>

It been a while since I posted that message so I appologise in advance if I`m talking out of my arse.

I hope this helps you in some way.

Regards,
Oliver Beddows.

skmalla

I don't know if the problem is same as what oliver-b mentioned but here is the brief code for temporary solution upto 40 page links which is divided for 20 page links displayed. If you want for more than that I guess you will have to pass more variable for the solution...

<?php

$dbhost = "";
$dbname = "";
$dbusername = "";
$dbpassword = "";

$connection = mysql_connect($dbhost, $dbusername, $dbpassword);
if (!$connection) { echo("ERROR: " . mysql_error() . "\n"); }

// the number of rows returned from database
$database = mysql_select_db($dbname,$connection);
$numresults = mysql_query("SELECT fieldname FROM tablename order by date ");
$numrows = mysql_num_rows($numresults);

$limit = 20;
// next determine if offset has been passed to script, if not use 0
if (!$offset) { $offset = 0; }

function pagelinkpreview()
{
global $limit,$offset,$pages,$numrows,$pagenumber;

// calculate number of pages needing links
$pages=intval(round($numrows/$limit));

// get previous page displayed
if ($offset>=$limit)
{
$newoff=$offset-$limit;
echo "<a href=\"$PHP_SELF?offset=$newoff\">PREV</a>";
}
else
{
echo "prev";
}
echo "  ";

// get next page displayed
if ($offset<$limit*($pages-1))
{
$newoff=$offset+$limit;
echo "<a href=\"$PHP_SELF?offset=$newoff\">NEXT</a>";
}
else
{
echo "next";
}

echo "   ";

// get the page number displayed
// carefully go through the code since you may have to adjust the $lastoffsetnumber value
// according to your requirement also along with the other value like $pagelinkmax
// $pagegroupnumer variable is not necessary but for future purpose I have linked it.
echo "Pages:  ";
$pagenumber=1;
$pagelinkmax=10;
$lastoffsetnumber=120;
$pagegroup=ceil($pages/$pagelinkmax);
$pagegroupnumber=1;
if ($offset <= $lastoffsetnumber)
{
while (($pagenumber <= $pages) and ($pagenumber <= $pagelinkmax))
{
if ((($pagenumber-1)$limit)==$offset)
{
print " $pagenumber ";
}
else
{
$newoff=($pagenumber-1)$limit;
echo "<a href=\"$PHP_SELF?offset=$newoff\"> [$pagenumber] </a>";
}
$pagenumber++;
}
if ($pagegroupnumber<$pagegroup)
{
$newoff=($pagenumber-1)*$limit;
echo "<a href=\"$PHP_SELF?offset=$newoff&pagegroupnumber=$pagegroupnumber\"> [Next 10 Pages] </a>";
}
}
else
{
$pagenumber=$pagenumber+10;
$pagelinkmax=$pagelinkmax+10;
$pagegroupnumber=$pagegroupnumber+1;

if ($offset>=$limit)
{
$newoff=$offset-$limit;
echo "<a href=\"$PHP_SELF?offset=$newoff&pagegroupnumber=$pagegroupnumber\"> [Previous 10 Pages] </a>";
}

while (($pagenumber <= $pages) and ($pagenumber <= $pagelinkmax))
{
if ((($pagenumber-1)$limit)==$offset)
{
print " $pagenumber ";
}
else
{
$newoff=($pagenumber-1)$limit;
echo "<a href=\"$PHP_SELF?offset=$newoff\"> [$pagenumber] </a>";
}
$pagenumber++;
}
if ($pagegroupnumber<$pagegroup)
{
$newoff=($pagenumber-1)*$limit;
$pagegroupnumber++;
echo "<a href=\"$PHP_SELF?offset=$newoff&pagegroupnumber=$pagegroupnumber\"> [Next 10 Pages] </a>";
}
}

} // END FUNCTION