|
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.
(written 2010-02-11)
Associated topics are indexed under H308 - PHP - Searches, and search engines [3163] Twitter - the special use of @ # and http: in tweets - (2011-02-09) [3159] Returning multiple values from a function call in various languages - a comparison - (2011-02-06) [2166] Crossrefering documents with uniqueness and inconsistency issues - PHP proof of concept demo - (2009-05-10) [2137] Reaching the right people with your web site - (2009-04-23) [1735] Finding words and work boundaries (MySQL, Perl, PHP) - (2008-08-03) [1020] Parallel processing in PHP - (2007-01-03)
Some other Articles
A PHP example that lets your users edit content without HTML knowledgeLondon to and from Melksham by public transportWhy do I teach niche skills rather than mainstream?Shipping a test harness with your class in PHPHow to show a large result set page by page in PHPStatic variables and ampersands in PHPCurly braces within double quoted strings in PHPAn example of an injection attack using JavascriptSaturdays out from Melksham - to Oxford, to Didcot or to SwindonOn Malachite Green
|
3603 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 at 50 posts per page
This is a page archived from The Horse's Mouth at
http://www.wellho.net/horse/ -
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).
|
|