PHP realizes the statistics of IP and PV contributed by daily outbound connections from this website to the target website

Save to database:

header("Content-type: text/html; charset=utf-8");

//echo $_COOKIE['iptag'];

date_default_timezone_set('PRC');

//Target website url

$aimUrl = $_GET['r'];

//Source website

$sourceUrl = $_GET['wangzhan'];

//Set the cookie identifier to prevent users from clicking on other links after the cookie is generated, resulting in inaccurate statistics

$cookieTag = $aimUrl.$sourceUrl;

//Time stamp at 0:00 tomorrow

$nonce_time = strtotime(date('Ymd')+1);

setcookie('iptag',$cookieTag,$nonce_time);

//Get the current time for database query

$time = date('Y-m-d');

$db = new MySQLi('localhost','a','acyr','www_a_com');

if ($mysqli->connect_errno) {

die('Database connection failed:'.$mysqli->connect_error);

}

$db->query('set names utf8');

$sql = "select * from dede_tongji where sourceUrl='$sourceUrl' and aimUrl='$aimUrl' and date='$time'";

$res = $db->query($sql); www.2cto.com

//First check whether there is data for this link in the current database on this day. If not, create it. Otherwise, use the cookie value to determine how much the IP and Pv have increased respectively.

if ( $row = $res->fetch_assoc() ){

$pvSum = $row['pvSum'] + 1;

if( $_COOKIE['iptag'] == $cookieTag ){

$sql = "update dede_tongji set pvSum = '$pvSum' where sourceUrl='$sourceUrl' and aimUrl='$aimUrl' and date='$time' ";

$db->query($sql);

//Otherwise just ip and pv increase by one

}else{

$ipSum = $row['ipSum'] + 1;

$sql = "update dede_tongji set ipSum = '$ipSum',pvSum = '$pvSum' where sourceUrl='$sourceUrl' and aimUrl='$aimUrl' and date='$time' ";

$db->query($sql);

} }

}else{

//If there is no data in the database, add a new piece of data

$sql = "insert into dede_tongji (sourceUrl,aimUrl,ipSum,pvSum,date) values ('$sourceUrl','$aimUrl',1,1,'$time')";

if( $db->query($sql)){

}else{

$db->error;

} }

}

//Use js to achieve jump

echo "";

Querying from the database, a paging class is used here. You can find it in my Lingyiyi blog. The usage of this paging class can be well understood by combining this example and the member functions of the paging class. It is mainly in progress. When querying the database, just add limit conditions to the sql statement. The paging class used is: page.class.php

The following is the use of querying front-end display data and paging classes from the database, as well as some js for controlling dates

header("Content-type: text/html; charset=utf-8");

date_default_timezone_set('PRC');

//Introduce paging class

require_once 'page.class.php';

//Get variables

$wangzhan = emptyempty($_GET['wangzhan']) ? '' : $_GET['wangzhan'];

//If the month and day are less than 10, add 0 for database date matching

$mm = $_GET['MM'];

$dd = $_GET['DD'];

if( $mm < 10 ){

$mm = '0'.$mm;

}

if( $dd < 10 ){

$dd = '0'.$dd;

}

$date = $_GET['YYYY'].'-'.$mm.'-'.$dd;

//echo $date;

//$time = date('Y-m-d');

//echo 'time:'.$time.'
';

//echo $date;

//exit();

//Connect to database

$db = new MySQLi('localhost','a','acyr','www_a_com');

if ($mysqli->connect_errno) {

die('Database connection failed:'.$mysqli->connect_error);

}

$db->query('set names utf8');

//If the current query date is the current date, output all and sort by date

if($date==$time){

//Get the total number of items in this case for paging display (this parameter is used for paging class)

$sql = "select count(*) from dede_tongji where sourceUrl='$wangzhan' order by date desc";

$row = $db->query($sql)->fetch_row();

$allRows = $row[0]; //Total number of items

$pageList = new Page($allRows,2,4,array('pre'=>'Previous page','next'=>'Next page'));

//$res = $db->query( "select * from dede_tongji where sourceUrl='$wangzhan' order by date desc {$pageList->limit()}" );

$sql = "select * from dede_tongji where sourceUrl='$wangzhan' order by date desc {$pageList->limit()}";

//echo $sql;

$res = $db->query($sql);

$resArr = array();

while( $row = $res->fetch_assoc()){

$resArr[] = $row;

} }

$res->free_result();

/*echo '

';

var_dump($resArr);

foreach( $resArr as $v ){

echo $v['aimUrl'];

}*/

//print_r($res);

//exit();

}else{

//Get the total number of items in this case for paging display

$sql = "select count(*) from dede_tongji where sourceUrl='$wangzhan' and date='$date'";

$row = $db->query($sql)->fetch_row();

$allRows = $row[0]; //Total number of items

$pageList = new Page($allRows,2,4,array('pre'=>'Previous page','next'=>'Next page'));

$sql = "select * from dede_tongji where sourceUrl='$wangzhan' and date='$date' {$pageList->limit()} ";

//echo $sql;

$res = $db->query($sql);

$resArr = array();

while( $row = $res->fetch_assoc()){

$resArr[] = $row;

}

$res->free_result();

//print_r($res);

//exit();

}

统计结果

统计网站：

Statistical website	Outbound connection	IP (independent)	PV	Date

if( $wangzhan != '' && isset($resArr[0])){

echo $pageList->pre(); echo $pageList->first();echo $pageList->strList();

echo $pageList->end();echo $pageList->next();

echo " Please choose to jump to page: ";echo $pageList->selectList().';

}

Finally, there is the structure of the database table, so that there is only one table with some small errors in the pv record, because the time here is mainly controlled by cookies, so there are errors. If there are experts, you can optimize the database design and use IP to Control, limited ability, please forgive me:

CREATE TABLE `dede_tongji` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `sourceUrl` varchar(255) NOT NULL, `aimUrl` varchar(255) NOT NULL, `ipSum` int(10) unsigned NOT NULL, `pvSum` int(10) unsigned NOT NULL, `date` date NOT NULL,

Related labels：

header php and accomplish database of Target statistics website contribute connect

source：php.cn

Previous article：About ob_start()_PHP Tutorial Next article：PHP upload file class_PHP tutorial

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

PHP realizes the statistics of IP and PV contributed by daily outbound connections from this website to the target website_PHP Tutorial