Createcommand | Yii Answers

ASK NEW QUESTION

Home Page » createCommand

0 Votes

8Answers

createCommand() only can use one time?

$command=Yii::app()->db->createCommand();
$result1=$command->select('test')->queryRow();
$result2=$command->select('test2')->queryRow();
$result3=$command->select('test3')->queryRow();

$command=Yii::app()->db->createCommand();
$result1=$command->select('test')->queryRow();
$result2=$command->select('test2')->queryRow();
$result3=$command->select('test3')->queryRow();

the $result1,$result2,$result3 all the same as $result1, why the $command only use one time?I need to write code as below:

$command1=Yii::app()->db->createCommand();
$command2=Yii::app()->db->createCommand();
$command3=Yii::app()->db->createCommand();
$result1=$command1->select('test')->queryRow();
$result2=$command2->select('test2')->queryRow();
$result3=$command3->select('test3')->queryRow();

$command1=Yii::app()->db->createCommand();
$command2=Yii::app()->db->createCommand();
$command3=Yii::app()->db->createCommand();
$result1=$command1->select('test')->queryRow();
$result2=$command2->select('test2')->queryRow();
$result3=$command3->select('test3')->queryRow();

I think thisREAD MORE