Sql query in yii2

Question

I would like to execute such a command:

SELECT number.phone_number 
FROM number 
LEFT JOIN ordered_number 
ON ordered_number.number_id=number.id 
WHERE ordered_number.order_id=123

with Yii2. I do this:

$numery = Number::find()
                    ->select('number.phone_number')
                    ->leftJoin('ordered_number', ['ordered_number.number_id' => 'number.id'])
                    ->where(['ordered_number.order_id' => 123])
                    ->createCommand()
                    ->rawSql;

But I get then this:

'SELECT `number`.`phone_number` FROM `number` LEFT JOIN `ordered_number` ON `ordered_number`.`number_id`='number.id' WHERE `ordered_number`.`order_id`=123'

Which doesn't work. When I put the first thing right into my base, I get 4 results, which is correct. But when I do (I think exactly the same) with Yii, I have troubles, because it is null. The only differences between what I have written and what appears after rawSql, are ` and '.

Is it still null if you remove ->select('number.phone_number') so all fields are returned (and of course with all() at the end instead of ->createCommand()->rawSql) — Bizley
– Bizley, Commented Dec 20, 2016 at 10:43

Bizley · Accepted Answer · 2016-12-20 10:54:10Z

2

Sorry, I've just read docs for this method - it should be:

->leftJoin('ordered_number', 'ordered_number.number_id = number.id')

because using the where() kind of conditions with array leads to comparing field to string.

answered Dec 20, 2016 at 10:54

Bizley

18.1k6 gold badges53 silver badges62 bronze badges

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

Collectives™ on Stack Overflow

Sql query in yii2

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related