changing pagination results with dropdown

[abda53]

to show how many results are shown i use
$limit = 20;

how can i get a dropdown with different options, or ever a text box form where they can put exactly how many they want?

also if there is none selected (like when you first enter the page) where there will still be say 20 shown..

[elementaluk]

simple IF should be the trick.
if(empty($GET['limit']))
{
$limit = 20;
}else{
$limit = $GET['limit'];
}

your probably best using predefined limits as most users are morons that'll put thousands as the limit.

So you'll just need a simple form with a drop-down box using the GET method (so coding is a bit easier on you) but be sure you write an array of predefined limits e.g.

$limits = array("20","40","60","80");
then do a check to see if its in the array, for security.

ok if you make heads or tails of that then it should probably work.

[devinemke]

<form action="<? echo $_SERVER['PHP_SELF'] ?>" method="POST">
select limit: <select name="limit_select">
<option>10
<option>20
<option>30
<option>40
<option>50
</select>
<br>
or enter a limit: <input type="text" name="limit_text"><br>
<input type="submit" name="submit" value="submit">
</form>
<br>
<br>

<?
if (!isset($_POST['submit'])) {$limit = 20;}
else
{
	if ($_POST['limit_text']) {$limit = $_POST['limit_text'];}
	else {$limit = $_POST['limit_select'];}
}

echo 'the current limit is ' . $limit;
?>

[abda53]

devin.. thanks that works great..

how can i make it so that it will stay that value to actually change $limit using the form?

or would i have to make a database change and add it so they will always see $limit as to what they chose..

[devinemke]

simply feed $limit into the LIMIT clause of your select query. to pass the user selected limit on the subsequent page hits you have a few choices:

1. pass $limit as GET variable in hypertext links

2. stick $limit into a hidden form field and use a form to move around the site.

3. use sessions