protected function add(Member $member) { $requete = $this->dao->prepare('INSERT INTO T_mem_memberc SET mmc_username = :username, mmc_password = :password, mmc_description = :description, mmc_mail = :mail'); $requete->bindValue(':username', htmlspecialchars($member->username())); $requete->bindValue(':password', htmlspecialchars($member->password())); $requete->bindValue(':description', htmlspecialchars($member->description())); $requete->bindValue(':mail', htmlspecialchars($member->mail())); $requete->execute(); }
protected function modify(Member $member) { $requete = $this->dao->prepare('UPDATE T_NEW_memberc SET NMC_pseudo = :pseudo, NMC_password = :password, NMC_philosophy = :philosophy, NMC_fk_NMY = :type WHERE NMC_id = :id'); $requete->bindValue(':pseudo', $member->pseudo()); $requete->bindValue(':password', $member->password()); $requete->bindValue(':philosophy', $member->philosophy()); $requete->bindValue(':type', $member->type(), \PDO::PARAM_INT); $requete->bindValue(':id', (int) $member->id(), \PDO::PARAM_INT); $requete->execute(); }
public function modify(Member $Member) { $requete = $this->dao->prepare('UPDATE T_FOR_memberc SET FMC_login = :login, FMC_password = :password, FMC_fk_FMY = :level, FMC_dateupdate = NOW() WHERE FMC_id = :id'); $requete->bindValue(':login', $Member->login(), \PDO::PARAM_STR); $requete->bindValue(':password', $Member->password(), \PDO::PARAM_STR); $requete->bindValue(':level', $Member->level(), \PDO::PARAM_INT); $requete->bindValue(':id', (int) $Member->id(), \PDO::PARAM_INT); $requete->execute(); }