PHP系统流量分析的程序

<?php
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);
?>