ページブラウズ統計の実装

<?php

session_start();

$server = '127.0.0.1';

$username = 'root';

$password = '';

$conn = mysql_connect($server, $username, $password);

$e = mysql_select_db('test',$conn);

mysql_query("SET NAMES UTF8");



//$sql = "select * from tongji";

//$result =mysql_query($sql);

//

//$e = mysql_fetch_array($result);







$ipdress = $_SERVER['REMOTE_ADDR'];



$data_id =$_GET['id'];



$time = time();



$_SESSION['data_id']=$_GET['id'];



$session_id = session_id();







$sql = "INSERT INTO tongji VALUES ('NULL','$data_id','$time','$ipdress','$session_id')";



$result =mysql_query($sql);

if($result){

    echo 'OK';

}  else {

    echo '     ，        ';

}

//$e = mysql_fetch_array($result);





?>







<?php

//        html  ，           php  
//id        ，                    id
//    www.test.com/test.php?id=1


$time =time();

$sql = "select count(distinct session_id) from tongji where data_id =$data_id and $time - visit_time > 600";

//600   10  

$result =mysql_query($sql);

$r = mysql_fetch_array($result);

var_dump($r);



//    ，                               ，               ，             ，       

//        

/*

tongji



                         

id    int(20)                   id 

data_id    int(20)                   id 

visit_time    int(20)                    

ipdress    varchar(50)                 ip 

session_id    varchar(50)               session  id 

 * 

 */