PHP 实现的留言板功能

<?php
//一、导入配置文件和函数库文件
require("dbconfig.php");

// define("HOST","localhost");
// define("USER","root");
// define("PASS","");
// define("DBNAME","carolcoral"); 

//二、连接MySQL，选择数据库
$link = mysql_connect(HOST,USER,PASS) or die("SQL die !");
mysql_select_db(DBNAME,$link);

//三、获取action参数的值，并做对应的操作
switch($_GET["action"]){
case "add": //添加

  //1. 获取添加信息
  $UserName = $_POST["UserName"];
  $Email = $_POST["Email"];
  $Subject = $_POST["Subject"];
  $Body = $_POST["Body"];
  $addtime = time();

  //2. 验证()省略
  if(empty($UserName)){
    die("UserName can't be empty !");
  }

  //3. 拼装sql语句，并执行添加
  $sql = "insert into contact values(null,'{$UserName}','{$Email}','{$Subject}','{$Body}','{$addtime}')";
  //echo $sql;
  $res=mysql_query($sql,$link);
  $count = mysql_affected_rows();

  //6. 判断并输出结果
  if($count>0){
    echo "<script>alert('Comments successful !')</script>";
    echo "<script>window.location.href='contactContent.php'</script>";
  }else{
    //echo ".$sql()";
    echo "<script>alert('Comments failure !')</script>".$sql();
    echo "<script>window.location.href='contact.php'</script>";
  }
  break;
}

//四、关闭数据库
mysql_close($link);

?>