How do I loop through a MySQL query via PDO in PHP?

by

Here is an example for using PDO to connect to a DB, to tell it to throw Exceptions instead of php errors (will help with your debugging), and using parameterised statements instead of substituting dynamic values into the query yourself (highly recommended):

// connect to PDO
$pdo = new PDO("mysql:host=localhost;dbname=test", "user", "password");

// the following tells PDO we want it to throw Exceptions for every error.
// this is far more useful than the default mode of throwing php errors
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

// prepare the statement. the placeholders allow PDO to handle substituting
// the values, which also prevents SQL injection
$stmt = $pdo->prepare("SELECT * FROM product WHERE productTypeId=:productTypeId AND brand=:brand");

// bind the parameters
$stmt->bindValue(":productTypeId", 6);
$stmt->bindValue(":brand", "Slurm");

// initialise an array for the results
$products = array();
$stmt->execute();
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $products[] = $row;
}

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. How can I properly use a PDO object for a parameterized SELECT query
  9. How do I return integer and numeric columns from MySQL as integers and numerics in PHP?
  10. PDO with INSERT INTO through prepared statements [closed]
  11. PDO::fetchAll vs. PDO::fetch in a loop
  12. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  13. Real escape string and PDO [duplicate]
  14. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  15. PDO Connection Test
  16. PHP PDO vs normal mysql_connect
  17. Can I create a database using PDO in PHP?
  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. Is “SET CHARACTER SET utf8” necessary?
  23. Getting a PHP PDO connection from a mysql_connect()?
  24. Having issue with matching rows in the database
  25. Set PDO to throw exceptions by default [duplicate]
  26. PDO: MySQL server has gone away
  27. How to get a query error from prepare() in PDO PHP?
  28. Checking for an empty result (PHP, PDO, and MySQL) [duplicate]
  29. PHP/SQL Insert Error when using Named Placeholders
  30. Is a BLOB converted using the current/default charset in MySQL?

Leave a Comment