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