Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
PerlMonks  

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

by misc (Pilgrim)
on Aug 27, 2007 at 10:08 UTC ( #635262=note: print w/replies, xml ) Need Help??


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

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
Node Status?
node history
Node Type: note [id://635262]
help
Chatterbox?
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (7)
As of 2017-11-20 04:03 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    In order to be able to say "I know Perl", you must have:













    Results (284 votes). Check out past polls.

    Notices?