Yii2 find with ActiveRecord return simple attribute array

Question

i have a problem using active record in Yii2. When i do:

$x = Model::find()->all();

What i expected the value of $x will be:

array(2) {
    [0] => array(2) {
        ['col1'] => string(3) "xxx2"
        ['col2'] => string(3) "xxx3"
    }
    [1] => {
        ['col1'] => string(3) "xxx2"
        ['col2'] => string(3) "xxx3"
    }
}

What i got with $x were:

array(2) { 
    [0]=> object(app\models\X)#77 (13) { 
        ['col1'] => string(3) "xxx2"
        ['col2'] => string(3) "xxx3" 
        ["_attributes":"yii\db\BaseActiveRecord":private]=> array(5) { 
            ['col1'] => string(3) "xxx2"
            ['col2'] => string(3) "xxx3"
        } 
        ["_oldAttributes":"yii\db\BaseActiveRecord":private]=> array(5) { 
            ['col1'] => string(3) "xxx2"
            ['col2'] => string(3) "xxx3"
        } 
        ["_related":"yii\db\BaseActiveRecord":private]=> array(0) { } 
        ["_errors":"yii\base\Model":private]=> NULL 
        ["_validators":"yii\base\Model":private]=> NULL 
        ["_scenario":"yii\base\Model":private]=> string(7) "default" 
        ["_events":"yii\base\Component":private]=> array(0) { } 
        ["_behaviors":"yii\base\Component":private]=> array(0) { } 
    } 

    [1]=> object(app\models\X)#77 (13) { 
        ['col1'] => string(3) "xxx2"
        ['col2'] => string(3) "xxx3"
        ["_attributes":"yii\db\BaseActiveRecord":private]=> array(5) { 
            ['col1'] => string(3) "xxx2"
            ['col2'] => string(3) "xxx3"
        } 
        ["_oldAttributes":"yii\db\BaseActiveRecord":private]=> array(5) { 
            ['col1'] => string(3) "xxx2"
            ['col2'] => string(3) "xxx3"
        } 
        ["_related":"yii\db\BaseActiveRecord":private]=> array(0) { } 
        ["_errors":"yii\base\Model":private]=> NULL 
        ["_validators":"yii\base\Model":private]=> NULL 
        ["_scenario":"yii\base\Model":private]=> string(7) "default" 
        ["_events":"yii\base\Component":private]=> array(0) { } 
        ["_behaviors":"yii\base\Component":private]=> array(0) { } 
    } 
}

The question is, how to make the $x's value just like what i expected. I use Yii2 basic. Thanks guys, i appreciate your help.

Use $x = Model::find()->asArray()->all();

Insane Skull
– Insane Skull

2017-11-23 04:31:34 +00:00
Commented Nov 23, 2017 at 4:31 — Insane Skull
– Insane Skull, Commented Nov 23, 2017 at 4:31
Thanks @InsaneSkull it worked.

Luckatme
– Luckatme

2017-11-23 05:39:24 +00:00
Commented Nov 23, 2017 at 5:39 — Luckatme
– Luckatme, Commented Nov 23, 2017 at 5:39

Naim Malek · Accepted Answer · 2017-11-23 04:33:46Z

1

Use it as

$x = Model::find()->asArray()->all();

answered Nov 23, 2017 at 4:33

Naim Malek

1,1841 gold badge11 silver badges21 bronze badges

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

Collectives™ on Stack Overflow

Yii2 find with ActiveRecord return simple attribute array

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