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

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

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

刚用PHP写了一个网站在线人数的程序，请大家进来指点下！'RQ Y1}N'ix
我是用PHP+MYSQL来写的，原理：网站在线人数的程序代码+后台有MYSQL数据库支持，可以直接统计出网站当前的在线人数。_/di3om;d@i%N
首先我创建MYSQL数据库表。
ld*Mn)?
~|fc CREATE TABLE tablename (k}*]Q|ST4W
field type(max_length) DEFAULT 'default_value' (NOT) NULL
+e7Py-L&Pqrid N }可以使用的SQL语句。
F1H~d#mo-s-\P CREATE TABLE useronline (
6p9JASB:g timestamp int(15) DEFAULT '0' NOT NULL,
l-w
Pw1?4e ip varchar(40) NOT NULL,2i5V)o @(}-Z V?@[ m
file varchar(100) NOT NULL, {"g7^2u3Z
PRIMARY KEY (timestamp),/?\l5NQM#m
KEY ip (ip),
%o[:jo5u KEY file (file)
Cu+z ciX-rL*L );下面我们是PHP脚本，首先我定义MYSQL的信息。
"NwGd;z)g7V"X3Q}5g%G $server = "localhost"; //你的服务器]luWDH
$db_user = "root"; //你的mysql的用户名(\VrX4m
$db_pass = "password"; //你的mysql的密码
6Uc.P&V.L"@9L $database = "users"; //表的名字设置统计的时间(多少秒内在线人数)
VC Qy G4p $timeoutseconds = 300;取当前时间。
2h5U4M
Y ao $timestamp = time();上面的完整代码：
K.et }Z)_\/O Gvsf <?phpES;Be(g0Z;s
$server = "localhost"; //your server
.[&pp_^Q $db_user = "root"; //your mysql database username
)f)dm ~L)^-uE $db_pass = "password"; //your mysql database password if anyX{Q_
L
$database = "users"; //the db name
it;C&lU6h0z $timeoutseconds = 300;//timeoutseconds limitF(@/j!X3F+m2py+P[
//get the current time
9r
} X6{N/J-N X $timestamp = time();
Ff,OTZ y&g1m-M //calculate the lowest timestamp allowed
5G!~Ov'CUs1H1FU $timeout = $timestamp-$timeoutseconds;.G]~a(naor
?>连接mysql
u9GR,e&S4AxF*oj mysql_connect('localhost', 'username', 'password');也允许使用变量形式。
0cB9pa?Z mysql_connect($server, $db_user, $db_pass);如果mysql数据库没有密码的话可以使用下面代码连接
vk9L}qY mysql_connect($server, $db_user);查询数据库的代码：h"]Q*uXJ
mysql_db_query('database', 'query');我们只要有访客就要增加一条记录。
Fh4eO5o#vV E $insert = mysql_db_query($database, "INSERT INTO useronline VALUES$` [sjpt4Y'R
('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");+g^6\-m-nAd%s
如果用户用错误信息的话，这样处理。
p%V8v3GilF if(!($insert)) {
FS+H.a b print "Useronline Insert Failed > ";O0P7hM9w
}然后实现当超过设置的时间就删除该用户记录。
V@$s:Q-QR2y D $delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");同样给出删除记录出错的处理。
wazFU3w,t"Gu if(!($delete)) {,~v5Ti
c2`/^7^d
print "Useronline Delete Failed > ";
,uTqX7m9[E;Q }下面我们解决数据库中不同IP的问题
x*bIQ ?&fg $result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");使用!D-Mm-ca5H0|+r2or$_
mysql_num_rows(query);来统计用户，代码如下。
3JE5HP6ooE{ $user = mysql_num_rows($result);最后关闭数据库。9Sd"\L)uO \4]&Czm
mysql_close();显示在线的人数。
8@%J.a)x)k1B5N K| if($user == 1) {
Tx9x6T`1O8v|3M print("1 user online\n");UHJY5{VK4q1i
} else {(XE/J$D\;M D
print("$user users online\n");Lpys e{/k
}最终把上面代码写成一个PHP文件如下。
6X;A9}kp6RV%D R;x <?php }d.N$o0l^
//Put your basic server info here
^IBf/\s8b q8Ys $server = "localhost"; //normally localhost
~d U)B(k&S+CyU $db_user = "root"; //your MySQL database username!k h/OIS S\ }1yS)@4x
$db_pass = "password"; //your MySQL database password
s%\,K O~ @#PRL $database = "users";
`-?5Di'{5m $timeoutseconds = 300; //it will delete all people which haven't refreshed(so probbably are
v6t"{+{ ? // offline or inactive) in $timieoutseconds time (so it actually checks the people that are active in the last
]aMh0](tm_ // $timeoutseconds seconds)
"x:q.MYf //this is where PHP gets the time2v7~&a)o!?)L;s
$timestamp = time();
&j3Zr-S}H //counts the timeout, all people which have been seen last online in earlier than this timestamp, will get removed
H*qb_c6z $timeout = $timestamp-$timeoutseconds;1l(d8ks,^x|)^&U
//connect to databasee(Z4tG2~ZY;C.VTn
mysql_connect($server, $db_user);
mx;yki1ekX {J //add the timestamp from the user to the online listS+S:kv7E~Kr)V
$insert = mysql_db_query($database, "INSERT INTO useronline VALUES-o:]U!o@'M0|'Yj/w#^
('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");uFW7P9P7x7Hfn3o
if(!($insert)) {'X$Q/\!~aA
print "Useronline Insert Failed > ";#cz0L g!m6R^
}8dQ&]m#R
//delete the peoples which haven't been online/active in the last $timeoutseconds seconds.
@0?N9Ra;f8o,c3}s\/x $delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");
r KF.}D4rf if(!($delete)) {
GQ(M2Qe!y print "Useronline Delete Failed > ";
/`Yh8X+m2o#[S3^h }7x
q&w:\B._
//select the amount of people online, all uniques, which are online on THIS pagew.k(pV(M
$result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");
"sp)gQS:Q,Ps if(!($result)) {
:u'O/ZbW1A"qf print "Useronline Select Error > ";Z0L'lQ;z!I2O
}_*J?rp
//Count the number of rows = the number of people online.G)Od.i_5O
$user = mysql_num_rows($result);]C IG@Dmc
//spit out the results
;P#}"U7vC4R-K+K2N mysql_close();
&Q9|1EgXG%~3m if($user == 1) {
v/t+zdn sYm-L?#^ print("1 user online\n");*` J.Cj%nN2j
} else {fq5[i:{h
print("$user users online\n");b"PBC'Ltk
}Crc)x^!MQ
?>
-wXop#W d [url=http://www.now.cn/vhost/][img]http://b.todayisp.com/bbs/760x90h.gif[/img][/url]:cDE7[7p0h?,Aldj
以上代码我是在时代互联提供的免费试用主机上测试的，感觉效果还不错，性能很稳定，不信的话你也可以去试试。当然，记得指出我这个程序中的不足先哦。
0W~CN cz^ 时代互联是行业内最早开始提供PHP 虚拟主机的公司之一，现在已经是的金牌域名注册商和中国互联网客户满意度十佳单位，产品功能已经非常完善 ，特别提一下几个特有用的功能：数据库自动备份、免费集成繁简通简装版、多域名绑定、多子网站支持、GCDN 网站加速器、镜像加速、高级访问统计系统、支持WAP、可选电信/网通/香港机房。

{jS~~Tc3w 我之前建站的时候选的是他们公司标准商务E型，因为这款机型还特别支持ASP.NET3.5(3.0/2.0/1.1)/ASP。_&c5J6sJDi
当然啦，这两款主机也是相当不错的。
Ll2g5nwS.LH 智强商务B型：Unix /Linux 操作系统+独立网页空间1000MB+送1000MB邮局空间+100MB MySQL数据库空间=1869元/年
)su's$`w y#T 标准商务B型：Unix /Linux 操作系统+独立网页空间500MB+送800MB邮局空间+60MB MySQL数据库空间=1365元/年
4q#U)e0_Jc*B 提供一下这个公司的联系方式：请见：[url=http://www.now.cn/vhost/]http://www.now.cn/vhost/[/url]
.dy`B-S 空间专线： 0756-2623871  QQ：168075865，好象还有全球免费网络电话:全球免费咨询电话 [url=http://www.now.cn/callcenter/call.net?LineName=55]http://www.now.cn/callcenter/call.net?LineName=55[/url]
XG/Rl-[ [e"a M 自己加QQ去问吧。

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