Yii framework 2.0 pass parameter to eager loading relational database table

0
votes

Working with Yii framework 2.0 I tried to retrieve data from my relational database tables following the documentation here http://www.yiiframework.com/doc-2.0/guide-db-active-record.html

Below is the code sample under the section Lazy and Eager Loading.

$customers = Customer::find()->limit(100)->with([
    'orders' => function($query) {
        $query->andWhere('subtotal>100');
    },
])->all();

In my case I want to pass a parameter to the andWhere() method as following.

$param = 'something flexible';
$customers = Customer::find()->limit(100)->with([
    'orders' => function($query) {
        $query->andWhere('subtotal > ' . $param);
    },
])->all();

It does not work this way. What do I miss or how can I pass the parameter from the first line to the andWhere() method?

1
yii2eager-loading

1 Answers

1
votes

I found the solution as following.

$param = 'something flexible';
$customers = Customer::find()->limit(100)->with([
    'orders' => function($query) use($param) {
       $query->andWhere('subtotal > ' . $param);
    },
])->all();