public function addUserToDatabase(\model\User $user)
{
//Checking if username already exists
if (isset($this->users[$user->getUserName()])) {
throw new \Exception("Username already exists");
} else {
if (isset($this->users[$user->getPassword()])) {
throw new \Exception("Password already exists");
} else {
//saving to "database with username as index key"
$key = $user->getUserName();
$this->users[$key] = $user->getPassword();
}
}
}
public function saveNewUser(\model\User $newUser)
{
$newUser->getUserName();
$file = fopen("data/" . $newUser->getUserName() . ".txt", "w");
fwrite($file, $newUser->getPassword());
fclose($file);
}
public function save(\model\User $user)
{
if ($this->doExists($user->getUsername())) {
throw new \Exception();
}
$stmt = $this->database->prepare("INSERT INTO `lab4` (`username` , `password`) VALUES (?, ?)");
if ($stmt === FALSE) {
throw new \Exception($this->database->error);
}
$username = $user->getUsername();
$password = $user->getPassword();
$stmt->bind_param('ss', $username, $password);
$stmt->execute();
}
/**
* Login user
*
* @param \model\User $credential
* @return bool
*/
public function doLogin(\model\User $credential)
{
$username = $credential->getUsername();
$password = $credential->getPassword();
$records = new \Db();
$records->query('SELECT username, password FROM users WHERE BINARY username = :username');
$records->bind(':username', $username);
$results = $records->single();
if (count($results) > 0 && password_verify($password, $results['password'])) {
return $this->sessionStorage->set(SessionStorage::$auth, $username);
} else {
return false;
}
}
/**
* @return bool
* Encrypts password with the php 5.5 hashing API (uses BCrypt)
*/
public function addUser(\model\User $user)
{
$successfulRegistration = false;
$users = $this->getAllUsers();
if ($users->isInList($user->getUsername())) {
throw new \UserAlreadyExistException("User exists, pick another username.");
}
try {
$db = $this->db->getConnection();
$sql = "INSERT INTO {$this->dbTable} (" . self::$usernameColumn . ", " . self::$passwordColumn . ") VALUES (?, ?)";
$params = array($user->getUsername(), password_hash($user->getPassword(), PASSWORD_DEFAULT));
$query = $db->prepare($sql);
$query->execute($params);
$successfulRegistration = true;
} catch (\PDOException $e) {
die("Database error, please try again later");
}
return $successfulRegistration;
}
/**
* @param User $user
* @return bool
* @throws \EmtpyPasswordException
* @throws \EmtpyUsernameException
*/
public function authenticateUser(\model\User $user)
{
$username = $user->getUserName();
$password = $user->getPassword();
if (empty($username)) {
throw new \common\EmtpyUsernameException();
}
if (empty($password)) {
throw new \common\EmtpyPasswordException();
}
if (file_exists("data/" . $username . ".txt")) {
$handle = fopen("data/" . $username . ".txt", "r");
$contents = fread($handle, filesize("data/" . $username . ".txt"));
fclose($handle);
if ($contents === $password) {
$this->setUserLoggedInSession();
return true;
} else {
return false;
}
} else {
return false;
}
}
function persist(User $user)
{
$requete = "INSERT INTO user(id, login, password) value(:id, :login,:password)";
$param = array('id' => $user->getId(), 'login' => $user->getLogin(), 'password' => $user->getPassword());
$this->conn->prepareAndExecuteQuery($requete, $param);
}
public function persist(User $user)
{
$query = "INSERT INTO USERS VALUES (:user_id, :user_name, :user_password)";
return $this->connection->executeQuery($query, [':user_id' => $user->getId(), ':user_name' => $user->getName(), ':user_password' => $user->getPassword()]);
}
/**
* This method sends new users data to the database
* @param User $registerData
*/
public function registerNewUserInDB(User $registerData)
{
$query = $this->connect->prepare("INSERT INTO `" . self::TABLE_NAME . "` VALUES ('', ?, ?, ?, ?)");
$query->bind_param('ssss', $this->escape_string($registerData->getNickname()), $this->escape_string($registerData->getPassword()), $this->escape_string($registerData->getRealName()), $this->escape_string($registerData->getUserID()));
$query->execute();
}
