Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options
 
PerlMonks  

Re^3: how to put links on the bottom of an image gallery

by atemon (Chaplain)
on Aug 27, 2007 at 02:25 UTC ( #635198=note: print w/replies, xml ) Need Help??


in reply to Re^2: how to put links on the bottom of an image gallery
in thread how to put links on the bottom of an image gallery

Hi,

Giving page=15 is a "direct" method by which you can use the argument "page" directly with LIMIT. If you are passing pages as 0, 1, 2, 3 you can multiply it with 15. If its starting with 1, multiply page-1 with 15. Your perl script may look like

my $q = new CGI; my $page = $q->param("page") || '0'; #default 0 my $count = $q->param("count") || 15; # more flexibility. you can pa +ss the No of records as count :), defaults to 15 $offset = $page * count; # assumes that page no starts with 0. #$offset = ($page-1) * count; # assumes that page no starts with 1. Co +mment previous line and uncomment this if you wish to start page from + 1 $SQL = "SELECT * FROM your_table ORDER BY id LIMIT $offset, $count"; ... <rest of your code> ...
Hope this helps :)

Cheers !

--VC



There are three sides to any argument.....
your side, my side and the right side.

Replies are listed 'Best First'.
Re^4: how to put links on the bottom of an image gallery
by misc (Friar) on Aug 27, 2007 at 10:08 UTC
    I'd also test that the arguments page/count/whatever don't contain any sql injections.
    e.g. if $count in this command "SELECT * FROM your_table ORDER BY id LIMIT $offset, $count";
    would contain "15; update users set password='hacked';" both statements will be executed:
    "SELECT * FROM your_table ORDER BY id LIMIT 0, 15; update users set password='hacked';"

    Since both count and offset should be numerical I'd do something like $count =~ s/\D*//g
    This will remove any nondigit character.

    michael

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://635198]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others browsing the Monastery: (1)
As of 2022-01-18 02:42 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    In 2022, my preferred method to securely store passwords is:












    Results (52 votes). Check out past polls.

    Notices?