The PHP spider statistics plug-in can be used as long as you have mysql_PHP tutorial

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:

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("请先安装程序安装");
?>

	Start installation
Server:
Username:
Password:
Database:
Table prefix:
Manage password:

荐礼啦 蜘蛛查看器

分类查看

所有的  百度   谷歌   必应  雅虎  搜狗   搜搜  有道

时时   今天  昨天  前天  七天  30天  90天

if($_SESSION['ss_sp_admin']==$sp_admin)
{
?>

管理  退出

清空   30天前   60天前   90天前    180天前   360天前

}
?>
if($t==0)
{
?>






while($rs=mysql_fetch_array($res))
{
?>





}
?>

蜘蛛	时间	地址

}else{
?>





while($rs=mysql_fetch_array($res))
{
?>




}
?>

蜘蛛	统计

}
?>

友情链接：荐礼啦 爱我爸妈 黑客帝国

http://www.bkjia.com/PHPjc/322528.htmlwww.bkjia.comtruehttp://www.bkjia.com/PHPjc/322528.htmlTechArticle于是昨天便认真的做了一下，功能多一点，可以对各种搜索引擎统计分析。可以在多个时间段进行查看。其实代码很简单，为了更简洁些，...