来源:自学PHP网 时间:2014-12-25 09:57 作者: 阅读:次
[导读] PHP系统流量分析的程序,gt;createtablestreamiptext,sTimeint,visitsint,infotext;lt;?if$daylt;0$day=0;$mlink=MySQL_connect'localhost','Ajax','xxxxxxx';//统计至今首页被浏览的总次数$query=quot;selectSUMvisitsastvisitsfromstre...
>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网专注网站建设学习,PHP程序学习,平面设计学习,以及操作系统学习
京ICP备14009008号-1@版权所有www.zixuephp.com
网站声明:本站所有视频,教程都由网友上传,站长收集和分享给大家学习使用,如由牵扯版权问题请联系站长邮箱904561283@qq.com