public function fetchByUsername($username) { $user = null; $userDb = $this->_connection->query("SELECT * FROM " . $this->_table . " WHERE username = '******'")->fetch_object(); if ($userDb) { $user = new \App\User\User(); $user->setId($userDb->id)->setPassword($userDb->password)->setUsername($userDb->username); if (!empty($userDb->options)) { $options = json_decode($userDb->options, true); if (is_array($options)) { $user->setOptions($options); } } } return $user; }