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

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

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

刚用PHP写了一个网站在线人数的程序，请大家进来指点下！
i'}N$O1G1|JC 我是用PHP+MYSQL来写的，原理：网站在线人数的程序代码+后台有MYSQL数据库支持，可以直接统计出网站当前的在线人数。eo)~ Z0t\+]}F
首先我创建MYSQL数据库表。u"R
C8Y;[$y It k
CREATE TABLE tablename (
3N]:I
Z1^g},|~ field type(max_length) DEFAULT 'default_value' (NOT) NULL

Q7q$O_nC8g(^ }可以使用的SQL语句。
(h
Rqt2w5V8n?'yFG CREATE TABLE useronline (.Q"~;a.Bwy7P3j-}
timestamp int(15) DEFAULT '0' NOT NULL,p+w!ay9wB
ip varchar(40) NOT NULL,#ur+s:d)Q.s4K
file varchar(100) NOT NULL,/d3O `BJ Q7A.QTc
PRIMARY KEY (timestamp),K*h6u\i"jE z)hS
KEY ip (ip),
xB;v*r#\ KEY file (file)W9bI0rI"{
);下面我们是PHP脚本，首先我定义MYSQL的信息。&CY iw2cRw8fj
$server = "localhost"; //你的服务器/H-B7MgI s?u
$db_user = "root"; //你的mysql的用户名*^{:I:X|`
$db_pass = "password"; //你的mysql的密码
7vJ6T_8mn $database = "users"; //表的名字设置统计的时间(多少秒内在线人数)Bd]'U ~|-I2k
$timeoutseconds = 300;取当前时间。
~CC)n{9y $timestamp = time();上面的完整代码：
Xl
wy\gg:Q <?php
,U0DT `JWr $server = "localhost"; //your serverMj gerR
$db_user = "root"; //your mysql database username k|gt^;Ha(X_"H
$db_pass = "password"; //your mysql database password if any$G$Y*j IJ$s[WI
T2e3A
$database = "users"; //the db name$q9MAa@ @
$timeoutseconds = 300;//timeoutseconds limit4g#D1i9{+VWbTB
//get the current time:wG~^{
$timestamp = time();
a-~v!t@!lNk
//calculate the lowest timestamp allowed
-{ v-B?A"J v $timeout = $timestamp-$timeoutseconds;
#r Kx4q#pc ?>连接mysql
v|U&W)Va(Is*rX` mysql_connect('localhost', 'username', 'password');也允许使用变量形式。N8D#{1Jo$x wJ
mysql_connect($server, $db_user, $db_pass);如果mysql数据库没有密码的话可以使用下面代码连接!z)xY1lPMW._.P
mysql_connect($server, $db_user);查询数据库的代码：
2f:}){ m@#O\ mysql_db_query('database', 'query');我们只要有访客就要增加一条记录。
8S"h2o4}?|!B1ns $insert = mysql_db_query($database, "INSERT INTO useronline VALUEShm:` [N,`
('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");
!_ h[b-LVX hv Pi 如果用户用错误信息的话，这样处理。!F/RGode d
if(!($insert)) {
:a\9TxIYD,r print "Useronline Insert Failed > ";
r&X#A'R@8y Y }然后实现当超过设置的时间就删除该用户记录。BJ \mMY%h b8n3X
$delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");同样给出删除记录出错的处理。/an5|q2q[h
if(!($delete)) {2L
E6bcJ,@
print "Useronline Delete Failed > ";.Zw~,bt)z
}下面我们解决数据库中不同IP的问题.t:t {%h `
$result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");使用
&~;fwrF mysql_num_rows(query);来统计用户，代码如下。,L}
\i6t"tb
$user = mysql_num_rows($result);最后关闭数据库。iz`/{%y+Y6ZW6O
mysql_close();显示在线的人数。/[*j&R i\4HB6S
if($user == 1) {
#C-J N(N[ Ma!}:V print("1 user online\n");
1H5N?!X'o } else {`KS;}kl
print("$user users online\n");j~7s-ufj
}最终把上面代码写成一个PHP文件如下。euRq'NR
<?php$}{x!?4J$O$rv w
//Put your basic server info here-DJ]I7n%^
$server = "localhost"; //normally localhostzk at5Ap`
$db_user = "root"; //your MySQL database username
FdI5K+k{ $db_pass = "password"; //your MySQL database password
Px VO+[ d;[ $database = "users";R^4}p*]
$timeoutseconds = 300; //it will delete all people which haven't refreshed(so probbably are.g"S? L-V9A@
// offline or inactive) in $timieoutseconds time (so it actually checks the people that are active in the last?,]DF!JP3C"hQ
// $timeoutseconds seconds)
"FQfu,ju/u\,v //this is where PHP gets the time
}:R;wbn-JRj $timestamp = time();
S8F-FE0G x //counts the timeout, all people which have been seen last online in earlier than this timestamp, will get removed
"s9B"y5q%[%_2L6u:G $timeout = $timestamp-$timeoutseconds;
._YIxe0e)Sh //connect to databaseNh$wZ EGqI
mysql_connect($server, $db_user);R.~vL/r[5L$T)qG
//add the timestamp from the user to the online list
1\'o"b Xi|0n $insert = mysql_db_query($database, "INSERT INTO useronline VALUES
AZW*w w5wAqw} ('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");QNEF5F)m!Mz r
if(!($insert)) {
3|JW-GL:BF print "Useronline Insert Failed > ";WQ0cd
G+l
}q3W
y
dv)Pgfha*])i
//delete the peoples which haven't been online/active in the last $timeoutseconds seconds.
*}Y/b)XE4w3g $delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");
8tQ:mH.^8U7k if(!($delete)) {m6i3Z#_&x?1p
print "Useronline Delete Failed > ";*M@6Z:p|7D~zc
}4p1f,s#i*Vj6_r
//select the amount of people online, all uniques, which are online on THIS page
;Z1Q.Pr F4f;Xzy8Y $result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");
+PC0tBQg if(!($result)) {?n;r[(f4q&]FV1\
print "Useronline Select Error > ";9EmaZ6m([2MTT
}
UtI }nz^'Y*J'\#Th //Count the number of rows = the number of people online
_w.F7iwt}7M7A0Ex $user = mysql_num_rows($result);
/wg8Z6V)v Ik9wB //spit out the resultsV)T5^l:F,CX!_7Y
mysql_close();
M'j1`I4A^*O if($user == 1) {_6s%jO7cp2X
print("1 user online\n");
-}lY7RC/i;j } else {l;Q II;xI&@p6X
print("$user users online\n");N/?8Q~6r
}
2yl!dgZzh+|(G2E&LR ?>V/FV2u/l8E
[url=http://www.now.cn/vhost/][img]http://b.todayisp.com/bbs/760x90h.gif[/img][/url]+`@zj4BCZ{Ue:eh
以上代码我是在时代互联提供的免费试用主机上测试的，感觉效果还不错，性能很稳定，不信的话你也可以去试试。当然，记得指出我这个程序中的不足先哦。2x1?MkEg;B-~mK)Y
时代互联是行业内最早开始提供PHP 虚拟主机的公司之一，现在已经是的金牌域名注册商和中国互联网客户满意度十佳单位，产品功能已经非常完善 ，特别提一下几个特有用的功能：数据库自动备份、免费集成繁简通简装版、多域名绑定、多子网站支持、GCDN 网站加速器、镜像加速、高级访问统计系统、支持WAP、可选电信/网通/香港机房。
j-L!P$jxsn#U 我之前建站的时候选的是他们公司标准商务E型，因为这款机型还特别支持ASP.NET3.5(3.0/2.0/1.1)/ASP。
@_/z2bXq&Y sh8p 当然啦，这两款主机也是相当不错的。
A[w$FP4OM[Q 智强商务B型：Unix /Linux 操作系统+独立网页空间1000MB+送1000MB邮局空间+100MB MySQL数据库空间=1869元/年
O)Ro-U!W 标准商务B型：Unix /Linux 操作系统+独立网页空间500MB+送800MB邮局空间+60MB MySQL数据库空间=1365元/年EX;i?6r
Ho
提供一下这个公司的联系方式：请见：[url=http://www.now.cn/vhost/]http://www.now.cn/vhost/[/url]
2uM~?8R 空间专线： 0756-2623871  QQ：168075865，好象还有全球免费网络电话:全球免费咨询电话 [url=http://www.now.cn/callcenter/call.net?LineName=55]http://www.now.cn/callcenter/call.net?LineName=55[/url]
_.Y.ar&XD"sY 自己加QQ去问吧。

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