tricky page counter

Anon

hello, i would like to put a next/prev page with numbers to my page, since my query return lot of page, i dont want to display all the pages, but something like (on first page, assuming i got 16 pages of result)
[ (1) 2 3 4 ... 16 ] -> next

when i click on page four it change to:
previous <- [ 1 ... 3 (4) 5 ... 16] -> next
and on page fifteen:
previous <- [ 1 ... 13 14 (15) 16] -> next

and so

<?
if ($offset!=0) { // bypass PREV link if offset is 0
$prevoffset=$offset-$limit;
print "<a href=\"$PHP_SELF?offset=$prevoffset\"><<previous</a>   \n";
}
$pages=intval($numrows/$limit);
if ($numrows%$limit) {
// has remainder so add one page
$pages++;
}
print "</td><td align=center >[   ";
for ($g=1;$g<=$pages;$g++) { // loop thru
$newoffset=$limit*($g-1);

if ($newoffset==$offset) {print "<b>$g</b>  &nbsp; ";}
else {print "<a href=\"$PHP_SELF?offset=$newoffset\">$g</a> &nbsp; \n";}

}
print "]</td><td align=left width=33%>   ";
if (!(($offset/$limit)==($pages-1)) && $pages!=0) {
//print "$offset - $limit - $pages";
// not last page so give NEXT link
$newoffset=$offset+$limit;
print "<a href=\"$PHP_SELF?offset=$newoffset\">next >></a>\n";
}

any clues to change the code to fit what i would like?
thanks in advance

Anon

Hai,

Please follow these steps for your coding.

1.First get the count ( total number of rows ) from the table.

//CODING FOR GOOGLE CONCEPT STARTS HERE
//CALCULATING NUMBER OF ROWS PER PAGE AND NUMBER OF PAGES
$norows=count from table;
$perpage=4;(assign as you wish ..how many rows you want per page)
$nopages=($norows)%($perpage);
if($nopages==0)
$nopages=$norows/$perpage;
else
$nopages=ceil($norows/$perpage);
//CODING FOR START RECORD AND END RECORD..CURRENTPAGE WILL BE NULL WHEN U COME FIRSTTIME
//START RECORD AND END RECORD WILL BE DIFFERENT FOR EACH NUMBER THAT IS EACH LINK
if($curpage=="")
$curpage=1;
$gen=0;
if($curpage==1)
$startrec=1;
else
$startrec=(($curpage-1)$perpage)+1;//current page is sent everytime
$endrec=$curpage$perpage;
//DISPLAY THE VALUES OF THE TABLE
while($row=mysql_fetch_array($result))
{
$gen=$gen+1;
if(($gen>=$startrec) && ($gen<=$endrec))
{

echo "Display the Values of the table";

}//close if of start record and end record
}//close of displaying the entire table values

5.//SECTION DEALS WITH HYPER LINK PREVIOUS
if ($curpage!=1)// FOR 1 THERE WILL BE NO PREVIOUS LINK
{
$prev=$curpage-1;
echo "<a href=\"$PHP_SELF?curpage=$prev\">Prev</a>";
}

6.//SECTION DEALS WITH LINKS(TOTAL NUMBERS) OF THE PAGE
for($i=1;$i<=$nopages;$i++)
{
if($nopages!=1)
{
if($curpage==$i)
{
echo "(".$i.")"; //CURRENT LINK(NUMBER) WILL BE SEEN IN BRACES
}
else
{
echo "<a href=\"$PHP_SELF?curpage=$i\">$i</a>";
}
}
}//close for loop
7.//SECTION DEALS WITH NEXT HYPER LINK

if($curpage!=$nopages) //FOR THE LAST LINK THERE WILL BE NO NEXT LINK.
{
	$next=$curpage+1;
	echo "<a href=\"$PHP_SELF?curpage=$next\">Next</a>";
}

Thats it .......Bye .......Ajay

Anon

thanks for your help!
your code was more clearer than mine... but it got the same result,
my goal is to show (in the numbered page section) just few page numeber and sobsitute the missing one with "..."

i mean something like
<- [1 ... 5 (6) 7 ... 16] ->
when im on page 5

(dots are printed dots that i want on the page... not just to not type here 🙂)

thanks

Anon

Change in Step 6 :

This makes the numbers less and numbers which are not shown will be a dot.
I think so this is your requirement.

6.//SECTION DEALS WITH LINKS(TOTAL NUMBERS) OF THE PAGE
for($i=1;$i<=$nopages;$i++)
{
if($nopages!=1)
{
if($curpage==$i)
{
echo "(".$i.")"; //CURRENT LINK(NUMBER) WILL BE SEEN IN BRACES
}
else
{
if($i%3==0)
{
echo "<a href=\"$PHP_SELF?curpage=$i\">$i</a>";
}
else
{
echo ".";
}
}
}
}//close for loop

----Ajay

gregz

Ajay,

Code works great! The only thing is if you have 10,0000 records the amount numbered pages wraps... I tried to tweak the code to limit the number of page numbers but to no avail...any ideas?

this is what I meant:

<< prev [ 1 | 2 | 3 | 4 | 5 ] next >>

<< prev [ 6 | 7 | 8 | 9 | 10 ] next >>

TIA,

GregZ

Anon

Change in Step 6 :

This makes the numbers less and numbers which are not shown will be a dot.
I think so this is your requirement.

6.//SECTION DEALS WITH LINKS(TOTAL NUMBERS) OF THE PAGE
for($i=1;$i<=$nopages;$i++)
{
if($nopages!=1)
{
if($curpage==$i)
{
echo "(".$i.")"; //CURRENT LINK(NUMBER) WILL BE SEEN IN BRACES
}
else
{
if($i%3==0) // 3 or 4 or 5 wat ever
{
echo "<a href=\"$PHP_SELF?curpage=$i\">$i</a>";
}
else
{
echo ".";
}
}
}
}//close for loop
This reduces the links if there are more records

----Ajay

Anon

Change in Step 6 :

This makes the numbers less and numbers which are not shown will be a dot.
I think so this is your requirement.

6.//SECTION DEALS WITH LINKS(TOTAL NUMBERS) OF THE PAGE
for($i=1;$i<=$nopages;$i++)
{
if($nopages!=1)
{
if($curpage==$i)
{
echo "(".$i.")"; //CURRENT LINK(NUMBER) WILL BE SEEN IN BRACES
}
else
{
if($i%3==0) // 3 or 4 or 5 wat ever
{
echo "<a href=\"$PHP_SELF?curpage=$i\">$i</a>";
}
else
{
echo ".";
}
}
}
}//close for loop
This reduces the links if there are more records

----Ajay

gregz

Oops...my bad 😉

yes, that will work...thanks.

Greg