htetnainglynn Posted June 8, 2010 Share Posted June 8, 2010 Hi everyone, I am sure the answer is out there but I just can't figure out the right keyword to search. I hope somebody would shed some light on this. I have like thousands of records in my mysql database and it's pretty much a routine, I wanna retrieve those records and display it using a table on a page using PHP. Obviously, displaying all those thousands of records on the page would probably overwhelm the user. So, I am thinking of break down the entire result into like 100 records per page. So, if I have 1000 returned result from mysql, I might have 10 pages each showing 100 records and a small hyperlink underneath of the table which allows user to hop on to more pages. I have no idea how to make something like that. Would be really appreciate anybody could point me to some sorta tutorial or code snippet. Thanks all. Quote Link to comment https://forums.phpfreaks.com/topic/204153-databinding-to-multiple-pages/ Share on other sites More sharing options...
dabaR Posted June 8, 2010 Share Posted June 8, 2010 Pagination is the word. Quote Link to comment https://forums.phpfreaks.com/topic/204153-databinding-to-multiple-pages/#findComment-1069271 Share on other sites More sharing options...
htetnainglynn Posted June 8, 2010 Author Share Posted June 8, 2010 Thanks. It's indeed what i'm looking for. I have found several and I find this tutorial quite useful. Hope anyone come across the same problem, can solve it out. http://www.tonymarston.net/php-mysql/pagination.html Cheers ! Quote Link to comment https://forums.phpfreaks.com/topic/204153-databinding-to-multiple-pages/#findComment-1069289 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.