PHP Learning notes: PHP network traffic statistics System

Source: Internet
Author: User
Tags contains datetime key php and php and mysql create database
Description: Code Source "PHP and MySQL Web application Development" book, there is some of the code is modified, after my test all can be used.   This IP address shown in the normal, my computer is supported IPv6.       Database scripts for this example ~ ~ Execute set names GBK first;   (because the script contains Chinese) then executes the statement: source D:\test\Vote.sql;  
CREATE DATABASE IF not EXISTS fluxstat COLLATE ' gb2312_chinese_ci ';
Use Fluxstat; CREATE TABLE IF not EXISTS webinfo (Id INT auto_increment PRIMARY KEY, WebName VARCHAR (m), Weburl Varcha

R (M), StartTime DATETIME, Ntotalnum int, Ndaymax int); INSERT into Webinfo (WebName, Weburl, StartTime, Ntotalnum, Ndaymax) VALUES (' Traffic statistics System home ', ' Http://localhost/test3/FluxSta

T/index.php ', ' 2015-07-07 0:0:0 ', 0, 0);
    CREATE TABLE IF not EXISTS visitors (Id INT auto_increment PRIMARY KEY, Vtime DATETIME, VIP VARCHAR (50),

VOS VARCHAR, Vexp VARCHAR, VRef VARCHAR (50)); CREATE TABLE IF not EXISTS fluxstat (Id INT auto_increment PRIMARY KEY, D1 int, D2 int, D3 int, D4 int, D5 int, D6 int, D7 int, D8 int, D9 int, D10 int, D11 int, D12 int, D13 int, D int, D15 int, D16 int, D17 int, D18 int, D19 int, D20 int, D21 int, D22 int, D23 in
 T   D24 int, D25 int, D26 int, D27 int, D28 int, D29 int, D30 int, D31 int, mtotalnum int) ;
Style. The CSS CSS style code class file contains 3 file fluxstat.php (Fluxstat classes), visitors.php (visitors Class), and webinfo.php (Webinfo Class) FLUXSTAT.P Number of daily visits to HP storage sites

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.