返回列表 发帖

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

刚用PHP写了一个网站在线人数的程序,请大家进来指点下!- X3 T7 ^1 r" y. Z3 I
我是用PHP+MYSQL来写的,原理:网站在线人数的程序代码+后台有MYSQL数据库支持,可以直接统计出网站当前的在线人数。. K* q' |7 L9 m' W
首先我创建MYSQL数据库表。: }: }% e4 H7 ]- c8 o; X' A' f4 G4 _
CREATE TABLE tablename (% ]% w, G, V8 b1 ^
field type(max_length) DEFAULT 'default_value' (NOT) NULL
6 O. t0 T/ J4 J' j+ t1 f}可以使用的SQL语句。
( i& r$ O$ T& ~* |* @% d, JCREATE TABLE useronline (- `8 {2 V! m7 K; y7 A, }2 ~
timestamp int(15) DEFAULT '0' NOT NULL,
! w7 G: J5 r) wip varchar(40) NOT NULL,
$ M% V9 z5 p6 A& ~# _6 r% afile varchar(100) NOT NULL,
6 N: R6 G. ]8 [; XPRIMARY KEY (timestamp),9 }; l$ f" G# Q) e; d( E
KEY ip (ip),, j- q# y. u; V+ |
KEY file (file)& b% Q1 ~* W. Z9 ?' s
);下面我们是PHP脚本,首先我定义MYSQL的信息。6 y/ `# s* s) v/ E1 d
$server = "localhost"; //你的服务器: V! b4 E& s% a0 f3 ~7 v
$db_user = "root"; //你的mysql的用户名
! [: Z4 E, ~! R, C* [, W$db_pass = "password"; //你的mysql的密码- V2 U0 q4 t: ~) q. ], i
$database = "users"; //表的名字设置统计的时间(多少秒内在线人数)
- x9 g: a: d" Q/ T. u" H$timeoutseconds = 300;取当前时间。
. Y  |) C& F4 S' x& B$timestamp = time();上面的完整代码:% Z& r+ q3 ]" a% [8 A% N
<?php
9 E3 W/ L: _1 \% [4 M$server = "localhost"; //your server
: j/ b& B0 z% V1 J* B- B$db_user = "root"; //your mysql database username
( Z$ ^. A% [1 p- ^$db_pass = "password"; //your mysql database password if any& u+ [' V2 B3 {7 P9 e
$database = "users"; //the db name
- H% ?; D3 Y7 z2 h8 P+ s* @$timeoutseconds = 300;//timeoutseconds limit
: \0 g! I  D1 g! l- g2 P//get the current time' e1 S& A8 `! r7 A* P. J
$timestamp = time();
( i0 Y% l# |) T: A5 A7 ~: W//calculate the lowest timestamp allowed8 \) l) H7 N& S9 C
$timeout = $timestamp-$timeoutseconds;
+ T; E; x  j1 O4 s+ G?>连接mysql
6 u9 ^: S; i. j- ]1 w) pmysql_connect('localhost', 'username', 'password');也允许使用变量形式。2 K/ y8 X% d+ }( a; c& f+ ^
mysql_connect($server, $db_user, $db_pass);如果mysql数据库没有密码的话可以使用下面代码连接# F& s( F1 P: f9 G
mysql_connect($server, $db_user);查询数据库的代码:  ^& L2 q" P! b* y! l7 I% H7 y
mysql_db_query('database', 'query');我们只要有访客就要增加一条记录。
, g$ [5 H6 y: n/ x& ~$insert = mysql_db_query($database, "INSERT INTO useronline VALUES
3 g6 j# R; i3 l('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");% H$ b$ `1 M; S5 J
如果用户用错误信息的话,这样处理。
, f/ v  D9 p) M, z& m- R4 Cif(!($insert)) {
, Q( r& m4 i9 R, |9 E5 ]print "Useronline Insert Failed > ";
8 d( ~  j/ Z: q. V0 p. F- O+ y}然后实现当超过设置的时间就删除该用户记录。
2 V" {" u( o* b$delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");同样给出删除记录出错的处理。2 k& E8 Y4 E4 d, Y6 K
if(!($delete)) {
" t7 o: O6 c  k4 {  Q9 ]( c$ i# ~4 t& g& |' |print "Useronline Delete Failed > ";
% M# Z/ o! N4 d2 l1 n% [}下面我们解决数据库中不同IP的问题
4 |$ l, d$ s' V; p1 r3 W" ^) V$result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");使用  ^: S, i7 n9 Q
mysql_num_rows(query);来统计用户,代码如下。0 V3 Z1 _% l- f0 {
$user = mysql_num_rows($result);最后关闭数据库。
/ K. y$ I8 v7 L6 z- f2 _% Xmysql_close();显示在线的人数。, b' j/ g7 X% F+ F, o3 m8 K
if($user == 1) {9 ?' j* O7 e2 I' J+ F
print("1 user online\n");
2 ~9 z' R" V# k* P7 h6 T0 m4 I} else {
: z0 Y6 g1 }+ }) Kprint("$user users online\n");1 p6 Q9 H; n$ p
}最终把上面代码写成一个PHP文件如下。$ A! c9 D, K3 Y; E' R
<?php
8 n3 p; O; p2 U/ O//Put your basic server info here
+ j8 E( z8 w6 ^, o1 L+ k) B. C$server = "localhost"; //normally localhost
2 V# V2 S3 }# F$db_user = "root"; //your MySQL database username
& g' b8 Q6 c) W# |7 I$db_pass = "password"; //your MySQL database password
$ ^4 s. o4 B& @) c! f- O$database = "users";
! y6 M0 P2 [6 I8 Y# `: E, j" s3 {$timeoutseconds = 300; //it will delete all people which haven't refreshed(so probbably are% O) n# {" S7 M5 [0 Q
// offline or inactive) in $timieoutseconds time (so it actually checks the people that are active in the last
6 B! Z. {/ ^2 F// $timeoutseconds seconds)! g2 H# U' e2 ?  P5 l
//this is where PHP gets the time" p& T  b% y8 n% l9 D0 k
$timestamp = time();( I4 ^* `0 \2 A2 T7 P) t' o5 `6 J
//counts the timeout, all people which have been seen last online in earlier than this timestamp, will get removed
/ M4 \: n# `2 I# r' B+ h$timeout = $timestamp-$timeoutseconds;
, ~0 _+ s+ J5 \6 k3 q# r1 A//connect to database: S9 H4 x% P6 F6 G2 q
mysql_connect($server, $db_user);2 u; d0 w- Z2 t. @
//add the timestamp from the user to the online list
9 I* K; u% l; ]/ r$insert = mysql_db_query($database, "INSERT INTO useronline VALUES
: Q% X/ d) Q  H" D* @- e' s: p('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");/ a% a7 p9 K' n7 f. e! T+ \
if(!($insert)) {+ z' X$ K- W! @% Y) G# W
print "Useronline Insert Failed > ";
0 a3 a& ?2 `" K. U}: s0 N4 [# F+ O" @- R& Y6 r) R
//delete the peoples which haven't been online/active in the last $timeoutseconds seconds.& a. x# Q" J! a' ~- s+ y
$delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");( z; h$ N" `4 o3 D4 f; a3 C* k
if(!($delete)) {
2 t2 R# R( b1 ]$ F3 T1 m' I9 lprint "Useronline Delete Failed > ";/ J  F( h4 y; b. e& E& Z: G1 W
}
+ h: q" R( q9 z% J( i3 O3 @//select the amount of people online, all uniques, which are online on THIS page" T5 Q, X- m; L( d' V! D
$result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");, u' {- v. D7 q
if(!($result)) {3 `" q4 m6 w" V0 X' s
print "Useronline Select Error > ";
7 I' }3 c; ^8 _' \* L* e8 C! q; \}# b' j+ b! X1 K7 Z4 e
//Count the number of rows = the number of people online
  l* s; |! ~2 t# [6 z$ g0 y$user = mysql_num_rows($result);
( ~/ j# h. F; ]3 \+ }//spit out the results
; f( n  g/ {+ I4 J7 d( h. smysql_close();4 i* h0 l$ R: e% k9 ]
if($user == 1) {. g+ v" ~: V- n
print("1 user online\n");
. ]5 K$ w# t# h; x4 `/ I9 R} else {
* O! R, D0 _0 m; Rprint("$user users online\n");
: P  N3 Y) c3 D: J  \}: L, H4 `6 t4 G4 ~4 J% z1 I
?>
; M" ?* n) M2 G9 l
8 _0 H8 r+ `; e- H0 R& O以上代码我是在时代互联提供的免费试用主机上测试的,感觉效果还不错,性能很稳定,不信的话你也可以去试试。当然,记得指出我这个程序中的不足先哦。2 r! Z4 m8 y$ ^1 d1 F
时代互联是行业内最早开始提供PHP 虚拟主机的公司之一,现在已经是的金牌域名注册商和中国互联网客户满意度十佳单位,产品功能已经非常完善 ,特别提一下几个特有用的功能:数据库自动备份、免费集成繁简通简装版、多域名绑定、多子网站支持、GCDN 网站加速器、镜像加速、高级访问统计系统、支持WAP、可选电信/网通/香港机房。
- V7 X+ k* ]6 N7 B! W; R我之前建站的时候选的是他们公司标准商务E型,因为这款机型还特别支持ASP.NET3.5(3.0/2.0/1.1)/ASP。
* A; W  l" ^  n% `& V/ u3 Y( J当然啦,这两款主机也是相当不错的。. i- Q  k  a2 m% |% P  j# O* |
智强商务B型:Unix /Linux 操作系统+独立网页空间1000MB+送1000MB邮局空间+100MB MySQL数据库空间=1869元/年6 B( {6 ]$ f* C; ^+ P/ {( D
标准商务B型:Unix /Linux 操作系统+独立网页空间500MB+送800MB邮局空间+60MB MySQL数据库空间=1365元/年  F* `+ g- m$ U
提供一下这个公司的联系方式:请见:http://www.now.cn/vhost/ ) ]! z8 Y9 }0 e9 H; H2 x" W
空间专线: 0756-2623871  QQ:168075865,好象还有全球免费网络电话:全球免费咨询电话 http://www.now.cn/callcenter/call.net?LineName=55
+ I  }3 |4 {: z5 @' {3 s& V! s自己加QQ去问吧。

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