Esempio n. 1
0
 /**
  * Удалить запись
  * @return int
  * @throws \Base\Db\MySql\Exception
  */
 public function delete()
 {
     return Service::db()->delete('DELETE FROM ' . static::$TABLE . ' WHERE id = :id', ['id' => $this->id]);
 }
Esempio n. 2
0
 /**
  * Грузим по токену
  * @param $token
  * @return null
  */
 public function loadByToken($token)
 {
     $data = Service::db()->select('SELECT ' . implode(',', static::$fields) . ' FROM ' . self::$TABLE . " WHERE token = :token AND UNIX_TIMESTAMP(tokenExpired) > UNIX_TIMESTAMP(:tokenExpired) LIMIT 0,1", ['token' => $token, 'tokenExpired' => date('Y-m-d H:i:s')]);
     if (isset($data[0])) {
         $this->assign($data[0]);
     }
     return $this;
 }