<a href ='index.php' >返回留言板</a><hr><hr>
<?php
/*
* to change the template for this generated file go to
* window - preferences - phpeclipse - php - code templates
*/
require("conn.php");
$user=$_post['user'];
$title=$_post['title'];
$content=$_post['content'];
$sql_luck="insert into sny (id,user,title,content,lastdate)value('','$user','$title','$content',now())"
$sql="select user from sny where user='$user'";
$query =mysql_query($sql);
$rows=mysql_fetch_array($query);
if((!empty($_post['sub']))and($rows['user']==$user)){
//echo $content;
echo "<script>alert('用户已存在，请重新输入');location.href='add2.php'</script>" ;exit;
mysql_free_result($query);exit;
}
else{
mysql_query($sql_luck);
echo"<script>alert('哟！成功！');location.href='index.php'</script>";
echo "插入成功";
}
?>
<form action="add.php" method="post">
用户：<input type="text" name="user" value="请输入用户名" size="20" maxlength="10"/><br/>
标题:<input type="text" name="title" value="请输入内容" size="40" maxlength="40"/><br/>
内容:<textarea name="content" rows="10" cols="50" wrap="off">
text</textarea>
<br/>
<input type="submit" name="sub" value="release"/><br/>
<form/>
解决方案
你if判断仔细看看里边缕缕。好么？
