>create table stream (
ip text,
sTime int,
visits int,
info text);
立即学习“PHP免费学习笔记(深入)”;
浏览首页总累积次数:';
if ($row = mysql_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<' . $stoday2;
$result = mysql_db_query('ajax', $query, $mlink);
echo '浏览首页累积次数:';
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 '
';
echo '| IP位址 | 最近时间 | 次数 | 用户资讯 | '; echo "
| ' . $row->ip . ' | '; echo '' . date("h:i:sa", $row->sTime) . ' | '; echo '' . $row->visits . ' | '; echo '' . $row->info . ' | '; echo "
'; } mysql_close($mlink); ?>











