- A+
所属分类:PHP编程
- >create table stream (
- ip text,
- sTime int,
- visits int,
- info text);
- <?
- 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);
- ?>