捌玖网络工作室 » 电脑软件 » 刚用PHP写了一个网站在线人数的程序，请大家进来指点下！

lilcy88 发表于 2008-5-28 10:40

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

刚用PHP写了一个网站在线人数的程序，请大家进来指点下！'O
~{3jB*K
我是用PHP+MYSQL来写的，原理：网站在线人数的程序代码+后台有MYSQL数据库支持，可以直接统计出网站当前的在线人数。w#II1|&WS]"w
首先我创建MYSQL数据库表。n3~-L!^)N f
CREATE TABLE tablename (8I.x6Z;ltTY,?
field type(max_length) DEFAULT 'default_value' (NOT) NULLr+pU rxU'Mp&W
}可以使用的SQL语句。E7Zs)BQ4W
CREATE TABLE useronline (B]vo4^M\*v'?"u;j7M
timestamp int(15) DEFAULT '0' NOT NULL,#zX2C3p$^AWHJ)MZ
ip varchar(40) NOT NULL,b??Gg q
file varchar(100) NOT NULL,
Ik&T0aC4l PRIMARY KEY (timestamp),
W_
`!fM5H KEY ip (ip),
,gJ+ub6nSde0tk KEY file (file)
"PL$[3wC4D:O7E.w'd^"]n );下面我们是PHP脚本，首先我定义MYSQL的信息。
)s{$A G'P p $server = "localhost"; //你的服务器
KXO!V-WC_ $db_user = "root"; //你的mysql的用户名
tj4y&p4I}Gk $db_pass = "password"; //你的mysql的密码+pu5b7T@
$database = "users"; //表的名字设置统计的时间(多少秒内在线人数)0efTF)a^
$timeoutseconds = 300;取当前时间。 PET(D2J%};C6K f'y
$timestamp = time();上面的完整代码：
9sWJa s <?php
d ?;J]8Bz $server = "localhost"; //your server+Q+nF:hNR8k0n
$db_user = "root"; //your mysql database username
m+fys"}.IIh4A $db_pass = "password"; //your mysql database password if any.cR2\ V@t,|
$database = "users"; //the db name%e8eW3O/M
$timeoutseconds = 300;//timeoutseconds limit5Wo3D*H k'a
//get the current time
;v*c C6Z ^&F3N $timestamp = time();
Z7Sw-LYI //calculate the lowest timestamp allowed
?5R$L*XL.j $timeout = $timestamp-$timeoutseconds;8G_9ecW4ca
?>连接mysql
&A9Z'j2T?]Vm-q%nG mysql_connect('localhost', 'username', 'password');也允许使用变量形式。 l'z(w|,V%xA7x\
mysql_connect($server, $db_user, $db_pass);如果mysql数据库没有密码的话可以使用下面代码连接h"|,M |p [
mysql_connect($server, $db_user);查询数据库的代码：
(`
@%VKSS9E mysql_db_query('database', 'query');我们只要有访客就要增加一条记录。7R#E?9b`+CV
$insert = mysql_db_query($database, "INSERT INTO useronline VALUES6Ct*s3k]V FHum
('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");B"C(IOc"`
如果用户用错误信息的话，这样处理。
;aQ"Z$L.] if(!($insert)) {%i%J6P Jm;_N7I
y-Nh;GEb9d
print "Useronline Insert Failed > ";xr(qM6Ka kKR
}然后实现当超过设置的时间就删除该用户记录。8z*kCrk3p({X_^Cl
$delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");同样给出删除记录出错的处理。@S)yb_9Wv,^w
if(!($delete)) {
}#zynK%d^~` print "Useronline Delete Failed > ";
r/A"z u\I;N#?s9\ }下面我们解决数据库中不同IP的问题3fx8Yg$Uv$km2Y:w.M
$result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");使用
7R K%f;C`oF7Q#K
aqP mysql_num_rows(query);来统计用户，代码如下。| A'ar)UOs`
$user = mysql_num_rows($result);最后关闭数据库。{+EroYk7t
yJ
mysql_close();显示在线的人数。
^7Kj` J+qufx_ if($user == 1) {4D
~lC@&V ?
print("1 user online\n");
@$HL8V6W5Y~X1? } else {+jD4[j r `j \EW
print("$user users online\n");
-m2^/dSqwD9c }最终把上面代码写成一个PHP文件如下。$N] J]}mi
<?php
#]Wj/x2L@6s //Put your basic server info here
;}
k:W:|n $server = "localhost"; //normally localhosth&qgZbW"ypv
$db_user = "root"; //your MySQL database usernamebz~f.NA*S
$db_pass = "password"; //your MySQL database password
qjzJ|+W[8kVI $database = "users";|?_R!~
$timeoutseconds = 300; //it will delete all people which haven't refreshed(so probbably are
})Q8O)`P7r // offline or inactive) in $timieoutseconds time (so it actually checks the people that are active in the lastye(`3Nk2U'l
// $timeoutseconds seconds)
t K*ZAJGY //this is where PHP gets the time
Z]S,qy+DE&I $timestamp = time();
C3R"cw)Oi //counts the timeout, all people which have been seen last online in earlier than this timestamp, will get removed
ca^q/Hg$g2s` $timeout = $timestamp-$timeoutseconds;)E5K"T Opa#nH"U
//connect to database
'k t w&LAqS;[ mysql_connect($server, $db_user);/dH5M0K t
//add the timestamp from the user to the online list
M@yt5Txw $insert = mysql_db_query($database, "INSERT INTO useronline VALUES
,j4hV#S@r1dvm ('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");'V.y8b,`:P1jD
if(!($insert)) { bQU9aDZIe
print "Useronline Insert Failed > ";I(_!MM,}G
} Z6T$zB'_
U
}!_3r
//delete the peoples which haven't been online/active in the last $timeoutseconds seconds.
hl!Q|t/J $delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");+@,L?,O s2oj"ip(v
ce
if(!($delete)) {
J
mws4d&L0I print "Useronline Delete Failed > ";
~ Iddz_
}
:v6nT"}}`NhO //select the amount of people online, all uniques, which are online on THIS page
K-p:oAD B7VP*e $result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");
Rl'P P9\$~ Hb if(!($result)) {7W7l7_Ok`$\e~7K-s
print "Useronline Select Error > ";
Otv1K2y1{eE$u }!\"u#y:L$ZM
//Count the number of rows = the number of people online
$HKq^KQ)Q w $user = mysql_num_rows($result);
n,x(Iw~}So.U //spit out the results5U7U0hHOHQ
mysql_close();
iIy }'`4_0Q&Q if($user == 1) {8\9B$W8?.Rz
print("1 user online\n");
:u @'r^RB;B%wx } else {
ts$g9B ? z/B[ print("$user users online\n");+]VY!g t?a%G'N
}cG:G`4?}
?>
3u^ N%kod5S [url=http://www.now.cn/vhost/][img]http://b.todayisp.com/bbs/760x90h.gif[/img][/url]
o)v {rwx'bt Y*^ 以上代码我是在时代互联提供的免费试用主机上测试的，感觉效果还不错，性能很稳定，不信的话你也可以去试试。当然，记得指出我这个程序中的不足先哦。
P9k6Uol:H2\ 时代互联是行业内最早开始提供PHP 虚拟主机的公司之一，现在已经是的金牌域名注册商和中国互联网客户满意度十佳单位，产品功能已经非常完善 ，特别提一下几个特有用的功能：数据库自动备份、免费集成繁简通简装版、多域名绑定、多子网站支持、GCDN 网站加速器、镜像加速、高级访问统计系统、支持WAP、可选电信/网通/香港机房。@4rd2Gy A"F-IbN
我之前建站的时候选的是他们公司标准商务E型，因为这款机型还特别支持ASP.NET3.5(3.0/2.0/1.1)/ASP。
u?c9f],p:D0k 当然啦，这两款主机也是相当不错的。2N ]x.tNp
智强商务B型：Unix /Linux 操作系统+独立网页空间1000MB+送1000MB邮局空间+100MB MySQL数据库空间=1869元/年]9h4q['l
标准商务B型：Unix /Linux 操作系统+独立网页空间500MB+送800MB邮局空间+60MB MySQL数据库空间=1365元/年-k/Gy|hD,})A
提供一下这个公司的联系方式：请见：[url=http://www.now.cn/vhost/]http://www.now.cn/vhost/[/url] {.`5aF:_D5h&|8G
空间专线： 0756-2623871  QQ：168075865，好象还有全球免费网络电话:全球免费咨询电话 [url=http://www.now.cn/callcenter/call.net?LineName=55]http://www.now.cn/callcenter/call.net?LineName=55[/url]
x4_n m:x5wI 自己加QQ去问吧。

查看完整版本: 刚用PHP写了一个网站在线人数的程序，请大家进来指点下！