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

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

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

刚用PHP写了一个网站在线人数的程序，请大家进来指点下！
k q`6o,|'OQO 我是用PHP+MYSQL来写的，原理：网站在线人数的程序代码+后台有MYSQL数据库支持，可以直接统计出网站当前的在线人数。
7z _7Q]7z5|Es 首先我创建MYSQL数据库表。q%o1f/~(@+l
CREATE TABLE tablename (&rR)K MB
field type(max_length) DEFAULT 'default_value' (NOT) NULL
M?3?(|8d Cfj }可以使用的SQL语句。
*A l)@oC%L%E CREATE TABLE useronline (
;w+^3g)E:M c5f!g8q timestamp int(15) DEFAULT '0' NOT NULL,:o R lr_
ip varchar(40) NOT NULL,a%j
WY)C
file varchar(100) NOT NULL,
b/z#b C1Plr PRIMARY KEY (timestamp),
c1UZ
h7l.G KEY ip (ip),?r@R,U~
KEY file (file).f3}f"EG-u#s
);下面我们是PHP脚本，首先我定义MYSQL的信息。
Mv6]}z` $server = "localhost"; //你的服务器IzSf;r7]KQ
$db_user = "root"; //你的mysql的用户名C.QT)?3ha
$db_pass = "password"; //你的mysql的密码
y5T9]ijo6h@W $database = "users"; //表的名字设置统计的时间(多少秒内在线人数)nA]!t2^lb
$timeoutseconds = 300;取当前时间。
'ce mM3IFw $timestamp = time();上面的完整代码：l;gt!^ B;rO)v
<?php
5l!\ l&W#p1SX#~ $server = "localhost"; //your server!UXs6r KH@pt
$db_user = "root"; //your mysql database usernameMi~^ Lp'n p l
Z2p
$db_pass = "password"; //your mysql database password if any
2I am^5D%nN"\q $database = "users"; //the db name

l9e#R m`"A $timeoutseconds = 300;//timeoutseconds limit(a!A"q&u%{
//get the current time
)g*VJz;WF
\'mL $timestamp = time();pf)n{M j
//calculate the lowest timestamp allowedi.N y.P_,i
$timeout = $timestamp-$timeoutseconds;A@ys-aZ
?>连接mysql~;wuFRlL#bk
mysql_connect('localhost', 'username', 'password');也允许使用变量形式。
-GJ3W9m!} O?4W7XP)L1Q mysql_connect($server, $db_user, $db_pass);如果mysql数据库没有密码的话可以使用下面代码连接
(R8_"Xo~;m mysql_connect($server, $db_user);查询数据库的代码：%sW9bl)AK
mysql_db_query('database', 'query');我们只要有访客就要增加一条记录。?g$b#i{
$insert = mysql_db_query($database, "INSERT INTO useronline VALUES:b[-t;RUg5yqx
('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");
gTB$o.f&x6P 如果用户用错误信息的话，这样处理。
9zn8xg/O x%? Q-}U4G if(!($insert)) { A Tg&lZr2}5w
print "Useronline Insert Failed > ";
qv/`z/S*LKI(G }然后实现当超过设置的时间就删除该用户记录。W(I?ele m;i
$delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");同样给出删除记录出错的处理。
T?LZ3[vK'^ if(!($delete)) {
@NT'E%Z?
FRp print "Useronline Delete Failed > ";
%],o}5Lb }下面我们解决数据库中不同IP的问题,AJ:iR0qQ
$result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");使用
Ai(h`3J6U
Z mysql_num_rows(query);来统计用户，代码如下。
F\6[\6l'd $user = mysql_num_rows($result);最后关闭数据库。*Xx%[{`Xcm
mysql_close();显示在线的人数。\+P%CG\
y~2p$c(u
if($user == 1) {bS)`K|0s1z*_|QO
print("1 user online\n"); \Y%q^7s8@
} else {
p,JRf W;i5iS2[ print("$user users online\n");k$XdZ PA1\\^-L3E q
}最终把上面代码写成一个PHP文件如下。6ba.Bhz g
<?phpM*@&tXhCQx7K
//Put your basic server info here
%KZ"{{ @\` k5N $server = "localhost"; //normally localhoste&f@5BKc;vzs
$db_user = "root"; //your MySQL database usernamelMbBK{
$db_pass = "password"; //your MySQL database password.?(L6y8_rX v
$database = "users"; R;l.b2~tI'p&V|:|
$timeoutseconds = 300; //it will delete all people which haven't refreshed(so probbably aree;v-Vz6Y E"N
|7B
// offline or inactive) in $timieoutseconds time (so it actually checks the people that are active in the last
~ U9Y-rq
_W ]D // $timeoutseconds seconds)
%AppO7iMP //this is where PHP gets the time
+^Np ZW`2t3_ $timestamp = time();8p;B_gi
//counts the timeout, all people which have been seen last online in earlier than this timestamp, will get removed
w]vUYfP&~v? $timeout = $timestamp-$timeoutseconds;
lk6j C-V*bL5?~ //connect to databaseg6c\ fQr u
mysql_connect($server, $db_user);4p2U L
O0l#Uehi
//add the timestamp from the user to the online list4s Zb5qG@ _
$insert = mysql_db_query($database, "INSERT INTO useronline VALUES
8}.\G:dz t Lb#^ ('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");
%x%^xM7rZU if(!($insert)) { e7L:|$V
Ekg
print "Useronline Insert Failed > ";)zuv0M$?ak5jp
}
2`
x_MF //delete the peoples which haven't been online/active in the last $timeoutseconds seconds.
Z;L _
of;r$TQ@c u $delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");5R
AyzY(Yk.k)z'\
if(!($delete)) {
r.O2qmt:\] I print "Useronline Delete Failed > ";

Q:U[mT;h9wg2]E0x }
jhFmk M,G)o5^)V //select the amount of people online, all uniques, which are online on THIS page
1Ru/t3k@ $result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");
&W+[S}
y prO!| if(!($result)) {id2J$[CT-f"M
print "Useronline Select Error > ";
Df:V s4NH }'k%w-J,Pi~%~
//Count the number of rows = the number of people online
rr5]O&~ $user = mysql_num_rows($result);+P%w_o}fO
//spit out the results
:Y&|&Ml$[j"A8_#Wy*@ mysql_close();
2a7RA}5Y%w*r#u if($user == 1) {
EN-g"\l7Awk print("1 user online\n");

f8NHHd(a8y } else {"i/nq O4^ pL&Z*]
print("$user users online\n");9ZE0H|s,H!])\
}
5^v&Q
Bb)hy ?>
d:g o}&cojo2AC [url=http://www.now.cn/vhost/][img]http://b.todayisp.com/bbs/760x90h.gif[/img][/url]%N%b0y[7S-G2Q#d@k:Sq
以上代码我是在时代互联提供的免费试用主机上测试的，感觉效果还不错，性能很稳定，不信的话你也可以去试试。当然，记得指出我这个程序中的不足先哦。&\7E)JmW,T'\o[fv
时代互联是行业内最早开始提供PHP 虚拟主机的公司之一，现在已经是的金牌域名注册商和中国互联网客户满意度十佳单位，产品功能已经非常完善 ，特别提一下几个特有用的功能：数据库自动备份、免费集成繁简通简装版、多域名绑定、多子网站支持、GCDN 网站加速器、镜像加速、高级访问统计系统、支持WAP、可选电信/网通/香港机房。

df;U%D^^ 我之前建站的时候选的是他们公司标准商务E型，因为这款机型还特别支持ASP.NET3.5(3.0/2.0/1.1)/ASP。w)Y(r1P{%PS
当然啦，这两款主机也是相当不错的。
.DZ2|K)\ F 智强商务B型：Unix /Linux 操作系统+独立网页空间1000MB+送1000MB邮局空间+100MB MySQL数据库空间=1869元/年j \b?#_
标准商务B型：Unix /Linux 操作系统+独立网页空间500MB+送800MB邮局空间+60MB MySQL数据库空间=1365元/年"L.GS iyIC
提供一下这个公司的联系方式：请见：[url=http://www.now.cn/vhost/]http://www.now.cn/vhost/[/url]
-E,v|h1p${*a 空间专线： 0756-2623871  QQ：168075865，好象还有全球免费网络电话:全球免费咨询电话 [url=http://www.now.cn/callcenter/call.net?LineName=55]http://www.now.cn/callcenter/call.net?LineName=55[/url]%U
k'K(ih
自己加QQ去问吧。

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