public function update(Adherent $data)
{
$q = $this->base->prepare('UPDATE adherents SET nom=:nom,prenom=:prenom,dateNaissance=:dn,lieu=:lieu,sexe=:sexe,region=:region,departement=:departement,ethnie=:ethnie,nationalite=:nat,profession_mere_parrain=:profession_mere_parrain,situationMatrimoniale=:situationMatrimoniale,lieuResidence=:lieuResidence,adresse=:adresse,telperso=:telperso,sosTel=:sosTel,sosName=:sosName,diplomeEleve=:diplomeEleve,dateAndObtentionPlace=:dateAndObtentionPlace,speakLanguage=:speakLanguage,filiere=:filiere WHERE id=:id');
$q->execute(array('nom' => $data->getNom(), 'prenom' => $data->getPrenom(), 'dn' => $data->getDateNaissance(), 'lieu' => $data->getLieu(), 'sexe' => $data->getSexe(), 'region' => $data->getRegion(), 'departement' => $data->getDepart(), 'ethnie' => $data->getEthnie(), 'nat' => $data->getNationalite(), 'profession_mere_parrain' => $data->getProf(), 'situationMatrimoniale' => $data->getSituation(), 'lieuResidence' => $data->getLieuR(), 'adresse' => $data->getAddr(), 'telperso' => $data->getTelperso(), 'sosTel' => $data->getSosTel(), 'sosName' => $data->getSosName(), 'diplomeEleve' => $data->getDiplome(), 'dateAndObtentionPlace' => $data->getPlace(), 'speakLanguage' => $data->getLang(), 'filiere' => $data->getFiliere(), 'id' => $data->getId()));
}