Yii model to array?

Question

How can I convert the result of Trips::model()->findAll() to an array?

Answer 1

$model = Trips::model()->findAll(); 
$arr = CHtml::listData($model, 'trip_id', 'trip_name');
var_dump($arr);

CHtml::listData() will return an array value.

Answer 2

You can use this.

$Trips::model()->findAll(array('index'=>'trip_id'));
if(count($Trips)>0)
            {                   
                $TripsArrayList=array();
                foreach($Tripsas as $singleTrip)
                {                   
                    $TripsArrayList[]=array('trip_id'=>$singleTrip->trip_id,'name'=>$singleTrip->name);         
                }                   
            }

Your output will be

Array
    (
      [0] => Array
                 (
                   [trip_id] => 1
                   [name] => Nashik
                 )
      [1] => Array
                 (
                   [trip_id] => 2
                   [name] => Puna
                 ) 
      [2] => Array
                 (
                   [trip_id] => 3
                   [name] => Mumbai
                 ) 
    )

Answer 3

Use DAO for arrays

$array = Yii::app()->db->createCommand('SELECT * FROM tbl')->queryAll();

Answer 4

Assuming from your question that you want all the attributes, a more compact solution to give you all attributes hashed by id, you can use CActiveRecord's 'attributes' pseudoproperty as follows:

CHtml::listData(Trips::model()->findAll(), 'id', 'attributes')

Answer 5

This is same.

$array = CHtml::listData(Trips::model()->findAll(), 'trip_id', 'trip_name');

Answer 6

You can create collections CMap continue to work with her

$collections = new CMap();
foreach (YourModel::model()->findAll(['index' => 'id']) as $key => $row) {
   $collections->add($key,$row->attributes);
}
var_dump($collections ->toArray());