Home > Article > Backend Development > PHP realizes the statistics of IP and PV contributed by daily outbound connections from this website to the target website_PHP Tutorial
PHP realizes the statistics of IP and PV contributed by daily outbound connections from this website to the target website_PHP Tutorial
- WBOYOriginal
- 2016-07-14 10:07:241095browse
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);
}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();
}
?>
<script> </div>
<div><!-- </div>
<div> function fix(){ </div>
<div> //alert('ok!'); </div>
<div> document.getElementById('wangzhan').options.focus(); </div>
<div> } </div>
<div>//--> </div>
<div></script>
统计网站：
| 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,
Statement：
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
Previous article：About ob_start()_PHP TutorialNext article：About ob_start()_PHP Tutorial