Yii2: Can ActiveQuery return array where the key is the first column of the SQL query?

Question

I often have a need for making a database query where the key of resulting array is the value of the first column specified in the SQL (instead of the key just being an auto-assigned incremental number as the array is being filled). Is that possible without having to rework the array manually afterwards?

I know there is queryAll(PDO::FETCH_KEY_PAIR) but that only works for two colums (the array value is a single database column instead of a sub-array of all the remaining columns)

So, instead of:

array (
  0 => 
    array (
      'id' => 6955,
      'firstname' => 'John',
      'lastname' => 'Doe',
      'country' => 'United States',
    ),
  1 => 
    array (
      'id' => 8588,
      'firstname' => 'Helen',
      'lastname' => 'Smith',
      'country' => 'Denmark',
    ),
)

...I need:

array (
  6955 => array (
    'firstname' => 'John',
    'lastname' => 'Doe',
    'country' => 'United States',
  ),
  8588 => array (
    'firstname' => 'Helen',
    'lastname' => 'Smith',
    'country' => 'Denmark',
  ),
)

It doesn't necessarily have to be arrays - it could made of objects as well. It is just the structure that is important.

Could you give an example of expected result?

Bizley
– Bizley

2016-08-01 11:15:24 +00:00
Commented Aug 1, 2016 at 11:15 — Bizley
– Bizley, Commented Aug 1, 2016 at 11:15

Bizley · Accepted Answer · 2016-08-01 13:15:04Z

5

You can use indexBy() for this (it will not skip the chosen column in results but I think this is not a problem).

Example:

$query = (new \yii\db\Query())
    ->from('user')
    ->limit(10)
    ->indexBy('id')
    ->all();

returns [
    100 => ['id' => 100, 'username' => '...', ...], 
    101 => [...], 
    103 => [...], 
    ...
]

See the guide for more info.

answered Aug 1, 2016 at 13:15

Bizley

18.1k6 gold badges53 silver badges62 bronze badges

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

Collectives™ on Stack Overflow

Yii2: Can ActiveQuery return array where the key is the first column of the SQL query?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related