public static function saveUser(User $user)
{
//Aiguilleur Insert/Update
$req = DataBase::getInstance()->prepare('SELECT COUNT(id) FROM user_data WHERE id = :id');
$req->bindvalue('id', $user->getId(), PDO::PARAM_INT);
$req->execute();
$count = $req->fetchColumn();
$req->closeCursor();
if ($count == 0) {
$req = DataBase::getInstance()->prepare('INSERT INTO user_data (login, password, name, surname, mail) VALUES (:login, :password, :name, :surname, :mail)');
} else {
$req = DataBase::getInstance()->prepare('UPDATE user_data SET (login = :login, password = :password, name = :name, surname = :surname, mail = :mail) WHERE id = :id');
$req->bindvalue('id', $user->getId(), PDO::PARAM_INT);
}
$req->bindValue('login', $user->getLogin(), PDO::PARAM_STR);
$req->bindValue('password', $user->getHashedPassword(), PDO::PARAM_STR);
$req->bindValue('name', $user->getName(), PDO::PARAM_STR);
$req->bindValue('surname', $user->getSurname(), PDO::PARAM_STR);
$req->bindValue('mail', $user->getMail(), PDO::PARAM_STR);
$req->execute();
$req->closeCursor();
if ($count == 0) {
$user->setId(DataBase::getInstance()->lastInsertId());
}
}
