PDO fetch one column from table into 1-dimensional array

by 
<?php
$sql = "SELECT `ingredient_name` FROM `ingredients`";
$ingredients = $pdo->query($sql)->fetchAll(PDO::FETCH_COLUMN);

More Related Contents:

  1. PHP/SQL Insert Error when using Named Placeholders
  2. mysqli or PDO – what are the pros and cons? [closed]
  3. PDOException SQLSTATE[HY000] [2002] No such file or directory
  4. How to get numeric types from MySQL using PDO?
  5. How can I use PDO to fetch a results array in PHP?
  6. PHP PDOException: “SQLSTATE[HY093]: Invalid parameter number”
  7. Causes of MySQL error 2014 Cannot execute queries while other unbuffered queries are active
  8. Use bound parameter multiple times
  9. MySQL check if a table exists without throwing an exception
  10. how safe are PDO prepared statements
  11. Replacing mysql_* functions with PDO and prepared statements
  12. PDO + MySQL and broken UTF-8 encoding
  13. Is there a way to fetch associative array grouped by the values of a specified column with PDO?
  14. PDOstatement (MySQL): inserting value 0 into a bit(1) field results in 1 written in table
  15. php code to test pdo is available?
  16. Understanding pdo mysql transactions
  17. Calling stored procedure with Out parameter using PDO
  18. When *not* to use prepared statements?
  19. How to insert an array into a single MySQL Prepared statement w/ PHP and PDO
  20. Setting a connect timeout with PDO
  21. In PHP with PDO, how to check the final SQL parametrized query? [duplicate]
  22. What is the best way to insert multiple rows in PHP PDO MYSQL?
  23. PDO MySQL: Insert multiple rows in one query
  24. How to bind LIKE values using the PDO extension?
  25. Warning: PDO::__construct(): [2002] No such file or directory (trying to connect via unix:///tmp/mysql.sock) in
  26. PDO::rowCount VS COUNT(*)
  27. PHP 7 RC3: How to install missing MySQL PDO
  28. PHP: mysql v mysqli v pdo [closed]
  29. PDO and MySQL ‘between’
  30. MySQL PHP – SELECT WHERE id = array()? [duplicate]

Leave a Comment