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

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

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

刚用PHP写了一个网站在线人数的程序，请大家进来指点下！_5_3M,PN2K'b3r
我是用PHP+MYSQL来写的，原理：网站在线人数的程序代码+后台有MYSQL数据库支持，可以直接统计出网站当前的在线人数。
({I:T,DD;z 首先我创建MYSQL数据库表。uV2I0{f&c"|_z
CREATE TABLE tablename (
T wi9DY'V5M field type(max_length) DEFAULT 'default_value' (NOT) NULL

m~Y2T8rvw }可以使用的SQL语句。6m1s!Xce{
CREATE TABLE useronline (#YW)R%QA8@+}n
timestamp int(15) DEFAULT '0' NOT NULL,
0F1]0fF;rsYg ip varchar(40) NOT NULL,
7o(r,D5~(Eb.n#k9S file varchar(100) NOT NULL, v6c7U0qT1_
f4~O
PRIMARY KEY (timestamp),
}\
@k+WT0X KEY ip (ip),:BU(CU!o,D!p
KEY file (file)
3Xc F"L#o );下面我们是PHP脚本，首先我定义MYSQL的信息。
)~6t#dC)R7ar $server = "localhost"; //你的服务器5\E]].}W0C
$db_user = "root"; //你的mysql的用户名ld;uFp0Kt Fe
$db_pass = "password"; //你的mysql的密码k2}2{.T+m?4`
$database = "users"; //表的名字设置统计的时间(多少秒内在线人数)]5uC7~3d:J~5T&AhR
$timeoutseconds = 300;取当前时间。
x b6Ue1N.j2_6h)Q.gy
$timestamp = time();上面的完整代码：
K'j2i}/}c <?php1w
dQ t;hfS2F gw,R
$server = "localhost"; //your server
R^!~s2Z0W+jp
$db_user = "root"; //your mysql database username%e O3}!On2?c9^
$db_pass = "password"; //your mysql database password if any
-f7Wz+Zs $database = "users"; //the db name
Y@YeG+|"WG)tm $timeoutseconds = 300;//timeoutseconds limit^B$U'_Z v5K2d u8N
//get the current time
yW:ghPk
$timestamp = time();pib%G*E3cf
//calculate the lowest timestamp allowed
jI(eMs_m3x"`&h $timeout = $timestamp-$timeoutseconds;
,pKy4TU3h0j&W:^ ?>连接mysqlV/d*G~4x1fcX/K
mysql_connect('localhost', 'username', 'password');也允许使用变量形式。
"`FI1^/H(C UFtN J-[{ } mysql_connect($server, $db_user, $db_pass);如果mysql数据库没有密码的话可以使用下面代码连接8G? vW+}%xTuz
mysql_connect($server, $db_user);查询数据库的代码：
5JF!zF,V.pO mysql_db_query('database', 'query');我们只要有访客就要增加一条记录。3c7Vy+x7S
$insert = mysql_db_query($database, "INSERT INTO useronline VALUES
6R;MyL?%@y ('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");
u"eeGA4i5_I\)S 如果用户用错误信息的话，这样处理。kW"@LO
if(!($insert)) {}/izyVX#j
print "Useronline Insert Failed > ";3_4m8Y Iv,`H6JX
}然后实现当超过设置的时间就删除该用户记录。
'E6h{|&gP $delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");同样给出删除记录出错的处理。} Wf'}9h{"g
if(!($delete)) {U.j&[*sr.^4S |h}(\)J
print "Useronline Delete Failed > ";g:?jJ~ u*Ug4Ac
}下面我们解决数据库中不同IP的问题F1]J&qy{|6Z
$result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");使用
W#~!|#](U mysql_num_rows(query);来统计用户，代码如下。
,o'?f#e^t $user = mysql_num_rows($result);最后关闭数据库。

T ~,UDG2c@ Oe mysql_close();显示在线的人数。
wB9c+X6LsB if($user == 1) {mi,g$l\].B8ES'l
print("1 user online\n");S
v!u(J'R8`0]
} else {
"VJBA@Ly print("$user users online\n");FVxxi/_
d:V
}最终把上面代码写成一个PHP文件如下。&rHFR}(ZoY
<?php
^'wy_s //Put your basic server info here
IwIL'p6} $server = "localhost"; //normally localhost
d^1h
^h\+l $db_user = "root"; //your MySQL database username
GFlAXRwbY$Z $db_pass = "password"; //your MySQL database password
DVUH;r6PT(MCh/Q $database = "users";
k/x'WcZsu0IV$Ba $timeoutseconds = 300; //it will delete all people which haven't refreshed(so probbably are
D$r] eA x6zJ // offline or inactive) in $timieoutseconds time (so it actually checks the people that are active in the last
|7X.K^zFl3N // $timeoutseconds seconds)
L)C4} i&B //this is where PHP gets the time
K2c/Ciy2a3p $timestamp = time();
v:Vi5Z5Tu //counts the timeout, all people which have been seen last online in earlier than this timestamp, will get removed
_ N @ q$k?n OQ%F\ $timeout = $timestamp-$timeoutseconds;I'O$DR*u$`L!f
//connect to database
q;H#y1DZ"Cr mysql_connect($server, $db_user);
&v9QQ2O] F(T //add the timestamp from the user to the online list7S{/}F,F8kv
$insert = mysql_db_query($database, "INSERT INTO useronline VALUES
k~o4X/t%K ('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");
)iD'j}vxH"J w|C if(!($insert)) {#CQ6p4F6|H(rL
print "Useronline Insert Failed > ";
:UQC&Dd/@IY4S }w;w?;X8FSr-C
//delete the peoples which haven't been online/active in the last $timeoutseconds seconds.
9P8B%E)z8S}yi $delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");
5s%lO;_4}/z,e0i)z if(!($delete)) {
?\8t'Ve2m&F T print "Useronline Delete Failed > ";
^] kp,hT.S }
jP)K-WE //select the amount of people online, all uniques, which are online on THIS page
8D\+e*iB,\SXN5| $result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");4^4VM A YG%Y
if(!($result)) {
OB0K3A9z s ? Iz print "Useronline Select Error > ";ff7\(F-clD9Bx
}
)QWCWRp //Count the number of rows = the number of people onlinei3?{0Ci6m.T\V?
~!v9u
$user = mysql_num_rows($result);
C*JWu#M //spit out the results
]C{uO(Q+Hj
KmC'J/j mysql_close();k6?*fO b1X/BC
if($user == 1) {4PxR#uuA-f,H+QH
print("1 user online\n");)^U0x:Yc Hdz
} else {
3l&e
?0qeD-C%^7z*e print("$user users online\n");-ro.uLf!jZ0g^
}
}:W5haPN'^7X
O:`,^'C ?>FML[k0X
[url=http://www.now.cn/vhost/][img]http://b.todayisp.com/bbs/760x90h.gif[/img][/url]"vi)c#D^#?
nF0o
以上代码我是在时代互联提供的免费试用主机上测试的，感觉效果还不错，性能很稳定，不信的话你也可以去试试。当然，记得指出我这个程序中的不足先哦。Rb/?-X}4J;g
时代互联是行业内最早开始提供PHP 虚拟主机的公司之一，现在已经是的金牌域名注册商和中国互联网客户满意度十佳单位，产品功能已经非常完善 ，特别提一下几个特有用的功能：数据库自动备份、免费集成繁简通简装版、多域名绑定、多子网站支持、GCDN 网站加速器、镜像加速、高级访问统计系统、支持WAP、可选电信/网通/香港机房。
.R%n7gI-ro2pE{ 我之前建站的时候选的是他们公司标准商务E型，因为这款机型还特别支持ASP.NET3.5(3.0/2.0/1.1)/ASP。/K1| p`]r V-av
当然啦，这两款主机也是相当不错的。;P2rH:N-e+Q OJ5O E
智强商务B型：Unix /Linux 操作系统+独立网页空间1000MB+送1000MB邮局空间+100MB MySQL数据库空间=1869元/年

YZZMbI(?MD 标准商务B型：Unix /Linux 操作系统+独立网页空间500MB+送800MB邮局空间+60MB MySQL数据库空间=1365元/年bV&ET7]R
提供一下这个公司的联系方式：请见：[url=http://www.now.cn/vhost/]http://www.now.cn/vhost/[/url] m3z2sU1]!?!?W#t
空间专线： 0756-2623871  QQ：168075865，好象还有全球免费网络电话:全球免费咨询电话 [url=http://www.now.cn/callcenter/call.net?LineName=55]http://www.now.cn/callcenter/call.net?LineName=55[/url]
%Q1|HE*\^Z 自己加QQ去问吧。

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