PHP Sql::pUpdate方法代码示例

 public function write($id, $data)
 {
     $time = time() + $this->expire_time;
     $q = 'REPLACE tblSessionData (session_id,session_data,expires) VALUES(?, ?, ?)';
     Sql::pUpdate($q, 'sss', $id, $data, sql_datetime($time));
     return true;
 }

 public function store()
 {
     $q = 'SELECT id FROM ' . self::$tbl_name . ' WHERE owner = ? AND season = ? AND episode = ?';
     $this->id = Sql::pSelectItem($q, 'iii', $this->owner, $this->season, $this->episode);
     if ($this->id) {
         $q = 'UPDATE ' . self::$tbl_name . ' SET owner = ?, title = ?, date = ?, info = ?, season = ?, episode = ?, link = ? WHERE id = ?';
         Sql::pUpdate($q, 'isssiisi', $this->owner, $this->title, $this->date, $this->info, $this->season, $this->episode, $this->link, $this->id);
         return $this->id;
     }
     $q = 'INSERT INTO ' . self::$tbl_name . ' SET owner = ?, title = ?, date = ?, info = ?, season = ?, episode = ?, link = ?';
     return Sql::pInsert($q, 'isssiis', $this->owner, $this->title, $this->date, $this->info, $this->season, $this->episode, $this->link);
 }

 public static function set($type, $owner, $name, $val)
 {
     $q = 'SELECT id FROM ' . self::$tbl_name . ' WHERE owner = ? AND type = ? AND name = ?';
     if (Sql::pSelectItem($q, 'iis', $owner, $type, $name)) {
         $q = 'UPDATE ' . self::$tbl_name . ' SET time_saved = NOW(), value = ?' . ' WHERE owner = ? AND type = ? AND name = ?';
         Sql::pUpdate($q, 'siis', $val, $owner, $type, $name);
     } else {
         $q = 'INSERT INTO ' . self::$tbl_name . ' SET time_saved = NOW(),' . 'owner = ?, type = ?, name = ?, value = ?';
         Sql::pInsert($q, 'iiss', $owner, $type, $name, $val);
     }
     return true;
 }

 /** Updates tblFiles entry with current file size & mime type, useful after Image resize / rotate etc */
 public static function sync($id)
 {
     $name = self::getUploadPath($id);
     if (!file_exists($name)) {
         throw new \Exception('cant sync nonexisting file, what do???');
     }
     $size = filesize($name);
     $mime = get_mimetype_of_file($name);
     $q = 'UPDATE tblFiles' . ' SET size = ?, mimetype = ?' . ' WHERE id = ?';
     Sql::pUpdate($q, 'isi', $size, $mime, $id);
 }

 /** Logs out the user */
 function logout()
 {
     dp($this->username . ' logged out');
     if (!$this->id) {
         throw new \Exception('already logged out');
     }
     Sql::pUpdate('UPDATE tblUsers SET time_last_logout = NOW() WHERE id = ?', 'i', $this->id);
     $params = session_get_cookie_params();
     setcookie(session_name(), '', time() - 604800, $params['path'], $params['domain'], $params['secure'], $params['httponly']);
     $page = XmlDocumentHandler::getInstance();
     $show_page = $this->logged_out_start_page ? $this->logged_out_start_page : $page->getRelativeUrl();
     header('Location: ' . $show_page);
     $this->end();
     die;
 }

 /**
  * Marks specified user as "deleted"
  */
 public function remove()
 {
     // also removes user from all user groups
     foreach (UserGroupHandler::getGroups($this->id) as $grp) {
         UserGroupHandler::removeFromGroup($this->id, $grp->id);
     }
     $q = 'UPDATE tblUsers SET time_deleted = NOW() WHERE id = ?';
     Sql::pUpdate($q, 'i', $this->id);
 }

 function save()
 {
     $session = SessionHandler::getInstance();
     if (!$this->id) {
         $q = 'SELECT groupId FROM tblUserGroups WHERE name = ?';
         $this->id = Sql::pSelectItem($q, 's', $this->name);
     }
     if ($this->id) {
         $q = 'UPDATE tblUserGroups SET name = ?, info = ?, level = ? WHERE groupId = ?';
         Sql::pUpdate($q, 'ssii', $this->name, $this->info, $this->level, $this->id);
     } else {
         $q = 'INSERT INTO tblUserGroups SET createdBy = ?, timeCreated = NOW(), name = ?, info = ?, level = ?';
         $this->id = Sql::pInsert($q, 'issi', $session->id, $this->name, $this->info, $this->level);
     }
     return $this->id;
 }

 public static function updateId($obj, $tblname, $field_name = 'id')
 {
     if (!is_alphanumeric($tblname) || !is_alphanumeric($field_name)) {
         throw new \Exception('very bad');
     }
     if (!$obj->{$field_name}) {
         d($obj);
         throw new \Exception('eehh');
     }
     $reflect = self::reflectQuery($obj, $field_name);
     $q = 'UPDATE ' . $tblname . ' SET ' . implode(', ', $reflect->cols) . ' WHERE ' . $field_name . ' = ?';
     $reflect->str .= is_numeric($obj->{$field_name}) ? 'i' : 's';
     $reflect->vals[] = $obj->{$field_name};
     return Sql::pUpdate($q, $reflect->str, $reflect->vals);
 }

 public static function deleteByOwner($type, $owner)
 {
     $session = SessionHandler::getInstance();
     $q = 'UPDATE ' . self::$tbl_name . ' SET deleted_by = ?, time_deleted = NOW()' . ' WHERE type = ? AND owner = ?';
     Sql::pUpdate($q, 'iii', $session->id, $type, $owner);
 }

 static function removePoll($id)
 {
     $session = SessionHandler::getInstance();
     $q = 'UPDATE tblPolls SET deleted_by = ?, time_deleted = NOW() WHERE id = ?';
     Sql::pUpdate($q, 'ii', $session->id, $id);
 }