1 reply to this topic

[lol33d]

hi guys

i want escape string for query

how to this?

in mysql is mysql_real_escape_string

what is this in PDO?

thank you

[Vaielab]

You can either either quote your data

$dbh->quote($string)

when $dbh is your instance of pdo
Or you can prepare your sql

$sth = $dbh->prepare('select * from user where id=:id');

$sth->execute(array(':id' => $id));

This is one way to prepare your sql, in pdo you can prepare it in many way
Here are one of the best tutorial for pdo that I read over the years: PHP Tutorials Examples Introduction to PHP PDO