Paginate with a dropdown

netfrugal

Currently I am using a tutorial about paginating with the regular page numbers.

How do I change this code to put the pages into a dropdown list?

$total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM log"),0); // Figure out the total number of results in DB:
$total_pages = ceil($total_results / $max_results); // Figure out the total number of pages. Always round up using ceil()

?>
 <center>Select a Page <? // Build Page Number Hyperlinks ?>

<?
// Build Previous Link
if($page > 1){
$prev = ($page - 1);
echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$prev\"><<Previous</a> ";
}

for($i = 1; $i <= $total_pages; $i++){
if(($page) == $i){
echo "$i ";
} else {
echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$i\">$i</a> ";
}
}

// Build Next Link
if($page < $total_pages){
$next = ($page + 1);
echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$next\">Next>></a>";
}
echo "</center>";
?>

Any help would be appreciated!
thanks!

vaaaska

I'm just going on the fly try this...see if you get what you want...

echo "<select name='goto'>\n";

for ($i = 1; $i <= $total_pages; $i++) {

$selected = ($i == $page) ? 'selected' : '';
echo "<option value='$i' $selected>$i</option>\n";

}

echo "</select>\n";

Then make a submit button and let javascript take you away...

netfrugal

Not bad vaaaska!

It placed the numbers into the dropdown box just fine. I will add the submit button now.

thanks!

One last thing. The pagination stops working about I go to the next pages:

http://localhost/paginate.php?page=2

Do the search parameters get lost from the search form on the previous page?

The form on the previous page searches records where ident = $username.

Should I be using $_POST[username] instead of $username?

vaaaska

Possibly.

I recommend validating your data always. Always. $username wasn't really mentioned in the previous post so it's hard to comment upon it. But, you really shouldn't have to pass it that way (use a session or a cookie to work with it).