How to print the executed sql string from active record ?

Archives Yii 1.0.x Discussions
1

Hi guys, I have seen here somewhere about printing the executed sql from an active record, but I think I’ve lost it, searched but can’t find it. So, please how do I return the sql string executed from ActiveRecord ?

Thanks!

2

The easiest is to active CWebLogRoute. It adds debugging output to the bottom of every page.

http://www.yiiframework.com/doc/cookbook/34/

You can also set enableParamLogging=>true in your db component configuration.

3

Hey Mike, thanks, that I knew. I guess, I want to hear the hardest one ? ???

4

What about within phpunit test scripts when you want to print it to the console or display in some other way?