文章详情

Php文档 Php问答 行业资讯 Php论坛 Php手册 Php博客
  • 游戏榜单
  • 软件榜单
关闭导航
热搜榜
热门下载
热门标签
关闭搜索
php爱好者> php文档>发款php蜘蛛插件只要有mysql就可用

发款php蜘蛛插件只要有mysql就可用

时间：2010-10-01  来源：lrjxgl

有时候我们为了看一下蜘蛛爬行的情况，不得不对日志进行大量的分析，由此想做一款插件可以记录蜘蛛的情况。在第一次做的时候，只是记录下蜘蛛的爬行次数，不大好分析。

于是昨天便认真的做了一下，功能多一点，可以对各种搜索引擎统计分析。可以在多个时间段进行查看。其实代码很简单，为了更简洁些，代码压缩到6k.分为6个文件

1.安装程序 spilder_install.php 

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>安装插件</title>
</head>
<?php

if($_POST['act']=='install')//如果是安装
{
        $mysql_host=trim($_POST['mysql_host']);//获取主机
        $mysql_user=trim($_POST['mysql_user']);//获取用户名
        $mysql_pwd=trim($_POST['mysql_pwd']);//获取密码
        $mysql_db=trim($_POST['mysql_db']);//数据库
        $table_prefix=trim($_POST['table_prefix']);//获取前缀
        if($link=mysql_connect($mysql_host,$mysql_user,$mysql_pwd))
        {
                echo "连接服务器成功！.................<br>";
        }
        else
        {
                echo "<script>alert('链接出错！请检查数据库服务器配置！');history.go(-1);</script>";
        }
        if(mysql_select_db($mysql_db,$link))
        {
                echo "连接数据库成功！.............<br>正在创建表................<br>";
        }
        $sql="CREATE TABLE `spilder_sp_count` (
  `id` bigint(20) NOT NULL auto_increment,
  `r_time` int(11) NOT NULL,
  `r_name` varchar(50) NOT NULL,
  `r_url` varchar(200) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=gb2312 AUTO_INCREMENT=4 ;
";
mysql_query("DROP TABLE IF EXISTS `".$table_prefix."sp_count`;");//删除已存在
$sql=str_replace("spilder_",$table_prefix,$sql);//替换前缀

        if(mysql_query($sql))
        {
                echo "表创建成功！正在写入文件";
        }
        $f=file_get_contents("spilder_config.php");//获取配置内容
        $f=str_replace(" ","",$f);//去除空格
        $f=preg_replace("/mysql_host=.*;/iUs","mysql_host='{$mysql_host}';",$f);
        $f=preg_replace("/mysql_user=.*;/iUs","mysql_user='{$mysql_user}';",$f);
        $f=preg_replace("/mysql_pwd=.*;/iUs","mysql_pwd='{$mysql_pwd}';",$f);
        $f=preg_replace("/mysql_db=.*;/iUs","mysql_db='{$mysql_db}';",$f);
        $f=preg_replace("/table_prefix=.*;/iUs","table_prefix='{$table_prefix}';",$f);
        $f=preg_replace("/sp_admin=.*;/iUs","sp_admin='{$sp_admin}';",$f);
        file_put_contents("spilder_config.php",$f);
        file_put_contents("isinstall.txt","OK");
        echo "恭喜！荐礼啦蜘蛛统计程序安装成功 <a href=\"index.php\">查看</a>";
        exit();
}



?>
<body>
<table width="600" border="0" align="center">
  <tr>
    <td align="center">荐礼啦 蜘蛛统计查看器</td>
  </tr>
</table>
<form method="post">
<table width="600" border="0" align="center" cellspacing="0">
  <tr>
    <td width="280"> </td>
    <td width="610">开始安装</td>
  </tr>
  <tr>
    <td align="right">服务器：</td>
    <td><input name="mysql_host" type="text" id="mysql_host" value="localhost" />
      (一般不用改)</td>
  </tr>
  <tr>
    <td align="right">用户名：</td>
    <td><input type="text" name="mysql_user" id="mysql_user" /></td>
  </tr>
  <tr>
    <td align="right">密码：</td>
    <td><input type="password" name="mysql_pwd" id="mysql_pwd" /></td>
  </tr>
  <tr>
    <td align="right">数据库：</td>
    <td><input type="text" name="mysql_db" id="mysql_db" /></td>
  </tr>
  <tr>
    <td align="right">表前缀：</td>
    <td><input name="table_prefix" type="text" id="table_prefix" value="spilder_" />
      <input name="act" type="hidden" id="act" value="install" /></td>
  </tr>
  <tr>
    <td align="right">管理密码：</td>
    <td><input type="password" name="sp_admin" id="sp_admin" /></td>
  </tr>
  <tr>
    <td align="right"> </td>
    <td><input type="submit" name="button" id="button" value="安装" /></td>
  </tr>
</table>
</form>
</body>
</html>

2.蜘蛛记录文件 

<?php
require("spilder_config.php");//调用配置文件
$link=mysql_connect($mysql_host,$mysql_user,$mysql_pwd) or die("服务器连接出错");//链接数据库
mysql_select_db($mysql_db,$link) or die('数据库连接出错');

$searchbot =  get_naps_bot();
if($searchbot)
{
        date_default_timezone_set('PRC');  //设置默认时区
        $r_time=strtotime(date("Y-m-d H:i:s"));//最后更新时间
        
        $ServerName = $_SERVER["SERVER_NAME"] ;     
        $ServerPort = $_SERVER["SERVER_PORT"] ;     
        $ScriptName = $_SERVER["SCRIPT_NAME"] ;     
        $QueryString = $_SERVER["QUERY_STRING"]  ;    
                 
        $url="http://".$ServerName ;
        If ($ServerPort != "80") 
         {
                 $url = $url.":".$ServerPort ;
        }    
        $url=$url.$ScriptName ;
        If ($QueryString !="")
         {
                        $url=$url."?".$QueryString  ; 
        }      
        
        
        //$url="http://".$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'];
        $GLOBALS['db']->db_query("insert into {$table_prefix}sp_count(r_time,r_name,r_url) values('$r_time','$searchbot','$url')");
}

function get_naps_bot()
{
  $useragent = strtolower($_SERVER['HTTP_USER_AGENT']);
  
  if (strpos($useragent, 'googlebot') !== false){
    return 'Googlebot';
  }elseif (strpos($useragent, 'msnbot') !== false){
    return 'MSNbot';
  }elseif (strpos($useragent, 'slurp') !== false){
    return 'Yahoobot';
  }elseif (strpos($useragent, 'baiduspider') !== false){
    return 'Baiduspider';
  }elseif (strpos($useragent, 'sogou') !== false){
    return 'Sogoubot';
  }elseif (strpos($useragent,'soso') !== false){
                return 'Sosobot';
  }elseif(strpos($useragent,'youdao')!==false)
  {
          return 'Youdao';
  }
  
  else
  {
        
          return false;
  }

}
?>

3.蜘蛛统计查看文件 

<?php
session_start();
require("spilder_config.php");
if($_GET['act']=='logout')
{
        $_SESSION['ss_sp_admin']='';//清空
}
if($_GET['sp_admin_login'])
{
        if($_GET['sp_admin_login']==$sp_admin)
        {
                $_SESSION['ss_sp_admin']=$sp_admin;
        }
}
date_default_timezone_set('PRC');  //设置默认时区
$day_start=strtotime(date("Ymd")."000001");//一天的开始时间
$day_out=strtotime(date("Ymd")."235959");//一天的结束时间
$day=3600*24;//一天的时间
$link=mysql_connect($mysql_host,$mysql_user,$mysql_pwd) or die("服务器连接出错");

mysql_select_db($mysql_db,$link) or die('链接数据库出错');//连接数据库
if($_GET['act']=='del')
{
        if($_SESSION['ss_sp_admin']<>'')
        {
                if($_GET['dt']==0)//清空
                {
                        mysql_query("delete from {$table_prefix}sp_count ");
                }
                $d_time=0;
                if($_GET['dt']==1)//删除30天前
                {
                        $d_time=$day_out-$day*30;
                }elseif($_GET['dt']==2)//删除60天前
                {
                        $d_time=$day_out-$day*60;
                }elseif($_GET['dt']==3)//删除90天前
                {
                        $d_time=$day_out-$day*90;
                }elseif($_GET['dt']==4)//删除180天前
                {
                        $d_time=$day_out-$day*180;
                }elseif($_GET['dt']==5)//删除360天前
                {
                        $d_time=$day_out-$day*360;
                }
                if($d_time>0)
                {
                        mysql_query("delete from {$table_prefix}sp_count where r_time<'$d_time'");//删除数据
                        
                }
        }
}

$ss=intval($_GET['ss']);
if($ss>0)//查看分类统计
{
        if($ss==999)//清空分类
        {
                $_SESSION['ss_ss']='';
        }else
        {
                $_SESSION['ss_ss']=$ss;
        }
}
$ss=$_SESSION['ss_ss'];
if($ss==1)
{
        $ss='Baiduspider';
}elseif($ss==2)
{
        $ss='Googlebot';
}elseif($ss==3)
{
        $ss="MSNbot";
}elseif($ss==4)
{
        $ss="Yahoobot";
}elseif($ss==5)
{
        $ss="Sogoubot";
}elseif($ss==6)
{
        $ss="Sosobot";
}elseif($ss==7)
{
        $ss=7;
}

$t=intval($_GET['t']);//查看时间分类统计
if($t==0)//时时情况
{
        if(empty($_SESSION['ss_ss']))
        {
        $sql =" select * from {$table_prefix}sp_count order by id desc   ";//最新情况
        $sql2="select count(*) from {$table_prefix}sp_count ";
        
        
        }else
        {
                $sql="select * from {$table_prefix}sp_count where r_name='$ss' order by id desc ";
                $sql2="select count(*) from {$table_prefix}sp_count where r_name='$ss' ";
        }
        
        $rscount=mysql_query($sql2);
        $rscount=@mysql_fetch_array($rscount);
        $rscount=$rscount[0];//获取总记录数
        $page=intval(trim($_GET['page']));//当前页数
        $pagesize=30;//每页记录数
        $pagecount=ceil($rscount/$pagesize);//获取总页数
        $pageurl="";
        if($page<=1)
        {       
                $page=1;
                $pageurl.=" 首页 上一页";
        }else
        {
                $pageurl .=" <a href='?page=1&ss=".$ss."'>首页</a>  <a href='?ss=".$ss."&page=".($page-1)."'>上一页</a>";
        }
        
        if($page>=$pagecount)
        {
                $page=$pagecount;
                $pageurl .=" 下一页  尾页";
        }else
        {
                $pageurl .=" <a href='?ss=".$ss."&page=".($page+1)."'>下一页</a>  <a href='?ss=".$ss."&page=".$pagecount."'>尾页</a>";
        }
        if($page<=1)
        {
                $page=1;
        }
        $start_rs=intval(($page-1)*$pagesize);//开始
        $end_rs=intval($page*$pagesize);//结束
        
        $sql .=" limit {$start_rs},{$end_rs} ";
}

if($t==1)//查看今天天统计
{
        $s_time=$day_start;//开始时间
        $e_time=$day_out;//结束时间
        $sql="select count(*) as ct,r_name from {$table_prefix}sp_count where r_time between '$s_time' and '$e_time' group by r_name ";
}elseif($t==2)//查看昨天统计
{
        $s_time=$day_start-$day;//开始
        $e_time=$day_out-$day;//结束
        $sql="select count(*) as ct,r_name from {$table_prefix}sp_count where r_time between '$s_time' and '$e_time' group by r_name ";
        
}elseif($t==3)//查看前天天的统计
{
        $s_time=$day_start-$day*2;
        $e_time=$day_out-$day*2;
        $sql="select count(*) as ct,r_name from {$table_prefix}sp_count where r_time between '$s_time' and '$e_time' group by r_name";
        
}elseif($t==4)//查看七天的统计
{
        $s_time=$day_start-$day*7;
        $e_time=$day_out;
        $sql="select count(*) as ct,r_name from {$table_prefix}sp_count where r_time between '$s_time' and '$e_time' group by r_name ";
        
}
elseif($t==5)//查看30天的
{
        $s_time=$day_start-$day*30;
        $e_time=$day_out;
        $sql="select count(*) as ct,r_name from {$table_prefix}sp_count where r_time between '$s_time' and '$e_time' group by r_name ";
        
}elseif($t==6)//查看90天的统计
{
        $s_time=$day_start-$day*90;
        $e_time=$day_out;
        $sql="select count(*) as ct,r_name from {$table_prefix}sp_count where r_time between '$s_time' and '$e_time' group by r_name ";
        
}
$res=mysql_query($sql);// or die("请先安装程序<a href='spilder_install.php'>安装</a>");
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>显示蜘蛛记录情况</title>
<style type="text/css">
td{font-size:14px;}
a,a:link{text-decoration:none; color:#000; }
a:hover{color:#F00;}
</style>
</head>
<body>

<table width="800" border="0" align="center" cellspacing="1" bgcolor="#CCCCCC" style="margin-bottom:6px;">
  <tr>
    <td height="28" align="center" bgcolor="#66CC00"><h1><a href="http://www.jianlila.com" target="_blank">荐礼啦</a> 蜘蛛查看器</h1></td>
  </tr>
</table>

<table width="800" border="0" align="center" cellspacing="1" bgcolor="#CCCCCC">
  <tr>
    <td width="65" height="38" bgcolor="#FFFFFF">分类查看</td>
    <td width="403" align="center" bgcolor="#FFFFFF">  
    <a href="?ss=999">所有的</a>  
    <a href="?ss=1">百度</a>  
    <a href="?ss=2">谷歌</a>  
    <a href="?ss=3">必应</a>  
    <a href="?ss=4">雅虎</a>  
    <a href="?ss=5">搜狗</a>  
    <a href="?ss=6">搜搜</a> 
    <a href="?ss=7">有道</a></td>
    <td width="322" bgcolor="#FFFFFF"> 
    <a href="?t=0">时时</a>  
    <a href="?t=1">今天</a>  
    <a href="?t=2">昨天</a> 
     <a href="?t=3">前天</a> 
      <a href="?t=4">七天</a> 
      <a href="?t=4">30天</a> 
      <a href="?t=5">90天</a> 
    </td>
  </tr>
</table>
<?php 
if($_SESSION['ss_sp_admin']==$sp_admin)
{
?>
<table width="800" border="0" align="center" cellspacing="1" bgcolor="#CCCCCC" style="margin-top:12px; margin-bottom:12px;">
  <tr>
    <td width="208" align="right" bgcolor="#FFFFFF">管理  <a href="?act=logout">退出</a>   </td>
    <td width="585" align="center" bgcolor="#FFFFFF">
    <a href="?act=del&dt=0" onclick="return confirm('确定清空')">清空</a>  
   <a href="?act=del&dt=1" onclick="return confirm('确定删除？')">30天前</a>  
   <a href="?act=del&dt=2" onclick="return confirm('确定删除？')">60天前</a>  
   <a href="?act=del&dt=3" onclick="return confirm('确定删除？')">90天前</a>   
   <a href="?act=del&dt=4" onclick="return confirm('确定删除？')">180天前</a>   
   <a href="?act=del&dt=5" onclick="return confirm('确定删除？')">360天前</a></td>
  </tr>
</table>
<?php
}
?>

<?php
if($t==0)
{
?>
<table width="800" border="0" align="center" cellspacing="1" bgcolor="#CCCCCC" style="margin-top:6px;">
  <tr>
    <td width="133" align="center" bgcolor="#FFFFFF">蜘蛛</td>
    <td width="217" align="center" bgcolor="#FFFFFF">时间</td>
    <td width="440" align="center" bgcolor="#FFFFFF">地址</td>
  </tr>
  <?php

  while($rs=mysql_fetch_array($res))
  {
  ?>
  <tr>
    <td align="center" bgcolor="#FFFFFF"><?php echo $rs['r_name'];?></td>
    <td align="center" bgcolor="#FFFFFF"><?php echo date("Y-m-d H:i:s",$rs['r_time']); ?></td>
    <td align="center" bgcolor="#FFFFFF"><a href="<?php echo $rs['r_url'];?>" target="_blank"> <?php echo $rs['r_url'];?></a></td>
  </tr>
  <?php
  }
  ?>
</table>
<table width="800" border="0" align="center" cellspacing="1" bgcolor="#CCCCCC" style="margin-top:20px; margin-bottom:20px;">
  <tr>
    <td align="center" bgcolor="#FFFFFF"><?php echo $pageurl;?></td>
  </tr>
</table>

<?php
}else{
?>
<table width="800" border="0" align="center" cellspacing="1" bgcolor="#CCCCCC" style="margin-top:6px;">
  <tr>
    <td width="219" align="center" bgcolor="#FFFFFF">蜘蛛</td>
    <td width="574" align="center" bgcolor="#FFFFFF">统计</td>
  </tr>
<?php
while($rs=mysql_fetch_array($res))
{
?>
  <tr>
    <td align="center" bgcolor="#FFFFFF"><?php echo $rs['r_name'] ?></td>
    <td align="center" bgcolor="#FFFFFF"><?php echo $rs['ct'];?></td>
  </tr>
  <?php
}
  
  ?>
</table>


<?php
}

?>
<table width="800" border="0" align="center" cellspacing="1" bgcolor="#CCCCCC" style="margin-top:6px;">
  <tr>
    <td align="center" bgcolor="#FFFFFF">友情链接：<a href="http://www.jianlila.com" target="_blank">荐礼啦</a> <a href="http://www.aiwobama.com" target="_blank">爱我爸妈</a> <a href="http://www.heikediguo.net">黑客帝国</a></td>
  </tr>
</table>

</body>
</html>

 

蜘蛛统计插件功能觉得差不多了，演示地址：http://www.jianlila.com/spilder_count/spilder_show.php 如有意见可以提出

下载地址：http://www.jianlila.com/spilder_count/spilder_show.rar

转载请注明：来源http://www.jianlila.com 爱我爸妈创业组

 

 

 

相关阅读 更多 +
排行榜 更多 +
辰域智控app

辰域智控app

系统工具 下载
网医联盟app

网医联盟app

运动健身 下载
汇丰汇选App

汇丰汇选App

金融理财 下载

Copyright 2006-2020 (phpxiu.com) All Rights Reserved.

本站为非盈利性网站，不接受任何广告。php爱好者