productadd.asp

中国电视购物网电子商务系统

<!--#include file="../../include/function.asp"-->
<!---#include file="../../include/prodconn.asp"-->
<%
prod_name=chkstr(Request.Form("prod_name"))
area=chkstr(Request.Form("area"))
prod_sign=chkstr(Request.Form("prod_sign"))
color=chkstr(Request.Form("color"))
prod_man=chkstr(Request.Form("prod_man"))
prod_number=chkstr(Request.Form("prod_number"))
price=chkstr(Request.Form("pricd"))
model=chkstr(Request.Form("model"))
prod_code=chkstr(Request.Form("prod_code"))
use_intro=htmlencode(Request.Form("use_intro"))
prod_intro=htmlencode(Request.Form("prod_intro"))
visual_file=chkstr(Request.Form("visual_file"))
voice_file=chkstr(Request.Form("voice_file"))
pic_file=chkstr(Request.Form("pic_file"))
sale_man=chkstr(Request.Form("sale_man"))


sql="insert into product(prod_name,area,prod_sign,color,prod_man,prod_number,price,model,prod_code,"
sql=sql&"use_intro,prod_intro,visual_file,voice_file,pic_file,sale_man) "
sql=sql&"values ('"&prod_name&"','"&area&"','"&prod_sign&"','"&color&"','"&prod_man&"',"
sql=sql&"'"&prod_number&"','"&price&"','"&model&"','"&prod_code&"','"&use_intro&"','"&prod_intro&"',"
sql=sql&"'"&visual_file&"','"&voice_file&"','"&pic_file&"','"&sale_man&"')"
conn.execute(sql)

if conn.errors.count=0 then
set rs=nothing
call conn_end
%>
<SCRIPT LANGUAGE=javascript>
<!--
alert("已成功加入产品信息！")
window.location.href="product.asp"
//-->
</SCRIPT>

<%
end if
%>