2011-07-15 15:12 426 0 发表评论

$agent_meta=$_SERVER['HTTP_USER_AGENT'];
$agent=null;
if(stripos($agent_meta,’Googlebot’)!==false) {
    $agent=’Google’;
} elseif(stripos($agent_meta,’Baiduspider’)!==false) {
    $agent=’Baidu’;
} elseif(stripos($agent_meta,’Yahoo’)!==false) {
    $agent=’Yahoo’;
} elseif(stripos($agent_meta,’msnbot’)!==false) {
    $agent=’MSN’;
}
if($agent) {
    $access_url=Yii::app()->request->url;
    $access_time=time();
    Yii::app()->db->createCommand(‘INSERT INTO {{crawler}} (agent,agent_meta,access_url,access_time) VALUES (?,?,?,?)’)->execute(array($agent,$agent_meta,$access_url,$access_time));
}

addslashes和mysql_real_escape_string PHP 爬虫记录（详解篇）