Back 1 2 3 4 5 Next - Please Help

cralyn

Hi,

I am hoping someone can help me. I have a small shopping cart script which lists all my products using PHP/MySQL. I have found that a page takes forever to load and now require a way of breaking up the list of products into pages of 10 products.

I would like to use the following format

Back | "page numbers" | Next

(where page numbers is generated depending on quantity of products).

I have tried using the "count" function but have been unsucessful due to my lack of knowledge with php.

Can someone please help me.

Regards
Craig

bernouli

<?php
$step = $diff = 10;
$tmp = 0;
$r = mysql_query("SELECT count(*) FROM table ") or die(mysql_error());

$anz = mysql_result($r,0);
if ($offset+$diff>=$anz) {
  $diff = $anz - $offset;
  $vor = TRUE;
}

if (!$offset || $offset<0) {
  $offset = 0;
  $zur = TRUE;
  $id = "0";
}

if ($zur != TRUE) echo '<a href="'.$PHP_SELF.'?id='.($id-($tmp+$step)).'&offset='.($offset-$step) . ' ">Back </a>  ';
for ($i=1;$i<=(int)ceil($anz/$step);$i++) echo '<a href="'.$PHP_SELF.'?id='.(($i-1)$step).'&offset='.(($i-1)$step). '" > '.$i.'</a>  ';

	if ($vor != TRUE) echo '<a href="'.$PHP_SELF.'?id='.$id.'&offset='.($offset+$step).'">next</a>';

cralyn

Hi,
Thanks for the reply and coding. How do i integrate it with the file i have already got running for the cart? I have attached the file for viewing.

bernouli

try this

<?
require("Cart.php");
DBinfo();
Brand();
Root();
mysql_connect("$DBHost","$DBUser","$DBPass");

if ($UID !=   "") {
$result=mysql(  "$DBName",  "SELECT * FROM Users WHERE User='$UID'");
$num=mysql_num_rows($result);
if ($num ==   "0") {
$dt=date(  "YmdHis");
$UID=  "$dt$REMOTE_ADDR";
$date=date(  "z");
mysql(  "$DBName",  "INSERT INTO Users VALUES ('$UID','$date')");
Header(  "Location: $PHP_SELF?CA=$CA&UID=$UID");
}
}

if ($UID ==   "") {
$dt=date(  "YmdHis");
$UID=  "$dt$REMOTE_ADDR";
$date=date(  "z");
mysql(  "$DBName",  "INSERT INTO Users VALUES ('$UID','$date')");
Header(  "Location: $PHP_SELF?CA=$CA&UID=$UID");
}

commonHeader("$Company","Select an item");

$step = $diff = 10; 
$offset=HTTP_POST_VARS['offset']; 
$r = mysql_query("SELECT count(*) FROM Items WHERE Category='$CA' ") or die(mysql_error()); 

$anz = mysql_result($r,0); 
if ($offset+$diff>=$anz) { 
$diff = $anz - $offset; 
$vor = TRUE; 
} 

if (!$offset || $offset<0) { 
$offset = 0; 
$zur = TRUE; 
} 


$result=mysql("$DBName","SELECT * FROM Items WHERE Category='$CA' ORDER BY ItemName LIMIT $offset,$diff");
fontFace("Arial","<B>Select an item:<br><br>");
echo "<table align='center'>";
while ($row  =  mysql_fetch_row($result)) {
$IS=$row[0];
$IN=$row[1];
$ID=$row[2];
$IC=$row[3];
$Ca=$row[4];
$SC=$row[5];
$II=$row[6];
fontFace("Arial","<table align='center' width='70%' border='0' cellspacing='0' cellpadding='0' bgcolor='#CCCCCC'><tr><td width='100%'>
<table width='100%'>
<tr>
<td align='left' width='20%'><a href='$Relative/description.php?II=$II&UID=$UID'><img border='0' src='$Relative/images/$II.jpg' width='75'></a>
</td>

<td valign='bottom' align='left' valign='center' width='60%'>&nbsp&nbsp&nbsp&nbsp<b><font color='#FF0000'>$IN</font></b> <font color='#FF0000'> - $$IC
</td>

<td width='20%' align='right'><a href='$Relative/description.php?II=$II&UID=$UID'><img border='0' src='$Relative/images/buy.gif'></a></font>
</td>

</tr>
</table>
</td>
</tr>
</table>
</P>");
if ($ID != "") {

fontFace("Arial",""); }
echo "";

}

if ($zur != TRUE) echo '<a href="'.$PHP_SELF.'?CA='.$CA.'&offset='.($offset-$step) . '&UID='.$UID.' ">Back </a>  '; 
for ($i=1;$i<=(int)ceil($anz/$step);$i++) echo '<a href="'.$PHP_SELF.'?CA='.$CA.'&offset='.(($i-1)*$step). '&UID='.$UID. '" > '.$i.'</a>  '; 

if ($vor != TRUE) echo '<a href="'.$PHP_SELF.'?CA='.$CA.'&offset='.($offset+$step). '&UID='.$UID.'">next</a>';

echo "</table>";

?>

cralyn

Hi,
The coding is great. Thanks.

There is one problem however. The pages get broken into list of 10 but it only shows the same first 10 products on every products.

I have attached a breakdown of the abbreviations used for my database.
$IS=$row[0]; //Item SKU
$IN=$row[1]; //Item Name
$ID=$row[2]; //Item Description
$IC=$row[3]; //Item Cost
$Ca=$row[4]; //Category
$SC=$row[5]; //Shipping Cost
$II=$row[6]; //Item ID - Auto Increment

Thanks again for any help i receive.
Regards
Craig

bernouli

i dont understand your problem so much , can i see your page online?

cralyn

The URL is http://www.kidzsquare.com
Click on the "clothing for girls" link.

The pages all have the same 10 products on them.
Thanks
Craig

bernouli

i think we have problem with the codes, i have edit the code above, try it first, i'll look for other wrong codes.

i see there is no "Back" url, but it can't be, and the offset is always the same one, do you use the newest php?
then you'll have to change $offset = HTTP_POST_VARS['offset]

cralyn

Everything is working fine. Thanks for your help.

cralyn

Hi,

I have got the code working perfectly now. Is there a way to show the current page number in the same code without a link and in Bold format?

EG:
Back 1 2 3 4 5 6 Next

jmcneese

if($page == $pg) {
    $pagebits .= "<b>$pg</b>&nbsp;";
} else {
    $pagebits .= "<a href=\"$PHP_SELF?page=$pg\">$pg</a>&nbsp;";
}

cralyn

How do i integrate the pagebits code with the following code?

<?
require("Cart.php");
DBinfo();
Brand();
Root();
mysql_connect("$DBHost","$DBUser","$DBPass");

if ($UID != "") {
$result=mysql( "$DBName", "SELECT * FROM Users WHERE User='$UID'");
$num=mysql_num_rows($result);
if ($num == "0") {
$dt=date( "YmdHis");
$UID= "$dt$REMOTE_ADDR";
$date=date( "z");
mysql( "$DBName", "INSERT INTO Users VALUES ('$UID','$date')");
Header( "Location: $PHP_SELF?CA=$CA&UID=$UID");
}
}

if ($UID == "") {
$dt=date( "YmdHis");
$UID= "$dt$REMOTE_ADDR";
$date=date( "z");
mysql( "$DBName", "INSERT INTO Users VALUES ('$UID','$date')");
Header( "Location: $PHP_SELF?CA=$CA&UID=$UID");
}
echo"<body link=\"#FF0000\" vlink=\"#FF0000\" alink=\"#FF0000\">";

commonHeader("$Company","Select an item");

$step = $diff = 5;
$tmp = 0;
$r = mysql_query("SELECT count(*) FROM Items WHERE Category='$CA' ") or die(mysql_error());

$anz = mysql_result($r,0);
if ($offset+$diff>=$anz) {
$diff = $anz - $offset;
$vor = TRUE;
}

if (!$offset || $offset<0) {
$offset = 0;
$zur = TRUE;
$id = "0";
}

$result=mysql("$DBName","SELECT * FROM Items WHERE Category='$CA' ORDER BY ItemName LIMIT $offset,$diff");
fontFace("Arial","<B>Select an item:<br><br>");
echo "<table align='center'>";
while ($row = mysql_fetch_row($result)) {
$IS=$row[0];
$IN=$row[1];
$ID=$row[2];
$IC=$row[3];
$Ca=$row[4];
$SC=$row[5];
$II=$row[6];
fontFace("Arial","<table align='center' width='70%' border='0' cellspacing='0' cellpadding='0' bgcolor='#CCCCCC'><tr><td width='100%'>
<table width='100%'>
<tr>
<td align='left' width='20%'><a href='$Relative/description.php?II=$II&UID=$UID'><img border='0' src='$Relative/images/$II.jpg' width='75'></a>
</td>

</tr>
</table>
</td>
</tr>
</table>
</P>");
if ($ID != "") {

fontFace("Arial",""); }
echo "";

}
echo "<center><font size=\"2\">";
if ($zur != TRUE) echo '<center><a href="'.$PHP_SELF.'?CA='.$CA.'&offset='.($offset-$step) . '&UID='.$UID.'" style=\"color: #FF0000; font-family: Arial; font-weight: bold\">Back</a> ';
for ($i=1;$i<=(int)ceil($anz/$step);$i++) echo '<a href="'.$PHP_SELF.'?CA='.$CA.'&offset='.(($i-1)*$step). '&UID='.$UID. '" > '.$i.'</a> ';

if ($vor != TRUE) echo '<a href="'.$PHP_SELF.'?CA='.$CA.'&offset='.($offset+$step). '&UID='.$UID.'" >Next</a>';

echo "</font></table>";

bernouli

<?
require("Cart.php");
DBinfo();
Brand();
Root();
mysql_connect("$DBHost","$DBUser","$DBPass");

if ($UID !="") {
$result=mysql( "$DBName", "SELECT * FROM Users WHERE User='$UID'");
$num=mysql_num_rows($result);
if ($num == "0") {
$dt=date( "YmdHis");
$UID= "$dt$REMOTE_ADDR";
$date=date( "z");
mysql( "$DBName", "INSERT INTO Users VALUES ('$UID','$date')");
Header( "Location: $PHP_SELF?CA=$CA&UID=$UID");
}
}

commonHeader("$Company","Select an item");

$step = $diff = 5;

if(!isset($pg)) $pg=1;
$nxt=$bck=$pg;

$r = mysql_query("SELECT count(*) FROM Items WHERE Category='$CA' ") or die(mysql_error());

$anz = mysql_result($r,0);
if ($offset+$diff>=$anz) {
$diff = $anz - $offset;
$vor = TRUE;
}

if (!$offset || $offset<0) {
$offset = 0;
$zur = TRUE;
$id = "0";
}

</tr>
</table>
</td>
</tr>
</table>
</P>");
if ($ID != "") {

fontFace("Arial",""); }
echo "";

}
echo "<center><font size=\"2\">";

if ($zur != TRUE) echo '<center><a href="'.$PHP_SELF.'?CA='.$CA.'&offset='.($offset-$step) .'&pg='.--$bck. '&UID='.$UID.'" style=\"color: #FF0000; font-family: Arial; font-weight: bold\">Back</a> ';

for ($i=1;$i<=(int)ceil($anz/$step);$i++) {
if($pg==$i) echo "<b>".$pg."</b>";
else
echo '<a href="'.$PHP_SELF.'?CA='.$CA.'&offset='.(($i-1)*$step). '&pg='.$i.'&UID='.$UID. '" > '.$i.'</a> ';
}

if ($vor != TRUE) echo '<a href="'.$PHP_SELF.'?CA='.$CA.'&offset='.($offset+$step). '&pg='.++$nxt.'&UID='.$UID.'" >Next</a>';

echo "</font></table>";

cralyn

Hi,
The code changes didnt work. I got an error saying there was an unexpected = on line 8

Thanks again for all your help

bernouli

try the code again, ive made changes on line 8

cralyn

Hi,
Im getting the following error.

Parse error: parse error, unexpected $ in /home/kidzsqua/public_html/cart/items.php on line 101

bernouli

try it again

cralyn

hi,
Im still getting the same error message even after the changes.

bernouli

anything must be ok this time

cralyn

You're a LEGEND...its working perfectly.
Thanks again for all the help.
Craig