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