digi duck Posted March 23, 2012 Share Posted March 23, 2012 Hi. I was hoping someone could tell me whether this is possible and if so how I could go about doing it preferably with a tutorial as im pretty new to programming. I have a database that will contain 100's of records. I want users to be able to select filter parameters on this data by both text and checkboxes with it automatically updating the results (hopefully without page reload). I managed this so far using this Jquery filter script: http://www.picnet.com.au/picnet-table-filter.html. As this will table will have so many rows however I think it would take ages to load so instead I would like to paginate the table but still allow filters applied to affect all records not just the ones displayed on the current page. Any ideas on how i could do this? Thanks in advance for your help. Quote Link to comment https://forums.phpfreaks.com/topic/259546-pagination-and-filter/ Share on other sites More sharing options...
litebearer Posted March 23, 2012 Share Posted March 23, 2012 Start with the mysql WHERE clause http://www.tizag.com/mysqlTutorial/mysqlwhere.php Then pagination http://www.phpfreaks.com/tutorial/basic-pagination Quote Link to comment https://forums.phpfreaks.com/topic/259546-pagination-and-filter/#findComment-1330446 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.