PHP代码实现爬虫记录――超管用

实现爬虫记录本文从创建crawler 数据库，robot.php记录来访的爬虫从而将信息插入数据库crawler,然后从数据库中就可以获得所有的爬虫信息。实现代码具体如下：

数据库设计

    create table crawler  
    (  
     crawler_ID bigint() unsigned not null auto_increment primary key,
     crawler_category varchar() not null,
     crawler_date datetime not null default '-- ::',
     crawler_url varchar() not null,
     crawler_IP varchar() not null
    )default charset=utf;

以下文件 robot.php 记录来访的爬虫，并将信息写入数据库：

    <?php
     $ServerName = $_SERVER["SERVER_NAME"] ; 
     $ServerPort = $_SERVER["SERVER_PORT"] ; 
     $ScriptName = $_SERVER["SCRIPT_NAME"] ; 
     $QueryString = $_SERVER["QUERY_STRING"]; 
     $serverip = $_SERVER["REMOTE_ADDR"] ; 
     $Url="http://".$ServerName;
     if ($ServerPort != "")
     {
      $Url = $Url.":".$ServerPort ;
     } 
     $Url=$Url.$ScriptName;
     if ($QueryString !="")
     {
      $Url=$Url."?".$QueryString;
     }  
     $GetLocationURL=$Url ;
     $agent = $_SERVER["HTTP_USER_AGENT"]; 
     $agent=strtolower($agent);
     $Bot ="";
     if (strpos($agent,"bot")>-)
     {
      $Bot = "Other Crawler";
     }
     if (strpos($agent,"googlebot")>-)
     {
      $Bot = "Google";
     }   
     if (strpos($agent,"mediapartners-google")>-)
     {
      $Bot = "Google Adsense";
     }
     if (strpos($agent,"baiduspider")>-)
     {
      $Bot = "Baidu";
     }
     if (strpos($agent,"sogou spider")>-)
     {
      $Bot = "Sogou";
     }
     if (strpos($agent,"yahoo")>-)
     {
      $Bot = "Yahoo!";
     }
     if (strpos($agent,"msn")>-)
     {
      $Bot = "MSN";
     }
     if (strpos($agent,"ia_archiver")>-)
     {
      $Bot = "Alexa";
     }
     if (strpos($agent,"iaarchiver")>-)
     {
      $Bot = "Alexa";
     }
     if (strpos($agent,"sohu")>-)
     {
      $Bot = "Sohu";
     }
     if (strpos($agent,"sqworm")>-)
     {
      $Bot = "AOL";
     }
     if (strpos($agent,"yodaoBot")>-)
     {
      $Bot = "Yodao";
     }
     if (strpos($agent,"iaskspider")>-)
     {
      $Bot = "Iask";
     }
     require("./dbinfo.php");
     date_default_timezone_set('PRC'); 
     $shijian=date("Y-m-d h:i:s", time());
     // 连接到 MySQL 服务器
     $connection = mysql_connect ($host, $username, $password);
     if (!$connection)
     {
      die('Not connected : ' . mysql_error());
     }
     // 设置活动的 MySQL 数据库
     $db_selected = mysql_select_db($database, $connection);
     if (!$db_selected)
     {
      die ('Can\'t use db : ' . mysql_error());
     }
     // 向数据库插入数据
     $query = "insert into crawler (crawler_category, crawler_date, crawler_url, crawler_IP) values ('$Bot','$shijian','$GetLocationURL','$serverip')";
     $result = mysql_query($query);
     if (!$result)
     {
      die('Invalid query: ' . mysql_error());
     }
    ?>

成功了，现在访问数据库即可得知什么时候哪里的蜘蛛爬过你的什么页面。

    view sourceprint?
    <?php
    include './robot.php';
    include '../library/page.Class.php';
    $page = $_GET['page'];
    include '../library/conn_new.php';
    $count = $mysql -> num_rows($mysql -> query("select * from crawler"));
    $pages = new PageClass($count,,$_GET['page'],$_SERVER['PHP_SELF'].'?page={page}');
    $sql = "select * from crawler order by ";
    $sql .= "crawler_date desc limit ".$pages -> page_limit.",".$pages -> myde_size;
    $result = $mysql -> query($sql);
    ?>
    <table width="">
     <thead>
      <tr> 
       <td bgcolor="#CCFFFF"></td> 
       <td bgcolor="#CCFFFF" align="center" style="color:#">爬虫访问时间</td> 
       <td bgcolor="#CCFFFF" align="center" style="color:#">爬虫分类</td>
       <td bgcolor="#CCFFFF" align="center" style="color:#">爬虫IP</td>
       <td bgcolor="#CCFFFF" align="center" style="color:#">爬虫访问的URL</td>
      </tr>
     </thead>
    <?php
    while($myrow = $mysql -> fetch_array($result)){
    ?>
    <tr>
     <td width=""><img src="../images/topicnew.gif" /></td>
     <td width="" style="font-family:Georgia"><? echo $myrow["crawler_date"] ?></td>
     <td width="" style="color:#FA"><? echo $myrow["crawler_category"] ?></td>
     <td width=""><? echo $myrow["crawler_IP"] ?></td>
     <td width=""><? echo $myrow["crawler_url"] ?></td>
    </tr>
    <?php
     }
    ?>
     </table>
    <?php
     echo $pages -> myde_write();
    ?>

以上代码就是PHP代码实现爬虫记录――超管用的全部内容，希望对大家有所帮助。