Fetching array data from database in symfony2

Question

I have a table "config" with three fields

------------------
id | name | value
------------------
 1 | na1  | va1 
 2 | na2  | va2
 3 | na3  | va3
 . | ...  | ...

I need to fetch the above data to an array "$confData" as given below

$confData ===>

  array(
   'na1' => 'va1',
   'na2' => 'va2',
   'na1' => 'va3',
   ' . ' => '...'
  );

I want to know wether there is any predefined function/method in symfony-doctrine to get this array? If it is not available, how can use doctrine way?

Vitalii Zurian · Accepted Answer · 2012-08-08 12:32:16Z

1

There is no such default way. You should build this array manually for fetched object.

//after fetching $objectCollection

$config = array();
foreach ($objectCollection as $object) {
    $config[$object->getName()] = $object->getValue();
}

answered Aug 8, 2012 at 12:32

Vitalii Zurian

18k4 gold badges69 silver badges83 bronze badges

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

Collectives™ on Stack Overflow

Fetching array data from database in symfony2

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related