Shulou(Shulou.com)06/03 Report--

This article mainly shows you "how to use ASP to write website statistics system", the content is easy to understand, clear, hope to help you solve your doubts, the following let the editor lead you to study and learn "how to use ASP to write website statistics system" this article.

In the current website statistics system, most of them are CGI, but it is very complex to write, while ASP is easy to learn and has the advantage of combining with the database, so combined with the website statistics system that I have done, I will discuss how to write the website statistics system with ASP.

Everyone has seen NetEase's website statistics system, which can count total visits, average daily visits, daily visits, maximum visits, maximum visit dates, daily traffic analysis, monthly traffic analysis, weekly traffic analysis, browser analysis, and so on.

In fact, the key to do an ASP access statistics system is the design of the system table structure. And how to collect the user's CGI variables and how to display the user's information. In other words, the key to the system is two ASP programs, the statistics program and the display program.

First of all, let's look at how to collect the user's access information.

To compile the access statistics, we need to know the following information about the user, the visitor's IP (the visitor IP list can be formed according to the access IP), the visitor's browser and operating system (statistics of the visitor's browser and operating system and the proportion of all visitors' browser and operating system), and the visitor's access time (daily traffic analysis, monthly traffic analysis, weekly traffic analysis) Let's take a look at the statement using ASP to get the above information:

1. Get the visitor IP

Dim M_IP

M_IP=Request.Servervariables ("REMOTE_HOST")

Use the above statement to get the visitor's IP.

2. Get browser information

Dim O_Browser,M_BrowserType

Set O_Browser=Server.Createobject ("MSWC.BrowserType")

M_BrowserType=O_Browser.Browser+O_Browser.Version

3. Get access time

Dim M_DateTime M_DateTime=Year (Date ()) & "/" & Right ("0" & Month (Date ()), 2) & "/" Right ("0" & Day (Date ()), 2) & "/" & Right ("0" & Hour (Time ()), 2) & "& Right (" 0 "& Minute (Time ()), 2) &" & Right ("0" & Second (Time ()), 2)

4. Get the user's operating system.

You can get the visitor's http_user_agent string by using the following statement in ASP.

Dim StrUserAgent

StrUserAgent=Request.ServerVariables ("HTTP_USER_AGENT")

This string is generally in the following format:

Mozilla/4.0 (compatible; MSIE 4.01; Windows 98)

The above string indicates that the operating system used by the visitor is Windows98 and the browser is MSIE 4.01, but the format of this string is not fixed and can be changed on its own.

Some of the other major UserAgent strings we usually see are as follows:

Browsers using IE:

Mozilla/2.0 (compatible; MSIE 3.01; Windows 95)

Mozilla/4.0 (compatible; MSIE 4.0; Windows 95)

Mozilla/4.0 (compatible; MSIE 4.01; Windows 98)

Mozilla/4.0 (compatible; MSIE 5.0; Windows 98)

Mozilla/4.0 (compatible; MSIE 5.0b2; Windows NT)

Browsers using NetScape:

Mozilla/4.03 (en) (Win95; I)

Mozilla/4.08 (en) (WinNT; U; Nav)

Mozilla/4.5 (en) (WinNT; U)

Mozilla/3.04Gold (Win95; I)

Browsers using Opera:

Mozilla/4.0 (compatible; Opera/3.0; Windows 95) 3.50b10

FrontPage Editor:

Mozilla/2.0 (compatible; MS FrontPage 3.0)

Use the Sun operating system:

Mozilla/3.01Gold (X11; I; SunOS 5.7 i86pc)

Macs using PowerPc:

Mozilla/4.0 (compatible; MSIE 4.5; Mac_PowerPC)

By analyzing the above string, we can find out the rule and write a subroutine to determine what kind of operating system the visitor is using, and because the control in ASP to determine the browser type needs to update the Browser.ini file, so we can combine this string to judge the browser properties.

In what way do we count websites?

We can ask the user to add the following sentence to his home page:

< a href= "http://www.abc.com/viewer.asp?userid=username" > < img src=" http://www.abc.com/counter.asp?userid=username" > < / a > which user is the userid above? note that users and visitors are not the same concept.

Through the above string, we can collect the user's access data and provide users with a link to view the data. When we look at the page with NetEase's statistics system, we will find that it will return an icon to the user, and we can implement this function in counter.asp.

Add: response.redirect "https://cache.yisu.com/upload/information/20201211/272/44758.gif"

This statement can be added to the statistical data collection and returned to the user.

How to design the structure of the data table?

The design of table structure is an extremely important work, whether it is reasonable or not is closely related to the programming.

A website statistical system should have a user table and a statistical table.

The user table is the table that keeps the information of the registered user, and the statistical table is the table that records the value of each statistical indicator of the user. In the table of statistical values, we can specify the statistical indicators of users, and we can represent each indicator with an ID value. Here we give a simple example.

User table:

Table Name:regist_table

Field type

Username C user name

Password C password

Regdate C Registration time

Value table:

Table Name:value_table

Field type

Username c user name

Id c Statistical indicator ID

Value i

The value of datetime c statistical indicator

Id list:

Table Name:id_table

Field type

Id C Statistical indicator ID

Description of idvalue C statistical indicators

With these three watches, we can start making them.

For example, we can specify the following ID

Id idvalue

101 total visits

Number of visits on 201 days

Number of visits in 202 days

::

::

The number of visits at 2331.

In order to start counting users, we must first register users. The process for users is as follows:

Fill in the registry form-> value table of the initial user (add the corresponding ID)-> feedback the registration information to the user

-> users add links to their pages-> start statistics

We can collect all the data, so we will start to compile the statistics page of ASP.

This page is called the count page, counter.asp.

For this asp code, we need to make it collect data, save and update data according to the following process:

Collect the user name, judge whether the user name is legal, collect the visitor's information, process the information, save and update the database, and return the logo icon.

Call this ASP in the way counter.asp?user=abc.

We can collect the user name by using the corresponding method of the Request object, then check the user table to determine whether the user is legal, then take the information, use the method we mentioned above to obtain the corresponding information, and then process it and save it in the data table, but the most important thing is how to update the data, such as hourly access statistics for the day, hourly statistics for the day, etc. How we update the daily data is the main point of this program. We can take several ways, such as updating the record of every hour every day at 12:00 at midnight every day. We update the data of each day of the month on the day of the month we switch.

Let me talk about the specific process, taking monthly statistics as an example:

1, get the date and time of the last statistics

2, get the current date and time, the current month and convert it to the corresponding ID

3. Judge whether the current month is the same as the previous month, add 1 to the total if the same, add 1 to the ID of the current month, zero all month ID if different, and only add 1 to the total ID

4. According to monthly statistics, we can do hourly statistics, weekly statistics and daily statistics.

According to the above process, we can do statistics page, we should pay attention to the distribution of each ID to be classified and the meaning of the representative should be clear.

The above is all the contents of the article "how to write a website Statistics system with ASP". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.