How do you make pagination with search, sort by, order by and limit work? |
[eluser]Warz[/eluser]
Hi, I'm basically just looking for some tips on how to deal with pagination, the best way to do it... Right now I got this URL: http://localhost/memberbase/index.php/admin/users/index This page is supposed to display a list of all users. I need the following: - Search for username ($_GET search) - Sort by ID, Username, Email, Country, etc. Both ASC and DESC - Option to change amount of users displayed per page This works fine: http://localhost/memberbase/index.php/ad...rs/index/2 I also added support for sort by and order by, which looks like this: http://localhost/memberbase/index.php/ad...rderby/asc http://localhost/memberbase/index.php/ad...derby/desc etc.. Now, is it so, that I really need to do this: http://localhost/memberbase/index.php/ad...earch/john to search for user john? Is it possible to just go http://localhost/memberbase/index.php/ad...earch/john and then later do the sort by, order by and limit? I know this is possible with $_GET however when turning that on I get Quote:An Error Was Encountered All this just seems rather confusing and not very user friendly? Then maybe there is something I didn't know? What is best practise? How do YOU deal with pagination? Thanks! |
Messages In This Thread |
How do you make pagination with search, sort by, order by and limit work? - by El Forum - 05-18-2010, 11:04 AM
How do you make pagination with search, sort by, order by and limit work? - by El Forum - 05-18-2010, 12:07 PM
How do you make pagination with search, sort by, order by and limit work? - by El Forum - 07-20-2011, 12:20 AM
|