How can I properly use a PDO object for a parameterized SELECT query

by

You select data like this:

$db = new PDO("...");
$statement = $db->prepare("select id from some_table where name = :name");
$statement->execute(array(':name' => "Jimbo"));
$row = $statement->fetch(); // Use fetchAll() if you want all results, or just iterate over the statement, since it implements Iterator

You insert in the same way:

$statement = $db->prepare("insert into some_other_table (some_id) values (:some_id)");
$statement->execute(array(':some_id' => $row['id']));

I recommend that you configure PDO to throw exceptions upon error. You would then get a PDOException if any of the queries fail – No need to check explicitly. To turn on exceptions, call this just after you’ve created the $db object:

$db = new PDO("...");
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

More Related Contents:

  1. Insert form in MySQL with PDO [duplicate]
  2. Undefined index $_POST
  3. How to check if a row exists in MySQL? (i.e. check if username or email exists in MySQL)
  4. Getting raw SQL query string from PDO prepared statements
  5. How do I set ORDER BY params using prepared PDO statement?
  6. “Invalid parameter number: parameter was not defined” Inserting data
  7. Having issue with matching rows in the database using PDO
  8. PDO with INSERT INTO through prepared statements [closed]
  9. PDO::fetchAll vs. PDO::fetch in a loop
  10. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  11. Resetting array pointer in PDO results
  12. Notice: Array to string conversion in
  13. Real escape string and PDO [duplicate]
  14. PDO multiple queries
  15. PHP PDO vs normal mysql_connect
  16. Can I create a database using PDO in PHP?
  17. How to bind parameters to a raw DB query in Laravel that’s used on a model?
  18. PDO::PARAM for type decimal?
  19. PHP PDO and MySQLi [duplicate]
  20. PDO fetch one column from table into 1-dimensional array
  21. Update query with PDO and MySQL
  22. Select from mysql table WHERE field=’$array’?
  23. Is “SET CHARACTER SET utf8” necessary?
  24. Getting a PHP PDO connection from a mysql_connect()?
  25. Having issue with matching rows in the database
  26. Set PDO to throw exceptions by default [duplicate]
  27. PDO: MySQL server has gone away
  28. Checking for an empty result (PHP, PDO, and MySQL) [duplicate]
  29. PHP/SQL Insert Error when using Named Placeholders
  30. PDO and MySQL ‘between’

Leave a Comment