For 2023 - we are now fully retired from IT training. We have made many, many friends over 25 years of teaching about Python, Tcl, Perl, PHP, Lua, Java, C and C++ - and MySQL, Linux and Solaris/SunOS too. Our training notes are now very much out of date, but due to upward compatability most of our examples remain operational and even relevant ad you are welcome to make us if them "as seen" and at your own risk.
Lisa and I (Graham) now live in what was our training centre in Melksham - happy to meet with former delegates here - but do check ahead before coming round. We are far from inactive - rather, enjoying the times that we are retired but still healthy enough in mind and body to be active!
I am also active in many other area and still look after a lot of web sites - you can find an index ((here)) |
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 as below, or enter http://melksh.am/nnnn for individual articles H308 - PHP - Searches, and search engines [1020] Parallel processing in PHP - (2007-01-03) [1735] Finding words and work boundaries (MySQL, Perl, PHP) - (2008-08-03) [2137] Reaching the right people with your web site - (2009-04-23) [2166] Crossrefering documents with uniqueness and inconsistency issues - PHP proof of concept demo - (2009-05-10) [3159] Returning multiple values from a function call in various languages - a comparison - (2011-02-06) [3163] Twitter - the special use of @ # and http: in tweets - (2011-02-09) [4401] Selecting RECENT and POPULAR news and trends for your web site users - (2015-01-19)
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
|
4759 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, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96 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).
|
|