Yii how to check if query execution failed

Question

I M Using YII to develop web application

i want to check if query executed successfully or not

$data = Yii::app()->db->createCommand($SQL);
$result = $data->queryAll();

if(count($result) == 0)
{
    throw new SoapFault('Sender', 'Unable to get display information.');
}

if code will execute if select query return no result-set. but i want to check if query executed successfully or not. based on that i want to throw exception. then if query executed successfully and returned no result-set then some other exception.

how to do this ? any suggestions ?

Yii will throw an exception by itself if the query fails due to syntax errors or other problems. — user1233508
– user1233508, Commented Mar 25, 2014 at 6:45
for service to execute properly i need to throw error explicitly... — Chintan_chiku
– Chintan_chiku, Commented Mar 25, 2014 at 7:05

Waqar Alamgir · Accepted Answer · 2016-10-09 16:37:53Z

5

try {
    $result = $data->queryAll();
} catch (Exception $ex) {
    echo 'Query failed', $ex->getMessage();
}

edited Oct 9, 2016 at 16:37

answered Mar 25, 2014 at 6:43

Waqar Alamgir

9,9884 gold badges33 silver badges37 bronze badges

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

4 Comments

Petruza Over a year ago

I made a DBCommand with a param and wrongfully added quotes: UPDATE ... WHERE hash = ':hash', the command didn't work but didn't throw an exception either. What should one do in such a case?

Waqar Alamgir Over a year ago

If a query has syntax error or failed to execute on database it throws exception. What do you mean by command didn't work? If you have logging setup-ed you can debug SQL generated by yii (log file in runtime dir).

Petruza Over a year ago

What I mean is that the update doesn't take place. The query per-se has no error, but as Yii adds its own quotes when replacing a string parameter, I guess the quotes I added in the query conflict with that, but the query does not throw an SQL error because the query never gets ran actually.

Waqar Alamgir Over a year ago

Well this is fine i think, can you post the code so I can see what is going wrong? Alternatively you can throw your own exception if no rows effected!

Deb · Accepted Answer · 2016-09-12 06:45:19Z

0

try 
{
   $result = Yii::app()->db->createCommand($sqlQuery)->execute();
   echo  'success';
}
catch (Exception $e) 
{
   echo  'fail';
}

answered Sep 12, 2016 at 6:45

Deb

5356 silver badges6 bronze badges

Collectives™ on Stack Overflow

Yii how to check if query execution failed

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related