📄 clearall.asp

📁 多多网店系统v3.01 完全免费可用版-功能简介: 支持多模板皮肤色切换[8套] 支持按商品特性[推荐商品/特价商品/新品分类]浏览支持按商品类别浏览支持单件商品用支付宝交易按钮直接支付订

💻 ASP

字号:

<!--#include file="admin_check.asp"-->
<%dim dbpath
dbpath="../"
%>
<!--#include file="../Conn.asp"-->
<!--#include file="../include/MyRequest.asp"-->
<%
action=my_request("action",0)
if action="save" then
    call save()
end if

sub save()
    conn.execute ("update [root_info] set root_info_OffNote=0,root_info_LogoPic=null,root_info_Icp=null,root_info_tel=null,root_info_email=null,root_info_qq=null,root_info_wangwang=null,root_info_msn=null,root_info_skin=null,root_info_indextitle=null,root_info_indexkeywords=null,root_info_indexdescription=null,root_info_aboutus=null,root_info_sitename=null,root_info_address=null,root_info_zip=0,root_info_fax=null where id=1")
    conn.execute ("update [root_option] set root_option_NumsPerRow=0,root_option_RowsPerPage=0,root_option_RowsIndexNew=0,root_option_RowsIndexTj=0,root_option_RowsIndexSpec=0,root_option_WidthSPic=0,root_option_HeighSPic=0 where id=1")
    conn.execute ("update [root_alipay] set root_AliPay_Email=null,root_AliPay_SafeCode=null where id=1")
    conn.execute ("update [adv_middle] set adv_middle_pic1=null,adv_middle_pic2=null,adv_middle_pic3=null,adv_middle_pic4=null,adv_middle_Pic1Url=null,adv_middle_Pic2Url=null,adv_middle_Pic3Url=null,adv_middle_Pic4Url=null,adv_middle_pic1Txt=null,adv_middle_pic2Txt=null,adv_middle_pic3Txt=null,adv_middle_pic4Txt=null where adv_middle_id=1")
    conn.execute ("delete from [root_deliver]")
    conn.execute ("delete from [product_class]")
    conn.execute ("delete from [product_info]")
    conn.execute ("delete from [order_info]")
    conn.execute ("delete from [order_buy]")
    conn.execute ("delete from [news_info]")
    conn.execute ("delete from [help_info]")
    conn.execute ("delete from [guest_info]")
    conn.execute ("delete from [link_info]")
    conn.execute ("delete from [adv_Left]")
    call ok("数据库中所有数据已清空！","ClearAll.asp")
end sub
%>
<html>

<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>清空数据</title>
<link rel="stylesheet" type="text/css" href="style.css">
</head>

<body>

<h2 align="center"><br>
清空数据库中所有数据</h2>
<div align="center">
	<table border="0" width="50%" id="table1" cellpadding="4" style="border-collapse: collapse">
	<form name=form1 action=ClearAll.asp method=post>
	<input type="hidden" name="action" value="save"> 
	<tr>
			<td><font color="#FF0000">请谨慎操作,请确认你是否真的要清空数据库中所有数据信息,一般建议在首次进行网店设置时进行此项操作!</font></td>
		</tr>
		<tr>
			<td bgcolor="#FF6600">
			<p align="center"><font color="#FFFFFF">因方便多人同时试用,演示时,此功能禁用!正式版完全可用</font></td>
		</tr>
		<tr>
			<td>
			<p align="center"> 
        <input type="submit" name="submit2" value="点此清空数据库中所有数据" onclick="{if(confirm('清空后将无法恢复，您确定要清空清空数据库中所有数据吗？')){this.document.form1.submit();return true;}return false;}" ></td>
		</tr>
	</form>
	</table>
</div>

</body>

</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -