Problems with query

cesar.yii · March 17, 2016, 10:14pm

I have this table:

business(id, id_head_office)

and I want to execute this query in yii:

select * from business where id_head_office = id;

using ActiveRecords methods. I tried these:


$head_offices = Business::find()

                ->where(['id_head_office' => 'id'])

                ->all();


$head_offices = Business::findAll([

                'id_head_office' => 'id',

            ]);

But I don’t get the correct result.

Why? Thanks in advance

softark · March 17, 2016, 10:45pm

cesar.yii:


$head_offices = Business::find()

                ->where(['id_head_office' => 'id'])

                ->all();


$head_offices = Business::findAll([

                'id_head_office' => 'id',

            ]);

‘id’ is treated as a string here.

[sql]

select * from business where id_head_office = "id";

[/sql]




$head_offices = Business::find()

                ->where(new Expression('id_head_office = id'))

                ->all();