PHP系统流量分析的程序

ip text,

sTime int,

visits int,

info text);

if($day<0)$day=0;

$mlink=mysql_connect('localhost','ajax','xxxxxxx');

//统计至今首页被浏览的总次数

$query="select SUM(visits) as tvisits from stream";

$result=mysql_db_query('ajax',$query,$mlink);

echo '浏览首页总累积次数:';

if($row=mysql_fetch_object($result)){

echo $row->tvisits;

}

$week=array("星期日","星期一","星期二","星期三","星期四","星期五","星期六");

for($i=0;$i<=$day;$i++){

echo '

';

$ctime1=time()-24*3600*$i;

$ctime2=time()-24*3600*($i-1);

echo '日期:'.date("m月d日",$ctime1).$week[date("w",$ctime1)];

echo "";

$stoday1=mktime(0,0,0,date(m,$ctime1),date(d,$ctime1),date(Y,$ctime1));

$stoday2=mktime(0,0,0,date(m,$ctime2),date(d,$ctime2),date(Y,$ctime2));

//统计当日首页被浏览的累积次数

$query='select SUM(visits) as tvisits from stream where sTime>=';

$query.=$stoday1.' and sTime<'.$stoday2;

$result=mysql_db_query('ajax',$query,$mlink);

echo '浏览首页累积次数:';

if($row=mysql_fetch_object($result)){

echo $row->tvisits;

}

//统计当日拜访ip的数量

$query='select * from stream where sTime>='.$stoday1;

$query.=' and sTime<'.$stoday2.' order by sTime DESC';

$result=mysql_db_query('ajax',$query,$mlink);

echo "

浏览总人数:".mysql_num_rows($result);

echo '

echo '

echo '

echo "

while($row=mysql_fetch_object($result)){

echo '

echo '

echo '

echo '

echo '

echo "

}

echo "

echo '

}

mysql_close($mlink);

?>