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

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

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

刚用PHP写了一个网站在线人数的程序，请大家进来指点下！? Lg%p A}
我是用PHP+MYSQL来写的，原理：网站在线人数的程序代码+后台有MYSQL数据库支持，可以直接统计出网站当前的在线人数。OE\0nf0G r
首先我创建MYSQL数据库表。3?4g&|uJD
q(d
CREATE TABLE tablename (5E8Ho6vG
field type(max_length) DEFAULT 'default_value' (NOT) NULLs8s#U;O M
H
z
}可以使用的SQL语句。
-Ftq;W9[LTv CREATE TABLE useronline (
t$B{:yB k!U timestamp int(15) DEFAULT '0' NOT NULL,RN q
ML2~/?
ip varchar(40) NOT NULL,&j$kN#tuZ,w
file varchar(100) NOT NULL,Gz+|3] J
PRIMARY KEY (timestamp),E0g/C$A t#Fic
KEY ip (ip),
cTb2? b KEY file (file)$\&Sj!X*Gd6yc
);下面我们是PHP脚本，首先我定义MYSQL的信息。Z7}2Jt0_6{QIA-z
$server = "localhost"; //你的服务器
(u~ec^P $db_user = "root"; //你的mysql的用户名"A5e@1`)_^|5t2Bo
$db_pass = "password"; //你的mysql的密码VZ)J,R \/w
s#^
$database = "users"; //表的名字设置统计的时间(多少秒内在线人数)sf"xU0XN"t
$timeoutseconds = 300;取当前时间。:VLU:w
fD.PaB
$timestamp = time();上面的完整代码：
9DZC%nuA%d <?phpu mt+g!]2jX B
$server = "localhost"; //your server5AmH7^7\N-i#wG]F;d
$db_user = "root"; //your mysql database username
\3rvK'hl,VfU#m $db_pass = "password"; //your mysql database password if anyK+p'b
b3v
$database = "users"; //the db nameLZ6m%`7Y5}~'ABD&K
$timeoutseconds = 300;//timeoutseconds limit
eTF+g_ xo^9\ //get the current time ^p`8q|%|J/QbI
$timestamp = time();
a JX2qa*[-Mr //calculate the lowest timestamp allowed
Q_+u$a,L2a(m2~h $timeout = $timestamp-$timeoutseconds;
Bl&f X"{6x0bO'I9b ?>连接mysql%D&w'J]_;ah ]
mysql_connect('localhost', 'username', 'password');也允许使用变量形式。
!Q&fZa6a;S mysql_connect($server, $db_user, $db_pass);如果mysql数据库没有密码的话可以使用下面代码连接
^t YD9p} mysql_connect($server, $db_user);查询数据库的代码：'[w,v_\#C m DO
mysql_db_query('database', 'query');我们只要有访客就要增加一条记录。G1o&H{UNt
$insert = mysql_db_query($database, "INSERT INTO useronline VALUES%k/G q5Dg'l;Q4F PJ
('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");~syg8T(]s$m
如果用户用错误信息的话，这样处理。 ] @-X7c?(^
if(!($insert)) {
b#L/W8i/g!kP1W print "Useronline Insert Failed > ";j.` `8w6H
}然后实现当超过设置的时间就删除该用户记录。zA;e6]-Z S
$delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");同样给出删除记录出错的处理。{+i8N0c;}I&n
if(!($delete)) {~3x!xa)t~Ik
print "Useronline Delete Failed > ";
)A}kLX4j }下面我们解决数据库中不同IP的问题
Uua9e"Gcd2U(d5P $result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");使用3xE6JIm
mysql_num_rows(query);来统计用户，代码如下。"m,\+[s;Xb4J
s B{i
$user = mysql_num_rows($result);最后关闭数据库。
2P hMY}8y+h} mysql_close();显示在线的人数。
O0B0S,OG.d7B if($user == 1) {+r%])G:_O
print("1 user online\n");
9xi/m5}Bw6^ } else {
-?"c&[4lk print("$user users online\n");
6y/X.]l? }最终把上面代码写成一个PHP文件如下。
V#\k(Sls0v <?php
Bz+f*ID7~h //Put your basic server info here3|gd/}3v4{/M+L
$server = "localhost"; //normally localhosta%t9{@3S%c;i {.z\T
$db_user = "root"; //your MySQL database usernameUm2c.i!{4m~)o
$db_pass = "password"; //your MySQL database password
_PF\v TA:E $database = "users";
mFb6oUA4L6C $timeoutseconds = 300; //it will delete all people which haven't refreshed(so probbably are"@`;S [ ^
// offline or inactive) in $timieoutseconds time (so it actually checks the people that are active in the last*i'd|XA1Q(t-z
// $timeoutseconds seconds)
:It\.aB#^hY^$F&\ //this is where PHP gets the timek!},Ch1t#ie_
$timestamp = time();@
l ]bACr
//counts the timeout, all people which have been seen last online in earlier than this timestamp, will get removedd9J?-BA V:?
$timeout = $timestamp-$timeoutseconds;%g'?m5J*iX
//connect to database
H'@Aq&?q mysql_connect($server, $db_user);
E1o)i.Q/b[s({ Z //add the timestamp from the user to the online list
JB
S"g?3|A9u(y4^ $insert = mysql_db_query($database, "INSERT INTO useronline VALUES
K#|&_
Wg+Ewq4a ('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')"); J3IvN5X%\
if(!($insert)) {\$z'z'OPAl
print "Useronline Insert Failed > ";L+Q6e3j.R
}
?#Y#y#?O FQ //delete the peoples which haven't been online/active in the last $timeoutseconds seconds.
$_E;c B,];SC $delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout"); e7jG/e"z
if(!($delete)) {
%S!HzJ.^p print "Useronline Delete Failed > ";z6W-m9?YW-H
}\^f w}!J
//select the amount of people online, all uniques, which are online on THIS page
3i&MM_.U4L
o!p $result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");
M"ER&s+I if(!($result)) {
u2OV {2Xy
print "Useronline Select Error > ";
+pr3cqAMm)R }
"j}H)PVz#C!S;X:Q //Count the number of rows = the number of people online_ bpyv~
$user = mysql_num_rows($result);
k,g:vnu&e,tX //spit out the results
J/[1o-}Iy mysql_close();
sK\'j!{5H)|q D if($user == 1) {
f~ r$O0x print("1 user online\n");9v?:e6Gh'U@L2q;P
} else {DDNeU!J
print("$user users online\n");
+Um]~K }
)z%qV `8F&o/L4r'pa ?>
}:NZ2v
m!k [url=http://www.now.cn/vhost/][img]http://b.todayisp.com/bbs/760x90h.gif[/img][/url],pFJf2\,M$R/u
以上代码我是在时代互联提供的免费试用主机上测试的，感觉效果还不错，性能很稳定，不信的话你也可以去试试。当然，记得指出我这个程序中的不足先哦。
z-\;ry0T u 时代互联是行业内最早开始提供PHP 虚拟主机的公司之一，现在已经是的金牌域名注册商和中国互联网客户满意度十佳单位，产品功能已经非常完善 ，特别提一下几个特有用的功能：数据库自动备份、免费集成繁简通简装版、多域名绑定、多子网站支持、GCDN 网站加速器、镜像加速、高级访问统计系统、支持WAP、可选电信/网通/香港机房。
5sTo4YW0od 我之前建站的时候选的是他们公司标准商务E型，因为这款机型还特别支持ASP.NET3.5(3.0/2.0/1.1)/ASP。4eGn-B7tQ.W
当然啦，这两款主机也是相当不错的。
i*IJ9e:k$E 智强商务B型：Unix /Linux 操作系统+独立网页空间1000MB+送1000MB邮局空间+100MB MySQL数据库空间=1869元/年
np p'\"? my^ 标准商务B型：Unix /Linux 操作系统+独立网页空间500MB+送800MB邮局空间+60MB MySQL数据库空间=1365元/年c|2w0RM
g4myo
提供一下这个公司的联系方式：请见：[url=http://www.now.cn/vhost/]http://www.now.cn/vhost/[/url]
5~HNLa/~ 空间专线： 0756-2623871  QQ：168075865，好象还有全球免费网络电话:全球免费咨询电话 [url=http://www.now.cn/callcenter/call.net?LineName=55]http://www.now.cn/callcenter/call.net?LineName=55[/url]
N'v.\1?k2`iv 自己加QQ去问吧。

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