INSERT avec jointure

	public function AjoutMembre() {
		$sql = "INSERT INTO tb_adherent(nom, prenom, email, naissance, fixe, mobile, adresse, lieu_dit, code_postal, ville, pseudo, password)
				VALUES(:nom, :prenom, :email, :naissance, :fixe, :mobile, :adresse, :lieu_dit, :code_postal, :ville, :pseudo, :password)";
		$requete = $this->bdd->prepare($sql);
		$donnees = $requete->execute(array(
					'nom' 			=> $this->nom,
					'prenom' 		=> $this->prenom,
					'email' 		=> $this->email,
					'naissance' 	=> $this->naissance,
					'fixe' 			=> $this->fixe,
					'mobile' 		=> $this->mobile,
					'adresse' 		=> $this->adresse,
					'lieu_dit' 		=> $this->lieu_dit,
					'code_postal' 	=> $this->code_postal,
					'ville' 		=> $this->ville,
					'pseudo' 		=> $this->pseudo,
					'password' 		=> $this->password,
					));
		
		$id_adherent = $this->bdd->lastInsertId();		
		
		$sql2 = "INSERT INTO tb_entree(debut, fin)
				VALUES(:debut, :fin)";
		$requete2 = $this->bdd->prepare($sql2);
		$donnees = $requete2->execute(array(
									'debut' => $this->debut,
									'fin' 	=> $this->fin,
									));
		
		$rid_entree = $this->bdd->lastInsertId();
		
		$sql = "INSERT INTO tb_adherent_tb_entree(rid_adherent, rid_entree)
				VALUES(:rid_adherent, :rid_entree)";
		$requete = $this->bdd->prepare($sql);
		$requete->execute(array(
									'rid_adherent' 	=> $id_adherent,
									'rid_entree' 	=> $rid_entree,
								));
		return $donnees;		
	}

	public function AjoutDateEntree() {
		$sql = "INSERT INTO tb_entree(debut, fin)
				VALUES(:debut, :fin)";
		$requete = $this->bdd->prepare($sql);
		$donnees = $requete->execute(array(
									'debut' => $this->debut,
									'fin' 	=> $this->fin,
									));
		
		$id_adherent = $this->bdd->lastInsertId();
		
		$sql = "INSERT INTO tb_adherent_tb_entree(rid_adherent, rid_entree)
				VALUES(:rid_adherent, :rid_entree)";
		$requete = $this->bdd->prepare($sql);
		$requete->execute(array(
									'rid_adherent' 	=> $id_adherent,
									'rid_entree' 	=> $this->rid_entree,
									));
		return $donnees;		
	}