How to bind SQL variables in php?

Question

How to bind SQL variables in php? I want to bind variables instead of just building SQL strings. Anyway, to do this in php?

MySQL or PostgreSQL answers will help.

thanks

Answer 1

There, for example. The PDO .
An introduction to pdo and prepared statements (including related parameters) can be found at http://docs.php.net/pdo.prepared-statements

Answer 2

You should read about the improved MySQL extension (MySQLi) at http://php.net/manual/en/book.mysqli.php and in prepared statements

Answer 3

Postgres - pg_query_params ( pg_send_query_params) , .

PDO, .

Answer 4

. , , PDO. sprintf().

PDO

StackOverflow .

Sprintf

$sql = sprintf('SELECT * FROM table WHERE id = %d AND field = %s',
               $id,
               mysql_real_escape_string($value));