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

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

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

刚用PHP写了一个网站在线人数的程序，请大家进来指点下！
+^E%K
O,VHL].k1w 我是用PHP+MYSQL来写的，原理：网站在线人数的程序代码+后台有MYSQL数据库支持，可以直接统计出网站当前的在线人数。b,Wz
ANCLt
首先我创建MYSQL数据库表。
G4i+?"T/G3h1E2Rg,ZN CREATE TABLE tablename (
9UL3H)G;a.GRu field type(max_length) DEFAULT 'default_value' (NOT) NULLT$y*| M`hKM |
}
}可以使用的SQL语句。)DWWD$k$Wb:K&jkyY(h
CREATE TABLE useronline (
3y%o3U;Vw-h4CM timestamp int(15) DEFAULT '0' NOT NULL,9R.uNNRl
ip varchar(40) NOT NULL,
9A#y1| Vq file varchar(100) NOT NULL,
(z)M-E5r5r PRIMARY KEY (timestamp), IQw9yc'Z
KEY ip (ip),
5C#S(Olh KEY file (file)
I ?n`` \f );下面我们是PHP脚本，首先我定义MYSQL的信息。
+c-MW+jg;D $server = "localhost"; //你的服务器
C9KYP'g $db_user = "root"; //你的mysql的用户名
V.s7jw#eR S $db_pass = "password"; //你的mysql的密码
kUwA3p0`tK $database = "users"; //表的名字设置统计的时间(多少秒内在线人数)
+Z9W|M(jt $timeoutseconds = 300;取当前时间。;Tz p9M-a/S
$timestamp = time();上面的完整代码：$Y0h*S/z*?L
<?php:^$ce`n7`5G
$server = "localhost"; //your server
]Q3? H3|abY $db_user = "root"; //your mysql database username
3X8H-N4W{i5U $db_pass = "password"; //your mysql database password if any
'n"bL mHz A $database = "users"; //the db name$t-X6W#[e^_
$timeoutseconds = 300;//timeoutseconds limit
-U:nJ]d.}? //get the current time
g^ Mh8emQ $timestamp = time();
9]t8o T UKU //calculate the lowest timestamp allowed

U#kB1t*LL-c P $timeout = $timestamp-$timeoutseconds;1[ o.r^M:q]f
?>连接mysql
$d7_Jr/fn:{/E mysql_connect('localhost', 'username', 'password');也允许使用变量形式。%Ed/eT,R-c0]
mysql_connect($server, $db_user, $db_pass);如果mysql数据库没有密码的话可以使用下面代码连接pZzT[,G
mysql_connect($server, $db_user);查询数据库的代码：Px7JT0v_0d1`
f
mysql_db_query('database', 'query');我们只要有访客就要增加一条记录。qECuhWNQZ
$insert = mysql_db_query($database, "INSERT INTO useronline VALUES XvN
B:AB,P4Oo
('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");
T'T!u?+{\O J/}*@)o 如果用户用错误信息的话，这样处理。wvz RnNQl*K
if(!($insert)) {8IJknak)z
print "Useronline Insert Failed > ";
};G`#SR/E }然后实现当超过设置的时间就删除该用户记录。
{b#mN{k $delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");同样给出删除记录出错的处理。
V0{-T*gW if(!($delete)) {
)@G+e;YI3_H{x print "Useronline Delete Failed > ";zzUY `,vvS7h
}下面我们解决数据库中不同IP的问题
0HM xW!~.M{ $result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");使用/GZ~e*@;km8b!JT
mysql_num_rows(query);来统计用户，代码如下。~x2Q
V"]NPh,[k
$user = mysql_num_rows($result);最后关闭数据库。h*p,v:}*x!}
mysql_close();显示在线的人数。9o%_(xG)O1KGS!O
if($user == 1) {&C;zfeWmLG!a };N
print("1 user online\n");
uQHW8c~ |
S } else {vd6} La%Q$q
i#EG
print("$user users online\n");2_qHQK1B;K@
}最终把上面代码写成一个PHP文件如下。
;Tz@J$l
D,YM6d <?php/g$qu.CI2PY
//Put your basic server info here
boC,CC2T $server = "localhost"; //normally localhostje3c9Sm N.D4V
$db_user = "root"; //your MySQL database username T'[|~-q4C
$db_pass = "password"; //your MySQL database password:uZCJg
$database = "users";){V+@oh+^}'ph
$timeoutseconds = 300; //it will delete all people which haven't refreshed(so probbably are
+?VOO;B1o d // offline or inactive) in $timieoutseconds time (so it actually checks the people that are active in the last
"T/A Z!hi'~ ^+x // $timeoutseconds seconds)
O8g;l0L-i i //this is where PHP gets the time
N'k5x#ev $timestamp = time();
EtUF1k&M D //counts the timeout, all people which have been seen last online in earlier than this timestamp, will get removed
$D;V;zK k~r} $timeout = $timestamp-$timeoutseconds; hD"O`8tq4m,[ vAi
//connect to database
$y}x'Ms3z mysql_connect($server, $db_user);&R:W8ngF]ME5F'u
//add the timestamp from the user to the online list
9k6t4]Yl0Z&B#s $insert = mysql_db_query($database, "INSERT INTO useronline VALUESu:y0L4W&EBC)\9^
('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");

ogI)g"x1Y if(!($insert)) {
R^B dRc8Ha5|z print "Useronline Insert Failed > ";
'` Xn0|s;y }h;qvFy4u
//delete the peoples which haven't been online/active in the last $timeoutseconds seconds.8~5M]d)?z#K*K
$delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");K*T oN0O Wq!D
if(!($delete)) {
$tc)i_{b(ez print "Useronline Delete Failed > ";
Jx.Fhzk y"? | }
K;SR:YIp$qT.Y //select the amount of people online, all uniques, which are online on THIS page
)Tfv?5i8dV $result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");
ub\4S"p3vto1u if(!($result)) {RzV ?-k V$~#L3I
print "Useronline Select Error > ";T0f"@
Xh7[ [(_
}
F i;kU#@n:I8|E //Count the number of rows = the number of people online a7~0Vc$nDb'[*P
$user = mysql_num_rows($result);,f#J*?wnlPF%Q
//spit out the results C#|C&G\y
mysql_close();n.Q]"`~
if($user == 1) { wFMv/R4i0rB
print("1 user online\n");+\1{8MDu}
} else {4jNK-`#U1@
print("$user users online\n");
z ?Dy6WwlC*~#}R } jTU}-y!H$e H
?>f}?1h8EfuN+X
[url=http://www.now.cn/vhost/][img]http://b.todayisp.com/bbs/760x90h.gif[/img][/url]:Mt-dh#Ts%oA+q
以上代码我是在时代互联提供的免费试用主机上测试的，感觉效果还不错，性能很稳定，不信的话你也可以去试试。当然，记得指出我这个程序中的不足先哦。
i/iHp(m'v%e^ y2g 时代互联是行业内最早开始提供PHP 虚拟主机的公司之一，现在已经是的金牌域名注册商和中国互联网客户满意度十佳单位，产品功能已经非常完善 ，特别提一下几个特有用的功能：数据库自动备份、免费集成繁简通简装版、多域名绑定、多子网站支持、GCDN 网站加速器、镜像加速、高级访问统计系统、支持WAP、可选电信/网通/香港机房。Z!RDt6G3d
我之前建站的时候选的是他们公司标准商务E型，因为这款机型还特别支持ASP.NET3.5(3.0/2.0/1.1)/ASP。
%E.O2hWJ s)T 当然啦，这两款主机也是相当不错的。d^| cdB+i'mE8v
智强商务B型：Unix /Linux 操作系统+独立网页空间1000MB+送1000MB邮局空间+100MB MySQL数据库空间=1869元/年r.f4U~_
标准商务B型：Unix /Linux 操作系统+独立网页空间500MB+送800MB邮局空间+60MB MySQL数据库空间=1365元/年
)RxHK&R S;M 提供一下这个公司的联系方式：请见：[url=http://www.now.cn/vhost/]http://www.now.cn/vhost/[/url]
uFiB*_ 空间专线： 0756-2623871  QQ：168075865，好象还有全球免费网络电话:全球免费咨询电话 [url=http://www.now.cn/callcenter/call.net?LineName=55]http://www.now.cn/callcenter/call.net?LineName=55[/url]
4tj`?&_"mp 自己加QQ去问吧。

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