Exemplo n.º 1
-4
 public function atualizar(Formulario $formulario)
 {
     try {
         $sql = "UPDATE formulario SET " . " anoConclusao = :anoConclusao," . " ia1 = :ia1," . " ia2 = :ia2," . " ia3 = :ia3," . " ia4 = :ia4," . " ia5 = :ia5," . " ia6 = :ia6," . " ic1 = :ic1," . " ic2 = :ic2," . " ic3 = :ic3," . " ic4 = :ic4," . " ic5 = :ic5" . " ic6 = :ic6," . " ic7 = :ic7," . " ic8 = :ic8," . " ic9 = :ic9," . " ic10 = :ic10" . " id1 = :id1," . " id2 = :id2," . " id3 = :id3," . " ic4 = :ic4," . " ip1 = :ip1" . " ip2 = :ip2," . " ip3 = :ip3," . " ip3a = :ip3a" . " ip3b = :ip3b," . " ip3c = :ip3c," . " ip3d = :ip3d," . " sugestao = :sugestao," . " semestre = :semestre," . " status = :status," . " idUsuario = :idUsuario" . " WHERE id = :id";
         $p_sql = $this->pdo->prepare($sql);
         $p_sql->bindValue(":id", $formulario->getId());
         $p_sql->bindValue(":anoConclusao", $formulario->getAnoConclusao());
         $p_sql->bindValue(":ia1", $formulario->getIA1());
         $p_sql->bindValue(":ia2", $formulario->getIA2());
         $p_sql->bindValue(":ia3", $formulario->getIA3());
         $p_sql->bindValue(":ia4", $formulario->getIA4());
         $p_sql->bindValue(":ia5", $formulario->getIA5());
         $p_sql->bindValue(":ia6", $formulario->getIA6());
         $p_sql->bindValue(":ic1", $formulario->getIC1());
         $p_sql->bindValue(":ic2", $formulario->getIC2());
         $p_sql->bindValue(":ic3", $formulario->getIC3());
         $p_sql->bindValue(":ic4", $formulario->getIC4());
         $p_sql->bindValue(":ic5", $formulario->getIC5());
         $p_sql->bindValue(":ic6", $formulario->getIC6());
         $p_sql->bindValue(":ic7", $formulario->getIC7());
         $p_sql->bindValue(":ic8", $formulario->getIC8());
         $p_sql->bindValue(":ic9", $formulario->getIC9());
         $p_sql->bindValue(":ic10", $formulario->getIC10());
         $p_sql->bindValue(":id1", $formulario->getID1());
         $p_sql->bindValue(":id2", $formulario->getID2());
         $p_sql->bindValue(":id3", $formulario->getID3());
         $p_sql->bindValue(":ip1", $formulario->getIP1());
         $p_sql->bindValue(":ip2", $formulario->getIP2());
         $p_sql->bindValue(":ip3", $formulario->getIP3());
         $p_sql->bindValue(":ip3a", $formulario->getIP3A());
         $p_sql->bindValue(":ip3b", $formulario->getIP3B());
         $p_sql->bindValue(":ip3c", $formulario->getIP3C());
         $p_sql->bindValue(":ip3d", $formulario->getIP3D());
         $p_sql->bindValue(":sugestao", $formulario->getSugestao());
         $p_sql->bindValue(":semestre", $formulario->getSemestre());
         $p_sql->bindValue(":status", $formulario->getStatus());
         $p_sql->bindValue(":idUsuario", $formulario->getIdUsuario());
         return $p_sql->execute();
     } catch (Exception $e) {
         print "Ocorreu um erro ao tentar executar esta ação, foi gerado um LOG do mesmo, tente novamente mais tarde.";
     }
 }