how to use MySQL code directly into a Yii query

Question

I have this MySQL insert:

INSERT INTO restaurant (id_restaurant, id_category)
SELECT id_rest, id_cat
FROM restaurant_menu rm, category_menu cm
WHERE rm.name = "discount" AND cm.name = "beach";

but now I want to do this insert in Yii. I know that I can do it using Yii query builder, but I think that if the query/insert/delete/update is very long, that is too complex. Therefore, I would like to know if is possible to use MySQL code into a Yii code directly, I mean, for example something similar to this:

$sql='INSERT INTO restaurant (id_restaurant, id_category) SELECT id_rest, id_cat FROM restaurant_menu rm, category_menu cm WHERE rm.name = "discount" AND cm.name = "beach"'

$command=$connection->createCommand($sql);

Please, someone could show me how to do this insert using the MySQL code directly in Yii?

Careful with your quoting in your second example. If you're using " for your string, use ' for your data. Or better, use placeholder values. — tadman
– tadman, Commented Nov 14, 2013 at 21:55
Thanks @user2989514. I have just corrected the code. Am I using right the "" and '' now? — user2989514
– user2989514, Commented Nov 14, 2013 at 23:02

Pitchinnate · Accepted Answer · 2013-11-14 22:06:49Z

1

You basically have it right:

$connection = Yii::app()->db;
$command=$connection->createCommand($sqlStatement);
$command->execute();

http://www.yiiframework.com/doc/api/1.1/CDbConnection

answered Nov 14, 2013 at 22:06

Pitchinnate

7,5561 gold badge22 silver badges39 bronze badges

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

2 Comments

user2989514 Over a year ago

Thanks @Pitchinnate. I understand that $sqlStatement in my case is $sql, is it right?

Pitchinnate Over a year ago

Yes the name of the variable is arbitrary it could be anything.

Collectives™ on Stack Overflow

how to use MySQL code directly into a Yii query

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related