Doctrine 2得到对id => value

Question

Hello i have one quick question.

I'm using Doctrine 2 and i need to get pairs from specific table as array. For example, i have table "Category" with columns ('id', 'name', 'description' , ...) and i want to get all rows in array format (category.id=>category.name) as follow:

array(
   7 => 'News',
   8 => 'Sport',
   11 => 'Work'
)

(I have only 3 categories with ids 7,8,11 in this example).

Is there some simple and quick way how to do it?

Answer 1

Try this

$result = $query->getResult(Query::HYDRATE_ARRAY);

OR

$result = $query->getArrayResult();

For more Info. See link

To convert categoryId to array key and categoryName to value

$newArr=[];
foreach($result as $cat){
    $newArr[] = [$cat['id'] => $cat['name']];
}