Creating a Record list with Prev / Next ability

[wqmmnm]

How do I create an html list using php and mysql that also has the
previous and next funtionality.

[Jerry Stuckle]

Re: Creating a Record list with Prev / Next ability

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.
jstucklex@attgl obal.net
=============== ===

[PaulB]

Re: Creating a Record list with Prev / Next ability

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

[wqmmnm]

Re: Creating a Record list with Prev / Next ability

On Mar 13, 9:28 am, Jerry Stuckle <jstuck...@attg lobal.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...@attgl obal.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]

Re: Creating a Record list with Prev / Next ability

On Mar 13, 5:45 am, wqmmnm <wqm...@gmail.c omwrote:

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-Paging-Data-Sets-With-PEAR-Pager

Walter

[Guillaume]

Re: Creating a Record list with Prev / Next ability

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

[Jerry Stuckle]

Re: Creating a Record list with Prev / Next ability

wqmmnm wrote:

On Mar 13, 9:28 am, Jerry Stuckle <jstuck...@attg lobal.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...@attg lobal.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.
jstucklex@attgl obal.net
=============== ===

[PaulB]

Re: Creating a Record list with Prev / Next ability

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/PHP/23/Pagination-with-PHP/1.php

Found this while looking for good newbie tutorials.

Paul
--
Add an underscore after the p to reply