So I did it seriously yesterday. It has more functions and can perform statistical analysis on various search engines. Can be viewed over multiple time periods. In fact, the code is very simple. In order to be more concise, the code is compressed to 6k. It is divided into 6 files
1. Installer spilder_install.php

Copy the code The code is as follows:

Install plug-in

if($_POST[ 'act']=='install')//If installing
{
$mysql_host=trim($_POST['mysql_host']);//Get the host
$mysql_user=trim($_POST ['mysql_user']);//Get the username
$mysql_pwd=trim($_POST['mysql_pwd']);//Get the password
$mysql_db=trim($_POST['mysql_db']); //Database
$table_prefix=trim($_POST['table_prefix']);//Get prefix
if($link=mysql_connect($mysql_host,$mysql_user,$mysql_pwd))
{
echo "Connection to server successful!.............
";
}
else
{
echo "";
}
if(mysql_select_db($mysql_db,$link))
{
echo "Connecting to database successfully!............
Creating table.............< 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`;");//Delete existing
$sql=str_replace("spilder_",$table_prefix,$sql) ;//Replace prefix
if(mysql_query($sql))
{
echo "Table created successfully! Writing file";
}
$f=file_get_contents("spilder_config.php");//Get configuration content
$f=str_replace(" ","",$f);// Remove spaces
$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 "Congratulations! The Jianli spider statistics program was installed successfullyView";
exit();
}
?>
< body>

Recommended Spider Statistics Viewer

(Generally no need to change)

< /tr>

< ;/table>

2. Spider record file

Copy code The code is as follows:

 
require(" spilder_config.php");//Calling the configuration file
$link=mysql_connect($mysql_host,$mysql_user,$mysql_pwd) or die("Server connection error");//Linking the database
mysql_select_db($mysql_db, $link) or die('Database connection error'); 
$searchbot = get_naps_bot(); 
if($searchbot) 
{ 
date_default_timezone_set('PRC'); //Set the default time zone 
$r_time=strtotime(date("Y-m-d H:i:s"));//Last update time
$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. Spider statistics view file

Copy code The code is as follows:

session_start();
require("spilder_config.php");
if($_GET['act']=='logout')
{
$_SESSION['ss_sp_admin']='';//Clear
}
if($_GET['sp_admin_login'])
{
if($_GET['sp_admin_login' ]==$sp_admin)
{
$_SESSION['ss_sp_admin']=$sp_admin;
}
}
date_default_timezone_set('PRC'); //Set the default time zone
$day_start=strtotime(date("Ymd")."000001");//The start time of the day
$day_out=strtotime(date("Ymd")."235959");//The end time of the day
$day=3600*24;//Time of day
$link=mysql_connect($mysql_host,$mysql_user,$mysql_pwd) or die("Server connection error");
mysql_select_db($mysql_db,$ link) or die('Error linking database');//Connect database
if($_GET['act']=='del')
{
if($_SESSION['ss_sp_admin'] <>'')
{
if($_GET['dt']==0)//Clear
{
mysql_query("delete from {$table_prefix}sp_count ");
}
$d_time=0;
if($_GET['dt']==1)//Delete 30 days ago
{
$d_time=$day_out-$day* 30;
}elseif($_GET['dt']==2)//Delete 60 days ago
{
$d_time=$day_out-$day*60;
}elseif($ _GET['dt']==3)//Delete 90 days ago
{
$d_time=$day_out-$day*90;
}elseif($_GET['dt']==4 )//Delete 180 days ago
{
$d_time=$day_out-$day*180;
}elseif($_GET['dt']==5)//Delete 360 days ago
{
$d_time=$day_out-$day*360;
}
if($d_time>0)
{
mysql_query("delete from {$table_prefix}sp_count where r_time< '$d_time'");//Delete data
}
}
}
$ss=intval($_GET['ss']);
if($ss>0) //View category statistics
{
if($ss==999)//Clear category
{
$_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']);//View time classification statistics
if($t ==0)//Time situation
{
if(empty($_SESSION['ss_ss']))
{
$sql =" select * from {$table_prefix}sp_count order by id desc ";//Latest situation
$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];//Get the total number of records
$page=intval(trim($_GET ['page']));//Current page number
$pagesize=30;//Number of records per page
$pagecount=ceil($rscount/$pagesize);//Get the total number of pages
$pageurl="";
if($page<=1)
{
$page=1;
$pageurl.=" Home page previous page";
}else
{
$pageurl .=" Homepage Previous page";
}
if($page>=$pagecount)
{
$page=$pagecount;
$pageurl .=" Next page Last page";
}else
{
$pageurl .=" Next page Last page";
}
if($page<=1)
{
$page=1;
}
$start_rs=intval( ($page-1)*$pagesize);//Start
$end_rs=intval($page*$pagesize);//End
$sql .=" limit {$start_rs},{$end_rs} ";
}
if($t==1)//View today’s statistics
{
$s_time=$day_start;//Start time
$e_time=$day_out;/ /End time
$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)//View yesterday’s statistics
{
$s_time=$day_start-$day;//Start
$e_time=$day_out-$day;//End
$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)//View the previous day's Statistics
{
$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)//View seven-day statistics
{
$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)//View 30 days
{
$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)//View 90-day statistics
{
$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("请先安装程序安装");
?>

显示蜘蛛记录情况