|go ahead... be a heretic|
Browsing a sql table on the webby BerntB (Deacon)
|on May 13, 2006 at 11:54 UTC||Need Help??|
BerntB has asked for the wisdom of the Perl Monks concerning the following question:
I have a standard problem -- browse data stored in sql tables.
The interface is a web browser. There will always be a relevant index on the sql table.
The user should be able to see the first 10-40 items, go forward or backwards in the list, etc. If the user goes for lunch, s/he should be able to just continue a browsing session afterwards. (In sum, just like browsing Questions or Meditations on PM.)
My idea is to make a representation of how far into the table the user was and save that in the Session information. When the user asks for the next/previous page of data, then the program does a new sql request.
Since most web applications has this kind of functionality, I wonder how it is usually implemented? I must have a simpler problem, since I don't need temporary tables with complex search results (I hope).
(Update: Made it a little bit clearer.)