Get array of values using Doctrine

Question

I'm using Symfony2 and Doctrine to get an array of values from the database. I want a list of values from one field of the database table.

I'm using the following code:

        return $this->createQueryBuilder('ad')
        ->select('ad.extId')
        ->where('ad.extId is not NULL')
        ->getQuery()
        ->getArrayResult();

It returns the following array:

Array
(
    [0] => Array
        (
            [extId] => 3038
        )
)

I would like to revieve the following:

Array
(
    [0] => 3038
)

Any one an idee to get this direct from Doctrine without an extra foreach loop?

this would be it stackoverflow.com/questions/11657835/… or this stackoverflow.com/questions/11657835/… — Confidence
– Confidence, Commented Apr 17, 2017 at 19:15

Jovan Perovic · Accepted Answer · 2017-04-17 19:14:44Z

1

Without custom hydrator, I don't think it is possible out of the box. However, you could do this (similar to foreach):

$arr = $this->createQueryBuilder('ad')
        ->select('ad.extId')
        ->where('ad.extId is not NULL')
        ->getQuery()
        ->getArrayResult();

return array_map(function($a){ return $a['extId']; }, $arr);

answered Apr 17, 2017 at 19:14

Jovan Perovic

20.2k5 gold badges47 silver badges92 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Jakub Matczak Over a year ago

For PHP5.5+ there's array_column() function which may be used instead of array_map here. array_map($arr, 'extId'); is simpler and actually has better performance.

Jovan Perovic Over a year ago

Sweet :) And you meant array_column($arr, 'extId') ;)

Jakub Matczak Over a year ago

Yeah, that's what I meant. :D

Collectives™ on Stack Overflow

Get array of values using Doctrine

1 Answer 1

3 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Linked

Related