[RESOLVED] simple previous, next item navigation

[phpforme]

Hi Guys, I'm a newbie. I'm trying to make a simple navigation on a product item page.

Something like this " Previous Item | Next Item"

I googled and couldn't find anything helpful. I am sure it's something pretty simple. I tried this: <a href="/item.php?itemID='.$record['itemID']-1.'">Previous item</a>. It gives me an error.

Any help would be really appreciated. Sorry if this has been already asked by someone else. Thanks so much!!:o

[coldwerturkey]

What is the error?

[phpforme]

It says:
Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING, expecting ',' or ';'

[coldwerturkey]

take a good careful look over your code. afaik it means you've missed a ';' somewhere, typically before line it designates

if you can't find it for whatever reason post the code here and be sure to wrap it in [php][/php] tags

[bradgrafelman]

Can you show us the lines of code around the line number PHP references in the error message? It sounds like you have a reference to an associative array inside a quoted string, but we can't be for sure unless we see the code.

[phpforme]

Hi here's the codes:

$query = " SELECT * FROM product";
$records = sqlGetAllRecords($query);
if (count($records))
{
foreach ($records as $record)
{
echo'<a href="/item.php?itemID='.$record['itemID']-1.'">Previous item</a>';
}
}

What I'm trying to do is to have a navigation on each product page so that the user can go to the next product or previous one.

I also have different categories. My concern is if I use the product ID to navigate, it would also go to the items from different category.

Thanks so much guys for helping me out on this!

[foyer]

The problem with just subtracting 1 number, or adding 1 number from the itemID (assuming, your incrementing id) isn't usually a good idea with Next | Previous buttons.. because what if you or someone deletes an item? Or what if you don't even want to sort these items by ID, maybe by name.

Besides that code you posted will just print Previous Item as many times as you have records in the table.

[phpforme]

True. That's why I need help with creating this navigation. I did find something for navigation for multiple pages (e.g 10 items per page, and if you click next, it goes to page 2). Here's the link to that: http://www.php-mysql-tutorial.com/wikis/php-tutorial/paging-using-php.aspx. I think I can use the same logic or some codes to do what I want to do: to navigate from item to item. But I just don't know how. Can someone please help me to the direction? Thanks

[coldwerturkey]

you may find this useful, to get a grasp on the logic.

[phpforme]

thank you. i'll try that out tonight and let you guys know.

[phpforme]

hey guys that wasn't what i was looking for. i have different product categories and when a user clicks on a category, i display a bunch of products in that category. when a user click on one of those items, i want to display <<previous | next>> navigation to navigate through each record in the same category.

I just don't understand how to carry over the array of items from the same category from the category page to the product individual page (each record page), and then use that array to go over to the previous/next product (record).

Any help would be really really appreciated. I'm just a beginner and this is one hard problem that's been bugging me for weeks.

Here's my code. There's something wrong because for any record, it has $previous = 0 and $next is the last recordID.

if (isset($_GET['productID'])) 
		$productID= $_GET['productID'];
	else 
		$productID = "";

if (isset($_GET['category'])) 
	$category = $_GET['category'];
else 
	$category = "";		

	$query = " SELECT * FROM productTable";
	$query .= " WHERE";
	if(strlen($productID) > 0)
	{
		$query .= " AND productID = " . $productID;
	}
	if(strlen($category) > 0)
	{
		$query .= " AND category= '" . $category . "'";
	}

$count = 0; 
$resultfetch = mysql_query($query);

while($resultfetch_ar = mysql_fetch_assoc($resultfetch))
{ 
	$count = $count +1; 

{ 
	$previous = $count - 2; 
	$nextone = $count; 
	if ($previous > -1) 
	{ 
		$resultfetch = mysql_query($query." LIMIT $previous,1"); 
		$resultfetch_ar = mysql_fetch_assoc($resultfetch); 
		$previousid = $resultfetch_ar['productID'];
		} 
	else
	{ 
		$previousid = 0;
		} 
	$resultfetch = mysql_query($query." LIMIT $nextone,1"); 
	$resultfetch_ar = mysql_fetch_assoc($resultfetch); 
	if (!$resultfetch_ar)
	{ 
		$nextid = 0;

	} 
	else 
	{ 
		$nextid = $resultfetch_ar['productID'];
				} 
}

}

[phpforme]

so I finally figured it out. It wasn't that hard 🙂 I start to like php alot. So anyways here's the solution for previous next record navigation in the same category for the beginners like me. I was almost there. Just had to tweak it a bit and it works.

    if (isset($_GET['productID'])) 
        $productID= $_GET['productID']; 
    else 
        $productID = ""; 

if (isset($_GET['category'])) 
    $category = $_GET['category']; 
else 
    $category = "";         

    $sql = " SELECT * FROM productTable WHERE category= '" . $category. "' ORDER BY productID";

$count = 0; 
$result = mysql_query($sql);
	while($result_ar = mysql_fetch_assoc($result))
	{ 
		$count = $count +1; 
		if ($result_ar["productID"]==$productID) 
		{ 
			$previous = $count - 2; 
			$nextone = $count; 
			if ($previous > -1) { 
			$result = mysql_query($sql." LIMIT $previous,1"); 
			$result_ar = mysql_fetch_assoc($result); 
			$previousid = $result_ar["productID"];
					} 
		else
		{ 
			$previousid = 0; 
					} 
		$result = mysql_query($sql." LIMIT $nextone,1"); 
		$result_ar = mysql_fetch_assoc($result); 
		if (!$result_ar) 
		{ 
			$nextid = 0;
					}
		else
		{ 
			$nextid = $result_ar["productID"];

	} 
} 

Then here's the table to display the nav.

 <table width="98%" border="0" align="center">
  <tr>
   <td width="33%">
      <?php if ($previousid != 0)
	  { 
         echo '<a href="jewelry_item.php?jewelryStone='.$jewelryStone.'&amp;jewelryID='.$previousid.'">Previous</a>';
      } 
	  ?>
   </td>
   <td width="34%">
      <div align="center">View Next/Previous Property </div>
   </td>
   <td width="33%">
      <div align="right">
      <?php if ($nextid != 0) 
	  { 
         echo '<a href="jewelry_item.php?jewelryStone='.$jewelryStone.'&amp;jewelryID='.$nextid.'">Next</a>';
      } 
	  ?>
      </div>
   </td>
  </tr>
</table>

then you have to create another query to get the specific product and use that query to display the item details.

[foyer]

You must at least want to do this:

    if (isset($_GET['category']))
        $category = mysql_real_escape_string($_GET['category']);
    else
        $category = "";

[phpforme]

Thanks. I'll do that.

[foyer]

And of course, the manual to what it does
http://www.php.net/mysql_real_escape_string