Esempio n. 1
0
    public function add(Cheque $cheque)
    {
        $query = $this->_db->prepare(' INSERT INTO t_cheque (
		dateCheque,numero,designationSociete,designationPersonne,montant,statut,url,
		idProjet, idSociete, compteBancaire, createdBy, created)
		VALUES (:dateCheque, :numero, :designationSociete, :designationPersonne, 
		:montant, :statut, :url, :idProjet, :idSociete, :compteBancaire, :createdBy, :created)') or die(print_r($this->_db->errorInfo()));
        $query->bindValue(':dateCheque', $cheque->dateCheque());
        $query->bindValue(':numero', $cheque->numero());
        $query->bindValue(':designationSociete', $cheque->designationSociete());
        $query->bindValue(':designationPersonne', $cheque->designationPersonne());
        $query->bindValue(':montant', $cheque->montant());
        $query->bindValue(':statut', $cheque->statut());
        $query->bindValue(':url', $cheque->url());
        $query->bindValue(':idProjet', $cheque->idProjet());
        $query->bindValue(':idSociete', $cheque->idSociete());
        $query->bindValue(':compteBancaire', $cheque->compteBancaire());
        $query->bindValue(':createdBy', $cheque->createdBy());
        $query->bindValue(':created', $cheque->created());
        $query->execute();
        $query->closeCursor();
    }