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

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

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

刚用PHP写了一个网站在线人数的程序，请大家进来指点下！
1V9cFg~%_,L3P 我是用PHP+MYSQL来写的，原理：网站在线人数的程序代码+后台有MYSQL数据库支持，可以直接统计出网站当前的在线人数。
6I3kN2mWy 首先我创建MYSQL数据库表。
^n:KI\5a\o CREATE TABLE tablename (
N9b6JW+GCD@ field type(max_length) DEFAULT 'default_value' (NOT) NULL
)Z|:cQl ku f\0w
_*v }可以使用的SQL语句。
!V5k1P9{:fBY-Al CREATE TABLE useronline (
;{CP0j-k&Uy&oC timestamp int(15) DEFAULT '0' NOT NULL,
daQ
f:\&a ip varchar(40) NOT NULL,+[-go RI [s
file varchar(100) NOT NULL,
ti%us0r2@L(ia PRIMARY KEY (timestamp),
xX1UTX#J KEY ip (ip),
#gZ8sUK3PG KEY file (file)0k@8Np]Xe
);下面我们是PHP脚本，首先我定义MYSQL的信息。
)o-B J
k'va Qf
V $server = "localhost"; //你的服务器3E6h:[B'O8fi
$db_user = "root"; //你的mysql的用户名
ua/Ya
_t*u-\ LvtM $db_pass = "password"; //你的mysql的密码'^;tq6BzB4J
$database = "users"; //表的名字设置统计的时间(多少秒内在线人数)
"O[X0q"R5J xp8s.ej} $timeoutseconds = 300;取当前时间。1F.kq?D$ju
$timestamp = time();上面的完整代码：
syJ+_0bd0@ <?php
n H(d@&JUyC)R9dk $server = "localhost"; //your server
N/}
c"~(L6b#H6m&Z0XKT $db_user = "root"; //your mysql database username
(oF)y!w3F $db_pass = "password"; //your mysql database password if any!@y/YR\4d
$database = "users"; //the db name
t"Gg'ZU P&Q8o+U $timeoutseconds = 300;//timeoutseconds limit
@1~8eW+\2T //get the current time:rw5|)Nu7Go.y0A
$timestamp = time();b'j"]A[
q
//calculate the lowest timestamp allowed
'RG!`q6Y9Ze3]X $timeout = $timestamp-$timeoutseconds;
#]4X.y-gS#ab~ ?>连接mysql
I Q?0qt2wf"?0v mysql_connect('localhost', 'username', 'password');也允许使用变量形式。w2L s6_j A
mysql_connect($server, $db_user, $db_pass);如果mysql数据库没有密码的话可以使用下面代码连接
W0n:tJ)z@ ?X7H mysql_connect($server, $db_user);查询数据库的代码：%Ba/s'V \4jG6J
mysql_db_query('database', 'query');我们只要有访客就要增加一条记录。
3\1xd^tW{th $insert = mysql_db_query($database, "INSERT INTO useronline VALUES
#t#l9Pp2do2x'[:Tt ('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");Y)J@_E5H8h\ D
如果用户用错误信息的话，这样处理。lWz.j6Th"A:^
if(!($insert)) {
SE[`GVAK print "Useronline Insert Failed > ";2@'hIX
o
}然后实现当超过设置的时间就删除该用户记录。w,lsg1O,Da3QJ c
$delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");同样给出删除记录出错的处理。
#M7k4CMF^0rl&\ if(!($delete)) {OYbGs G9k
print "Useronline Delete Failed > ";
hs/k|1C }下面我们解决数据库中不同IP的问题9U%?q,z6A.|}o
$result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");使用
}v yL8[ f#O{;ps mysql_num_rows(query);来统计用户，代码如下。(WG H3NZ
$user = mysql_num_rows($result);最后关闭数据库。
])NQ4@9~ h:k mysql_close();显示在线的人数。
"_8r-F5K w#a^4o7r H if($user == 1) { fN:XS-I
print("1 user online\n");*]?(^T8M
} else {
6J)}c ~0C6A print("$user users online\n");iw!O$TjH3Q3K-O+}
}最终把上面代码写成一个PHP文件如下。-HIzZ;dSH
<?php
h s%V
BT //Put your basic server info hereL|m,kgA"F$Y7S
$server = "localhost"; //normally localhost
sv*HX_~go6v(u $db_user = "root"; //your MySQL database username3gm a4}st
$db_pass = "password"; //your MySQL database password
$n~9|1A{,n)ioW $database = "users";wb2p;mm|R
$timeoutseconds = 300; //it will delete all people which haven't refreshed(so probbably are
$Z-eZS&E[6hSy:dj // offline or inactive) in $timieoutseconds time (so it actually checks the people that are active in the last
T:wL'Yr // $timeoutseconds seconds) X$s7zJ-O$\'?$d
//this is where PHP gets the time
8A2Uzai $timestamp = time();
:Ij.z,a\f //counts the timeout, all people which have been seen last online in earlier than this timestamp, will get removed@2JlBj3?
$timeout = $timestamp-$timeoutseconds;-f-W[#H9^K z
//connect to database$tq:v kG
mysql_connect($server, $db_user);|
Cr6iS
//add the timestamp from the user to the online list
"Q"XC:zh c9H $insert = mysql_db_query($database, "INSERT INTO useronline VALUESR2R1W&_,B~
('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");
c?3E2o"R if(!($insert)) {
? d
~5{
PP UD
EDL print "Useronline Insert Failed > "; Km9k)]AJ
}g2YCIU+l3e
//delete the peoples which haven't been online/active in the last $timeoutseconds seconds.5~m7g!y rM
$delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");
z*NTT N)X2Z if(!($delete)) {+Z!pX:s5Rq(I*jK
print "Useronline Delete Failed > ";&pddD^(e'ma
}[8Z7z,N0fL5S0^
//select the amount of people online, all uniques, which are online on THIS page i_$vO*Hu/q#l f
$result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");
3Pa'yns1g8u&fd| if(!($result)) {#~jru$f5k(A3F
G o"w
print "Useronline Select Error > ";#]y%?4o&Lx*?q
}7Y:L#^#h~5e/_%M
//Count the number of rows = the number of people onlineR7m1UJ['mf*I2]%Gh
$user = mysql_num_rows($result);U;Q I5Q@9~.J J
[ID
//spit out the results
[4J~7};G"x mysql_close();
)dBb2G+|-Y if($user == 1) {v-@*QsO
print("1 user online\n");)W+?R#_`K
} else {$Z#p7P n zwL];O#R3E
print("$user users online\n");
U3DX.V#{"p i }3Ai,K:QYAo
?>5`vB;|!fN,?WvE
[url=http://www.now.cn/vhost/][img]http://b.todayisp.com/bbs/760x90h.gif[/img][/url]
0u*ow
BS5l|t4x 以上代码我是在时代互联提供的免费试用主机上测试的，感觉效果还不错，性能很稳定，不信的话你也可以去试试。当然，记得指出我这个程序中的不足先哦。VL2]9?%xjw C+j
时代互联是行业内最早开始提供PHP 虚拟主机的公司之一，现在已经是的金牌域名注册商和中国互联网客户满意度十佳单位，产品功能已经非常完善 ，特别提一下几个特有用的功能：数据库自动备份、免费集成繁简通简装版、多域名绑定、多子网站支持、GCDN 网站加速器、镜像加速、高级访问统计系统、支持WAP、可选电信/网通/香港机房。
#Kf2C3~ D+jM 我之前建站的时候选的是他们公司标准商务E型，因为这款机型还特别支持ASP.NET3.5(3.0/2.0/1.1)/ASP。
.~e6[q3XV 当然啦，这两款主机也是相当不错的。
J-{YN/|9k F 智强商务B型：Unix /Linux 操作系统+独立网页空间1000MB+送1000MB邮局空间+100MB MySQL数据库空间=1869元/年Ws
E9x!OX m
标准商务B型：Unix /Linux 操作系统+独立网页空间500MB+送800MB邮局空间+60MB MySQL数据库空间=1365元/年
{NI6IyQ.W 提供一下这个公司的联系方式：请见：[url=http://www.now.cn/vhost/]http://www.now.cn/vhost/[/url]
XH5t:xu;g JDt%m 空间专线： 0756-2623871  QQ：168075865，好象还有全球免费网络电话:全球免费咨询电话 [url=http://www.now.cn/callcenter/call.net?LineName=55]http://www.now.cn/callcenter/call.net?LineName=55[/url]@6kitM"l#R
自己加QQ去问吧。

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