public function delete()
{
$userSQL = new UserSQL($this);
$userSQL->delete();
}
public function save()
{
include $_SERVER["DOCUMENT_ROOT"] . "/modele/bdd/connect.php";
if (!UserSQL::getUserByID($this->_user->getID())) {
$sql = "INSERT INTO user VALUES (:id_user,:pseudo,:password,:mail,:phoneNumber,:birth,:avatar,:sexe,:country,:city,:inscription,:isOnline,:lastMessage,:lastConnexion)";
} else {
$sql = "UPDATE user SET \n\t\tpseudo=:pseudo,\n\t\tpassword=:password, \n\t\tmail=:mail,\n phoneNumber=:phoneNumber,\n\t\tbirth=:birth, \n\t\tavatar=:avatar,\n\t\tsexe=:sexe, \n\t\tcountry=:country,\n\t\tcity=:city, \n\t\tinscription=:inscription,\n isOnline=:isOnline, \n\t\tlastMessage=:lastMessage,\n\t\tlastConnexion=:lastConnexion\n\t\t\n\t\tWHERE id_user=:id_user";
}
$req = $bdd->prepare($sql);
$array = array(":id_user" => $this->_user->getID(), ":pseudo" => $this->_user->getPseudo(), ":password" => $this->_user->getPassword(), ":mail" => $this->_user->getMail(), ":phoneNumber" => $this->_user->getPhoneNumber(), ":birth" => $this->_user->getBirth(), ":avatar" => $this->_user->getAvatar(), ":sexe" => $this->_user->getSexe(), ":country" => $this->_user->getCountry(), ":city" => $this->_user->getCity(), ":inscription" => $this->_user->getInscription(), ":isOnline" => $this->_user->getIsOnline(), ":lastMessage" => $this->_user->getLastMessage(), ":lastConnexion" => $this->_user->getLastConnexion());
$req->execute($array);
}
