Sign In | Register Now About Bytes | Help | Site Map
Connecting Tech Pros Worldwide

Creating a Record list with Prev / Next ability

Question posted by: wqmmnm (Guest) on March 13th, 2008 05:55 AM
How do I create an html list using php and mysql that also has the
previous and next funtionality.
Jerry Stuckle's Avatar
Jerry Stuckle
Guest
n/a Posts
March 13th, 2008
12:35 PM
#2

Re: Creating a Record list with Prev / Next ability
wqmmnm wrote:
Quote:
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.
Join Bytes!
==================


PaulB's Avatar
PaulB
Guest
n/a Posts
March 13th, 2008
01:55 PM
#3

Re: Creating a Record list with Prev / Next ability
wqmmnm wrote:
Quote:
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



wqmmnm's Avatar
wqmmnm
Guest
n/a Posts
March 14th, 2008
02:55 AM
#4

Re: Creating a Record list with Prev / Next ability
On Mar 13, 9:28*am, Jerry Stuckle <jstuck...@attglobal.netwrote:
Quote:
wqmmnm wrote:
Quote:
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

otrWalter@gmail.com's Avatar
otrWalter@gmail.com
Guest
n/a Posts
March 14th, 2008
07:35 AM
#5

Re: Creating a Record list with Prev / Next ability
On Mar 13, 5:45 am, wqmmnm <wqm...@gmail.comwrote:
Quote:
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/241...With-PEAR-Pager

Walter

Guillaume's Avatar
Guillaume
Guest
n/a Posts
March 14th, 2008
09:25 AM
#6

Re: Creating a Record list with Prev / Next ability
wqmmnm a écrit :
Quote:
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

Jerry Stuckle's Avatar
Jerry Stuckle
Guest
n/a Posts
March 14th, 2008
10:55 AM
#7

Re: Creating a Record list with Prev / Next ability
wqmmnm wrote:
Quote:
On Mar 13, 9:28 am, Jerry Stuckle <jstuck...@attglobal.netwrote:
Quote:
>wqmmnm wrote:
Quote:
>>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.
Join Bytes!
==================


PaulB's Avatar
PaulB
Guest
n/a Posts
March 17th, 2008
05:35 PM
#8

Re: Creating a Record list with Prev / Next ability
wqmmnm wrote:
Quote:
How do I create an html list using php and mysql that also has the
previous and next funtionality.


http://www.allsyntax.com/tutorials/...-with-PHP/1.php

Found this while looking for good newbie tutorials.

Paul
--
Add an underscore after the p to reply



 
Not the answer you were looking for? Post your question . . .
189,815 Experts ready to help you find a solution.
Sign up for a free account, or Login (if you're already a member).

Latest Articles: Read & Comment
  • Didn't find the answer you were looking for?
    Post Your Question
  • Top Community Contributors