public function alterar(TimeCapsuleModel $model) { try { $query = "update message\n set nam_to_message = :nam_to_message,\n nam_from_message = :nam_from_message,\n dat_message = :dat_message,\n eml_message = :eml_message,\n tel_message = :tel_message,\n txt_message = :txt_message\n where seq_message = :seq_message"; $stmt = $this->conn->prepare($query); $stmt->bindValue(":nam_to_message", $model->getTo()); $stmt->bindValue(":nam_from_message", $model->getFrom()); $stmt->bindValue(":dat_message", $model->getDate()); $stmt->bindValue(":eml_message", $model->getEmail()); $stmt->bindValue(":tel_message", $model->getPhone()); $stmt->bindValue(":txt_message", $model->getMessage()); $stmt->bindValue(":seq_message", $model->getSeq()); return $stmt->execute(); } catch (Exception $e) { echo "Erro ao alterar a mensagem \n" . $e->getMessage(); } }