saveinfo.asp

来自「大家好」· ASP 代码 · 共 47 行

ASP
47
字号
<%@ Language=VBScript %>
<%Response.Buffer=true%>
<html>

<head>

</head>
<body>
<%
FUNCTION  fixQuotes( theString ) 
    fixQuotes = Replace( theString, " ' ", " ' ' " )
END FUNCTION

	set conn=server.createObject("ADODB.Connection")
	dbpath=server.mappath("market.mdb")
	conn.open "driver={Microsoft Access Driver (*.mdb)};dbq="&dbpath
 sqlstr= "insert into buyinfo (cat,price,des,email,contact,city,pname,itype) values ('"
 sqlstr=sqlstr + Request.Form("cat") + "','"
 sqlstr=sqlstr + Request.Form("price") +"','"
 sqlstr=sqlstr + Request.Form("desc") +"','"
 sqlstr=sqlstr + Request.Form("email") +"','" 
 sqlstr=sqlstr + Request.Form("contact") +"','"
if cstr(trim(request("mjj")))="1" then
 sqlstr=sqlstr + trim(request("cname")) +"','"
else
 sqlstr=sqlstr + trim(request.form("cname2")) +"','"
end if
 sqlstr=sqlstr + Request.Form("pname") + "','"
 sqlstr=sqlstr + request("itype") + "')"
 sqlstr=replace(sqlstr,vbcrlf,"<br>")
 sqlstr=fixQuotes(sqlstr)

 conn.Execute sqlstr

 
%>

<script language=javascript>
<!--
	window.location.href="addsuccess.htm"
//-->

</script>
 	
</body>
</html>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?