<?php
$code = $_POST["code"];
session_start();
$randcode = $_SESSION['validationcode'];
if ($code == $randcode) {
require_once '../db/conn.php';
$sql = "insert into message(username,title,link,email,is_flag,create_date,content)" . "values('" . $_POST[username] . "','" . $_POST[title] . "','" . $_POST[phone] . "','" . $_POST[email] . "','0',now(),'" . htmtocode($_POST[content]) . "')";
if (mysql_query($sql, $conn)) {
mysql_close($conn);
echo "<script>alert('恭喜您,您的留言成功了,谢谢您的宝贵建议,我们将第一时间与您联系。');location.href='service.php';</script>";
} else {
die('Error:' . mysql_error());
mysql_close($conn);
echo "<script>alert('非常抱歉,您的留言失败了,因为正在系统升级,请通过其他方式联系我们,谢谢！');location.href='service.php';</script>";
}
} else {
echo "<script>alert('非常抱歉,您的留言失败了,因为您验证码输错咯。');location.href='service.php';</script>";
}
* Window 2003 - Preferences - PHPeclipse - PHP - Code Templates
*/
include "conn.php";
include "head.php";
$SQL = "SELECT * FROM `message` order by id desc";
$query = mysql_query($SQL);
while ($row = mysql_fetch_array($query)) {
?>
<table width=500 border="0" cellpadding="5" cellspacing="1" bgcolor="#add3ef">
<tr bgcolor="#eff3ff">
<td>标题：<?php
echo $row[title];
?>
用户：<?php
echo $row[user];
?>
</td>
</tr>
<tr bgColor="#ffffff">
<td>内容：<?php
echo htmtocode($row[content]);
?>
</td>
</tr>
</table>
<?php
}
?>