/** * Memperbarui record tertentu. * * @param integer $id * @param array $data * @return boolean */ public function update($id, $data = []) { try { if (!is_array($id)) { $id = [$this->primaryKey => $id]; } $this->db->update($this->table, $id, $data); return true; } catch (\Exception $e) { die($e->getMessage); } }
static function set_config($name, $value) { $one = DB::one('core_config', array('where' => array('slug' => $name))); if ($one) { DB::update('core_config', array('body' => $value), 'slug=:slug', array(':slug' => $name)); } else { DB::insert('core_config', array('slug' => $name, 'body' => $value)); } }
function actionDisplay($id, $form) { $id = (int) $id; if ($id < 1) { exit; } $one = DB::one('comment', array('where' => array('id' => $id))); $display = $one['display'] == 1 ? 0 : 1; DB::update('comment', array('display' => $display), 'id=:id', array(':id' => $id)); flash('success', __('sucessful')); $this->redirect(url('comment/site/index', array('form' => $form))); }
function member_get_third_set_user($me, $oauth_id, $token) { $me['email'] = $me['email'] ?: 'info'; $uniqid = md5(uniqid(microtime())); if (!$me['id']) { flash('error', __('login failed')); $this->redirect(return_url()); } $one = DB::one('oauth_users', array('where' => array('uid' => $me['id'], 'oauth_id' => $oauth_id))); if ($one) { DB::update('oauth_users', array('name' => $me['name'], 'email' => $me['email'], 'token' => $token, 'uuid' => $uniqid), "id=:id", array(':id' => $one['id'])); } else { DB::insert('oauth_users', array('uid' => $me['id'], 'name' => $me['name'], 'email' => $me['email'], 'oauth_id' => $oauth_id, 'token' => $token, 'uuid' => $uniqid)); } $one = DB::one('oauth_users', array('where' => array('uuid' => $uniqid, 'oauth_id' => $oauth_id))); if ($one) { $value = array('id' => $one['id'], 'name' => $one['name'], 'email' => $one['email'], 'oauth' => true); cookie('user', json_encode($value), 0); } }