php 统计uv,简单网站统计功能的实现 PV IP 真实访客数(UV) | 学步园

落日映苍穹つ 2022-11-17 14:00 678阅读 0赞

主要统计三个数值，网站的pv 和ip 以及UV 真实访客数 因为有详细的统计记录，所以可以实现的功能还有很大的扩展！把tallydate使用内存表的话，速度就会更快了

![0\_13311970091vkc.gif][0_13311970091vkc.gif]

需要用到二张表

CREATE TABLE \`tally\` (

\`date\` date NOT NULL,

\`pvtotal\` int(10) NOT NULL,

\`iptotal\` int(10) NOT NULL,

\`dltotal\` int(10) NOT NULL,

PRIMARY KEY (\`date\`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE \`tallydata\` (

\`tdid\` int(10) NOT NULL auto\_increment,

\`ip\` int(10) NOT NULL,

\`cookie\` varchar(32) NOT NULL,

\`date\` date NOT NULL,

\`time\` int(10) NOT NULL,

\`uri\` varchar(255) default NULL,

\`referer\` varchar(255) default NULL,

PRIMARY KEY (\`tdid\`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO\_INCREMENT=5 ;

统计的调用文件(用于所在统计的页面进行js调入)：

(注：因项目使用的是ThinkPHP框架，所以贴出的只是代码片段！因为代码刚完成，所以没有做优化以及注释)

class TallyAction extends Action\{

public function index()\{

if($\_SERVER\['SERVER\_NAME'\]!=‘fullyee.com’ && $\_SERVER\['SERVER\_NAME'\]!=‘www.fullyee.com’ && $\_SERVER\['SERVER\_NAME'\]!=‘company.fullyee.com’) exit;

$add\['ip'\]=ip2long(get\_client\_ip());

if(!Cookie::is\_set(‘fullyeetally’))\{

$value=md5(microtime().$add\['ip'\].rand());

$overTime=mktime(0,0,0,date(‘m’),date(‘d’)+1,date(‘Y’))-time();

Cookie::set("fullyeetally",$value,time()+$overTime);

$fullyeetally=Cookie::get(‘fullyeetally’);

$add\['cookie'\]=$fullyeetally;

$add\['date'\]=date(‘Y-m-d’);

$add\['time'\]=time();

$add\['uri'\]=$\_SERVER\['SERVER\_NAME'\].$\_SERVER\['REQUEST\_URI'\];

$add\['referer'\]=$\_SERVER\['HTTP\_REFERER'\];

$tallydata\_=D(‘Tallydata’);

$tallydata\_->create($add);

$tallydata\_->add();

public function saveData()

$tally\_=D(‘Tally’);

$tallydata\_=D(‘Tallydata’);

$nowDate=date(‘Y-m-d’,time()-3600\*24);

$now\['date'\]=$nowDate;

$now\['iptotal'\]=$this->gototal($nowDate,‘ip’);

$now\['pvtotal'\]=$tallydata\_->count(array(‘date’=>$nowDate),‘tdid’);

$now\['dltotal'\]=$this->gototal($nowDate,‘cookie’);

if($tally=$tally\_->find(array(‘date’=>$nowDate)))\{

$tally\_->save(array(‘iptotal’=>$now\['iptotal'\],‘pvtotal’=>$now\['pvtotal'\],‘dltotal’=>$now\['dltotal'\]),array(‘date’=>$nowDate));

\}else\{

$tally\_->create($now);

$tally\_->add();

$timeDel=time()-3600\*24\*50;

$tallydata\_->query("delete from \`tallydate\` where \`time\`

echo ‘Success ‘+date(‘Y-m-d H:i:s’);

function gototal($nowDate,$a)

$tallydata\_=D(‘Tallydata’);

$now\['iptotal'\]=$tallydata\_->query("select count(distinct $a) from \`tallydata\` where \`date\`=’$nowDate’ ");

return $now\['iptotal'\]\[0\]\["count(distinct $a)"\];

程序中的 saveDate 部分，用于服务器的定时运行，最简单的方法就是用linux的crontab在一个访问人数比较少的时间wget一下saveDate代码就行了。。这段代码的作用是，把前一天的访问数据全部统计，以天为单位写入tally表！并且删除一定时间外的统计记录。默认是删除50天以前的全部统计记录

显示部分：

class configAction extends Action\{

function \_initialize()\{

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

public function tally()

$tally\_=D(‘Tally’);

$tallydata\_=D(‘Tallydata’);

$nowDate=date(‘Y-m-d’);

$now\['date'\]=$nowDate;

$now\['iptotal'\]=$this->gototal($nowDate,‘ip’);

$now\['pvtotal'\]=$tallydata\_->count(array(‘date’=>$nowDate),‘tdid’);

$now\['dltotal'\]=$this->gototal($nowDate,‘cookie’);