RE: [PHP-DB] Re: Page counter from a query ?
not to belabour this topicbut, that i know. i was just curious as to why that class is written like that still? it seems that if PEAR does this for you(extract), that _may_ be a security concern for those that are not being security concious. Not that i'm saying, or know, that PEAR does this...but was hte reason for my post. "Gary Every" <[EMAIL PROTECTED]To: <[EMAIL PROTECTED]>, "pete M" <[EMAIL PROTECTED]> inment.com> cc: <[EMAIL PROTECTED]> Subject: RE: [PHP-DB] Re: Page counter from a query ? 11/04/2003 10:48 AM Just do an extract on your $_GET var (if security concerns are negligible) Say you get line is: ?sid=123&form=12 // Execute this extract($_GET) // You end up with: $sid == "123"; $form == "12"; Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 "Pay It Forward" mailto:[EMAIL PROTECTED] http://accessingram.com > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Tuesday, November 04, 2003 9:01 AM > To: pete M > Cc: [EMAIL PROTECTED] > Subject: Re: [PHP-DB] Re: Page counter from a query ? > > > > question/comment... > > i don't use PEAR currently. but i noticed this class expects > register_globals=on and would therefore not to work on my system. > > Or does another parent class take care of the translation > between $form and > $_GET['form']? > > > Jeff > > > > > > > > pete M > > > <[EMAIL PROTECTED]To: > [EMAIL PROTECTED] > > >cc: > > >Subject: > [PHP-DB] Re: Page counter from a query ? > > 11/04/2003 09:53 > > > AM > > > > > > > > > > > > > I use PEAR db to make my life easy.. > here's their pager class > http://vulcanonet.com/soft/index.php?pack=pager > > > pete > > Larry Sandwick wrote: > > Is there a way to limit the number of pictures being display from a > > query? > > > > > > > > Example. > > > > > > > > Let say I have 100 pictures and I would like to display only 20. How > > would I put the numbers at the bottom of the page? > > > > > > > > 1 2 3 4 5 > > > > > > > > When you click on 1 you get 1 - 20, and when you click on 2 > you get 21 - > > 40. I believe I can use the limit command for the query, I > just do not > > understand how to put the query on the number. > > > > > > > > Any help would greatly be appreciated!!! > > > > > > > > TIA > > > > > > > > > > > > Larry Sandwick > > > > Sarreid, Ltd. > > > > Network/System Administrator > > > > phone: (252) 291-1414 x223 > > > > fax : (252) 237-1592 > > > > > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Re: Page counter from a query ?
Just do an extract on your $_GET var (if security concerns are negligible) Say you get line is: ?sid=123&form=12 // Execute this extract($_GET) // You end up with: $sid == "123"; $form == "12"; Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 "Pay It Forward" mailto:[EMAIL PROTECTED] http://accessingram.com > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Tuesday, November 04, 2003 9:01 AM > To: pete M > Cc: [EMAIL PROTECTED] > Subject: Re: [PHP-DB] Re: Page counter from a query ? > > > > question/comment... > > i don't use PEAR currently. but i noticed this class expects > register_globals=on and would therefore not to work on my system. > > Or does another parent class take care of the translation > between $form and > $_GET['form']? > > > Jeff > > > > > > > > pete M > > > <[EMAIL PROTECTED]To: > [EMAIL PROTECTED] > > >cc: > > >Subject: > [PHP-DB] Re: Page counter from a query ? > > 11/04/2003 09:53 > > > AM > > > > > > > > > > > > > I use PEAR db to make my life easy.. > here's their pager class > http://vulcanonet.com/soft/index.php?pack=pager > > > pete > > Larry Sandwick wrote: > > Is there a way to limit the number of pictures being display from a > > query? > > > > > > > > Example. > > > > > > > > Let say I have 100 pictures and I would like to display only 20. How > > would I put the numbers at the bottom of the page? > > > > > > > > 1 2 3 4 5 > > > > > > > > When you click on 1 you get 1 - 20, and when you click on 2 > you get 21 - > > 40. I believe I can use the limit command for the query, I > just do not > > understand how to put the query on the number. > > > > > > > > Any help would greatly be appreciated!!! > > > > > > > > TIA > > > > > > > > > > > > Larry Sandwick > > > > Sarreid, Ltd. > > > > Network/System Administrator > > > > phone: (252) 291-1414 x223 > > > > fax : (252) 237-1592 > > > > > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: Page counter from a query ?
question/comment... i don't use PEAR currently. but i noticed this class expects register_globals=on and would therefore not to work on my system. Or does another parent class take care of the translation between $form and $_GET['form']? Jeff pete M <[EMAIL PROTECTED]To: [EMAIL PROTECTED] >cc: Subject: [PHP-DB] Re: Page counter from a query ? 11/04/2003 09:53 AM I use PEAR db to make my life easy.. here's their pager class http://vulcanonet.com/soft/index.php?pack=pager pete Larry Sandwick wrote: > Is there a way to limit the number of pictures being display from a > query? > > > > Example. > > > > Let say I have 100 pictures and I would like to display only 20. How > would I put the numbers at the bottom of the page? > > > > 1 2 3 4 5 > > > > When you click on 1 you get 1 - 20, and when you click on 2 you get 21 - > 40. I believe I can use the limit command for the query, I just do not > understand how to put the query on the number. > > > > Any help would greatly be appreciated!!! > > > > TIA > > > > > > Larry Sandwick > > Sarreid, Ltd. > > Network/System Administrator > > phone: (252) 291-1414 x223 > > fax : (252) 237-1592 > > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Page counter from a query ?
and here's a tutorial http://www.phpnoise.com/tutorials/9/1 ;-) Larry Sandwick wrote: Is there a way to limit the number of pictures being display from a query? Example. Let say I have 100 pictures and I would like to display only 20. How would I put the numbers at the bottom of the page? 1 2 3 4 5 When you click on 1 you get 1 - 20, and when you click on 2 you get 21 - 40. I believe I can use the limit command for the query, I just do not understand how to put the query on the number. Any help would greatly be appreciated!!! TIA Larry Sandwick Sarreid, Ltd. Network/System Administrator phone: (252) 291-1414 x223 fax : (252) 237-1592 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Page counter from a query ?
I use PEAR db to make my life easy.. here's their pager class http://vulcanonet.com/soft/index.php?pack=pager pete Larry Sandwick wrote: Is there a way to limit the number of pictures being display from a query? Example. Let say I have 100 pictures and I would like to display only 20. How would I put the numbers at the bottom of the page? 1 2 3 4 5 When you click on 1 you get 1 - 20, and when you click on 2 you get 21 - 40. I believe I can use the limit command for the query, I just do not understand how to put the query on the number. Any help would greatly be appreciated!!! TIA Larry Sandwick Sarreid, Ltd. Network/System Administrator phone: (252) 291-1414 x223 fax : (252) 237-1592 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php