本文整理匯總了PHP中DbCommand::execute方法的典型用法代碼示例。如果您正苦於以下問題：PHP DbCommand::execute方法的具體用法？PHP DbCommand::execute怎麽用？PHP DbCommand::execute使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類DbCommand的用法示例。
在下文中一共展示了DbCommand::execute方法的2個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: break_relation
protected function break_relation($object)
{
if (isset($this->options['through'])) {
$rel_table = $this->options['through'];
$local_field = $this->get_local_field();
$foreign_field = $this->get_foreign_field($this->foreign_model);
$local_id = $this->local_model->primary_key_value();
$foreign_id = $object->primary_key_value();
//TODO: fix it to a more generic way
if (isset($this->options['module'])) {
$module = $this->options['module'];
DbCommand::execute("DELETE FROM `{$rel_table}` WHERE `{$local_field}` = '{$local_id}' and `{$foreign_field}` = '{$foreign_id}' and `module` = '{$module}'");
} else {
DbCommand::execute("DELETE FROM `{$rel_table}` WHERE `{$local_field}` = '{$local_id}' and `{$foreign_field}` = '{$foreign_id}'");
}
} else {
$local_field = $this->get_foreign_field($this->local_model);
$object->{$local_field} = null;
$object->save();
}
}示例2: update
private function update()
{
$this->write_magic_time('updated_at');
$pk = $this->primary_key();
$pk_value = $this->sanitize($this->{$pk});
$table = $this->table();
$fields = $this->map_real_fields();
$sql_set = array();
foreach ($fields as $key => $value) {
$sql_set[] = "`{$key}` = " . $this->prepare_for_value($value);
}
$sql_set = implode(",", $sql_set);
$sql = "UPDATE `{$table}` SET {$sql_set} WHERE `{$pk}` = '{$pk_value}';";
DbCommand::execute($sql);
}