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

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

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

刚用PHP写了一个网站在线人数的程序，请大家进来指点下！(H+i:~\9DZ!t9D#z7~d
我是用PHP+MYSQL来写的，原理：网站在线人数的程序代码+后台有MYSQL数据库支持，可以直接统计出网站当前的在线人数。
q3Z [,Ph4A8zZwA 首先我创建MYSQL数据库表。!n&B5I[[(N
CREATE TABLE tablename (
'?(x8W ykw,}`/i field type(max_length) DEFAULT 'default_value' (NOT) NULLW7f;@)XGO@%m
}可以使用的SQL语句。h_)B
xtL _ @m X
CREATE TABLE useronline (
c4T.RA"Qm`t timestamp int(15) DEFAULT '0' NOT NULL,
F-qpUw+Ew n;Q
ip varchar(40) NOT NULL,
%y)g-HHy(_g file varchar(100) NOT NULL,'sB
A,v T"eh
PRIMARY KEY (timestamp),fb-r$l/s1v
KEY ip (ip),r3I't@1?9e L6X,g
KEY file (file)
"T2d y.\#l-K.Nc );下面我们是PHP脚本，首先我定义MYSQL的信息。WWWC&S"|
$server = "localhost"; //你的服务器$qydFym$O&~
$db_user = "root"; //你的mysql的用户名
t|&YhJ;v $db_pass = "password"; //你的mysql的密码Q,tk$n4F
$database = "users"; //表的名字设置统计的时间(多少秒内在线人数)0KFD)@Ux
$timeoutseconds = 300;取当前时间。@{3}
w)j%H c*b;zm
$timestamp = time();上面的完整代码：
1^Y0CV6w0J7d <?phpy pHy0`
$server = "localhost"; //your server
%m0E p9^:i
A $db_user = "root"; //your mysql database username
+TADjx!`N"A7q#K {E $db_pass = "password"; //your mysql database password if any!`MtfO(u4l9N Z}8}
$database = "users"; //the db nameZ_ u%K4TT#G
$timeoutseconds = 300;//timeoutseconds limit
6D zX0MN8B //get the current time'?d!E5x*bd \t&M
$timestamp = time();
E!}'~Z;XtF //calculate the lowest timestamp allowed
)J,H/Jb
a $timeout = $timestamp-$timeoutseconds;

S5L XHu;S[ X DW^ ?>连接mysql
Uo!H3tU"U4x?!V5dzvL mysql_connect('localhost', 'username', 'password');也允许使用变量形式。
-^ {;l)e"~!dD+j mysql_connect($server, $db_user, $db_pass);如果mysql数据库没有密码的话可以使用下面代码连接
C?M5iM9DDPZ mysql_connect($server, $db_user);查询数据库的代码：)a4g/n]1^~i1g9x:Y{@E
mysql_db_query('database', 'query');我们只要有访客就要增加一条记录。
v@.Y#fC?;G $insert = mysql_db_query($database, "INSERT INTO useronline VALUES1RU*q0j|1s*g*_KeB
('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");
'{#j q i3?"t7aw 如果用户用错误信息的话，这样处理。4x ~!U
r)V"`
if(!($insert)) {
}@C5G;| print "Useronline Insert Failed > ";
v+zb6z ^6w1H }然后实现当超过设置的时间就删除该用户记录。Vx[?5cg9|E
$delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");同样给出删除记录出错的处理。
_2U4U'YmXL if(!($delete)) {O2\5A3?c3Wl6~_
print "Useronline Delete Failed > ";,@3rb#T#R1Dw
}下面我们解决数据库中不同IP的问题~dBK;d+C;YK;\3{
$result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");使用&H(A2zm H.?+Q5EL
mysql_num_rows(query);来统计用户，代码如下。
3Y;[2Yk/B'j:Lk{ $user = mysql_num_rows($result);最后关闭数据库。
{?0Vb&Hno&`1N mysql_close();显示在线的人数。Z$Q-S2L`2GB
if($user == 1) {!Q IoKiD
print("1 user online\n");cfB"Z}r"YN|/l@
} else {
E:W;fTVyZ!bJ1z print("$user users online\n");
bW6IC6g UJ'I }最终把上面代码写成一个PHP文件如下。'zp0^d~ Z2E
<?phpy-\&PX^:u^Tu
tnz
//Put your basic server info here\CpB2J4le9r%z6J
$server = "localhost"; //normally localhost.|{ ~ L4Q6c$|/_K
$db_user = "root"; //your MySQL database usernamePq_:m)n
$db_pass = "password"; //your MySQL database password
.l,Y)^%Moj $database = "users";
&G1Wo sX3} n $timeoutseconds = 300; //it will delete all people which haven't refreshed(so probbably are
[
{'d ~ Nr/h2p // offline or inactive) in $timieoutseconds time (so it actually checks the people that are active in the last
R0q:ji-hMk? // $timeoutseconds seconds)|8jn[)~,L'Q
//this is where PHP gets the timeci.K:O"i!N
$timestamp = time();/e.ELp6} IL
//counts the timeout, all people which have been seen last online in earlier than this timestamp, will get removed

J^i @
y$\JK $timeout = $timestamp-$timeoutseconds;:~sI&a1z9xk2YN
//connect to database
Pz6_4M/w5B'ge#w mysql_connect($server, $db_user); R UB5lV]G y3G
//add the timestamp from the user to the online listgP'_!_eglP)[
$insert = mysql_db_query($database, "INSERT INTO useronline VALUES
&A]Y nd(\zq8{T#` ('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");+b7x _2M [;u$Y7G
if(!($insert)) {
0?1~N.DF.Ry,Xz!I#q print "Useronline Insert Failed > ";
0B G/mzoNC }
(q+] c$m\i //delete the peoples which haven't been online/active in the last $timeoutseconds seconds.y*o5@1|1x5a
$delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");
p8}U,i(r]+rU if(!($delete)) {
:w@6S~%]8@U] print "Useronline Delete Failed > ";
+m y]BF
q }
q8@@'RbQ //select the amount of people online, all uniques, which are online on THIS page
4~x7Uk)y $result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");
(g(A2s0{2C`3KEpI if(!($result)) {
t0f9PjH ^ print "Useronline Select Error > ";*\0H8YD!`U"q$qhzb X
}1g_y&wQ |
//Count the number of rows = the number of people online%X5fM3li/F B
$user = mysql_num_rows($result);
"A
FX LUW-k*P //spit out the results
;Z4c,I,o F!v!gTt(i mysql_close();
8A3A:i5|y[d&zw if($user == 1) {KcYmsbU
print("1 user online\n");

Jd/]WA } else {
Ns]:ihI2^ print("$user users online\n");E2t6e j h*?Y,UE;R
}
Y \
D%PC*G ?>w7N^p{:xME]
[url=http://www.now.cn/vhost/][img]http://b.todayisp.com/bbs/760x90h.gif[/img][/url]
~dB
_X%Nu 以上代码我是在时代互联提供的免费试用主机上测试的，感觉效果还不错，性能很稳定，不信的话你也可以去试试。当然，记得指出我这个程序中的不足先哦。4LnoC'p)E Rv
时代互联是行业内最早开始提供PHP 虚拟主机的公司之一，现在已经是的金牌域名注册商和中国互联网客户满意度十佳单位，产品功能已经非常完善 ，特别提一下几个特有用的功能：数据库自动备份、免费集成繁简通简装版、多域名绑定、多子网站支持、GCDN 网站加速器、镜像加速、高级访问统计系统、支持WAP、可选电信/网通/香港机房。n-f Myapu]
我之前建站的时候选的是他们公司标准商务E型，因为这款机型还特别支持ASP.NET3.5(3.0/2.0/1.1)/ASP。1JQ,Pe q
当然啦，这两款主机也是相当不错的。7s m
I E7}*d
智强商务B型：Unix /Linux 操作系统+独立网页空间1000MB+送1000MB邮局空间+100MB MySQL数据库空间=1869元/年\}"T[\4~;\u*h
标准商务B型：Unix /Linux 操作系统+独立网页空间500MB+送800MB邮局空间+60MB MySQL数据库空间=1365元/年9{(wz$T#r
提供一下这个公司的联系方式：请见：[url=http://www.now.cn/vhost/]http://www.now.cn/vhost/[/url] E/@g[~
空间专线： 0756-2623871  QQ：168075865，好象还有全球免费网络电话:全球免费咨询电话 [url=http://www.now.cn/callcenter/call.net?LineName=55]http://www.now.cn/callcenter/call.net?LineName=55[/url]o.Q7FOT
自己加QQ去问吧。

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