Previous & next buttons

[NeedaCart]

I just need a little guidence, and i think im on the right track, but here goes!

Ive go a website which people can buy jewellery and they can go to a particular category e.g. rings

I thought of putting a previous button and next button simply by adding and subtracing 1 to the product ID but thankfully i realized it wouldnt work before i implemented it.

It would indeed go to the next product, but that product might not be in the same category, or in the same way they were sorted, e.g. price high to low

I was thinking of putting this information into qn array so those buttons would query the array. This sounds good in my head!

i just wanted to know if this was the right method to what i am trying to achieve?

[bpat1434]

Does it do what you want? If so: Yes. If not: No.

I think it would work in your situation; unless you're expecting a lot of results. Then the array can really grow. But if your idea works, go for it.

~Brett

[AIS4U]

NeedaCart:

I am not a PHP expert, but I think if I was going to do something like you are discussing I would create a Search Catalog Page and have one or two select drop-down boxes so the person could choose the kind of item, for example: Rings and then maybe an additional choice as to price range or type, for example, diamond, ruby, etc.

This would of course depend on how you have your database set up. It would need to have fields that broke your items down by type, for example, rings, necklace, bracelet, etc.

I don't know how many items you are talking about, but you could have the search page results show pictures of 10 - 15 items at a time and under the picture you could have a brief description and price. Your customers could then click on the picture for more information or to add the item to their shopping cart.

Sorry, I don't have the PHP code for this just laying around. I know how to do it in ASP, but it shouldn't be that hard in PHP. I think I have a simple search page somewhat like I am talking about that I could zip up and send you, but I don't have the picture display code.

I hope maybe this will give you some good ideas.

Good Luck

[eriksmoen]

here is a code snippet from one that i created and use...

function drawPages($align, $current_page, $num_pages, $limit)
{
    include("globals.php");
    $query = $_GET['query'];
    $desk = $_GET['desk'];
    $desk = ($desk == "ALL")? "%" : $desk;
    echo "<div align='$align' style='color:#888888;'><font face='$fontface' size=2><B>Page ";
    $max = (isset($_GET['m']))? "&m=$_GET[m]" : "";
    $next = ($current_page < $num_pages)? "<a href='?query=$query&page=".($current_page+1)."&desk=$desk' style='text-decoration:none;'>Next »</a>" : "Next »";
    $prev = ($current_page > 1)? "<a href='?query=$query&page=".($current_page-1)."&desk=$desk' style='text-decoration:none;'>« Previous</a>" : "« Previous";
    echo "$current_page of $num_pages &nbsp;&nbsp;&nbsp; $prev | $next ";
    echo "</B></font></div>";
}

and then the caller...

$current_page = (isset($_GET['page']))? $_GET['page'] : "1";
$num_to_split_at = 10;
$db = @mysql_connect($sqlhost,$sqluser,$sqlpass);
@mysql_select_db($sqlserv);
if($desk == "ALL"){ $desk = ""; }
$theQuery = eregi_replace("[ ]","%",$actual_query);
$whereStatement = " `desk` LIKE('%$desk%') AND (`type` LIKE('%$theQuery%') OR `title` LIKE('%$theQuery%') OR `description` LIKE('%$theQuery%'))";
$total_found = @mysql_num_rows(@mysql_query("SELECT * FROM $sqlserv.manual WHERE $whereStatement"));
$num_pages = ceil($total_found / $num_to_split_at);
$stPoint = ($current_page * $num_to_split_at) - $num_to_split_at;
$query = @mysql_query("SELECT * FROM $sqlserv.manual WHERE $whereStatement ORDER BY num_hits DESC, id ASC LIMIT $stPoint,$num_to_split_at;");
if($total_found > 0){ drawPages("right", $current_page, $num_pages, $num_to_split_at); }

[NeedaCart]

thanks everyone for your help.

I just wanted to put the buttons on the page so the user didnt have to go back to the product category and have to retrive all the prooducts from the database, when they just wanted the next one!

One more question though.

Is there any way i can limit that maximum number of characers that are displayed?
Let me try and clear this up.

I have a feild in my database called description with hols the description of the item, which could be a few sentences.

I would want all of that to show when the user clicks on that product but not when there are lets say 20 products in a nicely formatted list. Probably just 150 characters or so.

I hope you understand me!

[eriksmoen]

substr($in_text, 0, 150)