【建立一个m文件将数组a和b】建立一个广告交换及跟踪系统

更新时间:2019-09-04 来源:热门资讯 点击:

【www.hzclsc.cn--热门资讯】

First you need a database to store your banners. We are using 2 tables; tblBanners and tblVendors:



tblBanners:

bID - auto number (banner ID)

bBanner - text (image file)

bUsedViews - number (# of views the banner has received)

bTotalViews - number (# of impressions the vendor has paid for)

bClicks - number (# of clicks the banner has received)

bURL - text (URL of the site)

bShow - yes/no (used to show and hide banners)

vID - number (vendor ID)



tblVendors:

vID - autonumber (vendor ID - links to tblBanners.vID)

vName - text (Vendor"s name)

etc..........





Now that the database is set up, we need to randomly display the banner on our pages and increment the "views" by 1:



First you need to open your database connection on the page you want your banner to be viewed on. We use a DSN-less connection; you can find it at the following address:



http://www.askasp.com/toolbox.asp?Expand=True ID=2#tool



Here is what the SQL might look like:



SQL = "SELECT tblBanners.bID, tblBanners.bImage, tblBanners.bUsedViews, tblBanners.bLastViewed "

SQL = SQL "FROM tblBanners "

SQL = SQL "WHERE (((tblBanners.bShow)=True) AND ((tblBanners.bTotalViews)>[tblBanners].[bUsedViews]));"



In the above SQL, we are checking for the "bShow" flag to be True, and that the UsedViews is less than the TotalViews.



Now that we have all of the banners that we can display, we need to display a random one. We can do this by grabbing the total number of banners, moving to the first record, and the moving to a random number, for example:





Dim rndMax, rndNumber



Randomize



rndMax = Int(RecordSet.RecordCount)

rndNumber = Int(RND * rndMax)



RecordSet.Move rndNumber





Now that we have moved to our random banner, we now need to display the banner on our page (I am sure you know how to do that, so I wont bore you with the details). However, Instead of using the banner"s URL in the link, we are going to use a redirect page so we can count the clicks. All we need to do is use the banner ID in the HREF tag, for example:



a href="redirect.asp?ID="



Now that we have the link set up, we can move on to our redirect.asp page. On this page, we are going to grab the ID that we are passing in the Query String, and grabbing the RecordSet that matches. Once we have the RecordSet, we can grab the banner"s URL, increase the Clicks by 1, and send the user to the destination URL. Below is the code for the redirect.asp page:







处理 SSI 文件时出错








处理 SSI 文件时出错









本文来源:http://www.hzclsc.cn/news/26376.html

为您推荐

dnf鬼泣新buff换装|dnf鬼泣BUFF换装如何搭配 dnf起源版鬼泣BUFF换装搭配攻略

您的位置:首页 → 网游资讯 → dnf资讯 → dnf鬼泣BUFF换装如何搭配 dnf起源版鬼泣BUFF换装搭配攻略 dnf鬼泣BUFF换装如何搭配 dnf起源版鬼泣BUFF换装搭配攻略时间:201dnf资讯

2021-02-25 18:54:41   dnf鬼泣buff换装95   地下城鬼泣buff换装  

dnf流年鬼泣装备_dnf鬼泣起源版本装备搭配推荐 dnf黑暗君主起源版本加点攻略

2月1日DNF起源版本正式更新了,这次更新全职业平衡性将进行调整,所以这个版本DNF黑暗君主起源版本怎么加点?DNF黑暗君主起源版本用什么装备好?下面小编为大家爱带来了DNF黑暗君主起源版本加点攻略dnf资讯

2021-02-25 18:54:41   dnf鬼泣装备推荐   dnf鬼泣毕业装备  

【dnf黄金雄鹰图腾怎么升级】dnf黄金雄鹰图腾怎么得 黄金雄鹰图腾出现概率介绍

DNF游戏中成功建造传说图腾的小伙伴可以一次性拿到20个图腾精华,而普通的和特殊也才只给到6个,是普通 特殊的3倍还多,难怪这么多的玩家追求黄金雄鹰图腾了,毕竟有了它,组合出传说的概率非常的高。 为dnf资讯

2021-02-25 18:54:41  

[dnf起源剧情]dnf起源版本公会改动一览 dnf起源版本公会有哪些变动

全新的起源版本已经到来,这次改版的改动很大,甚至有些小伙伴都在游戏中迷路了,那么在全新的起源版本中公会有哪些变化呢?下面就让我们一起去了解一下DNF起源版本公会改动吧! DNF起源版本公会改动一览起dnf资讯

2021-02-25 18:54:41  

德特尔兽人族|dnf兽人族的特别宝物礼盒有什么 兽人族的特别宝物礼盒选择建议

兽人族的特别宝物礼盒打开后,可以在两种宝物礼盒中选择一种,远古兽人族的神秘宝物礼盒、兽人族英雄的宝珠礼盒,很多小伙伴不知道怎么选择才好,小编今天带来一篇DNF兽人族的特别宝物礼盒选择建议,希望大家喜dnf资讯

2021-02-25 18:54:41   怪物猎人世界老练的兽人族学者   兽人族永不为奴除非