Yii2 Converting model objects to array with ArrayHelper::toArray()

Question

I am working in YII2 Framework on the following query

SELECT T.id, T.name, T.status, IFNULL(T.image,'no-image.png') as DP
FROM TABLE_NAME T;

here is my code

$modelTeam = Teams::find()
    ->select(
        ['T.id', 'T.name', 'T.status', 'IFNULL(T.image,"no-image.png") as DP']
    )
    ->from('{{%teams}} T')
    ->all();

Edit:

The result set does not include DP column at all why is that so, and how can I do that.

Edit 2:

While telling that the results do not include the DP column I missed a piece of important information that I was using the ArrayHelper::toArray() to convert the model object to an array and then iterate over it

$results=ArrayHelper::toArray($modelTeam);

Muhammad Omer Aslam · Accepted Answer · 2020-01-12 14:54:26Z

3

The actual problem is not where I was thinking it is, the query is alright, I used ArrayHelper::toArray($modelTeam) method to convert the model object to an array to further iterate over the array and display all the records, and that is where the problem lies.

I needed to use the second parameter $properties for the ArrayHelper::toArray(). The second argument converts properties mapping per class, as it has problems displaying the custom declared public properties of a model and the DP is declared public inside the Teams model as it is an alias in the ActiveRecrod query.

$modelTeam = Teams::find()->
    select(['TM.id', 'TM.name', 'TM.status'])
    ->addSelect([new \yii\db\Expression('IFNULL(TM.image,\'no-image.png\') AS DP')])
    ->from('{{%teams}} TM')->all();

$results = ArrayHelper::toArray($modelTeam, [
    'common\models\Teams' => [
        'id',
        'name',
        'status',
        'DP',
    ],
]);

edited Jan 12, 2020 at 14:54

answered Nov 1, 2016 at 17:13

Muhammad Omer Aslam

23.9k9 gold badges47 silver badges69 bronze badges

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

Comments

oaizumi · Accepted Answer · 2020-10-15 23:44:35Z

1

$modelTeam = Teams::find()
    ->select(['T.id', 'T.name', 'T.status'])
    ->addSelect([new Expression('IFNULL(T.image,"no-image.png") as DP')])
    ->from('{{%teams}} T')
    ->all();
$arrTeam = $modelTeam->asArray()->all();

answered Oct 15, 2020 at 23:44

oaizumi

112 bronze badges

3 Comments

ezio4df Over a year ago

pls, add explaianation of what u did

oaizumi Over a year ago

the highlight is that we can add ->asArray()->all() after model object. then we can use the result $arrTeam as a general array like $arrTeam[0]['name']. not sure for the alias 'DP' but hope it works.

Akhilesh Mishra Over a year ago

Please add the explanation in the question by editing it.

Miguel G. Flores · Accepted Answer · 2016-10-31 23:02:45Z

0

To use IFNULL in a select with Yii2 you must create a new expression.

$modelTeam = Teams::find()
    ->select(['T.id', 'T.name', 'T.status'])
    ->addSelect([new Expression('IFNULL(T.image,"no-image.png") as DP')])
    ->from('{{%teams}} T')
    ->all()

answered Oct 31, 2016 at 23:02

Miguel G. Flores

8127 silver badges21 bronze badges

2 Comments

Miguel G. Flores Over a year ago

With addSelect and having the new Expression into an array? What's the output?

Muhammad Omer Aslam Over a year ago

here is complete code ` $modelTeam = Teams::find()-> select( ['T.id','T.name','T.status'] ) ->addSelect([new \yii\db\Expression('IFNULL(T.image,\'no-image.png\') AS DP')])-> from('{{%teams}} T')->all(); print_r(ArrayHelper::toArray($modelTeam));` outputs

Array (     [0] => Array         (             [id] => 1             [name] => Pirates             [status] => active         ) )

Collectives™ on Stack Overflow

Yii2 Converting model objects to array with ArrayHelper::toArray()

3 Answers 3

Comments

3 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

3 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related