今天开发一个旅游网,要添加旅游景点,我在页面里面设置了两个表单,一个传图片的,一个提交数据的,两个表单不是嵌套,但是我提交数据表单要往数据库插入数据时会有两条记录,就是说会提交两次表单,什么原因?我吧代码复制出啦,大侠看看
<!--#include file="conn_ad.asp"-->
<!--#include file="session1.asp"-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script src="edit.js" type="text/javascript"></script>
<script src="calendar.js" type="text/javascript"></script>
<link href="../Images/MImages/style.css" rel="stylesheet" type="text/css">
</head>
<body>
<%
if instr(Request.ServerVariables("HTTP_REFERER"),"Hleft.asp")>0 or instr(Request.ServerVariables("HTTP_REFERER"),"Tour_scenery.asp")>0 then
session.Contents.Remove("image")
end if
%>
<table class="a" width="101%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#C4D8ED">
<tr >
<td><table width="100%" border="0" align="center" cellpadding="5" cellspacing="1" bgcolor="#C4D8ED" class="a">
<tr >
<td align="center" class="d"></td>
<td align="center" class="d"><strong>旅游景点</strong>信息添加</td>
</tr>
<tr >
<td align="right" valign="bottom" class="d">上传标题图片</td>
<td class="d"><form name="upfile" id="upfile" action="filesr.asp?act=upload" method="post" enctype="multipart/form-data" >
<input name="file" type="file" size="30" value="">
<input name="btnUpload" type="submit" id="btnUpload" value=" 上 传 ">
</form></td>
</tr>
<form name="myform" method="post" action="" onsubmit="return false;" >
<tr >
<td align="right" class="d">标题图片</td>
<td class="d"><label>
<input name="Tour_sceneryTitleImage" type="text" id="Tour_sceneryTitleImage" value="<%=session("image")%>" size="40" readonly>
(<span >用于在首页显示的图片</span>)</label></td>
</tr>
<tr >
<td width="12%" align="right" class="d">景点名称</td>
<td class="d"><input name="Tour_sceneryName" type="text" id="Tour_sceneryName" size="40" >
</td>
</tr>
<tr >
<td align="right" class="d">景点收费</td>
<td class="d"><input name="Tour_sceneryMenpiao" type="text" id="Tour_sceneryMenpiao" size="40" ></td>
</tr>
<tr >
<td align="right" class="d">乘车线路</td>
<td class="d"><input name="Tour_sceneryTraffic" type="text" id="Tour_sceneryTraffic" size="40" ></td>
</tr>
<tr >
<td align="right" class="d">景点位置</td>
<td class="d"><input name="Tour_sceneryPlace" type="text" id="Tour_sceneryPlace" size="40" ></td>
</tr>
<tr >
<td align="right" class="d">发布日期</td>
<td class="d"><INPUT id=inputBirthday onclick="fPopCalendar(this,this,this.value);return false;" readOnly maxLength=15 value="<%=Year(date())%>-<%=Month(Date())%>-<%=Day(Date())%>" name="fbrq">
</td>
</tr>
<tr >
<td colspan="2" align="center" valign="top" class="c">景点介绍:</td>
</tr>
<tr >
<td colspan="2" align="center" valign="top"><textarea id="content" name="content" ></textarea>
<IFRAME ID="content" SRC="editubb/ewebeditor.asp?id=content& FRAMEBORDER="0" SCROLLING="no" WIDTH="100%" HEIGHT="350"></IFRAME></td>
</tr>
<tr >
<td colspan="2" align="center" valign="top"></td>
</tr>
<tr >
<td></td>
<td height="30"><input type="button" name="button" value="提交保存" onClick="return checkkk()">
<input onClick="ClearReset()" type=reset name="Clear" value="重新填写"></td>
</tr>
</form>
</table></td>
</tr>
</table>
<%
conn.close
set conn=nothing
%>
</body>
</html><SCRIPT LANGUAGE="JavaScript">
<!--
function checkkk()
{
if(checkspace(document.myform.Tour_sceneryTitleImage.value)) {
document.myform.Tour_sceneryTitleImage.focus();
alert("请上传标题图片!");
return;
}
if(checkspace(document.myform.Tour_sceneryName.value)) {
document.myform.Tour_sceneryName.focus();
alert("请输入景点名称!");
return;
}
if(checkspace(document.myform.Tour_sceneryMenpiao.value)) {
document.myform.Tour_sceneryMenpiao.focus();
alert("请输入景点收费!");
return;
}
if(isNaN(document.myform.Tour_sceneryMenpiao.value)) {
document.myform.Tour_sceneryMenpiao.focus();
alert("景点收费必须是数字!");
return;
}
if(checkspace(document.myform.Tour_sceneryTraffic.value)) {
document.myform.Tour_sceneryTraffic.focus();
alert("请输入到达景点行车路线!");
return;
}
if(checkspace(document.myform.Tour_sceneryPlace.value)) {
document.myform.Tour_sceneryPlace.focus();
alert("请输入景点位置!");
return;
}
document.myform.action="SaveTourScenery.asp?tsc=add"
document.myform.submit();
}
function checkspace(checkstr) {
var str = '';
for(i = 0; i < checkstr.length; i++) {
str = str + ' ';
}
return (str == checkstr);
}
//-->
</script>
<script>
function regInput(obj, reg, inputStr)
{
var docSel = document.selection.createRange()
if (docSel.parentElement().tagName != "INPUT") return false
oSel = docSel.duplicate()
oSel.text = ""
var srcRange = obj.createTextRange()
oSel.setEndPoint("StartToStart", srcRange)
var str = oSel.text + inputStr + srcRange.text.substr(oSel.text.length)
return reg.test(str)
}
</script>
下面这个是数据库处理页面
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%><!--#include file="conn_ad.asp"-->
<!--#include file="session1.asp"-->
<%
if request("tsc")="add" then
dim Tour_sceneryName,Tour_sceneryContent,Tour_sceneryMenpiao,Tour_sceneryTraffic,Tour_sceneryTime,Tour_sceneryAuthor,Tour_sceneryPlace,Tour_sceneryTitleImage
Tour_sceneryName=request("Tour_sceneryName")
Tour_sceneryContent=request("content")
Tour_sceneryMenpiao=request("Tour_sceneryMenpiao")
Tour_sceneryTraffic=request("Tour_sceneryTraffic")
Tour_sceneryTime=request("fbrq")
Tour_sceneryAuthor=session("admin")
Tour_sceneryPlace=request("Tour_sceneryPlace")
Tour_sceneryTitleImage=request("Tour_sceneryTitleImage")
set ins=conn.execute("insert into Tour_scenery(Tour_sceneryName,Tour_sceneryContent,Tour_sceneryMenpiao,Tour_sceneryTraffic,Tour_sceneryTime,Tour_sceneryAuthor,Tour_sceneryPlace,Tour_sceneryTitleImage) values('"&Tour_sceneryName&"','"&Tour_sceneryContent&"',"&Tour_sceneryMenpiao&",'"&Tour_sceneryTraffic&"','"&Tour_sceneryTime&"','"&Tour_sceneryAuthor&"','"&Tour_sceneryPlace&"','"&Tour_sceneryTitleImage&"')")
session.Contents.Remove("image")
response.Write "<script>alert('发布成功');window.location.href='Tour_scenery.asp';</script>"
end if
%>