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:
$query_limit_WADAProducts = sprintf("%s LIMIT %d, %d", $query_WADAProducts, $startRow_WADAProducts, $maxRows_WADAProducts);
and change it to:
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:
<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.