how to execute sql query in yii?

Question

I want to execute a query in a view page in Yii, here is my code:

$connection=Yii::app()->db;
$connection->active=true;
$sql = "insert into news(idNews, news, display) values('', 'anything', 0)";
$command=$connection->createCommand($sql);
$command->execute();

but nothing is happened, what is the error with my code?

I don't know YII, but from the first look createCommand returns a normal PDO. So at first you need check if $command->execute() true, if not you have check what error mysql reports. — t.niese
– t.niese, Commented Jun 21, 2014 at 18:26
if idNews is auto incremental, you don't have to pass anything about it, also check /runtime/application.log if an error happend and you missed it — Developerium
– Developerium, Commented Jun 22, 2014 at 3:58
Using data management requests such as inserts goes against the practice of separating views, business logic and data management, which is used in MVC frameworks such as Yii. If you have to do this, you should re-evaluate your need to use a framework such as Yii. — crafter
– crafter, Commented Jun 22, 2014 at 8:48

onalbi · Accepted Answer · 2015-02-05 09:02:24Z

5

Or:

$sql = 'insert into news (news, display) values (:news, :display)';
$parameters = array(':user_id'=>'', ':created' => date('Y-m-d H:i:s'));
Yii::app()->db->createCommand($sql)->execute($parameters);

edited Feb 5, 2015 at 9:02

onalbi

2,7991 gold badge27 silver badges37 bronze badges

answered Jun 21, 2014 at 18:57

Jahongir Rahmonov

13.8k11 gold badges53 silver badges100 bronze badges

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

Comments

wamp · Accepted Answer · 2014-06-22 18:55:38Z

3

Why do you execute a query in a view page?In the data access layer is the place you usually do it from. You can try first in the controller.

Here you can read about Data Access Objects in Yii: http://www.yiiframework.com/doc/guide/1.1/en/database.dao

answered Jun 22, 2014 at 18:55

wamp

601 gold badge1 silver badge6 bronze badges

Comments

Jahongir Rahmonov · Accepted Answer · 2014-06-21 18:52:37Z

0

Try this:

$news = new News();
$news->news = "anything";
$news->display = 0;
$news->save(false);

answered Jun 21, 2014 at 18:52

Jahongir Rahmonov

13.8k11 gold badges53 silver badges100 bronze badges

6 Comments

Jahongir Rahmonov Over a year ago

@user3194430 do you have News model?

Jahongir Rahmonov Over a year ago

I posted one more answer, try that and let me know

MD.MD Over a year ago

ohh, I forgot to mention that the php file that contian this code is not in the protected dir

MD.MD Over a year ago

i know, but I putted it outside the protected dir, because thers is an ajax function need to use the file

Jahongir Rahmonov Over a year ago

I am not sure bro) Why dont you do your ajax functions in controller?

|

Collectives™ on Stack Overflow

how to execute sql query in yii?

3 Answers 3

Comments

Comments

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related