Home
Backend Development
PHP Tutorial
The PHP spider statistics plug-in can be used as long as you have mysql_PHP tutorial
Backend Development
PHP Tutorial
The PHP spider statistics plug-in can be used as long as you have mysql_PHP tutorial
The PHP spider statistics plug-in can be used as long as you have mysql_PHP tutorial
mysql
php
one time
by
Function
Can
Available
plug-in
yesterday
statistics
spider
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 |