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

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

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

刚用PHP写了一个网站在线人数的程序，请大家进来指点下！
ZCZjt8EQC 我是用PHP+MYSQL来写的，原理：网站在线人数的程序代码+后台有MYSQL数据库支持，可以直接统计出网站当前的在线人数。
8zzJ \.D*Q 首先我创建MYSQL数据库表。
X*dX!`^7e CREATE TABLE tablename (
UkvX1F"?_ field type(max_length) DEFAULT 'default_value' (NOT) NULL t-m[EY$t&D
}可以使用的SQL语句。W.L${},O/Fs
CREATE TABLE useronline (4G)h6T%a }3q
timestamp int(15) DEFAULT '0' NOT NULL,
3E {3? uOn i#Fu.y"dP ip varchar(40) NOT NULL,_@)m%['[7vU
file varchar(100) NOT NULL,GhR^ S
PRIMARY KEY (timestamp),
Q ^;^2R,`^ KEY ip (ip),{/]"Lz)Rq-v1b
KEY file (file)
m/t(E Al8~YH );下面我们是PHP脚本，首先我定义MYSQL的信息。H9^b(i x%{N!^ S
$server = "localhost"; //你的服务器JB^0@XO6s
$db_user = "root"; //你的mysql的用户名
+Q Yt|d/g $db_pass = "password"; //你的mysql的密码g6Vx%l2Q1d:L+o VWBi
$database = "users"; //表的名字设置统计的时间(多少秒内在线人数)
;Im{#XX,[;h#L/O $timeoutseconds = 300;取当前时间。&P-r[+G/c9T4M$CX
$timestamp = time();上面的完整代码：
8D$S }toRJ <?php
QLUt/z
z $server = "localhost"; //your server+h.b!_TIb;i}"a
$db_user = "root"; //your mysql database usernamec'?+I`,[v
$db_pass = "password"; //your mysql database password if any0g+Cg.f;~7_b'ft7\C
$database = "users"; //the db name
,p,W$L)L4v $timeoutseconds = 300;//timeoutseconds limit
e$u n"DL{py //get the current timeZ;|Fos
R
$timestamp = time();yg8Cpw4] LO
//calculate the lowest timestamp allowed
#IW"nuB7E)_ $timeout = $timestamp-$timeoutseconds;-|I,J)_5N*XLX
?>连接mysqljK(@1I0~R)BK%`
mysql_connect('localhost', 'username', 'password');也允许使用变量形式。${~9L#?D}{jW
mysql_connect($server, $db_user, $db_pass);如果mysql数据库没有密码的话可以使用下面代码连接9r ~tC(k@1Tx'~
mysql_connect($server, $db_user);查询数据库的代码：&vff7{d5l$B2K
mysql_db_query('database', 'query');我们只要有访客就要增加一条记录。DD?._D{K!f
$insert = mysql_db_query($database, "INSERT INTO useronline VALUES;q/a
|m1WP8WCu\E
('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");"cw6\'i#IScC|
如果用户用错误信息的话，这样处理。
"Tc#W4_
]X:n*p@ if(!($insert)) {
(ZcW_(zIfq8d print "Useronline Insert Failed > ";
!V [|c{ } }然后实现当超过设置的时间就删除该用户记录。
(eWd.E]fw;H $delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");同样给出删除记录出错的处理。
?eR,q*J b/m)E'oj$Z if(!($delete)) {)}'UE-o p,bb
print "Useronline Delete Failed > ";O6K7Itp*O*n/{9_ }2F
}下面我们解决数据库中不同IP的问题
#?'Z0u#{:`j:O&D $result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");使用
+QqPwq%~L6MT mysql_num_rows(query);来统计用户，代码如下。f)['KGz@d:\
$user = mysql_num_rows($result);最后关闭数据库。
LT
e1rAYxB
x mysql_close();显示在线的人数。A7c/sM}n
if($user == 1) {

J6Ex9`~d/tc print("1 user online\n");'ekHfR\
IXP
} else {4hZT Lb6[
print("$user users online\n");
qb5v9SBm }最终把上面代码写成一个PHP文件如下。
Vb} J(d <?php
,]8D3tG*mp Q;M@ //Put your basic server info here
]
H/vAJ&K4Y3p9XxY $server = "localhost"; //normally localhostxWR8e)vp,J
$db_user = "root"; //your MySQL database usernameu
P"]!]U3eh)i
$db_pass = "password"; //your MySQL database password
,N"Y:j7s9bW0`x*f $database = "users";a-q#x1Q^:p6^M3s!]}
$timeoutseconds = 300; //it will delete all people which haven't refreshed(so probbably are
7ab.t8P;T+uz} // offline or inactive) in $timieoutseconds time (so it actually checks the people that are active in the last `R0guP_/k
// $timeoutseconds seconds)
v;[$EDY*RP)ih //this is where PHP gets the time
GSeX[^ R3N $timestamp = time();RxB%?f5C^Yw+z
//counts the timeout, all people which have been seen last online in earlier than this timestamp, will get removed
'U9oc&D R.t8^D $timeout = $timestamp-$timeoutseconds;
8uF[7o,B
z //connect to databasejIy/[JG\(gk
mysql_connect($server, $db_user);-| k0|"b(I QI]
//add the timestamp from the user to the online listr0| U5d4cwtX4X
$insert = mysql_db_query($database, "INSERT INTO useronline VALUES
QjPiq%S
QF$C g ('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");
iy@ qPt-} if(!($insert)) {
tMP$B[DA.s print "Useronline Insert Failed > ";
3d!JN7J{C:x }g6D7clX"rbQ
//delete the peoples which haven't been online/active in the last $timeoutseconds seconds.7\2t/xJf
$delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");
"~)p_tb-lE+o if(!($delete)) { E6R)jMM x hw
print "Useronline Delete Failed > ";
`i-o:u#J_^3p(W*Wj }
e:DCq2Vn //select the amount of people online, all uniques, which are online on THIS page
3uc+\)t)HF${_3KSb $result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");e7tI-}h{9lE
if(!($result)) {
8b'o(gB J print "Useronline Select Error > ";LJ"V'P(z_#aQ
}
&C}'t~6jLU //Count the number of rows = the number of people online
,qC%BemYN $user = mysql_num_rows($result);
i-c4ihl{)k7@ //spit out the results
irjmV%T%Sz'o mysql_close();
SP/k2l5X*H if($user == 1) {
"A[B+j~h)|qC print("1 user online\n");]:|+MZ]1Y#])N
} else {.SP#S?!k$iU#P)b
print("$user users online\n");wfR&zYP x
}
.u1ua_!q8jg GO ?>
l9CB
d
{:} [url=http://www.now.cn/vhost/][img]http://b.todayisp.com/bbs/760x90h.gif[/img][/url])w#[s;Ezx
以上代码我是在时代互联提供的免费试用主机上测试的，感觉效果还不错，性能很稳定，不信的话你也可以去试试。当然，记得指出我这个程序中的不足先哦。8U.Diqs7W^,]l
时代互联是行业内最早开始提供PHP 虚拟主机的公司之一，现在已经是的金牌域名注册商和中国互联网客户满意度十佳单位，产品功能已经非常完善 ，特别提一下几个特有用的功能：数据库自动备份、免费集成繁简通简装版、多域名绑定、多子网站支持、GCDN 网站加速器、镜像加速、高级访问统计系统、支持WAP、可选电信/网通/香港机房。aL'b{;y:V._7MB/y
我之前建站的时候选的是他们公司标准商务E型，因为这款机型还特别支持ASP.NET3.5(3.0/2.0/1.1)/ASP。
JA N{'y]2r*~l 当然啦，这两款主机也是相当不错的。r9e7CA`~+F3CR
智强商务B型：Unix /Linux 操作系统+独立网页空间1000MB+送1000MB邮局空间+100MB MySQL数据库空间=1869元/年
xuro4c\T4x:u 标准商务B型：Unix /Linux 操作系统+独立网页空间500MB+送800MB邮局空间+60MB MySQL数据库空间=1365元/年 la*yBU2pL
提供一下这个公司的联系方式：请见：[url=http://www.now.cn/vhost/]http://www.now.cn/vhost/[/url]
:NB0C5aA 空间专线： 0756-2623871  QQ：168075865，好象还有全球免费网络电话:全球免费咨询电话 [url=http://www.now.cn/callcenter/call.net?LineName=55]http://www.now.cn/callcenter/call.net?LineName=55[/url]
7e|,N"A-~+T 自己加QQ去问吧。

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