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. 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. 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 ! Link to comment https://forums.phpfreaks.com/topic/204153-databinding-to-multiple-pages/#findComment-1069289 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.