[1062] PHP7入門
<?php
require_once 'smarty/libs/Smarty.class.php';
$smarty = new Smarty;
$db = new mysqli('localhost', 'root', '12345', 'reporter');
if ($db->connect_error) {
die('無法連上資料庫:' . $db->connect_error);
}
$db->set_charset("utf8");
if (isset($_POST['op']) and $_POST['op'] == "insert") {
$title = $db->real_escape_string($_POST['title']);
$content = $db->real_escape_string($_POST['content']);
$sql = "INSERT INTO `article` (`title`, `content`, `create_time`, `update_time`) VALUES ('{$title}', '{$content}', NOW(), NOW())";
$db->query($sql) or die($db->error);
$sn = $db->insert_id;
header("location: index.php?sn={$sn}");
exit;
}
// $smarty->assign('now', date("Y年m月d日 H:i:s"));
$smarty->display('admin.tpl');