PHP系统流量分析的程序

>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）;
？>