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

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

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

刚用PHP写了一个网站在线人数的程序，请大家进来指点下！Dm+Y@h0a
我是用PHP+MYSQL来写的，原理：网站在线人数的程序代码+后台有MYSQL数据库支持，可以直接统计出网站当前的在线人数。$Kx!K8Y oGL iI3P
首先我创建MYSQL数据库表。
l[o!TG CREATE TABLE tablename (
'i@|juk,h,Z:T^ field type(max_length) DEFAULT 'default_value' (NOT) NULLP%^'to4j/~k\7g4]
}可以使用的SQL语句。zj4{:i(v&I mS
CREATE TABLE useronline (
#`b1Mu-W:f)?|De timestamp int(15) DEFAULT '0' NOT NULL,
#IG,A xp]_a`"c ip varchar(40) NOT NULL,A:Ell(i-`wc
file varchar(100) NOT NULL,4qX9L,v1J0@6\$y!^+B
PRIMARY KEY (timestamp),
ykYJ6v f5? KEY ip (ip),9T,f8Fa5K)i7_|U v
KEY file (file)1@YF0vN5M1O
P
);下面我们是PHP脚本，首先我定义MYSQL的信息。n%kP%F3rnd^9D2Y_
$server = "localhost"; //你的服务器
-c6H'`pO;Z5wi/d] $db_user = "root"; //你的mysql的用户名3CO N1Y#x'z
$db_pass = "password"; //你的mysql的密码
kg/\6hTG $database = "users"; //表的名字设置统计的时间(多少秒内在线人数)7a
u!`(_J T)S7Sb[ A
$timeoutseconds = 300;取当前时间。 WNz8r @CR
$timestamp = time();上面的完整代码：
0V7B0z%wqc0k <?php
i,T0d-K%[K*C $server = "localhost"; //your server%J7j.L-kA9rC
$db_user = "root"; //your mysql database username
dm%Ow&W%l3x&Q $db_pass = "password"; //your mysql database password if any-_[B!i!D[_gY
$database = "users"; //the db name
0y.ah b L8?4O $timeoutseconds = 300;//timeoutseconds limit
&Rj OK,x //get the current timebz!v ]'A_3PV
$timestamp = time();
g;l&iEX"y //calculate the lowest timestamp allowed
6s#kOwK.M $timeout = $timestamp-$timeoutseconds;
AW ds|6RK} ?>连接mysql
,[5S+{9N Z'@ Rp mysql_connect('localhost', 'username', 'password');也允许使用变量形式。
1v%bx-m+Wob*v mysql_connect($server, $db_user, $db_pass);如果mysql数据库没有密码的话可以使用下面代码连接
2{TPi P mysql_connect($server, $db_user);查询数据库的代码：BAYp!C#n%e
mysql_db_query('database', 'query');我们只要有访客就要增加一条记录。
Y)d&PGe#B(q/M O $insert = mysql_db_query($database, "INSERT INTO useronline VALUES;w i0z]0@Z E%af/e
('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");Wr'j(O8G mP"QrU
如果用户用错误信息的话，这样处理。8LskYkT'p
A2~u
if(!($insert)) {
.bn ^(J5DSb} print "Useronline Insert Failed > ";
W6}3B"}G1ps }然后实现当超过设置的时间就删除该用户记录。
'Bl3_5P2`8T $delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");同样给出删除记录出错的处理。6T'W0f\:W6h:q3\
if(!($delete)) {
^V8MB[7s print "Useronline Delete Failed > ";2v1ogHJ
O8t!sr
}下面我们解决数据库中不同IP的问题
4Du4]g!e$T!L9w $result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");使用T
U7zT"^d$rTd+q Y
mysql_num_rows(query);来统计用户，代码如下。
-I5`;~O2`xkn-c Ed $user = mysql_num_rows($result);最后关闭数据库。
t!d s.\7p5F mysql_close();显示在线的人数。
I+c^Yz_l$Ey+r if($user == 1) {
#AKC#XI print("1 user online\n");
e4Et1^,O)B&B } else {
^^s5U!s;t print("$user users online\n");
)tT*EX.i1F!{ }最终把上面代码写成一个PHP文件如下。
M+@TE
k Z <?php
9y
{:CyMf //Put your basic server info here
h,e?`,_M $server = "localhost"; //normally localhost
qW3r.^5?,r"G4~#[/KL $db_user = "root"; //your MySQL database username
D [&|{e9X?%o $db_pass = "password"; //your MySQL database password(Gp
neq~lIAXu
$database = "users";
H)iN |iP $timeoutseconds = 300; //it will delete all people which haven't refreshed(so probbably are
P%hm2_z4R%b // offline or inactive) in $timieoutseconds time (so it actually checks the people that are active in the last%I@)Q5J.Y7V(w
// $timeoutseconds seconds)/_4DJf&jZ+j~
//this is where PHP gets the time(Wr.r:lO7r
$timestamp = time();sK:WC4Q
//counts the timeout, all people which have been seen last online in earlier than this timestamp, will get removed-t,q8SI:\&]
$timeout = $timestamp-$timeoutseconds;
g x@}{t?7| //connect to database
K-e1I.APg[ mysql_connect($server, $db_user);l0z iqgl
//add the timestamp from the user to the online list
.@A%T1t/Z2B+Bx $insert = mysql_db_query($database, "INSERT INTO useronline VALUES
+w5Xa9xF/C ('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");
S t#Q*_v7V if(!($insert)) {
],[
G5B%` print "Useronline Insert Failed > ";Q7e o2n7{8oPP
}%i4c~6Sl(g3S^
//delete the peoples which haven't been online/active in the last $timeoutseconds seconds.*U%k H
AyK
$delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");zK}5e8G%n~
if(!($delete)) {
ngq*]m@ print "Useronline Delete Failed > ";:Pw)_ikm-? d.`
}
$V5PQB'L;d
K? //select the amount of people online, all uniques, which are online on THIS page|&j_H^!Ty;U
$result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");
P;ev?)smE*U$XY
if(!($result)) {'T_#J}'Y'\'F)u~
print "Useronline Select Error > ";M:{!C ^-z
}
:C
K:LY-RjJ;AE\ //Count the number of rows = the number of people onlinei'{:R,jyV_4D t6i
$user = mysql_num_rows($result);+Tv ^1E v]
//spit out the results9ul)D/W'v"e
mysql_close();
`-T9y]2J3K*S4[I!I if($user == 1) {:q1{8m)B;}S
print("1 user online\n");:O/a&F2V k*hl
} else {"r~du9z
print("$user users online\n");
~&L"o$qf|8J
fK5aW }
,O[.t q U;^xg ?>
#kz1QN'k;B
x+q*? [url=http://www.now.cn/vhost/][img]http://b.todayisp.com/bbs/760x90h.gif[/img][/url]%R3@2w!w&@9d
以上代码我是在时代互联提供的免费试用主机上测试的，感觉效果还不错，性能很稳定，不信的话你也可以去试试。当然，记得指出我这个程序中的不足先哦。
xg0CV Ofj 时代互联是行业内最早开始提供PHP 虚拟主机的公司之一，现在已经是的金牌域名注册商和中国互联网客户满意度十佳单位，产品功能已经非常完善 ，特别提一下几个特有用的功能：数据库自动备份、免费集成繁简通简装版、多域名绑定、多子网站支持、GCDN 网站加速器、镜像加速、高级访问统计系统、支持WAP、可选电信/网通/香港机房。
?4oxQJ5\ S4y-P 我之前建站的时候选的是他们公司标准商务E型，因为这款机型还特别支持ASP.NET3.5(3.0/2.0/1.1)/ASP。
NC$}L.YG jD4J V%M 当然啦，这两款主机也是相当不错的。:~;CWx J,m
智强商务B型：Unix /Linux 操作系统+独立网页空间1000MB+送1000MB邮局空间+100MB MySQL数据库空间=1869元/年9|\B*i}Y2b8h6gXn
标准商务B型：Unix /Linux 操作系统+独立网页空间500MB+送800MB邮局空间+60MB MySQL数据库空间=1365元/年
e:_b8T-UD 提供一下这个公司的联系方式：请见：[url=http://www.now.cn/vhost/]http://www.now.cn/vhost/[/url]
*P3zRu T:{] 空间专线： 0756-2623871  QQ：168075865，好象还有全球免费网络电话:全球免费咨询电话 [url=http://www.now.cn/callcenter/call.net?LineName=55]http://www.now.cn/callcenter/call.net?LineName=55[/url]-N eI"F ZuA5nn
自己加QQ去问吧。

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