Yii's own query builder is still very useful, which eliminates the process of spelling SQL. Today I encountered such a problem when writing a sentence.
$connection = Yii::app()->db;
$command = $connection->createCommand();
$operate_rst = 0;
if(!empty($_POST['lid'])){
$operate_rst = $command->update('emg_landing', $landing_info, 'lid=:lid', array(':lid' => $_POST['lid']));
}
else{
$operate_rst = $command->insert('emg_landing', $landing_info);
}
$connection->active = false;
if($operate_rst > 0){
Functions::returnOk('OK!');
}
Functions::returnErrorJson();
Use $operate_rst to record the operation results. There is no problem in executing the new insert, but when updating, sometimes the operation fails. After checking for a long time, the reason cannot be found, so I have to translate the document
/doc/api/1.1/CDbCommand#update-detail
Seeing the return item is
{return} integer number of rows affected by the execution.
I immediately understood the problem, because sometimes the data may not be changed but the update operation is triggered, so at this time the number of lines that have been changed is 0, and the returned judgment enters the error code. .
Similarly, the return value of delete() and insert() methods is also the number of rows affected, so delete and insert can determine whether the operation is successful based on whether the return value is greater than 0, but the update operation is not necessarily. The return value of 0 may also indicate that the DB operation is successful.