Prev 123 Next Script KILLING ME!!!!

[ravegti]

I'm trying to get this [Prev] 123 [Next] Script Working... I got the Prev and Next buttons to work perfectly.... but adding the page numbers is making me pull my hair out. Here is what I've got so far...

$sqlnum2=mysql_query("SELECT * FROM Products WHERE Category='$Section'");
$totalnum2=mysql_num_rows($sqlnum2);

$pages=ceil($totalnum2/5); 
$print "$pages";

I know this is supposed to just print out how many pages there should be, and it worked. =)

But here is what I want my links to do. I want my first page to have an offset of 0, then my second page have an offset of 5, 10, 15 and so on... So it can match my Next button which looks like this...

////// Next Link ////////
$totalnum2=$totalnum2 - 5;
$nextoffset2=$offset + 5;

if($offset<$totalnum2){print "<a href=\"?phpid=view_products&Section=$qn&offset=$nextoffset2\">Next >></a>";}

See how it adds 5 to the offset? Can someone give me a clue on how to add an offset of 5 to each 1234.. page?

[planetsim]

Do a search on these forums.. I did i found a few articles many of which are quite useful

[ravegti]

i've looked through a whole bunch and none really work for the way i would like to add 5 to my offset...

[planetsim]

is offset your limit..

[ravegti]

Lets explain it this way... I have a random number which is called. In this case its an 8. So for 8, I want to print 8 items, like this...

12345678

Now under each item, I want to pass a value to my query string. Each value adding 5. for example

1=0 ( <a href="view.php?offset=0"> )
2=5 ( <a href="view.php?offset=5"> )
3=10 ( <a href="view.php?offset=10"> )
4=15 ( <a href="view.php?offset=15"> )

and so on...

Can anyone convert this into php?

[Duey]

hmm i dont really understand but maybe its this:

<?
$random_num = rand(1,9);
if($random_num == "1"){$offset = 5;}
elseif($random_num == "2"){$offset = 10;}
elseif($random_num == "3"){$offset = 10;}
elseif($random_num == "4"){$offset = 15;}
elseif($random_num == "5"){$offset = 20;}
elseif($random_num == "6"){$offset = 25;}
elseif($random_num == "7"){$offset = 30;}
elseif($random_num == "8"){$offset = 35;}
elseif($random_num == "9"){$offset = 40;}
$link = "<a href=\"view.php?offset=".$offset."\"></a>
?>

maybe that dont know u might need to do some rounding with that random number i forgot

[ravegti]

not really like that... here is my whole page... i'm looking for some help to add the 1234.. between the [Prev] and [Next] links. I have highlighted in bold where i need the help...

<?php

if($dbconnected==0){require('connect_db.php');}

$queryname=$GET['Section'];
$Section=addslashes(urldecode($queryname));
$offset=$GET['offset'];

$sql="SELECT * FROM Products WHERE Category='$Section' ORDER BY ProdID LIMIT $offset,5";
$result=mysql_query($sql,$db);
if($row=mysql_fetch_array($result))
{
$Category=stripslashes(stripslashes($Section));
print "<br/><div class=\"category\">$Category</div>";
print "<div align=\"right\">";

////// Previous Link //////
$qn=urlencode($Category);
$prevoffset1=$offset - 5;
if($offset>1){print "<a href=\"?phpid=view_products&Section=$qn&offset=$prevoffset1\"><< Previous</a>";}

print "   ";

////// Next Link ////////
$sqlnum1=mysql_query("SELECT * FROM Products WHERE Category='$Section'");
$totalnum1=mysql_num_rows($sqlnum1);

$totalnum1=$totalnum1 - 5;
$nextoffset1=$offset + 5;

if($offset<$totalnum1){print "<a href=\"?phpid=view_products&Section=$qn&offset=$nextoffset1\">Next >></a>";}

print "</div>";

do{

 $Name=stripslashes($row['Name']);
 $Picture=$row['Picture'];
 $ProdID=$row['ProdID'];

 print "
<br/><br/>
<table width=\"450\" border=\"2\" bordercolor=\"#006699\" cellpadding=\"5\" cellspacing=\"1\">
<tr>
<td width=\"100\">
<img src=\"pics/$Picture\" width=\"100\">
</td>
<td width=\"265\">
<div class=\"prodname\">$Name</div>
</td>
<td width=\"85\">
<a href=\"?phpid=view_products2&prodid=$ProdID&Section=$qn&offset=$offset\"><center><img src=\"images/more_info.gif\" width=\"80\" height=\"21\" border=\"0\"></a></center>
</td>
</tr>
</table>
<br/>
";
 }
 while($row=mysql_fetch_array($result));

print "<div align=\"right\">";

////// Previous Link //////
$qn=urlencode($Category);
$prevoffset2=$offset - 5;
if($offset>1){print "<a href=\"?phpid=view_products&Section=$qn&offset=$prevoffset2\"><< Previous</a>";}

print "   ";

////// Page Links //////
$sqlnum2=mysql_query("SELECT * FROM Products WHERE Category='$Section'");
$totalnum2=mysql_num_rows($sqlnum2);

$pages=ceil($totalnum2/5); 

       [COLOR=red]WHERE DO I GO FROM HERE???[/COLOR][/B]

////// Next Link ////////
$totalnum2=$totalnum2 - 5;
$nextoffset2=$offset + 5;

if($offset<$totalnum2){print "<a href=\"?phpid=view_products&Section=$qn&offset=$nextoffset2\">Next >></a>";}

print "</div>";

}
else{print "<div class=\"main\" align=\"center\"><br/><br/><br/>No Products Found.</div>";}
?>

[ravegti]

anyone? 😕

[Weedpacket]

I take it this article was no help? It does cover prev/next links, limited number of pages, offsets.... As the author notes in his previous article on the subject,

There have been numerous requests on the Support Forums recently asking how to do "NEXT 1 2 3 4 5 PREV" type links from a search result. I hope the following script will help you add this functionality to your search result pages. This example is written for MySQL but can be adapted quite easily to other SQL engines.

[ravegti]

yea i tired that artcle and it worked, but only increased my offset by 1 for each page... im looking to add 5 each time...

[Weedpacket]

Well, I'm not clear what you're wanting, but if you want to do
1=0 ( <a href="view.php?offset=0"> )
2=5 ( <a href="view.php?offset=5"> )
3=10 ( <a href="view.php?offset=10"> )
4=15 ( <a href="view.php?offset=15"> )
...

Then that's just

for($i=1; $i<=[i]n[/i]; $i++)
    $offset=($i-1)*5;
//check $offset in case it overflows. break if it does, write the link if it doesn't.

But that can't be what you want, 'cos it's too simple.

The code given in the article jumps in steps of 20, not 1 (due to the line:

// set this to the number of results you wish on each page
$limit=20;