PHP PDO prepared statements

by

There are two great examples on the pdo::prepare() documentation.

I have included them here and simplified them a bit.

This one uses ? parameters. $dbh is basically a PDO object. And what you are doing is putting the values 150 and 'red' into the first and second question mark respectively.

/* Execute a prepared statement by passing an array of values */
$sth = $dbh->prepare('SELECT name, colour, calories
                      FROM fruit
                      WHERE calories < ? AND colour = ?');

$sth->execute(array(150, 'red'));

$red = $sth->fetchAll();

This one uses named parameters and is a bit more complex.

/* Execute a prepared statement by passing an array of values */
$sql="SELECT name, colour, calories
        FROM fruit
        WHERE calories < :calories AND colour = :colour";

$sth = $dbh->prepare($sql, array(PDO::ATTR_CURSOR => PDO::CURSOR_FWDONLY));
$sth->execute(array(':calories' => 150, ':colour' => 'red'));

$red = $sth->fetchAll();

More Related Contents:

  1. mysqli or PDO – what are the pros and cons? [closed]
  2. PHP PDO: charset, set names?
  3. How to get numeric types from MySQL using PDO?
  4. PDO MySQL: Use PDO::ATTR_EMULATE_PREPARES or not?
  5. Why I am getting Cannot pass parameter 2 by reference error when I am using bindParam with a constant value?
  6. Causes of MySQL error 2014 Cannot execute queries while other unbuffered queries are active
  7. mysql PDO how to bind LIKE
  8. Use bound parameter multiple times
  9. What is the difference between MySQL, MySQLi and PDO? [closed]
  10. how safe are PDO prepared statements
  11. Can I use a PDO prepared statement to bind an identifier (a table or field name) or a syntax keyword?
  12. PHP PDO – Num Rows
  13. How to solve General error: 2006 MySQL server has gone away
  14. Replacing mysql_* functions with PDO and prepared statements
  15. Understanding pdo mysql transactions
  16. Calling stored procedure with Out parameter using PDO
  17. When *not* to use prepared statements?
  18. How to insert an array into a single MySQL Prepared statement w/ PHP and PDO
  19. Setting a connect timeout with PDO
  20. What is the best way to insert multiple rows in PHP PDO MYSQL?
  21. PDO MySQL: Insert multiple rows in one query
  22. How to bind LIKE values using the PDO extension?
  23. Error while using PDO prepared statements and LIMIT in query [duplicate]
  24. PDO prepared statement fetch() returning double results
  25. Warning: PDO::__construct(): [2002] No such file or directory (trying to connect via unix:///tmp/mysql.sock) in
  26. SQLSTATE[HY093]: Invalid parameter number: parameter was not defined
  27. PDO::rowCount VS COUNT(*)
  28. PHP 7 RC3: How to install missing MySQL PDO
  29. PHP: mysql v mysqli v pdo [closed]
  30. PDO and MySQL ‘between’

Leave a Comment