1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39
|
protected function add(ContenuAdherent $Adherent)
{
$requete = $this->db->prepare('INSERT INTO ef_adherent SET
adherent_nom = :nom,
adherent_prenom = :prenom,
adherent_datenaiss = :datenaiss,
adherent_lieunaiss= :lieunaiss,
adherent_adresse = :adresse,
adherent_cp = :cp,
adherent_ville = :ville,
adherent_pays = :pays,
adherent_tel = :tel,
adherent_email = :email,
adherent_date_creation = NOW(),
adherent_statut = :statut,
adherent_paiement = :paiement');
$requete->bindValue(':nom', $Adherent->getAdherentNom());
$requete->bindValue(':prenom', $Adherent->getAdherentPrenom());
$requete->bindValue(':datenaiss', $Adherent->getAdherentdatenaiss());
$requete->bindValue(':lieunaiss', $Adherent->getAdherentlieunaiss());
$requete->bindValue(':adresse', $Adherent->getAdherentAdresse());
$requete->bindValue(':cp', $Adherent->getAdherentCp());
$requete->bindValue(':ville', $Adherent->getAdherentVille());
$requete->bindValue(':pays', $Adherent->getAdherentPays());
$requete->bindValue(':tel', $Adherent->getAdherentTel());
$requete->bindValue(':email', $Adherent->getAdherentEmail());
$requete->bindValue(':statut', $Adherent->getAdherentStatut());
$requete->bindValue(':paiement', $Adherent->getAdherentPaiement());
$requete->execute();
$id = $this->db->lastInsertId();
return $id;
} |
Partager