刚用PHP写了一个网站在线人数的程序，请大家进来指点下！

主机, 虚拟主机

刚用PHP写了一个网站在线人数的程序，请大家进来指点下！
我是用PHP+MYSQL来写的，原理：网站在线人数的程序代码+后台有MYSQL数据库支持，可以直接统计出网站当前的在线人数。; Z+ q/ w# {& K! W, Y) w% L
首先我创建MYSQL数据库表。# C& _3 B" N: H! M' s
CREATE TABLE tablename (5 V) [+ n6 Y$ H/ j- h
field type(max_length) DEFAULT 'default_value' (NOT) NULL5 V! M" z8 Z' z! |7 E9 j* o; u1 G
}可以使用的SQL语句。; \' s) l  }1 Y( @
CREATE TABLE useronline (
timestamp int(15) DEFAULT '0' NOT NULL,
ip varchar(40) NOT NULL,
file varchar(100) NOT NULL,9 ?/ k. b/ z+ O: D; m% E
PRIMARY KEY (timestamp),
KEY ip (ip),
KEY file (file)
);下面我们是PHP脚本，首先我定义MYSQL的信息。
$server = "localhost"; //你的服务器3 ]2 }8 H. i& E
$db_user = "root"; //你的mysql的用户名
$db_pass = "password"; //你的mysql的密码
$database = "users"; //表的名字设置统计的时间(多少秒内在线人数)  u; j& y# y% e9 f" F3 m
$timeoutseconds = 300;取当前时间。! D9 S8 o9 E& \! r9 c- M
$timestamp = time();上面的完整代码：% e0 u2 U5 K! \# B
<?php7 b, x$ c! e1 v( T
$server = "localhost"; //your server
$db_user = "root"; //your mysql database username# Z7 b% q, c7 t# H$ M) H
$db_pass = "password"; //your mysql database password if any
$database = "users"; //the db name) R2 F6 C8 I4 p( E3 A$ e) a3 g" ?
$timeoutseconds = 300;//timeoutseconds limit
//get the current time% {5 ]$ \  b# p) X7 ~- H* P1 v7 a
$timestamp = time();
//calculate the lowest timestamp allowed
$timeout = $timestamp-$timeoutseconds;
?>连接mysql
mysql_connect('localhost', 'username', 'password');也允许使用变量形式。
mysql_connect($server, $db_user, $db_pass);如果mysql数据库没有密码的话可以使用下面代码连接
mysql_connect($server, $db_user);查询数据库的代码：9 {- Z* a4 e% q* d* m% H+ D0 X
mysql_db_query('database', 'query');我们只要有访客就要增加一条记录。- i1 I3 z3 w4 U( K
$insert = mysql_db_query($database, "INSERT INTO useronline VALUES
('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");7 C) u4 b, B9 `3 }) T6 l
如果用户用错误信息的话，这样处理。, p, a; V& D) P7 Q+ X
if(!($insert)) {5 k( n  F1 L2 T4 ]9 X
print "Useronline Insert Failed > ";; M9 o' l3 A. r1 q- O
}然后实现当超过设置的时间就删除该用户记录。' a1 ?, Q1 N& D9 I( k
$delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");同样给出删除记录出错的处理。
if(!($delete)) {
print "Useronline Delete Failed > ";6 i: K7 c5 D/ t+ T
}下面我们解决数据库中不同IP的问题3 n/ M' R+ R& E, p* r
$result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");使用5 G2 C) L& h3 j
mysql_num_rows(query);来统计用户，代码如下。
$user = mysql_num_rows($result);最后关闭数据库。4 {+ t; A+ v8 r$ ]: l& r0 [
mysql_close();显示在线的人数。
if($user == 1) {
print("1 user online\n");% E3 m" N" g  p
} else {! c2 r/ N  J6 D0 P; i9 x
print("$user users online\n");
}最终把上面代码写成一个PHP文件如下。
<?php
//Put your basic server info here6 ~: I6 [9 u% K( ?+ ~/ d
$server = "localhost"; //normally localhost
$db_user = "root"; //your MySQL database username# `% t, Y7 c; h& `
$db_pass = "password"; //your MySQL database password
$database = "users";( R1 G% Y9 o! [
$timeoutseconds = 300; //it will delete all people which haven't refreshed(so probbably are
// offline or inactive) in $timieoutseconds time (so it actually checks the people that are active in the last( s7 j3 u) a5 M& f6 V7 `9 d  |6 `
// $timeoutseconds seconds)4 |! n2 L+ a0 n- ]7 f* Z
//this is where PHP gets the time
$timestamp = time();! T9 S2 u! W# s& ^# P- t
//counts the timeout, all people which have been seen last online in earlier than this timestamp, will get removed- K( G5 [# X) \% B. \
$timeout = $timestamp-$timeoutseconds;
//connect to database
mysql_connect($server, $db_user);
//add the timestamp from the user to the online list
$insert = mysql_db_query($database, "INSERT INTO useronline VALUES
('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");/ |* C: M8 v. L6 O3 _, x5 G
if(!($insert)) {
print "Useronline Insert Failed > ";, s; z& o0 p3 G/ Y/ @
}
//delete the peoples which haven't been online/active in the last $timeoutseconds seconds.
$delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");
if(!($delete)) {2 g5 A! H# U1 o' ~) |- q- j1 I
print "Useronline Delete Failed > ";; p1 ?- O8 u3 Q$ f6 g
}1 ]. z6 E( L- b, R- ]0 U; J* f- Q& E
//select the amount of people online, all uniques, which are online on THIS page0 e! i$ W: ^5 A( F8 V7 x4 k% x/ {# O
$result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");
if(!($result)) {
print "Useronline Select Error > ";
}
//Count the number of rows = the number of people online: `  o  a0 G+ ^/ K, h1 n  ]
$user = mysql_num_rows($result);
//spit out the results
mysql_close();" ^6 H% r7 T% {4 ]* B, j
if($user == 1) {% p1 p3 {- g8 L! h8 q3 j& L8 i  k
print("1 user online\n");7 _/ u0 ^& n; S* `3 V
} else {5 D/ o0 H1 R; t# q. Y
print("$user users online\n");3 N2 L' S: S- C9 {8 Q8 {$ D  ~# q
}( \5 }$ U9 A; U* `3 C; M
?>

以上代码我是在时代互联提供的免费试用主机上测试的，感觉效果还不错，性能很稳定，不信的话你也可以去试试。当然，记得指出我这个程序中的不足先哦。
时代互联是行业内最早开始提供PHP 虚拟主机的公司之一，现在已经是的金牌域名注册商和中国互联网客户满意度十佳单位，产品功能已经非常完善，特别提一下几个特有用的功能：数据库自动备份、免费集成繁简通简装版、多域名绑定、多子网站支持、GCDN 网站加速器、镜像加速、高级访问统计系统、支持WAP、可选电信/网通/香港机房。# r- n" t* M' A9 A: ?7 U2 Q
我之前建站的时候选的是他们公司标准商务E型，因为这款机型还特别支持ASP.NET3.5(3.0/2.0/1.1)/ASP。
当然啦，这两款主机也是相当不错的。
智强商务B型：Unix /Linux 操作系统+独立网页空间1000MB+送1000MB邮局空间+100MB MySQL数据库空间=1869元/年
标准商务B型：Unix /Linux 操作系统+独立网页空间500MB+送800MB邮局空间+60MB MySQL数据库空间=1365元/年6 H# L9 K- M" @9 Y7 m: P
提供一下这个公司的联系方式：请见：http://www.now.cn/vhost/
空间专线： 0756-2623871 QQ：168075865，好象还有全球免费网络电话:全球免费咨询电话 http://www.now.cn/callcenter/call.net?LineName=55; `; ~/ S# a6 z5 R' ]. Y$ \
自己加QQ去问吧。

返回列表

刚用PHP写了一个网站在线人数的程序，请大家进来指点下！

[收藏此主题] [关注此主题的新回复]

[通过 QQ、MSN 分享给朋友]