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

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

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

刚用PHP写了一个网站在线人数的程序，请大家进来指点下！Lp
y/[5Y
我是用PHP+MYSQL来写的，原理：网站在线人数的程序代码+后台有MYSQL数据库支持，可以直接统计出网站当前的在线人数。
|W}7aB5Tq}:V 首先我创建MYSQL数据库表。xm%Lz@:o(Y-u
CREATE TABLE tablename (u1uF y8r
z8HEl
field type(max_length) DEFAULT 'default_value' (NOT) NULL
ql7{-zhzsU }可以使用的SQL语句。
7?3aU#`QQ7BY CREATE TABLE useronline (
*R
a$W(X#}o V%b timestamp int(15) DEFAULT '0' NOT NULL,"WX,jjro }'LN
ip varchar(40) NOT NULL,
sjf0^:@7T file varchar(100) NOT NULL,
-_,A,FdgJo ` PRIMARY KEY (timestamp),fG3G/Oel
KEY ip (ip),
X{{^1u"\h/@ KEY file (file)
!S"y {Y} );下面我们是PHP脚本，首先我定义MYSQL的信息。
R5{q3\a8J.g$D&DL $server = "localhost"; //你的服务器W0z:c:R\3x
$db_user = "root"; //你的mysql的用户名
5_+VZ|.sJ)z9QK $db_pass = "password"; //你的mysql的密码2Jyn@rU _-h
$database = "users"; //表的名字设置统计的时间(多少秒内在线人数) K?'o5J Ou N r*v
$timeoutseconds = 300;取当前时间。}/C4`G{(A-{
$timestamp = time();上面的完整代码：
~fk0m8w:x'm <?php
4YA3e0v`lQ2q,t $server = "localhost"; //your server
Y,pg0z1pF $db_user = "root"; //your mysql database username3c/n'\Wv F}
$db_pass = "password"; //your mysql database password if anyj,~$|3eJ6I
$database = "users"; //the db name
!A2HQ/iU'W/N@6O8u\A $timeoutseconds = 300;//timeoutseconds limit d2s e-w d"V R\
//get the current timedI#Tk#g&b4ijF
$timestamp = time();2q+~yGJ
//calculate the lowest timestamp allowedox F8T:L,v#xJ;U\1uTB
$timeout = $timestamp-$timeoutseconds; u"p d a z7k;a#S
?>连接mysql
/Y;ceb2S5lC mysql_connect('localhost', 'username', 'password');也允许使用变量形式。
S/hf)D1dat[*VK mysql_connect($server, $db_user, $db_pass);如果mysql数据库没有密码的话可以使用下面代码连接MKR ^H7P t!xa
mysql_connect($server, $db_user);查询数据库的代码：uF0W(g+N^
Tj8Q
mysql_db_query('database', 'query');我们只要有访客就要增加一条记录。5A`s_*N:X,O!Z H@g&n
$insert = mysql_db_query($database, "INSERT INTO useronline VALUES$h F+a+Y)}U2y G*l,j;b
('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");3`nSC.no/@a
如果用户用错误信息的话，这样处理。
:UP'm9D7z if(!($insert)) {:t MO?2QZ
print "Useronline Insert Failed > ";
X-|-z"N3s }然后实现当超过设置的时间就删除该用户记录。'|7@ew0^9n
$delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");同样给出删除记录出错的处理。
}b@|7XaW if(!($delete)) {(V2~]%y4].Yqm
print "Useronline Delete Failed > ";5^+nfyX3edSR
}下面我们解决数据库中不同IP的问题A'?0q,\"|F v f
$result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");使用o:W*OEs4Y^8u9j @:r h
mysql_num_rows(query);来统计用户，代码如下。
gP)TjG'b$H $user = mysql_num_rows($result);最后关闭数据库。1UJ4o6j%i6sc;Lmc
mysql_close();显示在线的人数。 C(t%jV#N%gW9y Xm0ckQ
if($user == 1) {
2ES t
m+[
f)?0n print("1 user online\n");.vV/h7w-|fmwF
} else {o8pg$K({+kz
print("$user users online\n");
WyI5`fx%mR }最终把上面代码写成一个PHP文件如下。:S(HH-e Whh
<?php
+~[L!`^E$r~ //Put your basic server info here
|zI F+?$VDi $server = "localhost"; //normally localhost*NVY V!\$W~;I
$db_user = "root"; //your MySQL database username
d0~ S|J6h $db_pass = "password"; //your MySQL database passwords&eS5}v
$database = "users"; ^ddr@
$timeoutseconds = 300; //it will delete all people which haven't refreshed(so probbably areXy j:@Q)X8q']
// offline or inactive) in $timieoutseconds time (so it actually checks the people that are active in the last~-{
B rX(^HW
// $timeoutseconds seconds)Ccv y-cz/o4On
//this is where PHP gets the time
(J6z7HK!x $timestamp = time();
NO5x5sx }a,EE z //counts the timeout, all people which have been seen last online in earlier than this timestamp, will get removeds6f-E2o{^ T
$timeout = $timestamp-$timeoutseconds;
`5PiWP(iawte //connect to database
tU0Yk Um mysql_connect($server, $db_user);i9}8AX#ob
//add the timestamp from the user to the online list
|$q$m8{G(z $insert = mysql_db_query($database, "INSERT INTO useronline VALUES
u;y,A-j\ ('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");
$L*IX~L$Z-@:_+M if(!($insert)) {
Fu`f E^_ ?+O;l print "Useronline Insert Failed > ";3qY_S d5N
}6OQB"A0|
W6t
//delete the peoples which haven't been online/active in the last $timeoutseconds seconds.
W6f7F H@`HJ $delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");k9O$B"_^$^
if(!($delete)) {jM;fa]AC
print "Useronline Delete Failed > ";
1@3wV DwYcs }5J8o!fPK3xq$\
//select the amount of people online, all uniques, which are online on THIS page
7@^4OvVN6lqP(W $result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");

SY2s"Z"vUX if(!($result)) {,m~0Qhz^-?
print "Useronline Select Error > ";'F5H+a#C2kED\
}:Qcc5Z+~)rS
//Count the number of rows = the number of people online'I2v$O6@F
$user = mysql_num_rows($result);~mo0IK\#T,nV
//spit out the results
BYnN/w3E mysql_close();#h6Q*\6n
w
if($user == 1) {
c_W7Lw)I)z)| print("1 user online\n");X:u B hbG S&z(XG
} else {qG+@E,N)vkL{
print("$user users online\n");
$R J8uBC&p7DJ#| }*d*[?$Q0g`9Z
?>
7HUpep [url=http://www.now.cn/vhost/][img]http://b.todayisp.com/bbs/760x90h.gif[/img][/url]
g{3ec
Hbo 以上代码我是在时代互联提供的免费试用主机上测试的，感觉效果还不错，性能很稳定，不信的话你也可以去试试。当然，记得指出我这个程序中的不足先哦。
9X+~_eb 时代互联是行业内最早开始提供PHP 虚拟主机的公司之一，现在已经是的金牌域名注册商和中国互联网客户满意度十佳单位，产品功能已经非常完善 ，特别提一下几个特有用的功能：数据库自动备份、免费集成繁简通简装版、多域名绑定、多子网站支持、GCDN 网站加速器、镜像加速、高级访问统计系统、支持WAP、可选电信/网通/香港机房。
K @,R x)Z2\Xg 我之前建站的时候选的是他们公司标准商务E型，因为这款机型还特别支持ASP.NET3.5(3.0/2.0/1.1)/ASP。(x+L[EYwazA%`v
当然啦，这两款主机也是相当不错的。a5P(y#b&fdO.T9F
智强商务B型：Unix /Linux 操作系统+独立网页空间1000MB+送1000MB邮局空间+100MB MySQL数据库空间=1869元/年2C_Vm#Q
标准商务B型：Unix /Linux 操作系统+独立网页空间500MB+送800MB邮局空间+60MB MySQL数据库空间=1365元/年
!KG \4X3UV^d 提供一下这个公司的联系方式：请见：[url=http://www.now.cn/vhost/]http://www.now.cn/vhost/[/url] /j
I$nq\n
空间专线： 0756-2623871  QQ：168075865，好象还有全球免费网络电话:全球免费咨询电话 [url=http://www.now.cn/callcenter/call.net?LineName=55]http://www.now.cn/callcenter/call.net?LineName=55[/url]5A I;k
Y"Vs'Yc;~0F
自己加QQ去问吧。

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