public function modify(User $user)
{
$sql = "UPDATE utilisateur\n\t\t\tSET login = :login,\n\t\t\tpwd = :pwd,\n\t\t\tnom = :nom,\n\t\t\tprenom = :prenom,\n\t\t\tadresse = :adresse\n\t\t\tWHERE idUtilisateur = :idUtilisateur";
$id = $user->getIdUtilisateur();
$log = $user->getLogin();
$password = $user->getPwd();
$name = $user->getNom();
$surname = $user->getPrenom();
$adress = $user->getAdresse();
$req = $this->_db->prepare($sql);
$req->bindParam(':idUtilisateur', $id, PDO::PARAM_STR);
$req->bindParam(':login', $log, PDO::PARAM_STR);
$req->bindParam(':pwd', $password, PDO::PARAM_STR);
$req->bindParam(':nom', $name, PDO::PARAM_STR);
$req->bindParam(':prenom', $surname, PDO::PARAM_STR);
$req->bindParam(':adresse', $adress, PDO::PARAM_STR);
$req->execute();
$nbTupleObt = $req->rowCount();
$req->closeCursor();
if ($nbTupleObt < 1) {
return false;
}
return true;
}
/**
* bool resetPwd(User $user)
*
* Resets an user password in the users table.
*
* @param User $user user to update
* @return boolean returns false, if error occurs
* @access public
*/
function resetPwd($user)
{
if (!$user instanceof User) {
$this->_error = "Argument is an inappropriate object.";
return false;
}
$sql = "UPDATE " . $this->_table . " SET";
$sql .= " pwd='" . urlencode($user->getPwd()) . "'";
// md5 from form
$sql .= " WHERE id_user="******";";
return $this->exec($sql);
}
