public function getOne($id) { $query = new MysqlQuery('SELECT groups.id , groups.name FROM groups WHERE groups.id = $1'); $query->addParam($id); return $query->query()->fetchOne(); }
public function isValidUser($username, $password) { $query = new MysqlQuery('SELECT id , firstname , lastname , salt , password FROM users WHERE username = $1'); $query->addParam($username); $result = $query->query(); if ($result->numRows() == 1) { $user = $result->fetchOne(); if ($this->bcrypt($password, $user['salt']) == $user['password']) { $user['groups'] = $this->getUserGroups($user['id']); return $user; } else { return false; } } else { return false; } }