>create table stream (ip text,sTime int,visits int,info text);浏览首页总累积次数:';if($row=mysql_fetch_object($result)){echo $row->tvisits;}$week=array("星期日","星期一","星期二","星期三","星期四","星期五","星期六");for($i=0;$i<=$day;$i ){echo '
';echo '';echo '
";echo '
';}mysql_close($mlink);?>
';$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);?>