News for hackers. Stuff that matters.
Re:Innovative way to combat SQL injection by seven on Thursday May 13, 2010 @04:36PM (#1345572)
Actually this is common old fashioned industry standard:

http://thedailywtf.com/Articles/Injection_Rejection.aspx

We where laughing our asses of. My name and the name of the other in-house guy, both contain an 'and'. Just our boss, could login and had no problem. :)

Re:Innovative way to combat SQL injection by petercooper on Thursday May 13, 2010 @06:27PM (#1345915)
Except, the bad code as shown requires whitespace (\s) before and after the "bad" terms, so the names the Daily WTF post mentions should pass through it.

  if (preg_match('/\s['.implode('|',$badSqlCode).']+\s/i', $sqlcode))
They probably didn't realize this wouldn't catch any of the bad terms at the very start or end of their code, though :-)