PHP系統流量分析的程序

>create table stream (
ip text,
sTime int,
visits int,
info text);
<?
if($day<0)$day=0;
$mlink=MySQL(和PHP搭配之最佳組合)_connect(localhost,ajax(動態網站靜態化),xxxxxxx);
//統計至今首頁被瀏覽的總次數
$query=”select SUM(visits) as tvisits from stream”;
$result=MySQL(和PHP搭配之最佳組合)_db_query(ajax(動態網站靜態化),$query,$mlink);

echo <span class=”st1″>瀏覽首頁總累積次數:;
if($row=MySQL(和PHP搭配之最佳組合)_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(和PHP搭配之最佳組合)_db_query(ajax(動態網站靜態化),$query,$mlink);
echo <span class=”st3″>瀏覽首頁累積次數:;
if($row=MySQL(和PHP搭配之最佳組合)_fetch_object($result)){
echo $row->tvisits;
}
//統計當日拜訪ip的數量
$query=select * from stream where sTime>=.$stoday1;
$query.= and sTime<.$stoday2. order by sTime DESC;
$result=MySQL(和PHP搭配之最佳組合)_db_query(ajax(動態網站靜態化),$query,$mlink);

echo “
瀏覽總人數:”.MySQL(和PHP搭配之最佳組合)_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(和PHP搭配之最佳組合)_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(和PHP搭配之最佳組合)_close($mlink);
?>


發佈留言

發佈留言必須填寫的電子郵件地址不會公開。 必填欄位標示為 *