返回列表 发帖

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

刚用PHP写了一个网站在线人数的程序,请大家进来指点下!+ C  c! X. x/ }- v
我是用PHP+MYSQL来写的,原理:网站在线人数的程序代码+后台有MYSQL数据库支持,可以直接统计出网站当前的在线人数。
+ X# v5 R& s; N' Y' ~( `8 Y首先我创建MYSQL数据库表。- T  d9 q0 x2 v2 |& o. f) c# g' d5 d
CREATE TABLE tablename (& I# O% F& _; G3 y' N
field type(max_length) DEFAULT 'default_value' (NOT) NULL
7 t% d# I! T5 |1 p}可以使用的SQL语句。/ ?5 C+ I0 i6 c5 l( B
CREATE TABLE useronline (' Z3 |+ M- Q2 b. O. Q- c  M
timestamp int(15) DEFAULT '0' NOT NULL,
4 a: G. j7 E5 \7 W* l$ X" gip varchar(40) NOT NULL,
: \: o1 S; ]) F; `+ n4 x1 Mfile varchar(100) NOT NULL,
! V( N  X/ L2 w4 _* W# [$ BPRIMARY KEY (timestamp),- X  W8 k5 i& H1 \( k9 G2 o
KEY ip (ip),
) G0 ]& j/ c! f5 v0 @KEY file (file)" {3 t2 r% b. J( F+ i' e# @# U2 M
);下面我们是PHP脚本,首先我定义MYSQL的信息。
/ r! e) N( v1 U) I! p, V$server = "localhost"; //你的服务器( F& }: ]& z) |  ~. l9 P! J
$db_user = "root"; //你的mysql的用户名' b' [' M( Y; \
$db_pass = "password"; //你的mysql的密码
/ J! v- ]2 Q' W/ Y9 K: e$database = "users"; //表的名字设置统计的时间(多少秒内在线人数)( j0 W5 F0 n0 e
$timeoutseconds = 300;取当前时间。
7 C- h  g2 X- L) r$timestamp = time();上面的完整代码:
2 b* I, l0 H& m1 h& w+ C<?php
8 a7 |! ]$ `5 j7 r9 V- y+ s6 L$server = "localhost"; //your server2 _# l8 {/ m" u* K& I6 C5 C
$db_user = "root"; //your mysql database username' Z" {" U9 C) m. s; K! h+ I
$db_pass = "password"; //your mysql database password if any
/ K1 n) Z3 Y) m. G$database = "users"; //the db name
+ b7 h9 e9 ^( ?/ _) R$timeoutseconds = 300;//timeoutseconds limit
  ?; ^: V3 K( g# x' u//get the current time! u$ z2 h$ Y/ x, p* b( j
$timestamp = time();% F* e. {! C6 G0 m& y
//calculate the lowest timestamp allowed! X/ L, q" r2 i: Q
$timeout = $timestamp-$timeoutseconds;% W* M/ E! X$ u  n/ Y
?>连接mysql$ \' Z* r4 W5 ]9 }) R6 @% y8 c
mysql_connect('localhost', 'username', 'password');也允许使用变量形式。
  e9 D6 H; m( Amysql_connect($server, $db_user, $db_pass);如果mysql数据库没有密码的话可以使用下面代码连接1 K+ h5 _% |$ }
mysql_connect($server, $db_user);查询数据库的代码:: M7 V* U; w/ S9 t
mysql_db_query('database', 'query');我们只要有访客就要增加一条记录。
$ h, n" p: K3 g% N8 b2 w$insert = mysql_db_query($database, "INSERT INTO useronline VALUES
) [. l; }- K: B4 ]('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");
# w4 N6 v% f- M) Z1 m* f如果用户用错误信息的话,这样处理。8 M$ G( @. U% h0 G  d/ n
if(!($insert)) {
( i: m5 u# A' xprint "Useronline Insert Failed > ";
+ e! k! S/ Q( ^7 p: a% ?- ?. A}然后实现当超过设置的时间就删除该用户记录。/ g3 T8 q$ o) f  s* h! t
$delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");同样给出删除记录出错的处理。1 `( L! R( n( ~) k( n3 y7 p  m4 _
if(!($delete)) {
, ]; @# g& i  s' R1 rprint "Useronline Delete Failed > ";
; w9 I/ B" [% Q}下面我们解决数据库中不同IP的问题! a1 j" `. \- Z  z, ]: b3 ~
$result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");使用
3 H2 m9 ]% k* l! C  \mysql_num_rows(query);来统计用户,代码如下。
. a& K4 h# z/ f$ d. C* y9 {$user = mysql_num_rows($result);最后关闭数据库。- P; o+ m* R4 r2 Q0 l0 U5 V0 k; [
mysql_close();显示在线的人数。
. X  O+ f% B" h; k. Eif($user == 1) {% v0 Y: S/ b- P  Q
print("1 user online\n");
0 B& r, U3 A4 Y: Y$ |} else {
  W/ z, q( [" b+ |5 |$ g/ Bprint("$user users online\n");3 D' t- R) y5 l3 A9 B( g
}最终把上面代码写成一个PHP文件如下。3 e% ]6 d- I" H# P
<?php
8 @- c7 ^4 y" j//Put your basic server info here& Y7 r" ]/ E  s6 K
$server = "localhost"; //normally localhost; F: T& `% A! E( a! i6 J, [
$db_user = "root"; //your MySQL database username
, |/ K0 q# Z9 }7 B, i$db_pass = "password"; //your MySQL database password
- _3 k8 B8 a6 r$database = "users";
1 x- }' W+ E/ U" n$ f0 W: B$timeoutseconds = 300; //it will delete all people which haven't refreshed(so probbably are. |+ a) r! k3 E6 x' i% i9 V
// offline or inactive) in $timieoutseconds time (so it actually checks the people that are active in the last
# l3 g6 @. C* r& C// $timeoutseconds seconds)7 U/ L2 h% o0 P% C) g* R2 m5 p
//this is where PHP gets the time2 K: }+ n! `1 ^# R
$timestamp = time();: U  D# M4 w% T# W% ~/ r0 ^
//counts the timeout, all people which have been seen last online in earlier than this timestamp, will get removed
* a* M5 p# z- }2 @2 b5 [) k$timeout = $timestamp-$timeoutseconds;+ n3 q& `7 j4 t* ^6 |
//connect to database
" m) b; [* Q+ `mysql_connect($server, $db_user);! V; g; ~1 ~6 e2 q& ]% ]- r
//add the timestamp from the user to the online list
0 a8 {) k: I; g$ d( B5 g  F( `$insert = mysql_db_query($database, "INSERT INTO useronline VALUES* @  e0 @  K) h. W
('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");/ ?; d, {4 g8 `8 Q8 V
if(!($insert)) {
: [+ M) ^4 D6 O2 C, Eprint "Useronline Insert Failed > ";! P' P& P1 o! w2 O
}3 T" L" M1 ^3 e" U
//delete the peoples which haven't been online/active in the last $timeoutseconds seconds.
7 R, g8 [$ K: U. ]6 Z$delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");
& l5 _2 X& b  R5 [if(!($delete)) {
! N1 J: g- _8 f( l7 I. v3 C3 Vprint "Useronline Delete Failed > ";5 G& I$ f4 M( h5 D3 [, N* X/ r
}# [2 r. k( E9 H  t
//select the amount of people online, all uniques, which are online on THIS page
2 F. i9 s, _- g  O$result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");* Y! i' f& m8 t2 [) T$ w
if(!($result)) {
, O  K% r7 h. r. _& r( c2 nprint "Useronline Select Error > ";0 G  f! m5 k/ z& _
}
0 ~; ?8 y0 s) d$ m//Count the number of rows = the number of people online: g) [/ f: h, F' t" ~0 l# z4 u- @
$user = mysql_num_rows($result);- z. @# L% f. g, {: g4 M
//spit out the results7 }% B  `+ h, W1 O
mysql_close();
" H4 J2 f, Q- i! b! C6 x4 fif($user == 1) {
% ]+ B3 y- C9 S$ s8 fprint("1 user online\n");9 `$ G2 O' B2 @0 W5 o9 L$ {
} else {
  M4 N5 Y0 }6 U. B/ w8 Kprint("$user users online\n");4 h6 `9 T) a( a/ a1 R1 g- F9 {) S4 I
}
1 o5 w3 L3 D) a2 E?>
# j' Z" t) j; L9 j1 j; G: l
" e. W) z4 N: I; v$ [. f以上代码我是在时代互联提供的免费试用主机上测试的,感觉效果还不错,性能很稳定,不信的话你也可以去试试。当然,记得指出我这个程序中的不足先哦。
  J9 m1 D; r# @+ ^5 F时代互联是行业内最早开始提供PHP 虚拟主机的公司之一,现在已经是的金牌域名注册商和中国互联网客户满意度十佳单位,产品功能已经非常完善 ,特别提一下几个特有用的功能:数据库自动备份、免费集成繁简通简装版、多域名绑定、多子网站支持、GCDN 网站加速器、镜像加速、高级访问统计系统、支持WAP、可选电信/网通/香港机房。' L* l) X/ Z2 @
我之前建站的时候选的是他们公司标准商务E型,因为这款机型还特别支持ASP.NET3.5(3.0/2.0/1.1)/ASP。* e/ Y+ i2 l3 h: `# E" ~7 @
当然啦,这两款主机也是相当不错的。" o5 v" X9 h; E& T. Z9 [
智强商务B型:Unix /Linux 操作系统+独立网页空间1000MB+送1000MB邮局空间+100MB MySQL数据库空间=1869元/年6 c9 O  M" ]( c3 W
标准商务B型:Unix /Linux 操作系统+独立网页空间500MB+送800MB邮局空间+60MB MySQL数据库空间=1365元/年9 l: z4 A% l+ K# |$ y% s3 ]
提供一下这个公司的联系方式:请见:http://www.now.cn/vhost/ # ]4 x; _2 n+ F# p- o2 m/ _' J
空间专线: 0756-2623871  QQ:168075865,好象还有全球免费网络电话:全球免费咨询电话 http://www.now.cn/callcenter/call.net?LineName=55
! L5 B  l. @* Y* C8 ], f自己加QQ去问吧。

返回列表
【捌玖网络】已经运行: