public function add(Terrain $terrain) { $query = $this->_db->prepare('INSERT INTO t_terrain (prix, vendeur, fraisAchat, superficie, emplacement, idProjet, created, createdBy) VALUES (:prix, :vendeur, :fraisAchat, :superficie, :emplacement, :idProjet, :created, :createdBy)') or die(print_r($this->_db->errorInfo())); $query->bindValue(':prix', $terrain->prix()); $query->bindValue(':vendeur', $terrain->vendeur()); $query->bindValue(':fraisAchat', $terrain->fraisAchat()); $query->bindValue(':superficie', $terrain->superficie()); $query->bindValue(':emplacement', $terrain->emplacement()); $query->bindValue(':idProjet', $terrain->idProjet()); $query->bindValue(':created', $terrain->created()); $query->bindValue(':createdBy', $terrain->createdBy()); $query->execute(); $query->closeCursor(); }
public function add(Terrain $terrain) { $query = $this->_db->prepare(' INSERT INTO t_terrain ( numeroTitre,nom,superficie,surplan,emplacement,prix, status, idProjet,created,createdBy) VALUES (:numeroTitre,:nom,:superficie,:surplan,:emplacement,:prix, :status,:idProjet,:created,:createdBy)') or die(print_r($this->_db->errorInfo())); $query->bindValue(':numeroTitre', $terrain->numeroTitre()); $query->bindValue(':nom', $terrain->nom()); $query->bindValue(':superficie', $terrain->superficie()); $query->bindValue(':surplan', $terrain->surplan()); $query->bindValue(':emplacement', $terrain->emplacement()); $query->bindValue(':prix', $terrain->prix()); $query->bindValue(':status', $terrain->status()); $query->bindValue(':idProjet', $terrain->idProjet()); $query->bindValue(':created', $terrain->created()); $query->bindValue(':createdBy', $terrain->createdBy()); $query->execute(); $query->closeCursor(); }