本文整理汇总了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);
}