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

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

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

刚用PHP写了一个网站在线人数的程序，请大家进来指点下！%F7t%MwU@ C'x,t,]'G
我是用PHP+MYSQL来写的，原理：网站在线人数的程序代码+后台有MYSQL数据库支持，可以直接统计出网站当前的在线人数。5h\%{GJ
首先我创建MYSQL数据库表。
n}n0z+Wq6OXi8T CREATE TABLE tablename (
1G7J7B D[ field type(max_length) DEFAULT 'default_value' (NOT) NULL B#^-Mq$Lm
}可以使用的SQL语句。H*{1u1U:v/N
E
CREATE TABLE useronline (YMm7l0d/~`n2XnY
timestamp int(15) DEFAULT '0' NOT NULL, RF0ug,RrOD0t}5Y
ip varchar(40) NOT NULL,E?)z4p7A Gw
file varchar(100) NOT NULL,
ul9O-Gd/s,uE-Y PRIMARY KEY (timestamp),
9}
a Ei'}3b KEY ip (ip),
m&c'|Lv N L KEY file (file)P[7g,Z7J/?f
);下面我们是PHP脚本，首先我定义MYSQL的信息。
#?9sD#}6IB2L(P $server = "localhost"; //你的服务器6d3C*Xc.yT
$db_user = "root"; //你的mysql的用户名
[8b p,{2{b j $db_pass = "password"; //你的mysql的密码
7Cj%TR b@ |B;Ex $database = "users"; //表的名字设置统计的时间(多少秒内在线人数)
UqOj`.H&R&U,U $timeoutseconds = 300;取当前时间。5X(Q+}L&y&fDV
$timestamp = time();上面的完整代码：0m-}5Ge;_N;q
<?php
"V*b t1pRt&[)LT $server = "localhost"; //your server0GN)kS6Ooo
$db_user = "root"; //your mysql database username c l0|kx%^
$db_pass = "password"; //your mysql database password if any
+a x0B5Hq\@v $database = "users"; //the db name;OOCg{7ez
$timeoutseconds = 300;//timeoutseconds limit
M o"\J*kfH0k //get the current time
9D(I9j,[Q&F.Uit $timestamp = time();
6d#Ku nnfn4eev+} //calculate the lowest timestamp allowed)t`C?(n-i?og%mB
$timeout = $timestamp-$timeoutseconds;.i#s8q.lDR%M m
?>连接mysqlV'rKn4H+E:w Yn&K
mysql_connect('localhost', 'username', 'password');也允许使用变量形式。
)m6s3p)?U]@z l/Z mysql_connect($server, $db_user, $db_pass);如果mysql数据库没有密码的话可以使用下面代码连接#iS)G9TU$rml5H P:P
mysql_connect($server, $db_user);查询数据库的代码：:tXu;QW/~(sf
mysql_db_query('database', 'query');我们只要有访客就要增加一条记录。3cN5m7c6i!B1Ur9C@
$insert = mysql_db_query($database, "INSERT INTO useronline VALUES
5x
Gpc]WQG^ ('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");&cO
Ch4^bg;?
如果用户用错误信息的话，这样处理。
m;qWT8DDW0Pf if(!($insert)) {i]m1w2p+o$Y3}7b
print "Useronline Insert Failed > ";
)w"P1ME|)X B0E6T[r }然后实现当超过设置的时间就删除该用户记录。
`'U;}z7mH(p PO u] $delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");同样给出删除记录出错的处理。qLE0t(h8CcM
if(!($delete)) {ar9w9D-a Iq~n
print "Useronline Delete Failed > "; P.s-Y$Imo*mu8W
}下面我们解决数据库中不同IP的问题
"@n+OaR $result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");使用9j};{3cTguC2|
mysql_num_rows(query);来统计用户，代码如下。
b,Bw2M} $user = mysql_num_rows($result);最后关闭数据库。Y-B}2U"j!c2Q
mysql_close();显示在线的人数。+aOLtG|4Q
if($user == 1) {
fI*^ i(j-ZF ]"oC,AK print("1 user online\n");
G\o*xa*A+]'h } else {
%VX&G%K;Z)~ print("$user users online\n");
/Lpg
g jo|!Q$NY C!X;N }最终把上面代码写成一个PHP文件如下。;D2[5w{lA/]W
<?php
*C'UcfH | Z3f //Put your basic server info here
'X
KSz(`'EyHE+b/y $server = "localhost"; //normally localhost
Y Gq'SH\5v.s E $db_user = "root"; //your MySQL database username E&~ ^4^m8IbkI
$db_pass = "password"; //your MySQL database password

g.^"cv(_
R:^ $database = "users";
O$x:v6Z Nh,D $timeoutseconds = 300; //it will delete all people which haven't refreshed(so probbably are
!H
gDJZ9^9I~O~bo // offline or inactive) in $timieoutseconds time (so it actually checks the people that are active in the last
sqD;K Ddt#V8T // $timeoutseconds seconds)
%D'Vo]qo //this is where PHP gets the timeB D*zFF%r t
$timestamp = time();]/U,_ xhY
//counts the timeout, all people which have been seen last online in earlier than this timestamp, will get removed
c4_x1VtNS $timeout = $timestamp-$timeoutseconds;
*f7B4XQo@1HPx:\n //connect to database
-p%sV:`;Mb+I|
m&[*E mysql_connect($server, $db_user);V2SW(jl%R
//add the timestamp from the user to the online list G'XZJ#v*v4M\0W"J'?
$insert = mysql_db_query($database, "INSERT INTO useronline VALUES
(zO4u6|u!U_&^ C8I ('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");E(q_;Jz:^};n/H
if(!($insert)) {kj N(Q#W { SJ7k'I
print "Useronline Insert Failed > ";
U9je;L2k }
m.y%T+i8Y"@:R //delete the peoples which haven't been online/active in the last $timeoutseconds seconds.tV[mS
IR3c1|
$delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");
/i7L NJg)b$yEp if(!($delete)) {C*u@^,i
print "Useronline Delete Failed > ";
TO#k4i,W;lA }6kPG4DF%f"O
//select the amount of people online, all uniques, which are online on THIS page.b/[:d2?"i v
$result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");B3];aR;s,j
if(!($result)) {
EQl4ZK print "Useronline Select Error > ";
s1UVGue8mt }
4o(T7j l,w8])iq //Count the number of rows = the number of people online
-U!H!bqv'z-^(h $user = mysql_num_rows($result);
&yk
i J:pmA //spit out the results
_!fMnNG$c \ mysql_close();
%^Gs6Pw3q~0d if($user == 1) {
0V'? ]|I1FP6SX print("1 user online\n");%gW p9O(nQ
} else {
/z/LVEg1x7m0U1P print("$user users online\n");
zl;^8~ E9|,mjL+JVj } { `t @+yJ)v7T
?>@j
v2IE-N;Z
[url=http://www.now.cn/vhost/][img]http://b.todayisp.com/bbs/760x90h.gif[/img][/url]n0}{$Vq!eob3MS(v
以上代码我是在时代互联提供的免费试用主机上测试的，感觉效果还不错，性能很稳定，不信的话你也可以去试试。当然，记得指出我这个程序中的不足先哦。
y'x8i3SCk 时代互联是行业内最早开始提供PHP 虚拟主机的公司之一，现在已经是的金牌域名注册商和中国互联网客户满意度十佳单位，产品功能已经非常完善 ，特别提一下几个特有用的功能：数据库自动备份、免费集成繁简通简装版、多域名绑定、多子网站支持、GCDN 网站加速器、镜像加速、高级访问统计系统、支持WAP、可选电信/网通/香港机房。E?Y3v?y[5e
我之前建站的时候选的是他们公司标准商务E型，因为这款机型还特别支持ASP.NET3.5(3.0/2.0/1.1)/ASP。
G8T:h%b!j#HX1o 当然啦，这两款主机也是相当不错的。
H,VC8N}O%m 智强商务B型：Unix /Linux 操作系统+独立网页空间1000MB+送1000MB邮局空间+100MB MySQL数据库空间=1869元/年;b#m2v%k9RL7Kl0c
标准商务B型：Unix /Linux 操作系统+独立网页空间500MB+送800MB邮局空间+60MB MySQL数据库空间=1365元/年
]3W%d8`)^;i7_c4l%~ 提供一下这个公司的联系方式：请见：[url=http://www.now.cn/vhost/]http://www.now.cn/vhost/[/url]
Z~6UX+|,s2ne 空间专线： 0756-2623871  QQ：168075865，好象还有全球免费网络电话:全球免费咨询电话 [url=http://www.now.cn/callcenter/call.net?LineName=55]http://www.now.cn/callcenter/call.net?LineName=55[/url],VM JEvaEf!x
自己加QQ去问吧。

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