Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number

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?

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

How do I use this? | Other CB clients
Other Users?
Others cooling their heels in the Monastery: (3)
As of 2015-11-28 03:06 GMT
Find Nodes?
    Voting Booth?

    What would be the most significant thing to happen if a rope (or wire) tied the Earth and the Moon together?

    Results (737 votes), past polls