|

- UID
- 455
- 帖子
- 3
- 精华
- 0
- 积分
- 8
- 金币
- 3
- 威望
- 0
- 贡献
- 0
|
刚用PHP写了一个网站在线人数的程序,请大家进来指点下!
刚用PHP写了一个网站在线人数的程序,请大家进来指点下!
3 k( E+ w7 ]6 S& ?- f& x4 }, C我是用PHP+MYSQL来写的,原理:网站在线人数的程序代码+后台有MYSQL数据库支持,可以直接统计出网站当前的在线人数。8 W3 L" B( Z3 G# l% ~8 y
首先我创建MYSQL数据库表。
: r9 {( }% `# ]" pCREATE TABLE tablename (3 }. u4 Z$ R7 e y4 ]
field type(max_length) DEFAULT 'default_value' (NOT) NULL
0 w, Z7 O; p. C! g3 Y. x}可以使用的SQL语句。
' [3 h0 j) D& Y" t/ VCREATE TABLE useronline (7 R2 |0 M- l. z, ~
timestamp int(15) DEFAULT '0' NOT NULL,( b4 c1 {8 N* z: j6 Z
ip varchar(40) NOT NULL,3 V5 q( r" U' p+ L, w2 Z
file varchar(100) NOT NULL,
8 {6 h3 [, b% e) O; o$ [ T2 C3 x) aPRIMARY KEY (timestamp),8 s( } M# n0 k& j% L
KEY ip (ip),
/ n! ], r1 S/ HKEY file (file)" B9 Y6 r" Z4 X/ z( X
);下面我们是PHP脚本,首先我定义MYSQL的信息。
* e- b, @# z$ _5 x% D: |: }+ i3 ~$server = "localhost"; //你的服务器4 t) o6 L$ D/ ]! K5 j" A
$db_user = "root"; //你的mysql的用户名3 p6 h/ e" }& ?# ]* |7 |; e9 G
$db_pass = "password"; //你的mysql的密码
; N) K4 {4 ^: W4 _2 b$database = "users"; //表的名字设置统计的时间(多少秒内在线人数)+ Q P/ _- o$ w4 z7 A
$timeoutseconds = 300;取当前时间。/ u- R+ \- o$ M( N
$timestamp = time();上面的完整代码:
9 l0 a( y& z3 X8 M& m' [<?php# j$ F8 m$ {1 c% k' q3 y/ i8 j
$server = "localhost"; //your server$ n( \) I9 L R8 n) ?
$db_user = "root"; //your mysql database username7 t! r4 A3 l' x
$db_pass = "password"; //your mysql database password if any
% Q0 v! \( y; |. A! J9 J! D6 m% u$database = "users"; //the db name$ S; }- `6 z4 Q2 E2 b0 G2 f
$timeoutseconds = 300;//timeoutseconds limit
g" X6 M, }" a! B5 h3 Y( T, K, L5 a//get the current time
: @+ o C1 ]+ \8 `6 c$timestamp = time();
5 S/ b# r: v4 [! n//calculate the lowest timestamp allowed: e9 a6 l. x3 X/ D; `
$timeout = $timestamp-$timeoutseconds;2 q9 h6 R# f0 ~" e- Q$ q0 F+ ]
?>连接mysql& l, K5 \) S! q5 P( O e. n
mysql_connect('localhost', 'username', 'password');也允许使用变量形式。3 o2 K( c: W }' g! D" J& f1 r
mysql_connect($server, $db_user, $db_pass);如果mysql数据库没有密码的话可以使用下面代码连接
1 O$ @5 ^$ o- K7 l& pmysql_connect($server, $db_user);查询数据库的代码:
: }) X! r& o/ P$ Qmysql_db_query('database', 'query');我们只要有访客就要增加一条记录。
T& g! U9 d7 j8 |7 t" Z$insert = mysql_db_query($database, "INSERT INTO useronline VALUES6 l0 U$ ~5 G+ y3 E$ O
('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");
* Q" _3 ~$ D6 p. x5 e6 }如果用户用错误信息的话,这样处理。
1 n, f5 t8 d" Z% ]! hif(!($insert)) {
- ]' o. ~% R" H. |3 M$ \+ t9 Vprint "Useronline Insert Failed > ";5 f9 ~* V- H3 Y3 ?3 w: U! {
}然后实现当超过设置的时间就删除该用户记录。) U4 @: a5 [ ?4 c$ }8 k
$delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");同样给出删除记录出错的处理。2 D/ c; C2 z7 ]
if(!($delete)) {
' g: G# j& m8 j- bprint "Useronline Delete Failed > ";3 L9 S- b J( x; _! L( H! H
}下面我们解决数据库中不同IP的问题
) x. Z, L3 q2 u: E( @# ^$result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");使用
' l; c0 v3 d8 S2 Y. p5 v2 hmysql_num_rows(query);来统计用户,代码如下。
! |3 i+ U1 W% a- t$user = mysql_num_rows($result);最后关闭数据库。
* a; \6 |4 a! Umysql_close();显示在线的人数。! k$ @, g: t O
if($user == 1) {
( ]! W& c0 m8 |! B: [: nprint("1 user online\n");
8 r" Y1 S# K8 H7 r* F2 ?7 q1 w} else {, X( s/ ~* q; F! H
print("$user users online\n");
) K, J/ \, p( M& l}最终把上面代码写成一个PHP文件如下。1 F L5 I8 Q; D' G$ `/ K4 N' a# _
<?php2 Z) r' R0 u4 ^! I
//Put your basic server info here
! E( p$ u& J0 t, m$ F" y$server = "localhost"; //normally localhost5 C: D( R. H% X( h# o- O% c
$db_user = "root"; //your MySQL database username& W" ?- v9 r( a" ~
$db_pass = "password"; //your MySQL database password
- w8 h' W6 f, f. ]* [( L/ ~$database = "users";
% j s' H H+ ?$timeoutseconds = 300; //it will delete all people which haven't refreshed(so probbably are4 g5 j" m; K( ^) h
// offline or inactive) in $timieoutseconds time (so it actually checks the people that are active in the last- O. J. L4 C- J3 G5 ~; z- t v; n
// $timeoutseconds seconds)2 L: i$ M, G) v1 s. f3 V7 k
//this is where PHP gets the time
/ I% _6 q9 \" U$timestamp = time();
5 H# p9 ?% V3 L) ]' y1 H' o( K7 k& J//counts the timeout, all people which have been seen last online in earlier than this timestamp, will get removed. w: I+ O9 {2 T
$timeout = $timestamp-$timeoutseconds; J2 \; n2 ^/ m5 e" x+ B) Y
//connect to database
* f6 F& T3 X3 |3 M+ E1 L4 Pmysql_connect($server, $db_user);0 X* h8 S" z; w
//add the timestamp from the user to the online list% U! |) N( l! ^* j6 N
$insert = mysql_db_query($database, "INSERT INTO useronline VALUES& I& g% S4 w' C( x+ T
('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");
5 @) ?- W3 U: X1 G3 B: q4 Nif(!($insert)) {, p Z, ]* a" X/ B! U' b
print "Useronline Insert Failed > ";
& H% N" y d- k8 @/ @}- t5 @# k$ J2 Q& C: t
//delete the peoples which haven't been online/active in the last $timeoutseconds seconds./ Q' A3 @1 w9 l3 [% I8 L# y
$delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");
! m- D1 R% H) V9 A; N: o: v) Vif(!($delete)) {
5 a# j1 k. Y4 a; nprint "Useronline Delete Failed > ";" U0 P* N! p; a F2 U4 A, | ^/ B
}
' ^4 o, `- k. [8 v- f//select the amount of people online, all uniques, which are online on THIS page
. Z1 N5 ]7 F c) C" \$result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");
5 ^* k& b$ H6 @" \! O& o2 Gif(!($result)) {0 ?7 D4 R6 G) r7 }
print "Useronline Select Error > ";0 b% L- v& x# |' {5 j0 R
}5 T( D- z# j! D- J" v% k8 k
//Count the number of rows = the number of people online, Y7 v; g8 ~& f8 Q6 c4 w3 w1 ^
$user = mysql_num_rows($result);+ p' Y7 f3 T. a- K) V4 e
//spit out the results
; j% j9 o. Z: [6 y) c: ~mysql_close();) S4 U# y1 e8 k& W+ H, o
if($user == 1) {
% A: i! i5 c) }print("1 user online\n");
. n/ I( j( q2 |} else {
+ o% n( \, I" m8 I& A1 t8 o* w7 Iprint("$user users online\n");* P/ {# J- i( l; J& j
}) s. S! `& f1 C, l, X- H
?>
: l1 M4 v8 `% a7 W3 [, o
( J) O. e% [4 j以上代码我是在时代互联提供的免费试用主机上测试的,感觉效果还不错,性能很稳定,不信的话你也可以去试试。当然,记得指出我这个程序中的不足先哦。1 h7 U6 E/ G2 B5 `
时代互联是行业内最早开始提供PHP 虚拟主机的公司之一,现在已经是的金牌域名注册商和中国互联网客户满意度十佳单位,产品功能已经非常完善 ,特别提一下几个特有用的功能:数据库自动备份、免费集成繁简通简装版、多域名绑定、多子网站支持、GCDN 网站加速器、镜像加速、高级访问统计系统、支持WAP、可选电信/网通/香港机房。
7 B; f9 q: r/ q# h8 G. q+ O我之前建站的时候选的是他们公司标准商务E型,因为这款机型还特别支持ASP.NET3.5(3.0/2.0/1.1)/ASP。9 c" A3 S6 p# R3 B
当然啦,这两款主机也是相当不错的。% W C K: }) f9 `( ]
智强商务B型:Unix /Linux 操作系统+独立网页空间1000MB+送1000MB邮局空间+100MB MySQL数据库空间=1869元/年
4 F! v: T4 b) ^' ~标准商务B型:Unix /Linux 操作系统+独立网页空间500MB+送800MB邮局空间+60MB MySQL数据库空间=1365元/年
$ l- a4 \( \6 ]6 l- v l: V提供一下这个公司的联系方式:请见:http://www.now.cn/vhost/ % O, |) T' d9 q% a. b6 @1 f
空间专线: 0756-2623871 QQ:168075865,好象还有全球免费网络电话:全球免费咨询电话 http://www.now.cn/callcenter/call.net?LineName=55; G. @1 Q* s* i: K4 _! n2 O7 F
自己加QQ去问吧。 |
|