Beispiel #1
0
<?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>";
}
Beispiel #2
0
 * 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 
}
?>