PHP系统流量分析的程序

create table stream (ip text,sTime int,visits int,info
text);?if($day0)$day=0;$mlink=mysql_connect(‘localhost’,’ajax’,’xxxxxxx’);//统计至今首页被浏览的总次数$query=select
SUM(visits) as tvisits from
stream;$result=mysql_db_query(‘ajax’,$query,$mlink);echo ‘span
class=st1浏览首页总累积次数:’;if($row=mysql_fetch_object($result)){echo
$row-tvisits;}$week=array(星期日,星期一,星期二,星期三,星期四,星期五,星期六);for($i=0;$i=$day;$i++){echo
‘p’;$ctime1=time()-24*3600*$i;$ctime2=time()-24*3600*澳门新葡亰手机版,($i-1);echo
‘span class=st4日期:’.date(m月d日,$ctime1).$week[date(w,$ctime1)];echo
/span;$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
‘span
class=st3浏览首页累积次数:’;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 ‘/spanhr size=1’;echo ‘table
border=0 width=100% cellspacing=0 cellpadding=2 class=st3’;echo ‘trtd
nowrap class=st2IP位址/tdtd nowrap class=st2最近时间/tdtd nowrap
class=st2次数/tdtd nowrap class=st2用户资讯/td’;echo
/tr;while($row=mysql_fetch_object($result)){echo ‘tr’;echo ‘td
nowrap’.$row-ip.’/td’;echo ‘td
nowrap’.date(h:i:sa,$row-sTime).’/td’;echo ‘td
nowrap’.$row-visits.’/td’;echo ‘td nowrap’.$row-info.’/td’;echo /tr
;}echo /table;echo ‘hr size=1’;}mysql_close($mlink);?