How to use a variable inside activerecord query in yii2

Question

How do I convert the following to active record style in yii2?

SELECT *
FROM orders
WHERE created_at >= (CURDATE() - INTERVAL 11 MONTH)
ORDER BY id DESC

What I have tried:

switch ($period) {
        case 'y':
            $p = "12 month";
            break;
        case 'm':
            $p = "1 month";
            break;
        case 'w':
            $p = "7 days";
            break;
        case 'd':
            $p = "1 days";
            break;
}

Customers::find()
  ->where('>=', 'created_at', (CURDATE() - INTERVAL $p))
  ->orderBy('id DESC');

But I get:

syntax error, unexpected '$p' (T_VARIABLE)

Yupik · Accepted Answer · 2017-09-28 11:02:50Z

4

insted of pass the string
you could pass the $p as a param

  Customers::find()
    ->where( 'created_at >=(CURDATE() - INTERVAL :p' ), [':p'=>$p])
    ->orderBy('id DESC');

edited Sep 28, 2017 at 11:02

Yupik

5,0291 gold badge15 silver badges27 bronze badges

answered Sep 27, 2017 at 17:54

ScaisEdge

133k10 gold badges98 silver badges111 bronze badges

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

Comments

smsalisbury · Accepted Answer · 2017-09-27 16:30:09Z

3

Yii2 has an Expression class to help with those kinds of things (doc here).

In your case, it'd look something like:

Customers::find()
    ->where(['>=', 'created_at', new \yii\db\Expression('(CURDATE() - INTERVAL ' . $p . ')'))
    ->orderBy('id DESC');

answered Sep 27, 2017 at 16:30

smsalisbury

3754 silver badges15 bronze badges

Collectives™ on Stack Overflow

How to use a variable inside activerecord query in yii2

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related