soycharliente Posted December 18, 2008 Share Posted December 18, 2008 Does anyone know a good tutorial to apply sorting to pagination? I don't know the best way to handle it. (Using post, get, sessions, etc.) Thanks. Quote Link to comment https://forums.phpfreaks.com/topic/137556-sorting-with-pagination/ Share on other sites More sharing options...
premiso Posted December 18, 2008 Share Posted December 18, 2008 What I do is have a drop down with "sort by" option, on change I do a post to the same change and set a session variable $_SESSION['sortby'] then add that the end of the query using the ORDER BY statement. That seems to be the easiest and does not require a whole lot of code change, so if select option = 1 "ORDER BY date_added" etc... Quote Link to comment https://forums.phpfreaks.com/topic/137556-sorting-with-pagination/#findComment-718927 Share on other sites More sharing options...
.josh Posted December 18, 2008 Share Posted December 18, 2008 Just change your column name in your tabulated data into a link that passes the column's name using the GET method, and sort by that. . . . $sortby = $_GET['sortby']; . . . $sql = "select blahblahblah sortby $sortby"; . . . echo "<a href='wherever.php?sortby=column'>column</a>"; Quote Link to comment https://forums.phpfreaks.com/topic/137556-sorting-with-pagination/#findComment-718941 Share on other sites More sharing options...
soycharliente Posted December 19, 2008 Author Share Posted December 19, 2008 What I do is have a drop down with "sort by" option, on change I do a post to the same change and set a session variable $_SESSION['sortby'] then add that the end of the query using the ORDER BY statement. That seems to be the easiest and does not require a whole lot of code change, so if select option = 1 "ORDER BY date_added" etc... What happens if it's empty? Quote Link to comment https://forums.phpfreaks.com/topic/137556-sorting-with-pagination/#findComment-719736 Share on other sites More sharing options...
soycharliente Posted December 19, 2008 Author Share Posted December 19, 2008 Just change your column name in your tabulated data into a link that passes the column's name using the GET method, and sort by that. I don't have tabular data. I'm spitting out what's basically threads similar to a forum (except people can't reply). It's a page that lists announcements to a group of people. I want them to be able to sort by date, author, etc. Quote Link to comment https://forums.phpfreaks.com/topic/137556-sorting-with-pagination/#findComment-719737 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.