数据库留言板代码
相关主题
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
</tr>
<tr><td height="36" bgcolor="#FFFF00"><span class="style2">留言主题</span>：<?php echo $row[title]; ?>
</td>
</tr>
<tr bgcolor="pink">
<td bgcolor="#00CCFF"><span class="style2">留言内容</span>：<?php echo $row[connect]; ?>
if(form1.content.value==""){
alter("请填写内容");
form1.content.focus();
return false; }
</SCRIPT><html>
<body bgcolor="purole">
<form name="form1" action="charu.php" method="post" onsubmit="return checkpost();">
<tr color="">
<td colspan="2">用户：<?php echo $row[sname];?></td>
</tr>
<tr><td width="399">留言内容：<?php echo $row[content];?></td></tr>
</table>
<?php
}
?>
<?php
mysql_query($sql,$conn);
?>
<SCRIPT language=javascript>
function CheckPost(){
if(form1.user.value==""){
alter("请填写留言人");
form1.user.focus();
return false; }
<?php
include("conn.php");
$sql="insert into student(sno,sname,title,content)values('','$_POST[sname]','$_POST[title]','$_POST[content]')";
mysql_query($sql,$conn);
$qq=mysql_query($sql,$conn);
while($row=mysql_fetch_array($qq)){?>
<table width="602" border="0">
<tr>
<td width="1013"><img src="20071215171420852_2.jpg" width="596" height="166"></td>
<?php
include("lianjie.php");
$sql="insert into message(id,user,e-mail,phone,address,title,content)
values('',"$_POST["user"],"$_POST["phone"],"$_POST["address"],"$_POST["title"],"$_POST["content"],")";
</td>
</tr>
</table>
<?php
}
?>
?>
<SCRIPT language=javascript>
function CheckPost(){
if(form1.sname.value==""){
alert("请填写用户名，不能为空！");
form1.sname.focus();
return false;
}
if(form1.title.value==""){
mysql_select_db("stu",$conn);
?>
<?php
$conn=mysql_connect("localhost","root","");
mysql_select_db("liuyan",$conn);
?>
<?php
include("conn.php");
$sql="select * from student";
<html>
<body>
<form name="form1" action="add.php" method="post" onsubmit="return CheckPost()">
用户名：<input type="text" name="sname"><br>
标 题：<input type="text" name="title"><br>
if(form1.e-mail.value==""){
alter("请填写电子邮箱");
form1.e-mail.focus();
return false; }
if(form1.phone.value==""){
alter("请填写电话号码");
form1.phone.focus();
return false; }
留 言：<textarea name="content" rows="10" cols="50" wrap="on"></textarea><br>
<input type="submit" name="submit" value="发表">
</form>
</body>
</html>
if(form1.time.value==""){
alter("请填写留言时间");
form1.time.focus();
return false; }
if(form1.title.value==""){
alter("请填写主题");wenku.baidu.com
form1.title.focus();
return false; }
留言主题：<input name="title" type="text"><br>
留言内容：<textarea name="connect" rows="12" cols="30" wrap="on"></textarea><br>
<input name="submit" type="submit" value="发表留言">
include("lianjie.php");
$sql="select * from message";
$qq=mysql_query($sql,$conn);
while($row=mysql_fetch_array($qq)){?>
<table width="350" height="166" border="0" >
alert("请填写用户名，不能为空！");
form1.title.focus();
return false;
}
if(form1.content.value==""){
alert("请填写用户名，不能为空！");
form1.content.focus();
return false;
}
}
</SCRIPT>
</tr>
</table>
<table width=600 border="1" cellpadding="0" cellspacing="0" bordercolor="#0033FF" >
<tr color=""><td colspan="2">标题：<?php echo $row[title];?></td></tr>
<tr bgcolor="#add3ef">
<td width="344" height="40" bordercolor="#FFFFFF" bgcolor="#9999FF"><span class="style2">留言人</span>：<?php echo $row[user]; ?>
</td>
留言人： <input name="user" type="text"><br>
电子邮箱：<input name="e-mail" type="text"><br>
联系电话：<input name="phone" type="text"><br>
留言时间：<input name="time" type="text"><br>
<input name="submit" type="submit" value="取消留言">
</form></body></html>
<?php
$conn=mysql_connect("localhost","root","");
<tr><td height="36" bgcolor="#FFFF00"><span class="style2">留言主题</span>：<?php echo $row[title]; ?>
</td>
</tr>
<tr bgcolor="pink">
<td bgcolor="#00CCFF"><span class="style2">留言内容</span>：<?php echo $row[connect]; ?>
if(form1.content.value==""){
alter("请填写内容");
form1.content.focus();
return false; }
</SCRIPT><html>
<body bgcolor="purole">
<form name="form1" action="charu.php" method="post" onsubmit="return checkpost();">
<tr color="">
<td colspan="2">用户：<?php echo $row[sname];?></td>
</tr>
<tr><td width="399">留言内容：<?php echo $row[content];?></td></tr>
</table>
<?php
}
?>
<?php
mysql_query($sql,$conn);
?>
<SCRIPT language=javascript>
function CheckPost(){
if(form1.user.value==""){
alter("请填写留言人");
form1.user.focus();
return false; }
<?php
include("conn.php");
$sql="insert into student(sno,sname,title,content)values('','$_POST[sname]','$_POST[title]','$_POST[content]')";
mysql_query($sql,$conn);
$qq=mysql_query($sql,$conn);
while($row=mysql_fetch_array($qq)){?>
<table width="602" border="0">
<tr>
<td width="1013"><img src="20071215171420852_2.jpg" width="596" height="166"></td>
<?php
include("lianjie.php");
$sql="insert into message(id,user,e-mail,phone,address,title,content)
values('',"$_POST["user"],"$_POST["phone"],"$_POST["address"],"$_POST["title"],"$_POST["content"],")";
</td>
</tr>
</table>
<?php
}
?>
?>
<SCRIPT language=javascript>
function CheckPost(){
if(form1.sname.value==""){
alert("请填写用户名，不能为空！");
form1.sname.focus();
return false;
}
if(form1.title.value==""){
mysql_select_db("stu",$conn);
?>
<?php
$conn=mysql_connect("localhost","root","");
mysql_select_db("liuyan",$conn);
?>
<?php
include("conn.php");
$sql="select * from student";
<html>
<body>
<form name="form1" action="add.php" method="post" onsubmit="return CheckPost()">
用户名：<input type="text" name="sname"><br>
标 题：<input type="text" name="title"><br>
if(form1.e-mail.value==""){
alter("请填写电子邮箱");
form1.e-mail.focus();
return false; }
if(form1.phone.value==""){
alter("请填写电话号码");
form1.phone.focus();
return false; }
留 言：<textarea name="content" rows="10" cols="50" wrap="on"></textarea><br>
<input type="submit" name="submit" value="发表">
</form>
</body>
</html>
if(form1.time.value==""){
alter("请填写留言时间");
form1.time.focus();
return false; }
if(form1.title.value==""){
alter("请填写主题");wenku.baidu.com
form1.title.focus();
return false; }
留言主题：<input name="title" type="text"><br>
留言内容：<textarea name="connect" rows="12" cols="30" wrap="on"></textarea><br>
<input name="submit" type="submit" value="发表留言">
include("lianjie.php");
$sql="select * from message";
$qq=mysql_query($sql,$conn);
while($row=mysql_fetch_array($qq)){?>
<table width="350" height="166" border="0" >
alert("请填写用户名，不能为空！");
form1.title.focus();
return false;
}
if(form1.content.value==""){
alert("请填写用户名，不能为空！");
form1.content.focus();
return false;
}
}
</SCRIPT>
</tr>
</table>
<table width=600 border="1" cellpadding="0" cellspacing="0" bordercolor="#0033FF" >
<tr color=""><td colspan="2">标题：<?php echo $row[title];?></td></tr>
<tr bgcolor="#add3ef">
<td width="344" height="40" bordercolor="#FFFFFF" bgcolor="#9999FF"><span class="style2">留言人</span>：<?php echo $row[user]; ?>
</td>
留言人： <input name="user" type="text"><br>
电子邮箱：<input name="e-mail" type="text"><br>
联系电话：<input name="phone" type="text"><br>
留言时间：<input name="time" type="text"><br>
<input name="submit" type="submit" value="取消留言">
</form></body></html>
<?php
$conn=mysql_connect("localhost","root","");