PHP simple website traffic statistics program (source, search engine, IP, keywords)

PHP simple website traffic statistics program (source, search engine, IP, keywords)_PHP tutorial

WBOY

Release： 2016-07-13 10:44:18

Original

1244 people have browsed it

This is an example of website traffic statistics based on php and mysql. It can count the source, search engine, IP, and keywords of people visiting the website. I hope this example will be helpful to all students.

Traffic statistics tools, such as cnzz, Baidu statistics, 51la, are all very good and have powerful functions. I have nothing to do, I wrote a simple traffic statistics tool, but it can only count access time, visitor IP, access source, visited pages, from seo/seo.html" target="_blank">search engines and searches Keywords. It is definitely trivial compared to professional traffic statistics work, but to put it bluntly, most of the collected data is not as difficult as we imagine. Sometimes it only requires a system variable or extracting some information from the URL. You can get the corresponding statistical information

(data table structure and some statistical information)

Program part:

The code is as follows

Copy code

visited(); //Call statistical function (preferably placed on a public page)

//访问量
function visited(){
    $now_time = time();
    $referer_url = $_SERVER['HTTP_REFERER'];    //来自的页面地址
    $from_spider = $keywords = '';
    if(!empty($referer_url)){
        if(strstr($referer_url,'www.baidu.com')){
            $referer_url = explode("&",$referer_url);
            foreach($referer_url as $val){
                if(strstr($val,'wd=')){
                    $keywords = explode("wd=",$val);
                    $keywords = $keywords[1];
                }
            }
            $from_spider = '百度';
            $keywords = urldecode($keywords);
        }elseif(strstr($referer_url,'www.google')){
            $referer_url = explode("&",$referer_url);
            foreach($referer_url as $val){
                if(strstr($val,'q=')){
                    $keywords = explode("q=",$val);
                    $keywords = $keywords[1];
                }
            }
            $from_spider = '谷歌';
            $keywords = urldecode($keywords);
        }
    }
    //只判断了百度和谷歌的，其他的原理一样
    $theData = array(
        'access_time'    => $now_time,
        'access_date'    => date("Y-m-d",$now_time),
        'access_url'    => $_SERVER['REQUEST_URI'],
        'referer_url'    => $_SERVER['HTTP_REFERER'],
        'keywords'        => $keywords,
        'ip_address'    => $_SERVER['REMOTE_ADDR'],
        'from_spider'    => $from_spider,
    );
    $sql = "insert into stats (access_time,access_date,access_url,referer_url,keywords,ip_address,from_spider) values ('".$theData['access_time']."','".$theData['access_date']."','".$theData['access_url']."','".$theData['referer_url']."','".$theData['keywords']."','".$theData['ip_address']."','".$theData['from_spider']."')";
    echo $sql; exit;mysql_query($sql);
}