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

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

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

刚用PHP写了一个网站在线人数的程序，请大家进来指点下！
,^r8z
q(} G;x/Zo'T(i#s 我是用PHP+MYSQL来写的，原理：网站在线人数的程序代码+后台有MYSQL数据库支持，可以直接统计出网站当前的在线人数。
TGLtH^{c.Nq 首先我创建MYSQL数据库表。
k8H.z/mb)giH CREATE TABLE tablename (R0]jm4NuY Q
field type(max_length) DEFAULT 'default_value' (NOT) NULL@do2P0b#P%Q2L
I
}可以使用的SQL语句。7A'?~y y7d
CREATE TABLE useronline (
tv ILKB2K,Yd d timestamp int(15) DEFAULT '0' NOT NULL,t8j]5Kw+k6b
ip varchar(40) NOT NULL,
;Qs^D\"mB1f}P file varchar(100) NOT NULL,
D{5?+p#P[3auQ PRIMARY KEY (timestamp),
8RIS/j+y:b@;XaN KEY ip (ip),d+iqL[4t
KEY file (file)M c\;WBIu
);下面我们是PHP脚本，首先我定义MYSQL的信息。4My3QL[-R
$server = "localhost"; //你的服务器
|v`3D\0k $db_user = "root"; //你的mysql的用户名
d3H%N.Kf $db_pass = "password"; //你的mysql的密码
9a9E/\$i*H!E)QM $database = "users"; //表的名字设置统计的时间(多少秒内在线人数)-Bh*_
\$\Vl#t
$timeoutseconds = 300;取当前时间。h wz&fGSi5o
$timestamp = time();上面的完整代码：
@#Hr?,J^;Y
<?php'i'MJ,P@:^9y#I0K y;G
$server = "localhost"; //your server
#n+c-C%v Wri9z $db_user = "root"; //your mysql database username
W3m.TaC0h J $db_pass = "password"; //your mysql database password if any
ycg!yz&@;rF9Y $database = "users"; //the db name
7[ribd+A@-|KNMr@ $timeoutseconds = 300;//timeoutseconds limitN|;~ ASKtM
//get the current time
(`pB(P(M7X _6lhO $timestamp = time();!x%NAU8y0eL
//calculate the lowest timestamp allowed
0S`*[7_!S|!N $timeout = $timestamp-$timeoutseconds;
J4Yx+o IG'H8P\iL ?>连接mysqljx'DF6~
mysql_connect('localhost', 'username', 'password');也允许使用变量形式。2oi_ML7Yan
mysql_connect($server, $db_user, $db_pass);如果mysql数据库没有密码的话可以使用下面代码连接
0l kI&v^)eB mysql_connect($server, $db_user);查询数据库的代码：
y6EJ1QiSp mysql_db_query('database', 'query');我们只要有访客就要增加一条记录。
i6o4e$Uf $insert = mysql_db_query($database, "INSERT INTO useronline VALUES
M_q!s5zM'e n/@)z ('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");'{Fz|z6kw'o)G
如果用户用错误信息的话，这样处理。
.a^#d,iIpk#GW if(!($insert)) {
Ws\\.OR?$Ux print "Useronline Insert Failed > ";u5{]u rO@
}然后实现当超过设置的时间就删除该用户记录。%Az L g5]uF
$delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");同样给出删除记录出错的处理。
e IzL.Od2] if(!($delete)) {
k!~/_&mEc+o print "Useronline Delete Failed > ";S\A
bE?v!n
}下面我们解决数据库中不同IP的问题
G;d8wl6G_/Y $result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");使用
1Equo:o,u6b3w
A mysql_num_rows(query);来统计用户，代码如下。L A{l5EXTl!@ ` ]
$user = mysql_num_rows($result);最后关闭数据库。E'Ih#M:VHOaD
mysql_close();显示在线的人数。
-vG n)^%g,`d nl2] if($user == 1) {
"d6A3g ST7f0b u!p6vU print("1 user online\n");u+T*~7Z-H@
} else {9yb1QO1kLZ5H}
print("$user users online\n");V xE
sC9H
}最终把上面代码写成一个PHP文件如下。
DJi/H3iO%dvma <?php'rH[k)hHq
//Put your basic server info here1Bo^1g.j@e
$server = "localhost"; //normally localhost
Xh1k$^;p-GJ)b9~ $db_user = "root"; //your MySQL database username
M.T}+K bW $db_pass = "password"; //your MySQL database passwordZS"vy `3k
$database = "users";_ i
VF3f i8U
$timeoutseconds = 300; //it will delete all people which haven't refreshed(so probbably are
1eF@4XL ldU // offline or inactive) in $timieoutseconds time (so it actually checks the people that are active in the last
u\w
o2V I\4Y // $timeoutseconds seconds)
%Op;Xm:x8v6OU //this is where PHP gets the timeAu rj;X\5U
$timestamp = time();
Y_:L_+m:W5Mv //counts the timeout, all people which have been seen last online in earlier than this timestamp, will get removed
L^!S5l F5H'u $timeout = $timestamp-$timeoutseconds;
r ~bl"e8B9{ //connect to databaseL4} Q |,__%D`!bD~
mysql_connect($server, $db_user);jj3u3s&Hy_
//add the timestamp from the user to the online list?5uHy@V
$insert = mysql_db_query($database, "INSERT INTO useronline VALUES
w to$P'C/{"E ('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");q1n*U%T$I@'}
if(!($insert)) {
5?m%B!LGBO print "Useronline Insert Failed > ";
P!w9obM%`L'I }
'oe6h(ny //delete the peoples which haven't been online/active in the last $timeoutseconds seconds.XI
X1f2Au"d
$delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");1cN]A&Jy&G
if(!($delete)) {`5JvZ)Oi \bp
print "Useronline Delete Failed > ";
`7q!A@$H }
IZ[ M
b //select the amount of people online, all uniques, which are online on THIS page
#NwS,L,S]+|7T*B $result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");
s5~2a
K;EZQ*A if(!($result)) {"L7P.H+UGc g
print "Useronline Select Error > ";6j8A\ h qL@
}
d!{hi+K;t*aq:i?{M g //Count the number of rows = the number of people onlinetm8ZV'z| N)vMG
$user = mysql_num_rows($result);`/NJJQ `6l\N
//spit out the results0y)T2s8RV~#T
mysql_close();1A4oH8@,n
if($user == 1) {
yL/vel;n`8R+W print("1 user online\n");'iF!djY~
} else {2y ajS`+Q
print("$user users online\n");
;}s2Q(cp"l$_8]?je }sM| [9Dhg~
?>.G-V8j{2UOfL*\(]"D
[url=http://www.now.cn/vhost/][img]http://b.todayisp.com/bbs/760x90h.gif[/img][/url]
+C#I,C&S&aiI'op 以上代码我是在时代互联提供的免费试用主机上测试的，感觉效果还不错，性能很稳定，不信的话你也可以去试试。当然，记得指出我这个程序中的不足先哦。
3WGd|E-Y"B 时代互联是行业内最早开始提供PHP 虚拟主机的公司之一，现在已经是的金牌域名注册商和中国互联网客户满意度十佳单位，产品功能已经非常完善 ，特别提一下几个特有用的功能：数据库自动备份、免费集成繁简通简装版、多域名绑定、多子网站支持、GCDN 网站加速器、镜像加速、高级访问统计系统、支持WAP、可选电信/网通/香港机房。
uC0`pie'C 我之前建站的时候选的是他们公司标准商务E型，因为这款机型还特别支持ASP.NET3.5(3.0/2.0/1.1)/ASP。
\z0[9cj)K t{ 当然啦，这两款主机也是相当不错的。
p C7v2D.NWD/d2D 智强商务B型：Unix /Linux 操作系统+独立网页空间1000MB+送1000MB邮局空间+100MB MySQL数据库空间=1869元/年
K)o*y!F U`x$m,R/e 标准商务B型：Unix /Linux 操作系统+独立网页空间500MB+送800MB邮局空间+60MB MySQL数据库空间=1365元/年
1m?a{aoB 提供一下这个公司的联系方式：请见：[url=http://www.now.cn/vhost/]http://www.now.cn/vhost/[/url] r!q"@ j#L(Pa'h0i
空间专线： 0756-2623871  QQ：168075865，好象还有全球免费网络电话:全球免费咨询电话 [url=http://www.now.cn/callcenter/call.net?LineName=55]http://www.now.cn/callcenter/call.net?LineName=55[/url]!M`kvj?.F
自己加QQ去问吧。

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