Example #1
0
 public function store(User $user)
 {
     if (!$this->db->tableExists($this->table)) {
         $this->createTable($this->table);
     }
     $query = "DELETE FROM :::table WHERE id=:id";
     $bindings = array(':::table' => $this->table, ':id' => $user->getID());
     try {
         $this->db->execute($query, $bindings);
     } catch (Exception $e) {
         throw new UserStorageException('Unable to store user.');
     }
     $query = "INSERT INTO :::table " . "(id, username, fullName, email, birthdate, gender, timezoneOffset, locale, lastLogin, secret) " . "VALUES (:id, :username, :fullName, :email, :birthdate, :gender, :timezoneOffset, :locale, :lastLogin, :secret)";
     $bindings = array(':::table' => $this->table, ':id' => $user->getID(), ':username' => $user->getUsername(), ':fullName' => $user->getFullName(), ':email' => $user->getEmail(), ':birthdate' => $user->getBirthdate(), ':gender' => $user->getGender(), ':timezoneOffset' => $user->getTimezoneOffset(), ':locale' => $user->getLocale(), ':lastLogin' => $user->getLastLogin(), ':secret' => $user->getSecret());
     try {
         $this->db->execute($query, $bindings);
     } catch (Exception $e) {
         throw new UserStorageException('Unable to store user.');
     }
 }
Example #2
0
 /**
  * Converts a user to an array.
  *
  * @param User $user the user to convert
  * @return array the array
  */
 private function userToArray(User $user)
 {
     $res = array();
     $res['id'] = $user->getID();
     $res['username'] = $user->getUsername();
     $res['fullName'] = $user->getFullName();
     $res['email'] = $user->getEmail();
     $res['birthdate'] = $user->getBirthdate();
     $res['gender'] = $user->getGender();
     $res['timezoneOffset'] = $user->getTimezoneOffset();
     $res['locale'] = $user->getLocale();
     $res['lastLogin'] = $user->getLastLogin();
     $res['secret'] = $user->getSecret();
     return $res;
 }