Yii2中的关系和主动查询？

Question

I have 2 tables:

Auto

id (pk) int

name varchar100

color int

AutoComparison

auto1_id

auto2_id

status

Where:

(*status - 
id 0 new

id 1 old

id 2 broken)

I need to select all cars whose status (id 2 "broken") and count the number of them.

The question that I need to change in the model and insert into the view file, in order to display the number of broken auto's. (Framework Yii2)

Answer 1

You can access your relations by calling the relation as you would a property of the model.

To count:

$count = AutoComparison::find()->where('status = 2')->count();

To select the models:

$models = AutoComparison::find()->where('status = 2')->all();

Show the names and colors of the broken cars:

foreach ($models as $model) {
    echo 'Car name: ' . $model->auto->name;
    echo '<br/>';
    echo 'Car color: ' . $model->auto->color;
}