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

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

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

刚用PHP写了一个网站在线人数的程序，请大家进来指点下！
Be*PQ(qks2G 我是用PHP+MYSQL来写的，原理：网站在线人数的程序代码+后台有MYSQL数据库支持，可以直接统计出网站当前的在线人数。
A)G#~%m_&J 首先我创建MYSQL数据库表。 ?7q7qVVm~Js
G#r
CREATE TABLE tablename (5DG#x V9B3h'D sz
field type(max_length) DEFAULT 'default_value' (NOT) NULL
q:eBw D2X|{,n }可以使用的SQL语句。L|5l,xx0A D"Do)U
CREATE TABLE useronline (
Y$kfQ,V4@5s7T timestamp int(15) DEFAULT '0' NOT NULL,8H7h}
wP$Mce
ip varchar(40) NOT NULL,
1f,r-M&n#yc&R file varchar(100) NOT NULL,
1}:O4p0n n+N PRIMARY KEY (timestamp),
R%RF~#P\]g)s KEY ip (ip),
(b%a,G&pyp(I KEY file (file)
W X5uw{ );下面我们是PHP脚本，首先我定义MYSQL的信息。'x7jCOkX}
$server = "localhost"; //你的服务器 gyh3V7H;]UF{1a
$db_user = "root"; //你的mysql的用户名
-MXZpvJ6Sh $db_pass = "password"; //你的mysql的密码9S%C:qHMn0`
$database = "users"; //表的名字设置统计的时间(多少秒内在线人数)k4zI mg[%o
$timeoutseconds = 300;取当前时间。
h${ I:]do|x $timestamp = time();上面的完整代码：
dP q&J-J \"b"I <?php
+gq UaHC:lK $server = "localhost"; //your server
*~4C e#K nw5D $db_user = "root"; //your mysql database username c swceE#oc"G
$db_pass = "password"; //your mysql database password if any
N8cP;d6jb $database = "users"; //the db nameS4f!oi&fGilQB
$timeoutseconds = 300;//timeoutseconds limitjgd2Fq'I-t!T
//get the current time*nc!x2`9R4Ah8MS~%s
$timestamp = time();-L_b T&Y
//calculate the lowest timestamp allowed
0oA+X3j:[tn0re_ $timeout = $timestamp-$timeoutseconds;
j6r2xH*I4t!\"n ?>连接mysql#gwg9tB4y O/]
mysql_connect('localhost', 'username', 'password');也允许使用变量形式。 O"Fwm)Q&j;v
mysql_connect($server, $db_user, $db_pass);如果mysql数据库没有密码的话可以使用下面代码连接
3S ? yLtqz2Y p)d mysql_connect($server, $db_user);查询数据库的代码：
5Z-KV4}N { mysql_db_query('database', 'query');我们只要有访客就要增加一条记录。
pDY4qa~[)L!f*^ $insert = mysql_db_query($database, "INSERT INTO useronline VALUES
!F
O#v;\5BRt:a ('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");z;q"{.k.P%jQ
如果用户用错误信息的话，这样处理。E#iR
L bb$q
if(!($insert)) {GQo/R6b
print "Useronline Insert Failed > ";9@} ]4?"m$MqI6g!X
}然后实现当超过设置的时间就删除该用户记录。
Qc9l9gxw $delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");同样给出删除记录出错的处理。
^w@e,Frv[(C if(!($delete)) {
$q\
m.@
e@'R S
b;w d2gGq print "Useronline Delete Failed > ";loBl QI)Q
}下面我们解决数据库中不同IP的问题
C1egZ!}/z7us $result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");使用
|#UC%B+x mysql_num_rows(query);来统计用户，代码如下。'ns\G1?"\"`*y/V)c
$user = mysql_num_rows($result);最后关闭数据库。G8^3v&g#}yB,s#Is
mysql_close();显示在线的人数。5n%DTF'U U;wu.Op
if($user == 1) {7Bq6jN9U{\/|3F
print("1 user online\n");
8h3~wcR5JH ["W;Vz~ } else {
o;FU6mi)R rj print("$user users online\n");T%k0O'm K/D
}最终把上面代码写成一个PHP文件如下。
flK
twxc/?'Q$bty
<?php
Wwnu1|E"g9n\ //Put your basic server info here
6X#A~r0P!Q/F)s $server = "localhost"; //normally localhost
q[ Dm8hFl c $db_user = "root"; //your MySQL database username4iVPg{-Pv)L
$db_pass = "password"; //your MySQL database password
N\1wb~"eD/{2C $database = "users";
Xh,W6N&B(_ $timeoutseconds = 300; //it will delete all people which haven't refreshed(so probbably areb_+LMfe?4C.A
// offline or inactive) in $timieoutseconds time (so it actually checks the people that are active in the last}Fg:o$Ry0as%f
// $timeoutseconds seconds)
c'T,D[A4M5Y Ge,W //this is where PHP gets the time
P i.J)l"`*[yY $timestamp = time();
aF0B(y-R8o+|IKFM!t //counts the timeout, all people which have been seen last online in earlier than this timestamp, will get removed
,T)b8kF(E4?U-?nd $timeout = $timestamp-$timeoutseconds;
)g9O9e:`iF@!H&?z%f //connect to database
m"qHJ^-p mysql_connect($server, $db_user);M(s?^7pA/B!\;m
//add the timestamp from the user to the online list0i^? G:c|[ K%w(n,f
$insert = mysql_db_query($database, "INSERT INTO useronline VALUESE%~e:o4R
('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");
D+K4WSq!? r$D6moc if(!($insert)) {
yl?l"R print "Useronline Insert Failed > "; g5k
q*Z~
}
r#n(Qx'V#argK //delete the peoples which haven't been online/active in the last $timeoutseconds seconds.
/~aTOD8^5C,z $delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");2d_L"q!{(BF&_
if(!($delete)) {VS6V%r$J9lv*C_Z
print "Useronline Delete Failed > ";%e#~tf??8X/\s
}kB.yOx$Sl6ns8^
//select the amount of people online, all uniques, which are online on THIS page
.N-^].JaC{ $result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");
buBG$e5z+_t if(!($result)) {
9Rb&D-@b9We(L[ print "Useronline Select Error > ";+k!j5L$F+Q;h;U
}
(ADn$s y ` //Count the number of rows = the number of people online
6K#ZW/r'z/e ws.] $user = mysql_num_rows($result);1SL:bpZC)U1X
//spit out the results
$~%j$_9Uj:?[Gp mysql_close();vn'gY
@#|(?'j}
if($user == 1) {
e"K,z+GnN
um print("1 user online\n");
"] t|lu7b } else { lZ7F,A%y#S*iDLx8h
print("$user users online\n");
"d)U+UCO0ra }4I'jFu2i#vN6C7_
?>
*t'W.c'w|&k [url=http://www.now.cn/vhost/][img]http://b.todayisp.com/bbs/760x90h.gif[/img][/url]5Fn\2o[u6^
以上代码我是在时代互联提供的免费试用主机上测试的，感觉效果还不错，性能很稳定，不信的话你也可以去试试。当然，记得指出我这个程序中的不足先哦。-|Q(z{$[*c+}M
时代互联是行业内最早开始提供PHP 虚拟主机的公司之一，现在已经是的金牌域名注册商和中国互联网客户满意度十佳单位，产品功能已经非常完善 ，特别提一下几个特有用的功能：数据库自动备份、免费集成繁简通简装版、多域名绑定、多子网站支持、GCDN 网站加速器、镜像加速、高级访问统计系统、支持WAP、可选电信/网通/香港机房。$ke[o6xBaIC
我之前建站的时候选的是他们公司标准商务E型，因为这款机型还特别支持ASP.NET3.5(3.0/2.0/1.1)/ASP。Vbl:O@.|;Rt
当然啦，这两款主机也是相当不错的。
]w
Xm0| 智强商务B型：Unix /Linux 操作系统+独立网页空间1000MB+送1000MB邮局空间+100MB MySQL数据库空间=1869元/年
w1Bx#[f"{#yn 标准商务B型：Unix /Linux 操作系统+独立网页空间500MB+送800MB邮局空间+60MB MySQL数据库空间=1365元/年5Q;d'x [UU$jt+I
提供一下这个公司的联系方式：请见：[url=http://www.now.cn/vhost/]http://www.now.cn/vhost/[/url]
:M;Njc i,J 空间专线： 0756-2623871  QQ：168075865，好象还有全球免费网络电话:全球免费咨询电话 [url=http://www.now.cn/callcenter/call.net?LineName=55]http://www.now.cn/callcenter/call.net?LineName=55[/url]
)V:\&W^ ~'}` F 自己加QQ去问吧。

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