>create table stream (
ip text,
stime int,
visits int,
info text);
if($day$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;$iecho '';
$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$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$result=mysql_db_query('ajax',$query,$mlink);
echo
浏览总人数:.mysql_num_rows($result);
echo '
';
echo '';
echo 'ip位址
最近时间
次数
用户资讯 ';
echo
;
while($row=mysql_fetch_object($result)){
echo '';
echo ''.$row->ip.' ';
echo ''.date(h:i:sa,$row->stime).' ';
echo ''.$row->visits.' ';
echo ''.$row->info.' ';
echo
;
}
echo
;
echo '';
}
mysql_close($mlink);
?>
http://www.bkjia.com/phpjc/315149.htmlwww.bkjia.comtruehttp://www.bkjia.com/phpjc/315149.htmltecharticlecreate table stream ( ip text, stime int, visits int, info text); ? if($day0)$day=0; $mlink=mysql_connect('localhost','ajax','xxxxxxx'); //统计至今首页被浏览的总次数 $q...