Is there a way to fetch associative array grouped by the values of a specified column with PDO?

by

It’s quite old topic, but I found very easy solution:

->fetchAll(\PDO::FETCH_GROUP|\PDO::FETCH_UNIQUE)

First col will be set as key, rest will be set as value.

No need to walk over the array or use array_map.

More Related Contents:

  1. Can I bind an array to an IN() condition in a PDO query?
  2. php pdo: get the columns name of a table
  3. PDO::fetchAll vs. PDO::fetch in a loop
  4. PDO fetch one column from table into 1-dimensional array
  5. PDO fetchAll array to one dimensional
  6. Using value of a column as index in results using PDO
  7. PDO prepared statement fetch() returning double results
  8. PHP/SQL Insert Error when using Named Placeholders
  9. how can I print multiple services in this way
  10. Remove Duplicates in array php
  11. Insert form in MySQL with PDO [duplicate]
  12. Undefined index $_POST
  13. Reference — frequently asked questions about PDO
  14. Getting raw SQL query string from PDO prepared statements
  15. PHP Sort a multidimensional array by element containing Y-m-d H:i:s date
  16. How to bind mysqli bind_param arguments dynamically in PHP?
  17. “Invalid parameter number: parameter was not defined” Inserting data
  18. Having issue with matching rows in the database using PDO
  19. php multi-dimensional array remove duplicate [duplicate]
  20. How can I properly use a PDO object for a parameterized SELECT query
  21. How is the PHP array implemented on the C level?
  22. Connect to SQL Server through PDO using SQL Server Driver
  23. Convert flat array to a delimited string to be saved in the database
  24. Group array data on one column and sum data from another column
  25. Check if specific array key exists in multidimensional array – PHP
  26. Re-index numeric array keys [duplicate]
  27. Getting a PHP PDO connection from a mysql_connect()?
  28. Reverse array in php
  29. Sort an array of associative arrays by column value
  30. Change array key without changing order

Leave a Comment