view all plus pagination?

[samoht]

hello again,

 

i have a online store that has about 2800+ products  - on my productList.php pages I have a few variables to display the number of products per page:

<?php
$productsPerRow = 3;
$productsPerPage = 27;

my boss would like a view all button that sets $productsPerPage to the total number of products  - and is active for as long as the SESSION (Perhaps unless the button is clicked again?)

 

Any Ideas on the best approach to accomplish this??

 

thanks

[cooldude832]

I'd assume your query is like

<?php
$q = "Select Fields from `table Where This=that";
$q .= " Limit ".$stat." , ".$end;
?>

If that is the case and you want to have a bool var saying pagination on/off just add some if logic like

 

<?php
$q = "Select Fields from `table Where This=that";
if($pagination == 1){
$q .= " Limit ".$stat." , ".$end;
}
?>

and you set $pagination based on a variable sent by the user via get or how ever you like.

 

Do the same on all other elements that are pagination.

 

This is also assuming your output is generated in a

while($row = mysql_fetch_array($r)){

 

sort of fashion

[samoht]

Thanks for the reply,

 

could you help further with the bool idea?

 

I have a input button

<input type="submit" id="viewall" name="viewall" value="View All">

do I need to toggle between 1 and 0 on click?

[cooldude832]

not on click no submit.

[samoht]

so then just a button?

<input type="button" id="viewall" name="viewall" value="View All">

 

then

<?php
$pagging = isset($_GET['viewall'])
if($pagging == 1){
$result     = dbQuery(getPagingQuery($sql, $productsPerPage));
$pagingLink = getPagingLink($sql, $productsPerPage, "g=$cgId&c=$catId");
}else{
$result = dbQuery($sql);
}
[code]

[/code]