467,098 Members | 1,148 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,098 developers. It's quick & easy.

Creating a Record list with Prev / Next ability

How do I create an html list using php and mysql that also has the
previous and next funtionality.
Mar 13 '08 #1
  • viewed: 1696
Share:
7 Replies
wqmmnm wrote:
How do I create an html list using php and mysql that also has the
previous and next funtionality.
You need to determine how many items are in the list and remember where
you are in the list.

The list comes from somewhere - i.e. a database, flat file, etc. You
can determine from that how many items are in the list. Start with the
current position as 0 and keep track of it (i.e. in a session variable).

When they press next, increment the current position until you reach the
end of the list. If they press prev, decrement the current position
until you reach the beginning of the list. Then display the item at
that position in the list.

If you're displaying multiple items on a page, the current position
becomes the page number and you just need to account for the fact you
have 8 (or however many) items per page instead of 1.

From your question, it's hard to give you any more specific information.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

Mar 13 '08 #2
wqmmnm wrote:
How do I create an html list using php and mysql that also has the
previous and next funtionality.
What like this? http://www.greenhithe.org.uk/php/allfr_a.php

If so I can give you the code.

Paul
--
Add an underscore after the p to reply
Mar 13 '08 #3
On Mar 13, 9:28*am, Jerry Stuckle <jstuck...@attglobal.netwrote:
wqmmnm wrote:
How do I create an html list using *php and mysql that also has the
previous and next funtionality.

You need to determine how many items are in the list and remember where
you are in the list.

The list comes from somewhere - i.e. a database, flat file, etc. *You
can determine from that how many items are in the list. *Start with the
current position as 0 and keep track of it (i.e. in a session variable).

When they press next, increment the current position until you reach the
end of the list. *If they press prev, decrement the current position
until you reach the beginning of the list. *Then display the item at
that position in the list.

If you're displaying multiple items on a page, the current position
becomes the page number and you just need to account for the fact you
have 8 (or however many) items per page instead of 1.

*From your question, it's hard to give you any more specific information..

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstuck...@attglobal.net
==================
Okay how do I keep track of the records that I am on after I hit next
or previous links. Do I use a hidden variable and just capture it use
GET or POST methods. My biggest things is how do you keep track of
what record you are on now to determine what the next records should
be.

Thanks,

Walter Q. Mason III
Mar 14 '08 #4
On Mar 13, 5:45 am, wqmmnm <wqm...@gmail.comwrote:
How do I create an html list using php and mysql that also has the
previous and next funtionality.
I had the same issue to solve.

PEAR/Pager

Works like dream! The NEXT/PREVIOUS needs a little "help" to look like
i want, but that's a minor details.

And here's a great example/tutorial on how to use it!

http://devzone.zend.com/article/2418...ith-PEAR-Pager

Walter
Mar 14 '08 #5
wqmmnm a écrit :
Okay how do I keep track of the records that I am on after I hit next
or previous links. Do I use a hidden variable and just capture it use
GET or POST methods.
A simple $start using GET is enough. Your script includes the number of
items (or it also can be a GET variable), you display X items from
$start, next page is $start + x, previous is $start - x, check for the
max value (and don't display next), check for the min value (if $start =
0 - and don't display previous)

--
Guillaume
Mar 14 '08 #6
wqmmnm wrote:
On Mar 13, 9:28 am, Jerry Stuckle <jstuck...@attglobal.netwrote:
>wqmmnm wrote:
>>How do I create an html list using php and mysql that also has the
previous and next funtionality.
You need to determine how many items are in the list and remember where
you are in the list.

The list comes from somewhere - i.e. a database, flat file, etc. You
can determine from that how many items are in the list. Start with the
current position as 0 and keep track of it (i.e. in a session variable).

When they press next, increment the current position until you reach the
end of the list. If they press prev, decrement the current position
until you reach the beginning of the list. Then display the item at
that position in the list.

If you're displaying multiple items on a page, the current position
becomes the page number and you just need to account for the fact you
have 8 (or however many) items per page instead of 1.

From your question, it's hard to give you any more specific information.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstuck...@attglobal.net
==================

Okay how do I keep track of the records that I am on after I hit next
or previous links. Do I use a hidden variable and just capture it use
GET or POST methods. My biggest things is how do you keep track of
what record you are on now to determine what the next records should
be.

Thanks,

Walter Q. Mason III
You could use hidden either hidden or session variables or a cookie.
For something like this, I'd probably just use a hidden variable, but
any of them will work.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

Mar 14 '08 #7
wqmmnm wrote:
How do I create an html list using php and mysql that also has the
previous and next funtionality.
http://www.allsyntax.com/tutorials/P...with-PHP/1.php

Found this while looking for good newbie tutorials.

Paul
--
Add an underscore after the p to reply
Mar 17 '08 #8

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

8 posts views Thread by AR John | last post: by
23 posts views Thread by Fuzzyman | last post: by
7 posts views Thread by chirag | last post: by
1 post views Thread by saturnius | last post: by
6 posts views Thread by Patrick Coghlan | last post: by
1 post views Thread by Stanley | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.