Yii - How to get a values array from an Active Record

Question

Using Yii, how can I get an array from an Active Record.

Say something like this:

array('foo', 'bar', 'lala')

From something like this:

MyTable::model()->findall()

Answer 1

If i understand you correctly:

$users = User::model()->findAll();
$usersArr = CHtml::listData( $users, 'id' , 'name');
print_r( $usersArr );

It will give you array id => name

Array {
    2 => 'someone',
    20 => 'kitty',
    102 => 'Marian',
    // ...
}

Answer 2

For yii2 , use:

yii\helpers\ArrayHelper::map(MyModel::find()->all(), 'id', 'name'));

or

yii\helpers\ArrayHelper::getColumn(MyModel::find()->all(), 'name'));