Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?
 
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.

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?
[Discipulus]: :=(
[perldigious]: I watched some video on YT awhile back with auto-subtitle on and the speaker had a very thick cockney sort of English accent... hillarity ensued in the subtitles.
[Discipulus]: IHAA=I hate acronyms anyway
LanX LOLs
[perldigious]: If you want a linguistic adventure...

How do I use this? | Other CB clients
Other Users?
Others imbibing at the Monastery: (9)
As of 2017-06-23 16:44 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    How many monitors do you use while coding?















    Results (552 votes). Check out past polls.