Using value of a column as index in results using PDO

by

Although PDO::FETCH_UNIQUE description in PHP manual is quite unclear, but in fact it’s exact parameter you actually need.

$data = $pdo->query('SELECT * FROM table')->fetchAll(PDO::FETCH_UNIQUE);

is giving you an array indexed by the field listed in SELECT clause first (when * is used then first field in the table definition, which should be id in your case).

Note that by default using just PDO::FETCH_UNIQUE will give you resulting rows with doubled values. You can either add preferred row mode to this call or – better, set it once for all PDO calls in constructor or via setAttribute(). The output below is shown for PDO::FETCH_ASSOC set as default fetch mode.

  1 => array (
    'name' => 'Solidfloor',
    'url' => 'solidfloor',
  ),
  2 => array (
    'name' => 'Quickstep',
    'url' => 'quickstep',
  ),
  4 => array (
    'name' => 'Cleanfloor',
    'url' => 'cleanfloor',
  ),
)

More Related Contents:

  1. Cleansing User Passwords
  2. Can I bind an array to an IN() condition in a PDO query?
  3. How to apply bindValue method in LIMIT clause?
  4. How to properly set up a PDO connection
  5. Getting raw SQL query string from PDO prepared statements
  6. PDO with INSERT INTO through prepared statements [closed]
  7. Use bound parameter multiple times
  8. How to replace MySQL functions with PDO?
  9. How to debug PDO database queries?
  10. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  11. Do SQL connections opened with PDO in PHP have to be closed
  12. Is there a way to fetch associative array grouped by the values of a specified column with PDO?
  13. PDO fetch one column from table into 1-dimensional array
  14. PDO fetchAll array to one dimensional
  15. How to use php array with sql IN operator? [duplicate]
  16. Pass array literal to PostgreSQL function
  17. I’m getting this error code: Invalid argument supplied for foreach() [duplicate]
  18. PHP/SQL Insert Error when using Named Placeholders
  19. PDO and MySQL ‘between’
  20. PDO Return All Rows [duplicate]
  21. PDO Exception Questions – How to Catch Them
  22. How can I use PDO to fetch a results array in PHP?
  23. What is the best way to loop through this array in PHP?
  24. MySQL check if a table exists without throwing an exception
  25. php var_dump() vs print_r()
  26. PHP combine two associative arrays into one array
  27. using array_search for multi dimensional array
  28. How to read “fetch(PDO::FETCH_ASSOC);”
  29. How to generate unique id in MySQL?
  30. PHP convert nested array to single array while concatenating keys?

Leave a Comment