How do I print the last query executed in Yii php framework?

Question

This is my code:

$ptoRequests = CalendarRequest::model()
                    ->with(array('intervals'))
                    ->findAll(array('order' => 't.time, t.id desc',
                'condition' => 'eventId in (5, 7, 8, 9, 10, 11) and statusId in (1,2) and userId = "' . $user->userId . '" and (intervals.enddate >= :from)',
                'params' => array('from' => date("Y-m-d"))));
                echo "<pre>"; var_dump($ptoRequests->getQuery()); echo "</pre>"; exit();

What I want to achieve is to print the last query executed. The getQuery() function returns me a fatal error. What should I do ? Thx

stackoverflow.com/questions/21231729/yii-echo-the-last-query On this github page: github.com/yiisoft/yii2/issues/1173, you can see developers bounced your specific functionality at the moment is was requested — mvbrakel
– mvbrakel, Commented Mar 16, 2015 at 13:38
I am no YII pro.. But could it be the with() function is not satified in the model and therefor no query has been made? — mvbrakel
– mvbrakel, Commented Mar 16, 2015 at 13:47

Talha Malik · Accepted Answer · 2015-03-17 12:08:48Z

1

Try this

echo ModelClassName::model()->
getCommandBuilder()->
createFindCommand('table_name', $criteria)->text;

where $criteria is

$criteria= new CDbCriteria();
$criteria->condition="your query condition";
$criteria->order="t.time desc"

check CDbCriteria here for reference

answered Mar 17, 2015 at 12:08

Talha Malik

1,5593 gold badges23 silver badges46 bronze badges

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

Collectives™ on Stack Overflow

How do I print the last query executed in Yii php framework?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related