PHP系统流量分析的程序

>create table stream (

ip text,

sTime int,

visits int,

info text);

<?php
if ($day < 0) $day = 0;
$mlink = mysql_connect(&#39;localhost&#39;, &#39;ajax&#39;, &#39;xxxxxxx&#39;);
//统计至今首页被浏览的总次数
$query = "select SUM(visits) as tvisits from stream";
$result = mysql_db_query(&#39;ajax&#39;, $query, $mlink);
echo &#39;<span class="st1">浏览首页总累积次数:&#39;;
if ($row = mysql_fetch_object($result)) {
    echo $row->tvisits;
}
$week = array(
    "星期日",
    "星期一",
    "星期二",
    "星期三",
    "星期四",
    "星期五",
    "星期六"
);
for ($i = 0; $i <= $day; $i++) {
    echo &#39;<p>&#39;;
    $ctime1 = time() - 24 * 3600 * $i;
    $ctime2 = time() - 24 * 3600 * ($i - 1);
    echo &#39;<span class="st4">日期:&#39; . 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 = &#39;select SUM(visits) as tvisits from stream where sTime>=&#39;;
    $query.= $stoday1 . &#39; and sTime<&#39; . $stoday2;
    $result = mysql_db_query(&#39;ajax&#39;, $query, $mlink);
    echo &#39;<span class="st3">浏览首页累积次数:&#39;;
    if ($row = mysql_fetch_object($result)) {
        echo $row->tvisits;
    }
    //统计当日拜访ip的数量
    $query = &#39;select * from stream where sTime>=&#39; . $stoday1;
    $query.= &#39; and sTime<&#39; . $stoday2 . &#39; order by sTime DESC&#39;;
    $result = mysql_db_query(&#39;ajax&#39;, $query, $mlink);
    echo "
浏览总人数:" . mysql_num_rows($result);
    echo &#39;</span><hr size="1">&#39;;
    echo &#39;<table border="0" width="100%" cellspacing="0" cellpadding="2" class="st3">&#39;;
    echo &#39;<tr><td nowrap class="st2">IP位址</td>
<td nowrap class="st2">最近时间</td>
<td nowrap class="st2">次数</td>
<td nowrap class="st2">用户资讯</td>&#39;;
    echo "</tr>";
    while ($row = mysql_fetch_object($result)) {
        echo &#39;<tr>&#39;;
        echo &#39;<td nowrap>&#39; . $row->ip . &#39;</td>&#39;;
        echo &#39;<td nowrap>&#39; . date("h:i:sa", $row->sTime) . &#39;</td>&#39;;
        echo &#39;<td nowrap>&#39; . $row->visits . &#39;</td>&#39;;
        echo &#39;<td nowrap>&#39; . $row->info . &#39;</td>&#39;;
        echo "</tr> ";
    }
    echo "</table>";
    echo &#39;<hr size="1">&#39;;
}
mysql_close($mlink);
?>