How to create name value pair array in yii2

Question

i am trying to create an Array in yii2 in following format

[
  ['id'=>'2', 'name'=>'ABC'],
  ['id'=>'3', 'name'=>'DEF']
]

So far i have tried to use ArrayHelper class but if i map using it than it removes the key part from the array,i need to create the array in exact this format

$data = User::find()
        ->where(['id' => $id])
        ->orderBy('id DESC')
        ->all();

As you know after this code i get the data in ActiveRecord format so i need to convert them to id and name array only,i dont need any other data.

I tried doing this

 $data2 = ArrayHelper::map($data, 'id', 'name');

But returns the data in following format

[
  ['2'=>'ABC'],
  ['3'=>'DEF']
]

I have tried this as well

$data = MainCategory::find()->select('id,name')
 ->where(['id' => $id])
  ->orderBy('id DESC') 
 ->asArray()->all();

But its returning the array in following format

[
  '0' =>
      [
       'id'=>'2', 
       'name'=>'ABC'
      ],
  '1' =>
      [
       'id'=>'3', 
       'name'=>'DEF'
      ]
]

How can i achive key and value format in yii2?

Returning array is the same as you mentioned in the very beginning. What's the current problem? — arogachev
– arogachev, Commented Nov 2, 2015 at 3:20
@arogachev when i fire the query it returns the array in the last format i posted in question but i want to achieve the format which is on top,without grouping — Bhavuk Suthar
– Bhavuk Suthar, Commented Nov 2, 2015 at 3:41

arogachev · Accepted Answer · 2015-11-02 03:22:06Z

2

You can fetch data as array like this:

$data = User::find()
    ->select('id, name')
    ->where(['id' => $id])
    ->orderBy('id DESC')
    ->asArray()
    ->all();

edited Nov 2, 2015 at 3:22

arogachev

33.6k8 gold badges121 silver badges118 bronze badges

answered Nov 2, 2015 at 2:24

Double H

4,1901 gold badge17 silver badges27 bronze badges

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

Comments

lubosdz · Accepted Answer · 2018-01-03 21:38:02Z

0

To create plain KEY => VALUE array use column() method:

$data = User::find()
    ->select(['name', 'id'])
    ->where(['id' => $id])
    ->orderBy('id DESC')
    ->asArray()
    ->indexBy('id')
    ->column();

First selected column [name] will be returned as a VALUE.

answered Jan 3, 2018 at 21:38

lubosdz

4,5762 gold badges34 silver badges45 bronze badges

Collectives™ on Stack Overflow

How to create name value pair array in yii2

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related