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

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

ActiveRecord class has an attribute called attributes. You can find its description here: http://www.yiiframework.com/doc/api/1.1/CActiveRecord#attributes-detail.

In order to get all attributes in an array, use this: $var = $model->attributes;

Answer 2

You could also do something like

$countries = Country::model()->findAll();
array_values(CHtml::listData($countries, 'country_id', 'country_name'));

which returns an array of all country names, or

array_keys(CHtml::listData($countries, 'country_id', 'country_name'));

which returns an array of all country ids.

Answer 3

Use the Yii2 ArrayHelper by including to your controller this will convert a model data to an associated array

    use yii\helpers\ArrayHelper; 

    $post = ArrayHelper::toArray(ClientProfilesForm::findOne(['id' => 1]));

//or use it directly by 

    $post = yii\helpers\ArrayHelper::toArray(ClientProfilesForm::findOne(['id' => 1]));

Answer 4

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 5

Don't use ActiveRecord. Use CDBCommand->queryColumn()

Answer 6

Use Chtml to this is a Ugly Hack! Apply this solution is the better way to this that I found:

public function queryAll($condition = '', $params = array())
{
    $criteria = $this->getCommandBuilder()->createCriteria($condition, $params);
    $this->applyScopes($criteria);
    $command = $this->getCommandBuilder()->createFindCommand($this->getTableSchema(), $criteria);
    $results = $command->queryAll();
    return $results;
}

You can add this code to an ActiveRecord class, e.g.:

class ActiveRecord extends CActiveRecord {
//...
}

And, use this way:

return $model->queryAll($criteria);

You can read more about in this link.