[Resolved] Paging works, need to shorten it...

[charles256]

I have 700 records, with 25 per page, that gives me 28 pages. It works, all is fine except the
[Page 1] | [Page 2] etc....thru [Page 28] goes all the way
across the bottom of my page.

I know this is the code that is making these for me, but where or how do I make them only Page 1 to 10 and then next?

for($i=1; $i<=$totalpages; $i++)
//for($i=1 ; $i<=3; $i++)
{
//print("<br>");
       print("<A href=table5.php?page=".$i.">");
       print("page".$i);
       print("</A>");
       print("|");
       }

charles256

[PHPGuru2]

Start from $GET['page'] to $GET['page'] + 10. If $GET['page'] + 10 is bigger than your maximum page (28 pages) then count from oposite (from $max down to $max - 10) and display the link OR display from $GET['page'] - ($max - $_GET['page'] + 10) to $max. Something like this??

[charles256]

thanks PHPGuru2, I'm alittle confused with this....
I'm not a noobie, but still in beginning stages. I was thinking more of needing a \n or something... or if else..

???
charles

ps... are you speaking in these terms:

$_GET['page'] + 10;
if($_GET['page'] + 10 >$perpage; $i-)

[charles256]

Still need help on this...

[bodzan]

...this:

If I understabd the problem correctly: you want to show just 10 links for the pages that are near yours...

if that's the case...
Do something like:

$p = $_GET['page'];

if($p<$totalpages){
while($p<($notp+10)){
$p++;
echo "|<A HREF=\"table5.php?page=".$p."\">Page ".$p."</A>|";
}
}

This will show you only ten links after your current page...

Take it from here...

[charles256]

so here is the full colde to help explain better....

$startrow  = 0; 
$perpage=25;  

$totalrecords=700;
$query = ("SELECT * FROM $table_name");
$query = ("SELECT Name,Manf,Sku,Price,Short_Desc,thumb_image FROM $table_name ORDER BY ID asc
LIMIT $startrow,$totalrecords");

if (!isset($page))
   {
$page=1;

$result = mysql_query($query) or die ("Database error");
$num_rows=mysql_num_rows($result);

echo "<center><b>" . $num_rows . " Items Found For Sports Gear</b></center><br>\n";


$totalpagesreal=($num_rows/$perpage);
$totalpages=intval($num_rows/$perpage);

if (($totalpages==$totalpagesreal) and ($totalpages==0) )
{
echo "There are no records";
$id=1;

}
else
{
//Checks if there are records which exactly fits in the integer
//number of pages
if (($totalpages==$totalpagesreal) and ($totalpages!=0))
{
$totalpages=$totalpages;

$id=2;
}

else
{

$id=3;

$totalpages=$totalpages+1;

}
}
}
/****************************************/
else
{
$page=$page;
$result = mysql_query($query) or die ("Database error");
$num_rows=mysql_num_rows($result);

$totalpagesreal=($num_rows/$perpage);

$totalpages=intval($num_rows/$perpage);
if (($totalpages==$totalpagesreal) and ($totalpages==0) )
{
echo "There are no records";
$id=1;

}
else
{
if (($totalpages==$totalpagesreal) and ($totalpages!=0))
{
$totalpages=$totalpages;

$id=2;

}
else
{
$id=3;

$totalpages=$totalpages+1;

}
}
}

//here is my table and other output

print("<table align='center' border='1' width='600'>");
for($n=($startrow+($page-1)*$perpage);  $n<($startrow+($page)*$perpage);$n++)
    {
     // print($n);

if($color == "#D8BFD8") {
 $color = "#C0C0C0";
} else {
  $color = "#D8BFD8";
}

 print("<tr bgcolor=".$color."><td valign='top'>");
 print ("<b>Item:&nbsp;</b><br>");
 @print(mysql_result($result,$n,0));
 print("<b>Manf:&nbsp;</b><br>");
 @print(mysql_result($result,$n,1));
 print("<br><b>Sku:&nbsp;</b>");
 @print(mysql_result($result,$n,2));
 echo "<br><b><font color='#ff0000'>$";
 @print(mysql_result($result,$n,3));
 echo "</font></b>";
 print ("</td><td bgcolor=".$color." valign='top'>");
 @print(mysql_result($result,$n,4));
 echo "";
 print("</td><td valign='top'align='center'>");
 echo "<img src=";
 @print(mysql_result($result,$n,5));
 echo " width='90' height='90' border='0'>";
 print("</td></tr>");
 //print("<BR>");
}
 print("</table></center>");
//end of center table

print ("</center><br></td>");
print ("<td width='2'>&nbsp;</td>");

//right navigator
print ("<td width='130' valign='top'>");
print ("<table width='130' border='0' cellspacing='0' cellpadding='0'>");
print ("<tr><td>");
include ("Includes/rightnav.shtml");
print ("</td></tr></table>");
//end right navigator

print ("<br></td></tr></table>");
echo "<p></p>";
echo "<center>";


for($i=1; $i<=$totalpages; $i++){
//print("<br>");
       print("<A href=table5.php?page=".$i.">");
       print("page".$i);
       print("</A>");
       print("|");
       }

I tried your suggestion with $p and $page, but got errors. Wasn't sure if it were to go before the for loop or after either. Thanks for the patients with this,
charles

[Corpheous]

Just curious but is there a reason you switch back and forth between "print" and "echo"?

[charles256]

not really....
I guess with so much effort I wasn't thinking. I have
changed them all to print now.
charles

[PHPGuru2]

For multiple lines of HTML, I use something like this:

echo <<<HTML
<table>
<tr><td>
...
...
...
</td></tr>
</table>
HTML;

Start with "echo <<<WHATEVER_YOU_WANNA_NAME" and end with "WHATEVER_YOU_WANNA_NAME". You just put regular HTML between them. Just be careful that end "WHATEVER_YOU_WANNA_NAME" cannot be indented (means that you cannot have tab or any space in front of it) otherwise you will get an error.

[charles256]

of them over now. Question, what is the purpose of
@print?
instead of just print?
This is a part that someone else helped me with and I was not quite clear of that.

But I still have all the page numbers going across the bottom, you have to scroll all the way to the right to see the last page in order to click on it.

....
charles

[charles256]

I have NEXT 25 and PREV 25 working great with Showing 1 - 700 printed at the top. Thanks to all for your help.

Now how do I do this:
Go to page: 2 and when they get there,
Go to page: 3 and having the PREV showing?
charles