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. 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 Link to comment https://forums.phpfreaks.com/topic/259546-pagination-and-filter/#findComment-1330446 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.