PHP statistical article ranking example_PHP tutorial

Copy code The code is as follows:

/**
*
* Monthly, weekly and daily rankings of statistical software and articles
*
* $field_id (article ID)
*/
//Method for counting monthly, weekly, and current day rankings
require_once(dirname(__FILE__)."/../include/common.inc.php");
function countdown($field_id){
date_default_timezone_set ('Asia/Shanghai'); //Set the default time zone
global $dsql;
$re_total = 1;
$tableName = 'dede_tongji';
$nowDateArray = getdate(time()) ;
$sql_tongji = "select * from `$tableName` where aid=$field_id";
$rs = $dsql->ExecuteNoneQuery2($sql_tongji);
//If this article does not exist information, then insert a new one
if($rs <= 0){
//Get the column ID value
$sql_typeid = "select typeid from `dede_archives` where id=$field_id";
$t_row = $dsql->GetOne($sql_typeid);
$query = " INSERT INTO `$tableName` VALUES($field_id,$t_row[typeid],1,1,1,1,$nowDateArray[ 0]); ";
$dsql->ExecNoneQuery($query);
}else{
$result = $dsql->GetOne($sql_tongji);
$oldTimeStamp = $ result['lasttime']; //Last click time
$m_total = $result['m_total']; //Clicks per month
$w_total = $result['w_total']; //Clicks per week
$d_total =  $result['d_total'];  //Daily clicks
$t_total =   $result['t_total'];  //Total clicks
$oldDateArray = getdate($oldTimeStamp);

//Statistics for the current month
if($nowDateArray["year"] == $oldDateArray["year"] && $nowDateArray["mon"] == $oldDateArray["mon"]){
$m_total++;
}else{
$m_total = 1;
}

//Statistics for this week
$tmpStartDate = mktime(0,0,0,$nowDateArray[ "mon"],$nowDateArray[ "mday"],$nowDateArray[ "year"]) - ($nowDateArray [ "wday "] * 86400);
$tmpEndDate = mktime(23,59,59,$nowDateArray[ "mon"],$nowDateArray[ "mday"],$nowDateArray[ "year"]) + (( 6 - $nowDateArray[ "wday"]) * 86400);
if($oldTimeStamp >= $tmpStartDate && $oldTimeStamp <= $tmpEndDate){
$w_total++;
}else{
$w_total = 1;
}

//Statistics today
$dayStart =mktime(0,0,0,$nowDateArray[ "mon"],$nowDateArray[ "mday"],$nowDateArray[ "year"]); //Start of the day Timestamp
$dayEnd =mktime(23,59,59,$nowDateArray[ "mon"],$nowDateArray[ "mday"],$nowDateArray[ "year"]); //End of the day timestamp
if($oldTimeStamp >= $dayStart && $oldTimeStamp <= $dayEnd){
$d_total++;
}else{
$d_total = 1;
}
$t_total++;
//Update statistics
$dsql->ExecuteNoneQuery("update $tableName set m_total=$m_total,w_total=$w_total,d_total=$d_total,t_total=$t_total,lasttime=$nowDateArray[0] where aid=$field_id");
$dsql->ExecuteNoneQuery("update dede_archives set click=$t_total where id=$field_id");
$re_total = $t_total;
}
return $re_total;
}

countdown($aid); //Method call

/*
//mysql table structure

CREATE TABLE IF NOT EXISTS `dede_tongji` (
`aid` int(11) NOT NULL,
`cid` smallint(5) NOT NULL,
`tid` smallint(5) NOT NULL ,
`m_total` int(11) NOT NULL DEFAULT '1',
`w_total` int(11) NOT NULL DEFAULT '1',
`d_total` int(11) NOT NULL DEFAULT '1 ',
`t_total` int(11) NOT NULL DEFAULT '1',
`lasttime` int(12) NOT NULL,
PRIMARY KEY (`aid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
*/
?>

http://www.bkjia.com/PHPjc/736801.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/736801.htmlTechArticleCopy the code code as follows: ?php /*** * Monthly, weekly, and day rankings of statistical software and articles * * $field_id (article ID)*/ //Statistical month, week, and day rankings The method require_once(dirname(_...