<?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');