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); }