>create table stream (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 "<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 "</span><hr size="1">";echo "<table border="0" width="100%" cellspacing="0" cellpadding="2" class="st3">";echo "<tr><td nowrap class="st2">IP位址</td><td nowrap class="st2">最近时间</td><td nowrap class="st2">次数</td><td 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);?>
