實現爬蟲記錄本文從創建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代碼實現爬蟲記錄——超管用的全部內容,希望對大家有所幫助。
新聞熱點
疑難解答