stat_client_5.inc.php

来自「采用模块化开发」· PHP 代码 · 共 57 行

<?php
defined('IN_PHPCMS') or exit('Access Denied');
if (isset($alexa))
{
	$res = $db -> query("SELECT COUNT(*) as num,COUNT(DISTINCT alexa) AS rownum FROM ".TABLE_STAT_VISITOR." WHERE alexa='$alexa'");
	$row = $db -> fetch_array($res);
	$total_pv = $row['num'];
	$record = $row['rownum'];
	$pageSize = 20;
	$pageCount = ceil($record / $pageSize);
	if (isset($page) && intval($page) > 0)
	{
		$curPage = intval($page);
		if ($curPage > $pageCount)
		{
			$curPage = $pageCount;
		}
	}
	else
	{
		$curPage = 1;
	}
	$offset = ($curPage - 1) * $pageSize;
	$res = $db -> query("SELECT COUNT(*) AS numpv,DATE_FORMAT(etime,'%Y-%m-%d') AS vdate FROM ".TABLE_STAT_VISITOR." WHERE alexa='$alexa' GROUP BY vdate ORDER BY vdate DESC LIMIT $offset,$pageSize");
	$maxpv = 0;
	$resault = array();
	while ($row = $db->fetch_row($res))
	{
		$resault[] = $row;
		if ($row[0] > $maxpv)
		{
			$maxpv = $row[0];
		}
	}
}
else
{
	if (!isset($fdate) && !isset($ldate))
	{
		$fdate = date('Y-m-01');
		$ldate = date('Y-m-d');
	}
	$res = $db -> query("SELECT COUNT(*) as numpv,alexa FROM ".TABLE_STAT_VISITOR." WHERE TO_DAYS(etime) BETWEEN TO_DAYS('$fdate') AND TO_DAYS('$ldate') GROUP BY alexa ORDER BY numpv DESC");
	$total_pv = 0;
	$maxpv = 0;
	$resault = array();
	while ($row = $db->fetch_row($res))
	{
		$resault[] = $row;
		if ($row[0] > $maxpv)
		{
			$maxpv = $row[0];
		}
		$total_pv += $row[0];
	}
}
?>