how to get bind param array in Yii create command

Question

Is there any way in yii to get the array of the parameters passed in createCommand?

     $countSQL= 'my sql query ';
     $command = Yii::app()->db->createCommand($countSQL);   
     $command->bindValue(":param1",'%'.$param1.'%');
     $command->bindValue(":param2",'%'.$param2.'%');
     $command->queryAll();

I want to know if it there is any way to get the array which will be similar to

array(
 ":param1" => '%'.$param1.'%',
 ":param2" => '%'.$param2.'%',
)

Use the bindValues() method.yiiframework.com/doc/api/1.1/CDbCommand#bindValues-detail — gpr
– gpr, Commented May 11, 2015 at 11:21

Sanjay Mohnani · Accepted Answer · 2015-05-11 11:24:55Z

1

You can get those parameters but only with extending some library files like PDO Connection and CDbCommand.

In my project, I had created extended CPdoConnection and CDbCommand.

I had code for you, let me know if you need it.

Regards, Sanjay

answered May 11, 2015 at 11:24

Sanjay Mohnani

1,0109 silver badges18 bronze badges

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

Collectives™ on Stack Overflow

how to get bind param array in Yii create command

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related