Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot
 
PerlMonks  

Re: DBI & MySQL Login Test

by Your Mother (Canon)
on Aug 25, 2009 at 03:55 UTC ( #790969=note: print w/ replies, xml ) Need Help??


in reply to DBI & MySQL Login Test

I can help you learn a painful lesson. Make this your next username: Robert'); DROP TABLE Users; --.

The actual problem in your code is the single quotes. They make the $ literal so the variable is not interpolated. Next to address the bigger problem with little Bobby Tables above, read the stuff on placeholders in the DBI docs. You should *never* do SQL like your example. The docs, and any number of nodes here, will explain why in detail.


Comment on Re: DBI & MySQL Login Test
Download Code
Re^2: DBI & MySQL Login Test
by quester (Vicar) on Aug 25, 2009 at 10:40 UTC

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others lurking in the Monastery: (3)
As of 2014-09-22 23:22 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How do you remember the number of days in each month?











    Results (208 votes), past polls