How to get a one-dimensional scalar array as a doctrine dql query result?

by

PHP < 5.5

You can use array_map, and since you only have on item per array, you can elegantly use
'current' as callback, instead of writing a closure.

$result = $em->createQuery("SELECT a.id FROM Auction a")->getScalarResult();
$ids = array_map('current', $result);

See Petr Sobotka’s answer below for additional info regarding memory usage.

PHP >= 5.5

As jcbwlkr’s answered below, the recommended way it to use array_column.

More Related Contents:

  1. Doctrine2: Best way to handle many-to-many with extra columns in reference table
  2. Is there a built-in way to get all of the changed/updated fields in a Doctrine 2 entity
  3. On delete cascade with doctrine2
  4. Why I am suddenly getting a “Typed property must not be accessed before initialization” error when introducing properties type hints?
  5. How to do left join in Doctrine?
  6. Default value in Doctrine
  7. Doctrine 2 and Many-to-many link table with an extra field
  8. How to use WHERE IN with Doctrine 2
  9. How to select randomly with doctrine
  10. Should I use EAV model?
  11. Select entries between dates in doctrine 2
  12. Too much data with var_dump in symfony2 doctrine2
  13. How to re-save the entity as another row in Doctrine 2
  14. Subquery in doctrine2 notIN Function
  15. Injecting SecurityContext into a Listener prePersist or preUpdate in Symfony2 to get User in a createdBy or updatedBy Causes Circular Reference Error
  16. How to set up entity (doctrine) for database view in Symfony 2
  17. Symfony2, Dynamic DB Connection/Early override of Doctrine Service
  18. How to setup table prefix in symfony2
  19. How to use a findBy method with comparative criteria
  20. Symfony 2.0 getting service inside entity
  21. “Class XXX is not a valid entity or mapped super class” after moving the class in the filesystem
  22. Can I access discriminator field from php in doctrine2?
  23. How to force Doctrine to update array type fields?
  24. Query on a many-to-many relationship using Doctrine with Symfony2
  25. Doctrine2 association mapping with conditions
  26. How can I use DATE() in Doctrine 2 DQL?
  27. Join subquery with doctrine 2 DBAL
  28. Converting a UNIX Timestamp to Formatted Date String
  29. remove duplicate from string in PHP
  30. Using javascript history.back() fails in Safari .. how do I make it cross-browser?

Leave a Comment