public function lacrar() { $model = new TimeCapsuleModel(); $model->setTo(isset($_POST["to"]) ? $_POST["to"] : ""); $model->setFrom(isset($_POST["from"]) ? $_POST["from"] : ""); $model->setDate(isset($_POST["date"]) ? $_POST["date"] : ""); $model->setEmail(isset($_POST["email"]) ? $_POST["email"] : ""); $model->setPhone(isset($_POST["phone"]) ? $_POST["phone"] : ""); $model->setMessage(isset($_POST["message"]) ? $_POST["message"] : ""); $sucesso = $model->gravar($model); if ($sucesso) { $this->exibir("sucesso"); } else { $this->exibir("erro"); } }
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(); } }
<?php require "TimeCapsuleModel.php"; $timecapsuleModel = new TimeCapsuleModel(); foreach ($timecapsuleModel->consultar() as $mensagem) { //$timecapsuleModel->setSeq($mensagem["seq_message"]); //$timecapsuleModel->setTo(utf8_decode($mensagem["nam_to_message"])); //$timecapsuleModel->setFrom(utf8_decode($mensagem["nam_from_message"])); //$timecapsuleModel->setPhone($mensagem["num_phone"]); //$timecapsuleModel->setEmail($mensagem["eml_message"]); //$timecapsuleModel->setDate($mensagem["dat_message"]); //$timecapsuleModel->setMessage(utf8_decode($mensagem["txt_message"])); //$timecapsuleModel->gravar($timecapsuleModel); echo "Sequencial corrigido: " . $mensagem["seq_message"] . "\n"; echo "To: " . utf8_decode($mensagem["nam_to_message"]) . "\n"; echo "From: " . utf8_decode($mensagem["nam_from_message"]) . "\n"; echo "Message: " . utf8_decode($mensagem["txt_message"]) . "\n"; echo "------- \n"; } $timecapsuleDAO = NULL; $timecapsuleModel = NULL;