>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 浏览首页总累积次数:;
if($row=MySQL(和PHP搭配之最佳组合)_fetch_object($result)){
echo $row->tvisits;
}
$week=array("星期日","星期一","星期二","星期三","星期四","星期五","星期六");
for($i=0;$i<=$day;$i++){
echo
;
$ctime1=time()-24*3600*$i;
$ctime2=time()-24*3600*($i-1);
echo 日期:.date("m月d日",$ctime1).$week[date("w",$ctime1)];
echo "";
$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<.>
$result=MySQL(和PHP搭配之最佳组合)_db_query(ajax(动态网站静态化),$query,$mlink);
echo 浏览首页累积次数:;
if($row=MySQL(和PHP搭配之最佳组合)_fetch_object($result)){
echo $row->tvisits;
}
//统计当日拜访ip的数量
$query=select * from stream where sTime>=.$stoday1;
$query.= and sTime<. order by stime desc>
$result=MySQL(和PHP搭配之最佳组合)_db_query(ajax(动态网站静态化),$query,$mlink);
echo "
浏览总人数:".MySQL(和PHP搭配之最佳组合)_num_rows($result);
echo
;
echo
echo
IP位址最近时间次数用户资讯;echo "
";while($row=MySQL(和PHP搭配之最佳组合)_fetch_object($result)){
echo
;echo
.$row->ip.;echo
.date("h:i:sa",$row->sTime).;echo
.$row->visits.;echo
.$row->info.;echo "
";}
echo "
";echo
;
}
MySQL(和PHP搭配之最佳组合)_close($mlink);
?>