Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister
 
PerlMonks  

Re: DBI & MySQL Login Test

by Your Mother (Chancellor)
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
Replies are listed 'Best First'.
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 rifling through the Monastery: (12)
As of 2015-07-08 05:08 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (94 votes), past polls