//统计总记录数,即在线用户数
list($totalOnline) = mysql_fetch_array(mysql_query("select count(*) fr
om online"));
echo $totalOnline;//输出在线总数
mysql_close();
关于新浪 IP 地址库的调用
函数 get_client_ip()用来获取用户真实 IP。
function get_client_ip() {
if (getenv("HTTP_CLIENT_IP") && strcasecmp(getenv("HTTP_CLIENT
_IP"), "unknown"))
$ip = getenv("HTTP_CLIENT_IP");
else if (getenv("HTTP_X_FORWARDED_FOR") && strcasecmp(getenv
("HTTP_X_FORWARDED_FOR"),
"unknown"))
$ip = getenv("HTTP_X_FORWARDED_FOR");
else if (getenv("REMOTE_ADDR") && strcasecmp(getenv("REMOTE_
ADDR"), "unknown"))
$ip = getenv("REMOTE_ADDR");
else if (isset ($_SERVER['REMOTE_ADDR']) &&
$_SERVER['REMOTE_ADDR'] && strcasecmp($_SERVER['REMOTE_ADD
R'], "unknown"))
$ip = $_SERVER['REMOTE_ADDR'];
else
$ip = "unknown";
return ($ip);
}
geo.php 用来统计各省份(区域)访客人数分布。通过查询数据库,并按省份分组
排序即可,注意我们将最终的数据集以 JSON 的形式输出,便于前端 ajax 交互。
include_once('connect.php');//连接数据库
//查询区域统计
$sql = "select province,count(*) as total from online group by provinc
e order by total desc";
$result = mysql_query($sql);
while($row=mysql_fetch_array($result)){
$list[] = array(
'province' => $row['province'],
'total' => $row['total']
);
}
echo json_encode($list);//以 json 格式输出
jQuery