$data = User::find()
->select('id, name')
->where(['status' => 'active'])
->orderBy('id DESC')
->asArray()
->all();
[
[0]=>[
id=>1
name="test"
]
[1]=>[
id=>2
name="test1"
]
]
What I want is array which looks similar to this. Mapping the id with name so it can be accessed and checked.
[
[1]=>'test'
[2]=>'test1'
]
Instead of using the ArrayHelper you can directly achieve the desired output by using indexBy() and column() within your query:
$data = User::find()
->select(['name', 'id'])
->where(['status' => 'active'])
->orderBy(['id' => SORT_DESC])
->indexBy('id')
->column();
indexBy() defines the array key, while column() will take the first column in the select condition as value.
id being a INTEGER. For indexing by text fields, such as a key field, this does work as expected. When numerical fields are used, the resulting array will be re-indexed, starting with 0. The ArrayHelper solution as proposed by @Vivek does work in both situations.
Example::find()->select(['title', 'id'])->indexBy('id')->column() works perfect. array(2) { [33]=> string(8) "title1" [47]=> string(9) "title2" }
->select(['name', 'id']). At first I use vice versa and it not working array returned as ["id" => "id"]Try this Add the below namespace and use the arrayhelper of Yii2 to map
use yii\helpers\ArrayHelper
$userdata = ArrayHelper::map($data, 'id', 'name');
