<?php
require_once('../config.php');
require_once('../functions.php');
session_start();
$dbh = connectDb();
if (preg_match('/^[1-9][0-9]*$/', $_GET['id'])){
$id = (int)$_GET['id'];
} else{
echo "不正なIDです!";
exit;
}
if ($_SERVER['REQUEST_METHOD'] != "POST"){
setToken();
$stmt = $dbh->prepare("select * from entries where id = :id limit 1");
$stmt->execute(array(":id" => $id));
$entry = $stmt->fetch() or die("no one found!");
$name = $entry['name'];
$email = $entry['email'];
$memo = $entry['memo'];
} else {
checkToken();
$name = $_POST['name'];
$email = $_POST['email'];
$memo = $_POST['memo'];
$error = array();
if(!filter_var($email, FILTER_VALIDATE_EMAIL)){
$error['email'] = 'メールアドレスの形式が正しくありません';
}
if($email == ''){
$error['email'] = 'メールアドレスを入力してください';
}
if($memo == ''){
$error['memo'] = '内容を入力してください';
}
if(empty($error)){
$sql = "update entries set
name = :name,
email = :email,
memo = :memo,
modified = now()
where id = :id";
$stmt = $dbh->prepare($sql);
$params = array(
":name" => $name,
":email" => $email,
":memo" => $memo,
":id" => $id
);
$stmt->execute($params);
header('Location: '.ADMIN_URL);
exit;
}
}
?>
<!DOCTYPE html>
<html lang="ja">
<head>
<meta charset="utf-8">
<title>データの編集</title>
</head>
<body>
<h1>データの編集</h1>
<form method="POST" action="">
<p>お名前:<input type="text" name="name" value="<?php echo h($name); ?>"></p>
<p>メールアドレス*:<input type="text" name="email" value="<?php echo h($email); ?>">
<?php if($error['email']){ echo h($error['email']); } ?></p>
<p>内容*:</p>
<p><textarea name="memo" cols="40" rows="5"><?php echo h($memo); ?></textarea>
<?php if($error['memo']){ echo h($error['memo']); } ?></p>
<p><input type="submit" value="更新"></p>
<input type="hidden" name="token" value="<?php echo h($_SESSION['token']); ?>">
</form>
<p><a href="<?php echo ADMIN_URL; ?>">戻る</a>
</body>
</html>
delete
<?php
require_once('../config.php');
require_once('../functions.php');
$dbh = connectDb();
$id = (int)$_POST['id'];
$dbh->query("update entries set status = 'deleted' where id = $id");
echo $id;
thanks
<!DOCTYPE html> <html lang="ja"> <head> <meta charset="utf-8"> <title>ありがとうございました！</title> </head> <body> <h1>ありがとうございました！</h1> <p></p> <p><a href="index.php">お問い合わせフォームに戻る</a></p> </body> </html>