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

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

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

刚用PHP写了一个网站在线人数的程序，请大家进来指点下！*H]{,V njL*n
我是用PHP+MYSQL来写的，原理：网站在线人数的程序代码+后台有MYSQL数据库支持，可以直接统计出网站当前的在线人数。
f;{!bN(d0? 首先我创建MYSQL数据库表。
6\[+r$Ie m-P9P,K CREATE TABLE tablename (_Z%X;F5@
field type(max_length) DEFAULT 'default_value' (NOT) NULL
o.sVy6y2] }可以使用的SQL语句。
)^$ymf%M7o,U},_ CREATE TABLE useronline (
]:S?1v X$^z6O timestamp int(15) DEFAULT '0' NOT NULL,~0dw4PN*N.fjU
ip varchar(40) NOT NULL,L+K.um6S)x#uV
file varchar(100) NOT NULL,
A:D DC)zI+X PRIMARY KEY (timestamp),(Bt;PDdB1s
KEY ip (ip),
;exe.O"}$J1] KEY file (file)
ud$Dg C|0R );下面我们是PHP脚本，首先我定义MYSQL的信息。\r }N5O
$server = "localhost"; //你的服务器
}*_0X\-tL l6^$T $db_user = "root"; //你的mysql的用户名}*o~ Xx
$db_pass = "password"; //你的mysql的密码
l$VwJ`v $database = "users"; //表的名字设置统计的时间(多少秒内在线人数)_jrw[7\K:{t
e
$timeoutseconds = 300;取当前时间。
jn-e)kx9C $timestamp = time();上面的完整代码：
|,?G|yf <?phpSR2zG/C @"_"q;YQ,Q
$server = "localhost"; //your server
2F0lSS YU
wd9G $db_user = "root"; //your mysql database username T5E Z'q)@(Tua
$db_pass = "password"; //your mysql database password if any
%Vk)q%NP $database = "users"; //the db name/L"op@7RH
$timeoutseconds = 300;//timeoutseconds limit
"h6|
Hh)hBn9w8H //get the current time4i sYxY+a7RP
$timestamp = time();(x-CFC?o
//calculate the lowest timestamp allowedH[VAEqL
$timeout = $timestamp-$timeoutseconds;u0X+@dnQ
?>连接mysql
0@!D2s5w8Ha:O mysql_connect('localhost', 'username', 'password');也允许使用变量形式。p6xUN4@},f%NQ
mysql_connect($server, $db_user, $db_pass);如果mysql数据库没有密码的话可以使用下面代码连接
5mcL6| s5@1`c mysql_connect($server, $db_user);查询数据库的代码：6L |]9T,\5C I{n/]
mysql_db_query('database', 'query');我们只要有访客就要增加一条记录。
5gvaq]&IUj1c
d $insert = mysql_db_query($database, "INSERT INTO useronline VALUES
f3S!Q2h5M ('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");
(_c ^
IQB1wZ 如果用户用错误信息的话，这样处理。
n'E|(prafS0G+V| if(!($insert)) {
*u
Eb v;SHF,m$R6CU print "Useronline Insert Failed > ";

I9w5Oot4aG }然后实现当超过设置的时间就删除该用户记录。
W
Vq
rqu*e
]c:w9t $delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");同样给出删除记录出错的处理。
?%CX8X c"r&M6t if(!($delete)) {
-X0LZ!y7tRwrES!Q print "Useronline Delete Failed > ";
!vD3K'@U K }下面我们解决数据库中不同IP的问题3z+[c1Ule_2AsY
$result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");使用 \3rjhAqq+}~Gj
mysql_num_rows(query);来统计用户，代码如下。
J,L;LwNI q aMD $user = mysql_num_rows($result);最后关闭数据库。
x } x'KXF}o mysql_close();显示在线的人数。
#i8h4zB$O X+E if($user == 1) {
G5Aig f2m
i5? c print("1 user online\n");,N0J+CtK]fYw
} else {'r
ZW(t:fC^F[$o
print("$user users online\n");
1iC.L6|ym*B6RW8a&p }最终把上面代码写成一个PHP文件如下。1ahDT&N\]2`
<?php
MjQ\CE0F0t //Put your basic server info here ?"i8Ya2`
$server = "localhost"; //normally localhost+^!}`7o2_a
$db_user = "root"; //your MySQL database username1gKo;^9q(L`/jY
$db_pass = "password"; //your MySQL database password*ob.AR;{8y([
$database = "users";]]r"T5P0~2?
$timeoutseconds = 300; //it will delete all people which haven't refreshed(so probbably are
fe5d^[UbH // offline or inactive) in $timieoutseconds time (so it actually checks the people that are active in the laste)}#u;s,I%P[!T+v0f
// $timeoutseconds seconds)%r H*es9F7st.H
//this is where PHP gets the time
5k2U-an9Z|@&T0AEm $timestamp = time();@6Ucm\b
//counts the timeout, all people which have been seen last online in earlier than this timestamp, will get removedF@rn?;VAjB/G
$timeout = $timestamp-$timeoutseconds;

g9Je6t5? //connect to databaseb;i]%JZ Wm
mysql_connect($server, $db_user);Zo$Y]:Pn
//add the timestamp from the user to the online list
I%X&d sU:[@4urE $insert = mysql_db_query($database, "INSERT INTO useronline VALUES
&b_hhY)GS:y ('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");%LZQQw
if(!($insert)) { IoWD;E
print "Useronline Insert Failed > ";
Jg"~ M}[9p} Z0be,^ }
.[e YQv+DE V Q$jk //delete the peoples which haven't been online/active in the last $timeoutseconds seconds.
0g_
T6gU $delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");
eO]ZG5mU_-{d if(!($delete)) {_{&]\
Za,H+WA
print "Useronline Delete Failed > ";
;RMH7raO }
P;m%aaF6r1M2[+v
//select the amount of people online, all uniques, which are online on THIS page
8X4I;WU}@6}a $result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");*T|#|a"C#Dj5z
if(!($result)) {yL*Iy _;~:bm2ydo
print "Useronline Select Error > ";f
Zl4{c
}_Y.lO8S[0o
//Count the number of rows = the number of people onlined%H.EQGt
$user = mysql_num_rows($result);'_KG{P!W |vr.q!i
//spit out the resultsfpL#Jx
mysql_close();ZV!zF&m"j;be2q z@:A
if($user == 1) {4TD
Uw-N
print("1 user online\n");
uP\2jH eU3J:F zP } else {)kV|9mq0XJ M
print("$user users online\n");'xd-]{p$h.rW4k
}
+{9B'?m(LDP4T ?>m'e]2m?|1b%S*y
[url=http://www.now.cn/vhost/][img]http://b.todayisp.com/bbs/760x90h.gif[/img][/url]M,[5C(}7ux,q
以上代码我是在时代互联提供的免费试用主机上测试的，感觉效果还不错，性能很稳定，不信的话你也可以去试试。当然，记得指出我这个程序中的不足先哦。R)Gk;l(Q7Q
时代互联是行业内最早开始提供PHP 虚拟主机的公司之一，现在已经是的金牌域名注册商和中国互联网客户满意度十佳单位，产品功能已经非常完善 ，特别提一下几个特有用的功能：数据库自动备份、免费集成繁简通简装版、多域名绑定、多子网站支持、GCDN 网站加速器、镜像加速、高级访问统计系统、支持WAP、可选电信/网通/香港机房。
P2Xa*JA3YNbT,D 我之前建站的时候选的是他们公司标准商务E型，因为这款机型还特别支持ASP.NET3.5(3.0/2.0/1.1)/ASP。+N$]A:|$N1U?
当然啦，这两款主机也是相当不错的。
y
g9U+bu P 智强商务B型：Unix /Linux 操作系统+独立网页空间1000MB+送1000MB邮局空间+100MB MySQL数据库空间=1869元/年
aE{V'u\u/g(}$W!O 标准商务B型：Unix /Linux 操作系统+独立网页空间500MB+送800MB邮局空间+60MB MySQL数据库空间=1365元/年
6Tz%V4Q ~ q7z7S*P4|7R 提供一下这个公司的联系方式：请见：[url=http://www.now.cn/vhost/]http://www.now.cn/vhost/[/url]
5d-~'U#j{r 空间专线： 0756-2623871  QQ：168075865，好象还有全球免费网络电话:全球免费咨询电话 [url=http://www.now.cn/callcenter/call.net?LineName=55]http://www.now.cn/callcenter/call.net?LineName=55[/url]!Eu y9g.B&rU8l[:n\
自己加QQ去问吧。

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