>create table stream (
ip text,
sTime int,
visits int,
info text);
'; $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 '
| IP位址 | 最近时间 | 次数 | 用户资讯 | '; echo "
| '.$row->ip.' | '; echo ''.date("h:i:sa",$row->sTime).' | '; echo ''.$row->visits.' | '; echo ''.$row->info.' | '; echo "
'; } mysql_close($mlink); ?>```