Zend框架$db->更新结果 [英] Zend framework $db->update result

问题描述

Zend_Db_Adapter::update() 返回受更新操作影响的行数.确定查询是否成功的最佳方法是什么?

Zend_Db_Adapter::update() returns the number of rows affected by the update operation. What is best way to determine if the query was successful?

$data = array(
    'updated_on'      => '2007-03-23',
    'bug_status'      => 'FIXED'
); 

$n = $db->update('bugs', $data, 'bug_id = 2');

推荐答案

$data = array(
    'updated_on' => '2007-03-23',
    'bug_status' => 'FIXED',
);
$n = 0;
try {
    $n = $db->update('bugs', $data, 'bug_id = 2');
} catch (Zend_Exception $e) {
    die('Something went wrong: ' . $e->getMessage());
}
if (empty($n)) {
    die('Zero rows affected');
}

这篇关于Zend框架$db->更新结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！