Questions about Products_Results.php Page in PS3

9/06/2010 11:35 am | #1 pistartech366237

Hi,

I have two questions about Products_Results.php page:

I want to add two options:

1. Show all products for each created category on the same page (instead of showing just 10 products per page (as it is set by default). But only by the request of page visitor. Which means - I want the page to show only 10 results per page, however, add the link "Show All Products", which if clicked, shows all products for the particular category. (I've tried to use the "Display Record Count" server behavior, but it gives me an error that says that the repeat region is locked by the main template and wouldn't let me make any changes).

2. Create the option of showing the products by price range (for example $0-$500, $501- $999, etc.).

Please advise ASAP.

Thank you so much in advance.

Best regards,

Paul.

9/08/2010 8:31 am | #2 Jason ByrnesWebAssist

NOTE: These are not supported modifications, we can explain what you need to do, but cannot offer assistance in actually doing it.

1) to show all records by link, add a link that passes a querystring:

<a href="products_results.php?show=all">show all</a>

then find the following line:

php:

$query_limit_WADAProducts = sprintf("%s LIMIT %d, %d", $query_WADAProducts, $startRow_WADAProducts, $maxRows_WADAProducts);

and change it to:

php:

if(isset($_GET['show']) && $_GET['show'] == 'all'){
    $query_limit_WADAProducts = sprintf("%s", $query_WADAProducts);
}else{
    $query_limit_WADAProducts = sprintf("%s LIMIT %d, %d", $query_WADAProducts, $startRow_WADAProducts, $maxRows_WADAProducts);
}

you will also want to add an if statement around the navigation to hide it if all records are being shown:

php:

<div class="links"><?php if(!isset($_GET['show']) || (isset($_GET['show']) && $_GET['show'] != 'all')) { ?> Products <?php echo ($startRow_WADAProducts + 1) ?> to <?php echo min($startRow_WADAProducts + $maxRows_WADAProducts, $totalRows_WADAProducts) ?> of <?php echo $totalRows_WADAProducts ?>
      <?php if ($pageNum_WADAProducts > 0) { // Show if not first page ?>
        <a href="<?php printf("%s?pageNum_WADAProducts=%d%s", $currentPage, 0, $queryString_WADAProducts); ?>">First</a>
        <?php } // Show if not first page ?>
      <?php if ($pageNum_WADAProducts > 0) { // Show if not first page ?>
        <a href="<?php printf("%s?pageNum_WADAProducts=%d%s", $currentPage, max(0, $pageNum_WADAProducts - 1), $queryString_WADAProducts); ?>">Prev</a>
        <?php } // Show if not first page ?>
      <?php if ($pageNum_WADAProducts < $totalPages_WADAProducts) { // Show if not last page ?>
        <a href="<?php printf("%s?pageNum_WADAProducts=%d%s", $currentPage, min($totalPages_WADAProducts, $pageNum_WADAProducts + 1), $queryString_WADAProducts); ?>">Next</a>
        <?php } // Show if not last page ?>
      <?php if ($pageNum_WADAProducts < $totalPages_WADAProducts) { // Show if not last page ?>
        <a href="<?php printf("%s?pageNum_WADAProducts=%d%s", $currentPage, $totalPages_WADAProducts, $queryString_WADAProducts); ?>">Last</a>
        <?php } // Show if not last page ?><?php } ?>

2) The products results page already supports price pange.

go to the search page. on the search page, you can enter the price range you wish to view.

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Questions about Products_Results.php Page in PS3

9/06/2010 11:35 am | #1 pistartech366237