国产探花免费观看_亚洲丰满少妇自慰呻吟_97日韩有码在线_资源在线日韩欧美_一区二区精品毛片,辰东完美世界有声小说,欢乐颂第一季,yy玄幻小说排行榜完本

首頁 > 網站 > 建站經驗 > 正文

PHP代碼實現爬蟲記錄――超管用

2024-04-25 20:40:29
字體:
來源:轉載
供稿:網友

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

發表評論 共有條評論
用戶名: 密碼:
驗證碼: 匿名發表
主站蜘蛛池模板: 高要市| 陕西省| 宁阳县| 瑞金市| 井研县| 玛纳斯县| 石泉县| 大同县| 上杭县| 池州市| 德清县| 洞口县| 儋州市| 乐至县| 吉水县| 苍山县| 偏关县| 泸西县| 宁都县| 永仁县| 温州市| 松潘县| 和静县| 二连浩特市| 株洲市| 平谷区| 铜陵市| 满洲里市| 沧源| 台安县| 灵石县| 和林格尔县| 高安市| 策勒县| 吉木乃县| 韶山市| 宜黄县| 眉山市| 遂宁市| 阿合奇县| 太湖县|