Yii framework 2.0 pass parameter to eager loading relational database table

Question

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?

O Connor · Accepted Answer · 2014-12-01 09:51:57Z

1

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();

answered Dec 1, 2014 at 9:51

O Connor

4,44216 gold badges57 silver badges103 bronze badges

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

1 Comment

DaSourcerer Over a year ago

Please do not construct queries like this. andWhere() allows you to have $param bound and escaped for you like this: ->andWhere('subtotal > :param', [':param' => $param]). See also: yiiframework.com/doc-2.0/guide-db-query-builder.html#where

Collectives™ on Stack Overflow

Yii framework 2.0 pass parameter to eager loading relational database table

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related