usergoods_ok.asp

这是一个网上购物物网站,数据库的连接在CONN.ASP中,既有前台网站,也有后台管理

<!--#include file="conn.asp"-->

<%
action=request("action")
if action="add" then       '添加数据
    set rs=server.createobject("adodb.recordset")
	rs.open "select * from oldgoods",conn,3,2
	rs.addnew	
	rs("username")=session("username")
    rs("name")=request.Form("name")
	rs("email")=request.Form("email")
	rs("telphone")=request.Form("telphone")
    rs("bigclass")=request.Form("bigclass")
	rs("hyprice")=request.Form("hyprice")
	rs("img")=request.Form("img")
    rs("content")=request.Form("content")
    rs("addtime")=now()
	rs.update
	Response.Write("<script>alert('添加成功！');window.location='usergoods_add.asp';</script>")
	

elseif action="del" then   '删除数据
	sql="delete from newgoods where goodid=" &request("goodid")
    set rs=conn.execute(sql)
	Response.Write("<script>alert('删除成功！');window.location='user_sale.asp';</script>")
end if
%>