PDO fetchAll array to one dimensional

by

Take a look at example 2 in the manual. In your first query you can use:

$staff = $select->fetchAll(PDO::FETCH_COLUMN, 0);

And your second array will have the same form as the first array.

More Related Contents:

  1. Can I bind an array to an IN() condition in a PDO query?
  2. Is there a way to fetch associative array grouped by the values of a specified column with PDO?
  3. PDO fetch one column from table into 1-dimensional array
  4. Using value of a column as index in results using PDO
  5. PHP/SQL Insert Error when using Named Placeholders
  6. Perform logic operations on boolean array values
  7. How to apply bindValue method in LIMIT clause?
  8. How to Remove Array Element and Then Re-Index Array?
  9. PHP PDO – Bind table name? [duplicate]
  10. How to debug PDO database queries?
  11. PHP: merge two arrays while keeping keys instead of reindexing?
  12. How to check if an array value exists?
  13. PDO multiple queries
  14. multidimensional array array_sum
  15. Parametrized PDO query and `LIMIT` clause – not working [duplicate]
  16. Using htmlspecialchars function with PDO prepare and execute
  17. Dynamic array keys
  18. Convert a String into an Array of Characters
  19. How do i count same values in an array and store it to a variable?
  20. What is the advantage of using try {} catch {} versus if {} else {}
  21. Remove duplicate items from an array [duplicate]
  22. ERROR: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it
  23. Call to undefined method PDO::execute()
  24. Chunk and transpose a flat array into rows with a specific number of columns
  25. What is the max key size for an array in PHP?
  26. return one value from database with mysql php pdo
  27. Split array into a specific number of chunks
  28. How can I pass an array of PDO parameters yet still specify their types?
  29. Sort a multidimensional array descending by subarray count and preserve first level keys
  30. Why does PHP not complain when I treat a null value as an array like this?

Leave a Comment