Anatomy of a SQL Injection Attack

Trailrunner7 writes "SQL injection has become perhaps the most widely used technique for compromising Web applications, thanks to both its relative simplicity and high success rate. It's not often that outsiders get a look at the way these attacks work, but a well-known researcher is providing just that. Rafal Los showed a skeptical group of executives just how quickly he could compromise one of their sites using SQL injection, and in the process found that the site had already been hacked and was serving the Zeus Trojan to visitors." Los's original blog post has more and better illustrations, too.

A cautionary tale' OR 1=1

[kyz]

...for these modern times.

Obligatory xkcd

[tangent3]

http://xkcd.com/327/ [xkcd.com]

Re:Obligatory xkcd

[Inda]

Oh, oh, oh, please let it be Bobby DropTables, please, please.

Re:Obligatory xkcd

[Anonymous Coward]

Select TOP 1 as bestever from t_XKCD where id = thisone

Slash Dot Virus Sequel Injected in You

[h00manist]

You can't stop reading slashdot. Full of nonsensensical arguments, but you read on, your brain oozes, your eyes are red, dry and hurt. Still, you read on, and participate in the debate. You don't recognize your odd behavior. There's a sequel reply injected into your brain. It's a slash dot sequel brain virus injection. There's no cleaning utility, you will need to reformat your brain.

Re:Lemme be the first to say

[pooh666]

I remember that Perl was not too good for web programming. It was unstable in a sense that variables sometimes got strange values inexplicably.

Perhaps less(or more) drinking would help?

Re:Use a persistence library

[TheSunborn]

IT's very simple. Don't use any of the mysql_* functions.

Use the PDO prepare function (http://dk2.php.net/manual/en/pdo.prepare.php) and remember newer to pass any input you got from the user directly into the string you give to prepare.

In most cases(99%) the string you give to the prepare function should really be constant and not depend on user input at all.

Re:Obligatory xkcd

[Anonymous Coward]

You win.