How to show a large result set page by page in PHP
One of the major requirements on dynamic web pages is for them to present selected results from a data set.
If the results will nicely fit on one page, that's good - but if there are too many for a single page they should be offered page by page, with links to move forward and back, and to the beginning and end. Where there are a very large number of results, even a list of page numbers to link to can be excessive and there should be a mechanism for adding "..." over sections of the page list.
And if there are no results at all, it's useful to the user of your page to suggest to him/her "did you mean" and offer the closest alternative(s).
Taking a simple but long data file as my source, I wrote a demonstration of such a system on Tuesday - the well commented source code is [here]
and you can try it out [here]
. Try it out with "on", "ington", "o" and "Hoxham" to see the various results. If you want to learn how to write things like this for yourself, our PHP Technology Workshop
covers this sort of thing very fully.
Associated topics are indexed as below, or enter http://melksh.am/nnnn for individual articlesH308 - PHP - Searches, and search engines 
Twitter - the special use of @ # and http: in tweets - (2011-02-09) 
Returning multiple values from a function call in various languages - a comparison - (2011-02-06) 
Crossrefering documents with uniqueness and inconsistency issues - PHP proof of concept demo - (2009-05-10) 
Reaching the right people with your web site - (2009-04-23) 
Finding words and work boundaries (MySQL, Perl, PHP) - (2008-08-03) 
Parallel processing in PHP - (2007-01-03)
Some other Articles
4206 posts, page by page
Link to page ... 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85 at 50 posts per page
This is a page archived from The Horse's Mouth at
the diary and writings of Graham Ellis.
Every attempt was made to provide current information at the time the
page was written, but things do move forward in our business - new software
releases, price changes, new techniques. Please check back via
our main site for current courses,
prices, versions, etc - any mention of a price in "The Horse's Mouth"
cannot be taken as an offer to supply at that price.
Link to Ezine home page (for reading).
Link to Blogging home page (to add comments).