发款php蜘蛛统计插件只要有mysql就可用_PHP教程

<br> <br> <br> <br><meta http-equiv="Content-Type" content="text/html; charset=gb2312"> <br><title>安装插件</title> <br> <br><!--?php <BR-->if($_POST['act']=='install')//如果是安装 <br>{ <br>$mysql_host=trim($_POST['mysql_host']);//获取主机 <br>$mysql_user=trim($_POST['mysql_user']);//获取用户名 <br>$mysql_pwd=trim($_POST['mysql_pwd']);//获取密码 <br>$mysql_db=trim($_POST['mysql_db']);//数据库 <br>$table_prefix=trim($_POST['table_prefix']);//获取前缀 <br>if($link=mysql_connect($mysql_host,$mysql_user,$mysql_pwd)) <br>{ <br>echo "连接服务器成功！.................<br>"; <br>} <br>else <br>{ <br>echo ""; <br>} <br>if(mysql_select_db($mysql_db,$link)) <br>{ <br>echo "连接数据库成功！.............<br>正在创建表................<br>"; <br>} <br>$sql="CREATE TABLE `spilder_sp_count` ( <br>`id` bigint(20) NOT NULL auto_increment, <br>`r_time` int(11) NOT NULL, <br>`r_name` varchar(50) NOT NULL, <br>`r_url` varchar(200) NOT NULL, <br>PRIMARY KEY (`id`) <br>) ENGINE=MyISAM DEFAULT CHARSET=gb2312 AUTO_INCREMENT=4 ; <br>"; <br>mysql_query("DROP TABLE IF EXISTS `".$table_prefix."sp_count`;");//删除已存在 <br>$sql=str_replace("spilder_",$table_prefix,$sql);//替换前缀 <br>if(mysql_query($sql)) <br>{ <br>echo "表创建成功！正在写入文件"; <br>} <br>$f=file_get_contents("spilder_config.php");//获取配置内容 <br>$f=str_replace(" ","",$f);//去除空格 <br>$f=preg_replace("/mysql_host=.*;/iUs","mysql_host='{$mysql_host}';",$f); <br>$f=preg_replace("/mysql_user=.*;/iUs","mysql_user='{$mysql_user}';",$f); <br>$f=preg_replace("/mysql_pwd=.*;/iUs","mysql_pwd='{$mysql_pwd}';",$f); <br>$f=preg_replace("/mysql_db=.*;/iUs","mysql_db='{$mysql_db}';",$f); <br>$f=preg_replace("/table_prefix=.*;/iUs","table_prefix='{$table_prefix}';",$f); <br>$f=preg_replace("/sp_admin=.*;/iUs","sp_admin='{$sp_admin}';",$f); <br>file_put_contents("spilder_config.php",$f); <br>file_put_contents("isinstall.txt","OK"); <br>echo "恭喜！荐礼啦蜘蛛统计程序安装成功 查看"; <br>exit(); <br>} <br>?> <br> <br><br><br><br><br><table width="600" border="0" align="center"> <tbody><tr> <td align="center">荐礼啦 蜘蛛统计查看器</td> </tr> </tbody></table> <br> <br> <br> <br> <br>2.蜘蛛记录文件 <br><span style="CURSOR: pointer" onclick="doCopy('code63654')"><u></u></span> 代码如下:<pre class="brush:php;toolbar:false layui-box layui-code-view layui-code-notepad"><ol class="layui-code-ol"><li><br><!--?php <BR-->require("spilder_config.php");//调用配置文件 <br>$link=mysql_connect($mysql_host,$mysql_user,$mysql_pwd) or die("服务器连接出错");//链接数据库 <br>mysql_select_db($mysql_db,$link) or die('数据库连接出错'); <br>$searchbot = get_naps_bot(); <br>if($searchbot) <br>{ <br>date_default_timezone_set('PRC'); //设置默认时区 <br>$r_time=strtotime(date("Y-m-d H:i:s"));//最后更新时间 <br>$ServerName = $_SERVER["SERVER_NAME"] ; <br>$ServerPort = $_SERVER["SERVER_PORT"] ; <br>$ScriptName = $_SERVER["SCRIPT_NAME"] ; <br>$QueryString = $_SERVER["QUERY_STRING"] ; <br>$url="http://".$ServerName ; <br>If ($ServerPort != "80") <br>{ <br>$url = $url.":".$ServerPort ; <br>} <br>$url=$url.$ScriptName ; <br>If ($QueryString !="") <br>{ <br>$url=$url."?".$QueryString ; <br>} <br>//$url="http://".$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI']; <br>$GLOBALS['db']->db_query("insert into {$table_prefix}sp_count(r_time,r_name,r_url) values('$r_time','$searchbot','$url')"); <br>} <br>function get_naps_bot() <br>{ <br>$useragent = strtolower($_SERVER['HTTP_USER_AGENT']); <br>if (strpos($useragent, 'googlebot') !== false){ <br>return 'Googlebot'; <br>}elseif (strpos($useragent, 'msnbot') !== false){ <br>return 'MSNbot'; <br>}elseif (strpos($useragent, 'slurp') !== false){ <br>return 'Yahoobot'; <br>}elseif (strpos($useragent, 'baiduspider') !== false){ <br>return 'Baiduspider'; <br>}elseif (strpos($useragent, 'sogou') !== false){ <br>return 'Sogoubot'; <br>}elseif (strpos($useragent,'soso') !== false){ <br>return 'Sosobot'; <br>}elseif(strpos($useragent,'youdao')!==false) <br>{ <br>return 'Youdao'; <br>} <br>else <br>{ <br>return false; <br>} <br>} <br>?> <br> <br>3.蜘蛛统计查看文件 <br><span style="CURSOR: pointer" onclick="doCopy('code41628')"><u></u></span> 代码如下:<pre class="brush:php;toolbar:false layui-box layui-code-view layui-code-notepad"><ol class="layui-code-ol"><li><br><!--?php <BR-->session_start(); <br>require("spilder_config.php"); <br>if($_GET['act']=='logout') <br>{ <br>$_SESSION['ss_sp_admin']='';//清空 <br>} <br>if($_GET['sp_admin_login']) <br>{ <br>if($_GET['sp_admin_login']==$sp_admin) <br>{ <br>$_SESSION['ss_sp_admin']=$sp_admin; <br>} <br>} <br>date_default_timezone_set('PRC'); //设置默认时区 <br>$day_start=strtotime(date("Ymd")."000001");//一天的开始时间 <br>$day_out=strtotime(date("Ymd")."235959");//一天的结束时间 <br>$day=3600*24;//一天的时间 <br>$link=mysql_connect($mysql_host,$mysql_user,$mysql_pwd) or die("服务器连接出错"); <br>mysql_select_db($mysql_db,$link) or die('链接数据库出错');//连接数据库 <br>if($_GET['act']=='del') <br>{ <br>if($_SESSION['ss_sp_admin']<>'') <br>{ <br>if($_GET['dt']==0)//清空 <br>{ <br>mysql_query("delete from {$table_prefix}sp_count "); <br>} <br>$d_time=0; <br>if($_GET['dt']==1)//删除30天前 <br>{ <br>$d_time=$day_out-$day*30; <br>}elseif($_GET['dt']==2)//删除60天前 <br>{ <br>$d_time=$day_out-$day*60; <br>}elseif($_GET['dt']==3)//删除90天前 <br>{ <br>$d_time=$day_out-$day*90; <br>}elseif($_GET['dt']==4)//删除180天前 <br>{ <br>$d_time=$day_out-$day*180; <br>}elseif($_GET['dt']==5)//删除360天前 <br>{ <br>$d_time=$day_out-$day*360; <br>} <br>if($d_time>0) <br>{ <br>mysql_query("delete from {$table_prefix}sp_count where r_time<'$d_time'");//删除数据 <br>} <br>} <br>} <br>$ss=intval($_GET['ss']); <br>if($ss>0)//查看分类统计 <br>{ <br>if($ss==999)//清空分类 <br>{ <br>$_SESSION['ss_ss']=''; <br>}else <br>{ <br>$_SESSION['ss_ss']=$ss; <br>} <br>} <br>$ss=$_SESSION['ss_ss']; <br>if($ss==1) <br>{ <br>$ss='Baiduspider'; <br>}elseif($ss==2) <br>{ <br>$ss='Googlebot'; <br>}elseif($ss==3) <br>{ <br>$ss="MSNbot"; <br>}elseif($ss==4) <br>{ <br>$ss="Yahoobot"; <br>}elseif($ss==5) <br>{ <br>$ss="Sogoubot"; <br>}elseif($ss==6) <br>{ <br>$ss="Sosobot"; <br>}elseif($ss==7) <br>{ <br>$ss=7; <br>} <br>$t=intval($_GET['t']);//查看时间分类统计 <br>if($t==0)//时时情况 <br>{ <br>if(empty($_SESSION['ss_ss'])) <br>{ <br>$sql =" select * from {$table_prefix}sp_count order by id desc ";//最新情况 <br>$sql2="select count(*) from {$table_prefix}sp_count "; <br>}else <br>{ <br>$sql="select * from {$table_prefix}sp_count where r_name='$ss' order by id desc "; <br>$sql2="select count(*) from {$table_prefix}sp_count where r_name='$ss' "; <br>} <br>$rscount=mysql_query($sql2); <br>$rscount=@mysql_fetch_array($rscount); <br>$rscount=$rscount[0];//获取总记录数 <br>$page=intval(trim($_GET['page']));//当前页数 <br>$pagesize=30;//每页记录数 <br>$pagecount=ceil($rscount/$pagesize);//获取总页数 <br>$pageurl=""; <br>if($page<=1) <br>{ <br>$page=1; <br>$pageurl.=" 首页 上一页"; <br>}else <br>{ <br>$pageurl .=" 首页  上一页"; <br>} <br>if($page>=$pagecount) <br>{ <br>$page=$pagecount; <br>$pageurl .=" 下一页  尾页"; <br>}else <br>{ <br>$pageurl .=" 下一页  尾页"; <br>} <br>if($page<=1) <br>{ <br>$page=1; <br>} <br>$start_rs=intval(($page-1)*$pagesize);//开始 <br>$end_rs=intval($page*$pagesize);//结束 <br>$sql .=" limit {$start_rs},{$end_rs} "; <br>} <br>if($t==1)//查看今天天统计 <br>{ <br>$s_time=$day_start;//开始时间 <br>$e_time=$day_out;//结束时间 <br>$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 "; <br>}elseif($t==2)//查看昨天统计 <br>{ <br>$s_time=$day_start-$day;//开始 <br>$e_time=$day_out-$day;//结束 <br>$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 "; <br>}elseif($t==3)//查看前天天的统计 <br>{ <br>$s_time=$day_start-$day*2; <br>$e_time=$day_out-$day*2; <br>$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"; <br>}elseif($t==4)//查看七天的统计 <br>{ <br>$s_time=$day_start-$day*7; <br>$e_time=$day_out; <br>$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 "; <br>} <br>elseif($t==5)//查看30天的 <br>{ <br>$s_time=$day_start-$day*30; <br>$e_time=$day_out; <br>$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 "; <br>}elseif($t==6)//查看90天的统计 <br>{ <br>$s_time=$day_start-$day*90; <br>$e_time=$day_out; <br>$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 "; <br>} <br>$res=mysql_query($sql);// or die("请先安装程序安装"); <br>?> <br> <br> <br><meta http-equiv="Content-Type" content="text/html; charset=gb2312"> <br><title>显示蜘蛛记录情况</title> <br><style type="text/css"> <BR>td{font-size:14px;} <BR>a,a:link{text-decoration:none; color:#000; } <BR>a:hover{color:#F00;} <BR></style> <br> <br> <br><br><br><br><br><table width="800" border="0" align="center" cellspacing="1" bgcolor="#CCCCCC" style="margin-bottom:6px;"> <tbody><tr> <td height="28" align="center" bgcolor="#66CC00"><h2>荐礼啦 蜘蛛查看器</h2></td> </tr> </tbody></table> <br><br><br><br><br><br><br><table width="800" border="0" align="center" cellspacing="1" bgcolor="#CCCCCC"> <tbody><tr> <td width="65" height="38" bgcolor="#FFFFFF">分类查看</td> <td width="403" align="center" bgcolor="#FFFFFF">   <br>所有的  <br>百度   <br>谷歌   <br>必应  <br>雅虎  <br>搜狗   <br>搜搜  <br>有道</td> <td width="322" bgcolor="#FFFFFF">  <br>时时   <br>今天  <br>昨天  <br>前天  <br>七天  <br>30天  <br>90天  <br></td> </tr> </tbody></table> <br><!--?php <BR-->if($_SESSION['ss_sp_admin']==$sp_admin) <br>{ <br>?> <br><br><br><br><br><br><table width="800" border="0" align="center" cellspacing="1" bgcolor="#CCCCCC" style="margin-top:12px; margin-bottom:12px;"> <tbody><tr> <td width="208" align="right" bgcolor="#FFFFFF">管理  退出   </td> <td width="585" align="center" bgcolor="#FFFFFF"> <br>清空   <br>30天前   <br>60天前   <br>90天前    <br>180天前   <br>360天前</td> </tr> </tbody></table> <br><!--?php <BR-->} <br>?> <br><!--?php <BR-->if($t==0) <br>{ <br>?> <br><br><br><br><br><br><br>while($rs=mysql_fetch_array($res)) <br>{ <br>?> <br><br><br><br><br><br>} <br>?> <br><table width="800" border="0" align="center" cellspacing="1" bgcolor="#CCCCCC" style="margin-top:6px;"> <tbody><tr> <td width="133" align="center" bgcolor="#FFFFFF">蜘蛛</td> <td width="217" align="center" bgcolor="#FFFFFF">时间</td> <td width="440" align="center" bgcolor="#FFFFFF">地址</td> </tr> <!--?php <BR--><tr> <td align="center" bgcolor="#FFFFFF"><!--?php echo $rs['r_name'];?--></td> <td align="center" bgcolor="#FFFFFF"><!--?php echo date("Y-m-d H:i:s",$rs['r_time']); ?--></td> <td align="center" bgcolor="#FFFFFF">" target="_blank"> <!--?php echo $rs['r_url'];?--></td> </tr> <!--?php <BR--></tbody></table> <br><br><br><br><br><table width="800" border="0" align="center" cellspacing="1" bgcolor="#CCCCCC" style="margin-top:20px; margin-bottom:20px;"> <tbody><tr> <td align="center" bgcolor="#FFFFFF"><!--?php echo $pageurl;?--></td> </tr> </tbody></table> <br><!--?php <BR-->}else{ <br>?> <br><br><br><br><br><br>while($rs=mysql_fetch_array($res)) <br>{ <br>?> <br><br><br><br><br>} <br>?> <br><table width="800" border="0" align="center" cellspacing="1" bgcolor="#CCCCCC" style="margin-top:6px;"> <tbody><tr> <td width="219" align="center" bgcolor="#FFFFFF">蜘蛛</td> <td width="574" align="center" bgcolor="#FFFFFF">统计</td> </tr> <!--?php <BR--><tr> <td align="center" bgcolor="#FFFFFF"><!--?php echo $rs['r_name'] ?--></td> <td align="center" bgcolor="#FFFFFF"><!--?php echo $rs['ct'];?--></td> </tr> <!--?php <BR--></tbody></table> <br><!--?php <BR-->} <br>?> <br><br><br><br><br><table width="800" border="0" align="center" cellspacing="1" bgcolor="#CCCCCC" style="margin-top:6px;"> <tbody><tr> <td align="center" bgcolor="#FFFFFF">友情链接：荐礼啦 爱我爸妈 黑客帝国</td> </tr> </tbody></table> <br> <br> <br></li><li><p></p></li><li><p align="left"><span id="url" itemprop="url">http://www.bkjia.com/PHPjc/322528.html</span><span id="indexUrl" itemprop="indexUrl">www.bkjia.com</span><span id="isOriginal" itemprop="isOriginal">true</span><span id="isBasedOnUrl" itemprop="isBasedOnUrl">http://www.bkjia.com/PHPjc/322528.html</span><span id="genre" itemprop="genre">TechArticle</span><span id="description" itemprop="description">于是昨天便认真的做了一下，功能多一点，可以对各种搜索引擎统计分析。可以在多个时间段进行查看。其实代码很简单，为了更简洁些，...</span></p></li><li>                    </li></ol></pre></li></ol></pre>