public function update(Projet $projet)
    {
        $query = $this->_db->prepare('UPDATE t_projet SET 
		name=:name, description=:description, adresse=:adresse, 
		dateCreation=:dateCreation, avancementConstruction=:avancementConstruction,
		avancementFinition=:avancementFinition, updated=:updated, updatedBy=:updatedBy
		WHERE id=:id') or die(print_r($this->_db->errorInfo()));
        $query->bindValue(':id', $projet->id());
        $query->bindValue(':name', $projet->name());
        $query->bindValue(':description', $projet->description());
        $query->bindValue(':adresse', $projet->adresse());
        $query->bindValue(':dateCreation', $projet->dateCreation());
        $query->bindValue(':avancementConstruction', $projet->avancementConstruction());
        $query->bindValue(':avancementFinition', $projet->avancementFinition());
        $query->bindValue(':updated', $projet->updated());
        $query->bindValue(':updatedBy', $projet->updatedBy());
        $query->execute();
        $query->closeCursor();
    }
Beispiel #2
0
    public function update(Projet $projet)
    {
        $query = $this->_db->prepare(' UPDATE t_projet SET 
		nom=:nom,numeroTitre=:numeroTitre,emplacement=:emplacement,
		superficie=:superficie, description=:description,dateCreation=:dateCreation,
		createdBy=:createdBy,created=:created, idSociete=:idSociete
		WHERE id=:id') or die(print_r($this->_db->errorInfo()));
        $query->bindValue(':id', $projet->id());
        $query->bindValue(':nom', $projet->nom());
        $query->bindValue(':numeroTitre', $projet->numeroTitre());
        $query->bindValue(':emplacement', $projet->emplacement());
        $query->bindValue(':superficie', $projet->superficie());
        $query->bindValue(':description', $projet->description());
        $query->bindValue(':dateCreation', $projet->dateCreation());
        $query->bindValue(':createdBy', $projet->createdBy());
        $query->bindValue(':created', $projet->created());
        $query->bindValue(':idSociete', $projet->idSociete());
        $query->execute();
        $query->closeCursor();
    }