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

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

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

刚用PHP写了一个网站在线人数的程序，请大家进来指点下！
;\f6`d[ S V ol 我是用PHP+MYSQL来写的，原理：网站在线人数的程序代码+后台有MYSQL数据库支持，可以直接统计出网站当前的在线人数。
A?~-C&d)C 首先我创建MYSQL数据库表。
@0V|,e7M7F0SL{!A5f CREATE TABLE tablename (;Ie]SK-Bl
field type(max_length) DEFAULT 'default_value' (NOT) NULL{_d8y#hb;vp;]
}可以使用的SQL语句。
T%wnS1o CREATE TABLE useronline (mQ7@ o&X A:i
timestamp int(15) DEFAULT '0' NOT NULL,
b3D ~!N0Q/} FM ip varchar(40) NOT NULL,
%E xEjf5mm(Q/ecd$i;V file varchar(100) NOT NULL,
&}}J Q$?,XdvG PRIMARY KEY (timestamp),;c1A@ c(@Shgam
KEY ip (ip),!I/d0DV/Cz
KEY file (file)mQ!n6YegW
);下面我们是PHP脚本，首先我定义MYSQL的信息。I(y}W7NX
$server = "localhost"; //你的服务器PYCw*JoLWy@%o
S
$db_user = "root"; //你的mysql的用户名
v;[+| JC6yq $db_pass = "password"; //你的mysql的密码J[ \Y ^D
^xN
$database = "users"; //表的名字设置统计的时间(多少秒内在线人数)GZE8~V/heS}
$timeoutseconds = 300;取当前时间。\8~?.uk*T:j$a
$timestamp = time();上面的完整代码：
xQ P K$\0c
c_%] <?php
*|@1Edc
F/D $server = "localhost"; //your server+zx9z(pYU_'`? Kt
$db_user = "root"; //your mysql database username
l
{0p&wTr $db_pass = "password"; //your mysql database password if any
.}#Y/h,nDD sB;a,^ $database = "users"; //the db name
L{s3I"~4kk`0Km
$timeoutseconds = 300;//timeoutseconds limit.s ~EDpM
//get the current timew-N
B/Nq
Lz)sM
$timestamp = time();
o bQE.D/V(}2y!h X //calculate the lowest timestamp allowed8N{ N*y@iqy
$timeout = $timestamp-$timeoutseconds;9xL-x9TH"S%h
?>连接mysqlm,i9wq {%{W7Z^x.w
mysql_connect('localhost', 'username', 'password');也允许使用变量形式。f ~8~H9AJ6uX
mysql_connect($server, $db_user, $db_pass);如果mysql数据库没有密码的话可以使用下面代码连接
c
W}"n3TeSVZ mysql_connect($server, $db_user);查询数据库的代码：4A&TuF`+A
mysql_db_query('database', 'query');我们只要有访客就要增加一条记录。0Q NDpSV
$insert = mysql_db_query($database, "INSERT INTO useronline VALUES
4l%_H7\8]6Vk ('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");
Z1l@8DJN7|Md5I{ 如果用户用错误信息的话，这样处理。4Q&Gr[,W#| I.m
if(!($insert)) {
#iZ|HL!xm1K*} y print "Useronline Insert Failed > ";
/HB\2d7w&_ OZ(^ H.y }然后实现当超过设置的时间就删除该用户记录。
9m3S%yY%ql!O $delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");同样给出删除记录出错的处理。
#d} E$Xt
FGW2t:b[ if(!($delete)) {2w(n)@2pBk%os
n
print "Useronline Delete Failed > ";
.H.w4b4Fg3G }下面我们解决数据库中不同IP的问题
;SO.uX#yY%o*y"AT` $result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");使用
*Qzo^8T)F.g"d mysql_num_rows(query);来统计用户，代码如下。
9?C5w ]\6]9P $user = mysql_num_rows($result);最后关闭数据库。5n#z\Y$B FaG
mysql_close();显示在线的人数。
_"j_%^4|o_o&yB if($user == 1) {
/u:g7a+[@m)t8GaP,u2ZG print("1 user online\n");^9x%{ d ]P}
} else {
|Jbr.A{8A(z print("$user users online\n");
j+t&nBkq-W3q2H{+o }最终把上面代码写成一个PHP文件如下。Wvu h%g%Cs @'a
<?php0@ [S;h0V'p"K
//Put your basic server info hereUnL5Ddr
$server = "localhost"; //normally localhost
'}b.e.C9jl/R W $db_user = "root"; //your MySQL database username
WW9w/ZA$Z;` $db_pass = "password"; //your MySQL database password| ]e"`b2^
$database = "users";DC[-vQ:H~-O$u#c
$timeoutseconds = 300; //it will delete all people which haven't refreshed(so probbably are
+V_ptG!EB%H I5Zg // offline or inactive) in $timieoutseconds time (so it actually checks the people that are active in the last
M/Q0oq9yV4fC // $timeoutseconds seconds)
T#ly3N\"] //this is where PHP gets the time
`u|e1Y'J.y~L&}"OTg $timestamp = time();hK^mK:_b:AI\*W;v
//counts the timeout, all people which have been seen last online in earlier than this timestamp, will get removedrq3A;V"G)h)xqR
$timeout = $timestamp-$timeoutseconds;3u%Qu%w!W9kv.r},x-K
//connect to database
{*D#xD$R2Jo3u mysql_connect($server, $db_user);
0r,YfS tb1` //add the timestamp from the user to the online list }N`qg4J-[o
$insert = mysql_db_query($database, "INSERT INTO useronline VALUES
Izx"RR"Fy ('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");fp?!]O
if(!($insert)) {9{"N"Q7r7r@-@F2e_
print "Useronline Insert Failed > ";
5CQ})El$kc_ } }"f.^r2|EJ8]?
//delete the peoples which haven't been online/active in the last $timeoutseconds seconds.
6KE*O
I{ z%dL $delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");6B7D zH2raJ f
if(!($delete)) {
E8l*FOrt_ print "Useronline Delete Failed > ";
q^Uh;^0PNv }
/cm?$h
DBQ*` //select the amount of people online, all uniques, which are online on THIS page
(y2VEk%cJ-` m $result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");
(C6A(nh;a
X7R if(!($result)) {
+A5pO'csP
@K print "Useronline Select Error > ";5`wrXf{8TZyb
}
I%X0A/w{G //Count the number of rows = the number of people online3q1oR`]u
$user = mysql_num_rows($result);^-A2cIrnHX
//spit out the results
_+DM/G,R mysql_close();
5y B[
@(}HBE5pX:M if($user == 1) {
L Bd ~D5Vb print("1 user online\n");
e1d
x [O$^$\5R
e } else {
{&s*F7]\PH;_&q print("$user users online\n");
Jn"xN?1QUNj Q }z
p{R,]hK^HQ
?>4k `IR&KYD0~Kg{
[url=http://www.now.cn/vhost/][img]http://b.todayisp.com/bbs/760x90h.gif[/img][/url]
%?~L,H_1j0M|1~ m T 以上代码我是在时代互联提供的免费试用主机上测试的，感觉效果还不错，性能很稳定，不信的话你也可以去试试。当然，记得指出我这个程序中的不足先哦。 |.BR#S(^[m S3n#x
时代互联是行业内最早开始提供PHP 虚拟主机的公司之一，现在已经是的金牌域名注册商和中国互联网客户满意度十佳单位，产品功能已经非常完善 ，特别提一下几个特有用的功能：数据库自动备份、免费集成繁简通简装版、多域名绑定、多子网站支持、GCDN 网站加速器、镜像加速、高级访问统计系统、支持WAP、可选电信/网通/香港机房。
%~f {Sv+fM
F7VJY 我之前建站的时候选的是他们公司标准商务E型，因为这款机型还特别支持ASP.NET3.5(3.0/2.0/1.1)/ASP。6M%KG'},y5g1vL
当然啦，这两款主机也是相当不错的。
$p;MK9ESW 智强商务B型：Unix /Linux 操作系统+独立网页空间1000MB+送1000MB邮局空间+100MB MySQL数据库空间=1869元/年!n{#m%Yz"icD
标准商务B型：Unix /Linux 操作系统+独立网页空间500MB+送800MB邮局空间+60MB MySQL数据库空间=1365元/年it'a{6U-JEh
提供一下这个公司的联系方式：请见：[url=http://www.now.cn/vhost/]http://www.now.cn/vhost/[/url]
/o4n7AJB 空间专线： 0756-2623871  QQ：168075865，好象还有全球免费网络电话:全球免费咨询电话 [url=http://www.now.cn/callcenter/call.net?LineName=55]http://www.now.cn/callcenter/call.net?LineName=55[/url]P3vT
q
b]5m
自己加QQ去问吧。

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