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 + -
显示快捷键?