public function add(Commande $commande){ $query = $this->_db->prepare(' INSERT INTO t_commande ( idFournisseur, idProjet, dateCommande, numeroCommande, designation, status, codeLivraison, created, createdBy) VALUES (:idFournisseur, :idProjet, :dateCommande, :numeroCommande, :designation, :status, :codeLivraison, :created, :createdBy)') or die (print_r($this->_db->errorInfo())); $query->bindValue(':idFournisseur', $commande->idFournisseur()); $query->bindValue(':idProjet', $commande->idProjet()); $query->bindValue(':dateCommande', $commande->dateCommande()); $query->bindValue(':numeroCommande', $commande->numeroCommande()); $query->bindValue(':designation', $commande->designation()); $query->bindValue(':status', $commande->status()); $query->bindValue(':codeLivraison', $commande->codeLivraison()); $query->bindValue(':created', $commande->created()); $query->bindValue(':createdBy', $commande->createdBy()); $query->execute(); $query->closeCursor(); }