⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 lookcount.asp

📁 程序为自主开发ASP+SQL大型购物搜索网站,系统管理、商铺、会员三种会员唯一帐号管理。目前已有数据条商品数据与数万条商铺信息
💻 ASP
字号:
<!--#include file="../../../INC/ConnTxt.asp"-->
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../../../Search/images/search.css" rel="stylesheet" type="text/css">
<%

Dim ProductNumberID
    ProductNumberID = Trim(Request.QueryString("ID"))

Set Rs = Conn.Execute("Select Shop.LookCount As ShopLookCount,Product.LookCount As ProductLookCount,Shop.ShopNumberID As ShopNumberID,Shop.ShopNumberID,Product.ShopNumberID From Product,Shop Where Shop.ShopNumberID=Product.ShopNumberID and ProductNumberID = '"& ProductNumberID &"'")

	IF Not Rs.eof Then
	
	ProductLookCount	= Rs("ProductLookCount")
	ShopLookCount		= Rs("ShopLookCount")
	ShopNumberID		= Rs("ShopNumberID")

	End IF
	
	Rs.Close
	
Set Rs = Nothing 

Set Rs = Conn.Execute("Update Product Set LookCount = "& ProductLookCount+1 &" Where ProductNumberID = '"& ProductNumberID &"'")
Set Rs = Conn.Execute("Update Shop Set LookCount = "& ShopLookCount+1 &" Where ShopNumberID = '"& ShopNumberID &"'")

Conn.Close
Set Conn = Nothing
%>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<%=ProductLookCount%>
</Body>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -