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;
