member_del_ok.asp

来自「房地产管理系统 vb写的,很不错!!!!!!!!!!!」· ASP 代码 · 共 50 行

<%
If session("manager")="" Then
  Response.Redirect("manage.asp")
  Response.end
 End If
%><!--#include file="../inc/conn.asp"-->
<%
'┌─  风云ASP在线  ────────────────────────┐
'│                                                                 │
'│  作者：赵振波.	http://www.fyasp.com	    				    │
'│                                                                 │
'│   Q Q：176189168  										   	    │
'│                                                                 │
'│ Email：[e-mail]                                             │
'│                                                                 │
'│ 程序定做，系统开发，网站制作，提供高质量的网络产品、技术和服务！│
'│                                                                 │
'│                                                                 │
'└───────────────────  http://www.fyasp.com ──┘
%>
<%   
opendataconn
  ids=split(request("id"),",") 
  for i=0 to ubound(ids)
    tt=ids(i)
	set rs=server.createobject("adodb.recordset")
	sql="select * from company where id="&tt&""
	rs.open sql,conn,1,1
	if not rs.eof then
	reguser=trim(rs("userid"))
	end if 
	rs.close
	set rs=nothing
    conn.execute"delete from company where id="&tt&""
	'conn.execute "delete from zhaoping where reguser='"&reguser&"'"
	'conn.execute "delete from gongqiu where reguser='"&reguser&"'"
	'conn.execute "delete from shopdetail where userid='"&reguser&"'"
	'conn.execute "delete from hyedetail where loginid='"&reguser&"'"
	'conn.execute "delete from images where userid='"&reguser&"'"
	'conn.execute "delete from meet where userid='"&reguser&"'"
	'conn.execute "delete from mtex where userid='"&reguser&"'"
        next
  response.redirect "member_del.asp"
closedataconn
%>