<a href ='index.php' >返回留言板</a><hr><hr>
<?php
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
"<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/>