本文整理匯總了PHP中Zend_Db_Adapter_Pdo_Mysql::update方法的典型用法代碼示例。如果您正苦於以下問題：PHP Zend_Db_Adapter_Pdo_Mysql::update方法的具體用法？PHP Zend_Db_Adapter_Pdo_Mysql::update怎麽用？PHP Zend_Db_Adapter_Pdo_Mysql::update使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類Zend_Db_Adapter_Pdo_Mysql的用法示例。
在下文中一共展示了Zend_Db_Adapter_Pdo_Mysql::update方法的2個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: update
/**
* Updates table rows with specified data based on a WHERE clause.
*
* @param mixed $table The table to update.
* @param array $bind Column-value pairs.
* @param mixed $where UPDATE WHERE clause(s).
* @return int The number of affected rows.
*/
public function update($table = null, array $bind = null, $where = '')
{
if (is_null($table) && is_null($bind) && !strlen($where)) {
return new Harmoni_Db_Update($this);
} else {
return parent::update($table, $bind, $where);
}
}示例2: _updateOccurrence
/**
* update tag occurrrence
*
* @param Tinebase_Model_Tag|string $tag
* @param integer $toAddOrRemove
*/
protected function _updateOccurrence($tag, $toAddOrRemove)
{
if ($toAddOrRemove == 0) {
return;
}
$tagId = $tag instanceof Tinebase_Model_Tag ? $tag->getId() : $tag;
if (Tinebase_Core::isLogLevel(Zend_Log::DEBUG)) {
Tinebase_Core::getLogger()->debug(__METHOD__ . '::' . __LINE__ . " de/increasing tag occurrence of {$tagId} by {$toAddOrRemove}");
}
$quotedIdentifier = $this->_db->quoteIdentifier('occurrence');
if ($toAddOrRemove > 0) {
$toAdd = (int) $toAddOrRemove;
$data = array('occurrence' => new Zend_Db_Expr($quotedIdentifier . ' + ' . $toAdd));
} else {
$toRemove = abs((int) $toAddOrRemove);
$data = array('occurrence' => new Zend_Db_Expr('(CASE WHEN (' . $quotedIdentifier . ' - ' . $toRemove . ') > 0 THEN ' . $quotedIdentifier . ' - ' . $toRemove . ' ELSE 0 END)'));
}
$this->_db->update(SQL_TABLE_PREFIX . 'tags', $data, $this->_db->quoteInto($this->_db->quoteIdentifier('id') . ' = ?', $tagId));
}