PHP系统流量分析的程序

时间:2010-01-20 08:24:17  来源:第二电脑网  作者:第二电脑网

  第二电脑网导读:ysql_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=...
  正文:

 >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);
  ?>


PHP系统流量分析的程序》由第二电脑网原创提供,转载请注明:http://www.002pc.com/master/College/Programming/PHP/12057.html


关键字:

关于《PHP系统流量分析的程序》文章的评论

站内搜索: 高级搜索

热门搜索: Windows style 系统 tr IP QQ CPU 安装 function 注册 if td