>create table stream (
ip text,
sTime int,
visits int,
info text);
<?
if($day<0)$day=0;
$mlink=mysql_connect('localhost','ajax','xxxxxxx');
//統(tǒng)計(jì)至今首頁被瀏覽的總次數(shù)
$query="select SUM(visits) as tvisits from stream";
$result=mysql_db_query('ajax',$query,$mlink);

echo '<span class="st1">瀏覽首頁總累積次數(shù):';
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));
//統(tǒng)計(jì)當(dāng)日首頁被瀏覽的累積次數(shù)
$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">瀏覽首頁累積次數(shù):';
if($row=mysql_fetch_object($result)){
echo $row->tvisits;
}
//統(tǒng)計(jì)當(dāng)日拜訪ip的數(shù)量
$query='select * from stream where sTime>='.$stoday1;
$query.=' and sTime<'.$stoday2.' order by sTime DESC';
$result=mysql_db_query('ajax',$query,$mlink);

echo "
瀏覽總?cè)藬?shù):".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">最近時(shí)間</td>
<td nowrap class="st2">次數(shù)</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);
?>

最新評(píng)論