A Title advertisement management system based on ASP (I.)

Banner ads are the most common form of advertising on the web. This article introduces a banner ad management system based on IIS and ASP, the system supports the management of advertisers and advertising, can randomly select ads and generate HTML code to display ads (but the level of reference ads, the number of display restrictions, clicks limit), and can record the advertising display, click the historical record.
I. DATABASE table structure
The title ad, banner ad, is the most common form of advertising on the web. The title AD management system introduced in this article uses Access database Db.mdb to save data. Db.mdb contains three tables: advertisement holds information about the advertisement, Advertiser saves The Advertiser information, Bannerhistory saves the history of the advertisement display and clicks. The three tables are structured as follows:
Table field type description
Advertisment (AD) Advertiserid the number of the digital advertiser.
The Status number indicates whether the advertisement is allowed to display. 0 indicates no display, 1 indicates display. When the number of ad displays (or clicks) exceeds the display limit (or the number of hits), the system sets the value to 0. can also be in the advertising management function manually prohibit advertising display. (within the management module, 1 is displayed as "available," and 0 is displayed as "unavailable.") ）
ImageURL the URL of the text ad picture, which is the location of the picture.
ImageWidth the width of the digital advertising picture.
ImageHeight the height of the digital advertising picture.
Link text Advertisers are required by the advertising links.
Text for alttext text ad pictures. (Alt attribute for tag)
Weight Digital display level. The level value affects how frequently the advertisement appears. This article implements predefined 10 levels (1-10). The higher the level value the greater the chance that the advertisement will appear.
StartDate Date Time Start date
EndDate Date Time End date. In this implementation, these two date values do not affect the display of ads, as long as the number of displayed and the number of clicks did not exceed the limit, the ads can always be displayed.
Viewlimit number Display number limit. The status changes to 0 when the ad is displayed more than this value.
Clickslimit number of clicks limit. The status will change to 0 when the number of ad clicks exceeds this value.
Adid Digital advertising number, automatically generated by the system, is the only identification of advertising. Adid is the primary key for this table.
Impressions number of times this advertisement has been shown.
Clickthroughs number of times this ad was clicked.
Advertiser (ad customer) name text customer Name
Address text addresses
CityStateZip text city and zip code
Phone text telephone
Fax text Faxes
URL Text Client Site
Login text The logon name used by the customer to query their advertising display and clicks via the Web.
Password the password used by the text client to log on.
Email text message.