How to print converted SQL query from yii2 query

Question

I want to print query:

$demo = Demo::find()->all();

I want to see converted SQL query with parameters:

createCommand()->getRawSql();

is showing me an error message:

yii2 Call to a member function createCommand() on a non-object

Please help me to see the actual SQL query.

This question already been answered <stackoverflow.com/questions/27389146/…> — BHoft
– BHoft, Commented Nov 10, 2016 at 7:54
No the the queston and the asnwer in the link is not related to this question .. — ScaisEdge
– ScaisEdge, Commented Nov 10, 2016 at 10:44

Thao Ngo · Accepted Answer · 2016-11-11 14:09:35Z

40

Eg:

$query = Demo::find()->where(['category'=>2]);
echo $query->createCommand()->getRawSql();

answered Nov 11, 2016 at 14:09

Thao Ngo

3,7811 gold badge23 silver badges24 bronze badges

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

Comments

BHoft · Accepted Answer · 2016-11-10 12:53:48Z

6

$demo = Demo::find()->all();

returns an array of all models not the actual sql.

if you want the sql use this (this is the sql which is excecuted)

$query = Demo::find()->where('1');
var_dump($query->prepare(Yii::$app->db->queryBuilder)->createCommand()->rawSql)

answered Nov 10, 2016 at 12:53

BHoft

1,67311 silver badges18 bronze badges

Comments

ScaisEdge · Accepted Answer · 2016-11-10 07:53:04Z

5

A simple way is use the Active Query Builder createCommand method

  $sqlCommand = Demo::find()->createCommand();

  echo $sqlCommand->sql;

see this for refernce http://www.yiiframework.com/doc-2.0/yii-db-activequery.html and http://www.yiiframework.com/doc-2.0/yii-db-activequery.html#createCommand()-detail

answered Nov 10, 2016 at 7:53

ScaisEdge

134k10 gold badges98 silver badges111 bronze badges

4 Comments

Paritosh Mahale Over a year ago

it showing me an error message "Call to a member function createCommand() on a non-object"

ScaisEdge Over a year ago

Be sure that Demo::Find() is a valid object .. and you have access .. eventually update your question and show your code .. where use are using this statements

Paritosh Mahale Over a year ago

yes, Demo::find()->all(); returns an array of object . and i am using this query in method of model class

ScaisEdge Over a year ago

You don't should use Demo::find()->all(); but Demo::find()->createCommand(); .. you must substitute all() with createComman() if you want see the resulting query .. Demo::find()->all(); return the row model objec not the sql intruction for retrieve this rows

Mohan · Accepted Answer · 2016-11-10 12:05:07Z

2

Hiii Paritosh,
You can view the query that is being executed in SQl format by yii\db\Connection::createCommand() objects like

$query = new \yii\db\Query;
        $query->select(['*'])
                ->from('table_demo');

        $command = $query->createCommand();

//      $command->sql returns the actual SQL
        $rows = $command->sql;
        echo $rows;
        exit;

answered Nov 10, 2016 at 12:05

Mohan

6164 silver badges11 bronze badges

Comments

TomoMiha · Accepted Answer · 2021-05-31 09:31:28Z

0

Easiest way is to select some non-existing field, for example:

Demo::find()->select('nonExistingField')->all();

and see the debug message like this:

The SQL being executed was: SELECT `nonExistingField` ...

This way, you dont need to remove your ->all() or ->one() calls.

answered May 31, 2021 at 9:31

TomoMiha

1,2762 gold badges14 silver badges13 bronze badges

Comments

WeSee · Accepted Answer · 2021-06-15 10:57:02Z

0

The shortest way is probably:

echo Demo::find()->createCommand()->rawSql;

answered Jun 15, 2021 at 10:57

WeSee

3,8345 gold badges39 silver badges70 bronze badges

Collectives™ on Stack Overflow

How to print converted SQL query from yii2 query

6 Answers 6

Comments

Comments

4 Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

Comments

4 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related