Board logo

标题: 刚用PHP写了一个网站在线人数的程序,请大家进来指点下! [打印本页]

作者: lilcy88    时间: 2008-5-28 10:40     标题: 刚用PHP写了一个网站在线人数的程序,请大家进来指点下!

刚用PHP写了一个网站在线人数的程序,请大家进来指点下!. Z0 a6 x6 d- K. W
我是用PHP+MYSQL来写的,原理:网站在线人数的程序代码+后台有MYSQL数据库支持,可以直接统计出网站当前的在线人数。
7 I, G& ]! D4 v0 A7 S# d首先我创建MYSQL数据库表。) {5 u- E6 `7 i. T" e9 U( r+ e7 b( v
CREATE TABLE tablename (
5 s3 ~) L: u& |0 Ufield type(max_length) DEFAULT 'default_value' (NOT) NULL
4 t7 p: d6 U( i! @* {}可以使用的SQL语句。
) v  T* m' ~/ d8 D/ ~. t7 r+ K: K$ RCREATE TABLE useronline (. h7 N3 A9 }1 }5 M+ F
timestamp int(15) DEFAULT '0' NOT NULL,
% Y' h9 x% b$ Lip varchar(40) NOT NULL,
0 b' K6 ^& A( ^5 v8 ofile varchar(100) NOT NULL,0 N5 b6 S5 j$ `+ v
PRIMARY KEY (timestamp),1 _5 b4 b) D2 K8 u  `( g3 J
KEY ip (ip),& c2 |+ e  w4 ~2 c4 g! l& e
KEY file (file)
: }  l$ J2 N' D! Z$ x2 D$ k# Q);下面我们是PHP脚本,首先我定义MYSQL的信息。
# U- i, S& W2 q5 I' k$server = "localhost"; //你的服务器( Y1 v1 B4 b! a+ n4 j6 b4 ^
$db_user = "root"; //你的mysql的用户名; k2 F% v: `8 i; K
$db_pass = "password"; //你的mysql的密码- D$ c8 F5 t( {3 P* s0 g
$database = "users"; //表的名字设置统计的时间(多少秒内在线人数)
+ j2 w- R9 q! W% k, ]$timeoutseconds = 300;取当前时间。9 F% u0 r$ O. l  C& U$ m& U3 X
$timestamp = time();上面的完整代码:! Z5 P3 f% y, f5 }' B% ]/ u9 ]
<?php. e% K9 F) ]" H4 r/ R# |" e
$server = "localhost"; //your server
, x" Z, F8 x5 L, y4 @2 ?  B$db_user = "root"; //your mysql database username
9 K/ y: D" O( i: w, K) e$db_pass = "password"; //your mysql database password if any
. i  o5 t1 I) h) v* ~: h$database = "users"; //the db name) \- X" t7 B$ O3 ?; [% ^
$timeoutseconds = 300;//timeoutseconds limit" h- b$ c. z& C. Q4 q0 ?$ ?
//get the current time
* e, H' c: _& g+ Q$timestamp = time();
4 U$ Z6 \# ^; }8 ^: @4 h//calculate the lowest timestamp allowed/ g; [2 B( t4 ~
$timeout = $timestamp-$timeoutseconds;6 k) W: |# U' z, p, O0 Q
?>连接mysql) N6 s5 E7 j& l+ ], P
mysql_connect('localhost', 'username', 'password');也允许使用变量形式。$ P3 }4 B" z8 `  [9 W" h
mysql_connect($server, $db_user, $db_pass);如果mysql数据库没有密码的话可以使用下面代码连接
( ^* O2 _  T2 m9 l/ @2 Bmysql_connect($server, $db_user);查询数据库的代码:
* w4 A4 z7 u; k$ h; _' `6 O9 Ymysql_db_query('database', 'query');我们只要有访客就要增加一条记录。
5 \# D2 i/ V8 Z$insert = mysql_db_query($database, "INSERT INTO useronline VALUES/ e/ v$ D4 ?0 S; t& U7 b1 h
('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");
- m( X! ]- g  q; H; S如果用户用错误信息的话,这样处理。
" b# m- ~8 {7 }5 X5 N. Iif(!($insert)) {; a5 Y4 p. H' {/ r) x( u
print "Useronline Insert Failed > ";
4 n. a; R3 C' A+ v# {  H7 V}然后实现当超过设置的时间就删除该用户记录。* s4 D' f* ?! v; ]& j
$delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");同样给出删除记录出错的处理。
- d% W& r" ]+ T  u6 L0 _if(!($delete)) {( N' G( T! n- g
print "Useronline Delete Failed > ";' {% L# @# X4 a* C1 U2 n. u
}下面我们解决数据库中不同IP的问题7 w& e4 [: k+ E; f3 I
$result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");使用. \9 M: I/ _- \- d4 I
mysql_num_rows(query);来统计用户,代码如下。% Z0 O3 }/ R8 p; a7 Q9 b
$user = mysql_num_rows($result);最后关闭数据库。: |1 W4 @4 q" F
mysql_close();显示在线的人数。
0 ?' ^* Y$ |; x( G; w, j; Wif($user == 1) {* L! i( Z* \# w3 \: O4 Q
print("1 user online\n");4 W! h) }; D' D5 [, L4 E
} else {
/ P! b. Q6 Q- h/ B! oprint("$user users online\n");" J2 V2 r3 N( u8 a
}最终把上面代码写成一个PHP文件如下。0 C- E/ v$ q! k/ g& E, y& T* {5 C
<?php
( d  g: {% \8 P+ @7 f//Put your basic server info here
; E" [& a' \* a3 k- z, M$server = "localhost"; //normally localhost
3 B7 q; l* C( |/ l$db_user = "root"; //your MySQL database username
" d" u- s& G& c+ H. u$db_pass = "password"; //your MySQL database password; ~, D% G. T  |9 T+ D
$database = "users";, P! X& @1 }+ [; v/ l8 G
$timeoutseconds = 300; //it will delete all people which haven't refreshed(so probbably are
  d- U* m( j9 g! M% x0 B% @// offline or inactive) in $timieoutseconds time (so it actually checks the people that are active in the last( o4 ?" m7 t! Q, v$ V& O' L# o
// $timeoutseconds seconds)8 `! u/ \5 q" B; W; ^8 K  ^
//this is where PHP gets the time
$ e+ |- H& ~* O( L5 U- h: P4 X$timestamp = time();, h1 w; ?- `( I8 A1 k& \
//counts the timeout, all people which have been seen last online in earlier than this timestamp, will get removed" W( L9 R( ?0 @. j; E& M
$timeout = $timestamp-$timeoutseconds;
: u9 C( }& S: l  z//connect to database
# K2 s! A* F* W+ y" i. N  K0 amysql_connect($server, $db_user);
$ ^! e- P* r% [+ w# \3 R& l* g1 B//add the timestamp from the user to the online list
4 e& Q0 Z. _* X# f7 P7 l) H$insert = mysql_db_query($database, "INSERT INTO useronline VALUES
7 b4 ]9 ?* _) o6 _# s0 V! d('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");
! L/ l; q$ h5 i/ E" K0 Mif(!($insert)) {
3 a8 `2 t0 S+ Hprint "Useronline Insert Failed > ";
3 F6 a' |- L: l+ Y2 J; X8 \" l}
4 E- i* r0 @* C* }) d//delete the peoples which haven't been online/active in the last $timeoutseconds seconds.
! S% n* f) }) K  |" ^8 D' W+ ]$delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");8 q# h1 b0 ^$ {5 W" I1 l  \' q4 m
if(!($delete)) {
- b- C2 t* @5 f- ]print "Useronline Delete Failed > ";2 B3 W' D; y, O' y. a# }! E- d6 c
}, L" ^4 C9 \$ V, k
//select the amount of people online, all uniques, which are online on THIS page" Q; p; Y/ S6 R+ h& {9 ]
$result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");8 Q. U: l5 x6 q- O( k5 d
if(!($result)) {
; ]5 p6 K% j  K+ }+ C/ Z8 _" y$ H0 yprint "Useronline Select Error > ";* v& ]6 T1 D, ]3 N- s' U
}
/ u! L- a$ W: m; Z% i+ u//Count the number of rows = the number of people online$ A: m9 S  ^, }) {; f5 r
$user = mysql_num_rows($result);
  N% b* P. D& n5 X2 T//spit out the results
: z* U5 `1 i$ vmysql_close();
3 u' \% n0 j+ R! P1 Pif($user == 1) {
. N( s% O1 y0 ]& pprint("1 user online\n");& w! O8 t" X+ ?
} else {! `! M  m: a2 k( y: m
print("$user users online\n");% `! a, |* V! }. h* n& f
}5 b8 ?! f& e/ W- r4 q
?>) z2 r. a) X$ g4 \
" P" `8 L) l9 o- j" z0 M
以上代码我是在时代互联提供的免费试用主机上测试的,感觉效果还不错,性能很稳定,不信的话你也可以去试试。当然,记得指出我这个程序中的不足先哦。
& b' o8 t; l) l$ u* Y; g2 a; [# f时代互联是行业内最早开始提供PHP 虚拟主机的公司之一,现在已经是的金牌域名注册商和中国互联网客户满意度十佳单位,产品功能已经非常完善 ,特别提一下几个特有用的功能:数据库自动备份、免费集成繁简通简装版、多域名绑定、多子网站支持、GCDN 网站加速器、镜像加速、高级访问统计系统、支持WAP、可选电信/网通/香港机房。
& @: t" X9 \. F我之前建站的时候选的是他们公司标准商务E型,因为这款机型还特别支持ASP.NET3.5(3.0/2.0/1.1)/ASP。- j, \9 R; r9 Y' s
当然啦,这两款主机也是相当不错的。! N( A3 x1 f! S) _" J& f
智强商务B型:Unix /Linux 操作系统+独立网页空间1000MB+送1000MB邮局空间+100MB MySQL数据库空间=1869元/年
! [/ L2 q, T2 `& L! @/ H: C& \) H标准商务B型:Unix /Linux 操作系统+独立网页空间500MB+送800MB邮局空间+60MB MySQL数据库空间=1365元/年
* r$ ?7 z, e/ _提供一下这个公司的联系方式:请见:http://www.now.cn/vhost/ 8 G" n) `3 D, }4 {) j. g- S8 R# C
空间专线: 0756-2623871  QQ:168075865,好象还有全球免费网络电话:全球免费咨询电话 http://www.now.cn/callcenter/call.net?LineName=55
) \! t+ `/ g4 ~" ]( p3 T' r; P4 P, B: Y自己加QQ去问吧。




欢迎光临 捌玖网络工作室 (http://www.89w.org/) Powered by Discuz! 7.2