191 reputation
4
bio website 127.0.0.1
location Richmond, VA
age 37
visits member for 2 years, 2 months
seen yesterday
stats profile views 6

OK, i have to rant for a second. Why is it that of the thousands of posts of PHP/MySQL advice on SO, about 99.5% are still using mysql_query -- and about half of those could be the poster child for SQL injection?

It's really not that hard, y'all...

$db = new PDO(...);
$stmt = $db->prepare('
    SELECT some_stuff
    FROM some_table
    WHERE some_field = ?
');
$stmt->execute(array('some value'));

while ($row = $stmt->fetch())
{
     ...
}

I don't want to have to start calling people out on it, but seriously, prepared statements aren't just safer, they're freaking easier. Learn them or quit calling yourself a PHP programmer.


This user has not asked any questions
Stack Overflow Stack Overflow 34,586 rep 63980
Meta Stack Overflow Meta Stack Overflow 1,361 rep 416
Code Review Stack Exchange Code Review 1,121 rep 39
Programmers Stack Exchange Programmers 582 rep 39
Super User Super User 534 rep 27

1 Vote Cast

all time   by type  
1 up 0 question
0 down 1 answer