';
			// var_dump($mail);
			$query->CloseCursor();
			$query=$bdd->prepare('SELECT user_id FROM users WHERE username=:username');//look for unique mail step2
			$query->bindValue(':username',$_POST["oldusername"],PDO::PARAM_STR);
			$query->execute();
			$id=$query->fetch();
			// var_dump($id);
			$query->CloseCursor();
			if($_POST["user"]!=$_POST["oldusername"]){
				$query=$bdd->prepare('SELECT user_id FROM users WHERE username=:username');//look for unique new username
				$query->bindValue(':username',$_POST["user"],PDO::PARAM_STR);
				$query->execute();
				$cusername=$query->fetch();
				$query->CloseCursor();
			}
			// var_dump($cusername);
			if(!isset($cusername)||empty($cusername)){
				if((!$mail||$mail==$id)){
					$statutvalidation=(isset($_POST["statutvalidation"]))?$_POST["statutvalidation"]:0;
					$role=(isset($_POST["role"]))?$_POST["role"]:"user";
					$group=new managemyusers($bdd,$_POST['user'],md5($_POST['password']),$_POST['firstname'],$_POST['lastname'],$_POST['mail'],$_POST['groupid'],$role,$statutvalidation);
					$group->update($_POST['oldusername']);
				}else{
					echo 'This email address is already associated to another account';
				}
			}else{
				echo 'your new username is already used by another user please change it and try again 
';
			}
		}else{
			echo 'your email address can not be empty';
		}
	}else{
		echo "you have nothing to do here";
	}
?>