delphoto.asp

用ASP写的ASP交友系统

<%
dim conn,DBPath,sql,sql2,rs_apply

'叛断Session变量是否超时
if isempty(session("user_id")) then
   response.redirect "timeout.htm"
end if

'叛断此用户是否已经注册
if session("user_id")=1 then response.redirect "notreg.htm"

id=request("id")
user_id=request("user_id")

'-----------------------------------------------------------------
Set conn = Server.CreateObject("ADODB.Connection")
DBPath = Server.MapPath("pic.mdb")
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DBPath
'-----------------------------------------------------------------

set rs_apply=server.createobject("adodb.recordset")
sql="delete * from pic where id =" & id
rs_apply.open sql,conn,3,2


'-----------------------------------------------------------------
Set conn = Server.CreateObject("ADODB.Connection")
DBPath = Server.MapPath("friend.mdb")
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DBPath
'-----------------------------------------------------------------
sql2="Update larchives Set photo=photo-1 Where user_ID=" & user_id
rs_apply.open sql2,conn,3,2

  conn.close
  set conn=nothing
  response.redirect "sendphoto.asp"
 %>