返回列表 发帖

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

刚用PHP写了一个网站在线人数的程序,请大家进来指点下!0 J2 A8 {7 V- V2 ?4 p" ~
我是用PHP+MYSQL来写的,原理:网站在线人数的程序代码+后台有MYSQL数据库支持,可以直接统计出网站当前的在线人数。2 D7 f# G& o5 g' T5 a3 Z
首先我创建MYSQL数据库表。, a4 F2 b/ [  q0 w
CREATE TABLE tablename (
0 |4 ^; M; n( mfield type(max_length) DEFAULT 'default_value' (NOT) NULL% F; T$ q% \+ b. }$ X6 P9 `" T
}可以使用的SQL语句。& \! Y2 k7 R" R0 `$ _
CREATE TABLE useronline (. j5 u/ f8 J0 ?/ O+ A* N
timestamp int(15) DEFAULT '0' NOT NULL," q" a) j3 N2 Z* \5 t
ip varchar(40) NOT NULL,
# ]; y) n, h, Wfile varchar(100) NOT NULL,
2 @+ S* h$ v! d8 hPRIMARY KEY (timestamp),
  k+ _' r9 ^4 QKEY ip (ip),- d. s1 d+ b/ k: d/ T- ?/ b
KEY file (file)
# \/ V+ r! ^% @6 p1 D/ G& T);下面我们是PHP脚本,首先我定义MYSQL的信息。
0 h% G7 S5 v+ A! i/ q$server = "localhost"; //你的服务器
. F9 h3 F8 p. |& D$db_user = "root"; //你的mysql的用户名
) M4 s( z1 M2 X, u' ?8 g2 t$db_pass = "password"; //你的mysql的密码
: D  `" [, j% o1 A$ G4 Y$database = "users"; //表的名字设置统计的时间(多少秒内在线人数)8 p/ Z  c+ l% P  v
$timeoutseconds = 300;取当前时间。
; N* o: Y  ^( I- F  H, Y/ \$timestamp = time();上面的完整代码:
1 ?6 w% I+ a) g2 H" R. V<?php
: T4 Q9 t0 d. Z" t$server = "localhost"; //your server- Q3 T4 n3 P7 ^  ~# e* |
$db_user = "root"; //your mysql database username7 z/ p4 l- ^% x3 u: ?
$db_pass = "password"; //your mysql database password if any( A3 ]; U$ {; e' }0 B4 q
$database = "users"; //the db name
) r6 E  F1 h% g/ `5 ?$timeoutseconds = 300;//timeoutseconds limit- P: W$ {! w. d3 h" U2 k: ]" k
//get the current time# `/ g/ `- x7 f. j5 q
$timestamp = time();
4 R# \1 d' q. U) C, t//calculate the lowest timestamp allowed
' j' n! E: S: ~. p3 A( v. G  B$timeout = $timestamp-$timeoutseconds;
2 W$ S4 T6 _& H3 x2 F?>连接mysql
/ P9 {: {+ i- D* Lmysql_connect('localhost', 'username', 'password');也允许使用变量形式。
: S8 T, g' o8 Q, k7 _mysql_connect($server, $db_user, $db_pass);如果mysql数据库没有密码的话可以使用下面代码连接7 O: r) g9 y3 K# |3 `/ {
mysql_connect($server, $db_user);查询数据库的代码:
/ E) X8 M$ u  c: |; K, e" _) b$ l9 wmysql_db_query('database', 'query');我们只要有访客就要增加一条记录。
2 {2 V- ^& S0 e! L4 H, Q- Y. B7 ~$insert = mysql_db_query($database, "INSERT INTO useronline VALUES
2 ?0 o5 O5 Z( \- l, D( l('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");
( ~" R# r6 _( }; i& J! }7 E& Q如果用户用错误信息的话,这样处理。! }) y! A7 p4 V$ ]! G2 J3 f/ E
if(!($insert)) {
; I8 {  @7 k/ wprint "Useronline Insert Failed > ";3 q: H3 }2 \+ Y' Y( F6 m5 J
}然后实现当超过设置的时间就删除该用户记录。
: c1 H; ^0 C1 w/ R2 e$delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");同样给出删除记录出错的处理。
# }6 G, l( J7 `- i- f) }1 J: fif(!($delete)) {7 i, l7 {; ]3 m; |
print "Useronline Delete Failed > ";
9 K9 H7 \$ ]: U* A: e/ v2 N* s: q}下面我们解决数据库中不同IP的问题
, T) H1 X4 v/ }  C  X4 X; [$result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");使用; |: X! c& `; m  e4 ?  g
mysql_num_rows(query);来统计用户,代码如下。
. Y' D' S; z2 G4 g4 [$ A: f; _$user = mysql_num_rows($result);最后关闭数据库。. ]& s. M9 `/ A4 s
mysql_close();显示在线的人数。
- H* ~/ U7 r) A! R. e! e& Z: x  Hif($user == 1) {
* k4 k, B$ B1 z/ d' ]9 Hprint("1 user online\n");
8 E# o, s9 T0 d  K} else {
: K( t5 i* V4 T- Yprint("$user users online\n");' y% A5 m  t5 B* E9 h7 ?9 _( m
}最终把上面代码写成一个PHP文件如下。# C- U$ L# g; W7 J. N
<?php" @! |1 a/ A* j) c
//Put your basic server info here
. U, t5 ]; W0 T2 p# Q1 Y: S( b$server = "localhost"; //normally localhost
( F4 [2 T9 U9 O. G# c( c" P) z5 T0 F$db_user = "root"; //your MySQL database username
4 i, ?) [6 q, V9 i8 j) V$db_pass = "password"; //your MySQL database password7 T' e" I- Y$ r; g
$database = "users";4 _; i% r  h; S1 `1 |* ]' _
$timeoutseconds = 300; //it will delete all people which haven't refreshed(so probbably are& N( O3 S5 D" r
// offline or inactive) in $timieoutseconds time (so it actually checks the people that are active in the last% b' X, T& }$ y3 V( s, ]- y2 a& {
// $timeoutseconds seconds)
% W7 f& g/ t3 ]//this is where PHP gets the time
5 u6 E/ y% Y6 y1 p+ B$timestamp = time();
4 d; I( ~4 g: h. }# T//counts the timeout, all people which have been seen last online in earlier than this timestamp, will get removed( m* b) X& m- T# t- b7 f
$timeout = $timestamp-$timeoutseconds;6 h9 l8 w6 k( r/ R
//connect to database& M7 |' I& W) `6 R9 b
mysql_connect($server, $db_user);$ T: u& L8 g3 Z& C
//add the timestamp from the user to the online list! A5 }6 p# N, i  k, b+ d
$insert = mysql_db_query($database, "INSERT INTO useronline VALUES  R6 X& V2 z0 U& i; g9 E- r
('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");
, I( f. _7 V7 ?  {( T5 y! yif(!($insert)) {0 Z6 k: V/ |! L# a. P- C
print "Useronline Insert Failed > ";( P/ [. F3 t6 w3 c
}+ ^: Q5 t: @* X+ R
//delete the peoples which haven't been online/active in the last $timeoutseconds seconds.5 N% c6 M; i1 r: v! X6 z7 u
$delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");+ @; C0 L7 u) ~* W( m: W2 z1 A/ b
if(!($delete)) {3 b" T5 j( E( ]! L
print "Useronline Delete Failed > ";$ G- q8 U  @8 D0 V. O$ Y6 n
}8 n4 S( S' W/ J
//select the amount of people online, all uniques, which are online on THIS page
* K% ]4 L. |1 X8 w$result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");' G. Q( c# J$ `0 J' w/ x5 ~
if(!($result)) {! t3 x7 d- T+ z% o! w
print "Useronline Select Error > ";( @, n2 _% H  c  t3 t
}
) g3 t8 S6 _. c3 f  M, k//Count the number of rows = the number of people online
/ y  I$ {# P$ L5 d: r: q! b$user = mysql_num_rows($result);
- _8 c0 A4 m2 M7 ^2 ?//spit out the results
& D6 }. e6 X: Z) P; Amysql_close();( d6 z: q9 Y- B# j
if($user == 1) {6 a! \6 K5 u; O. u, p
print("1 user online\n");
. \$ |7 f, q% M' q+ j} else {$ m; G' i8 ]1 M; U5 b& E
print("$user users online\n");4 N6 `7 _0 \) c3 ^
}2 k' m0 Z3 m6 b
?>
- R9 m$ r/ d# R* D$ I' b& P2 x$ ^
! Z( a$ _0 h! w2 T- }7 [9 t以上代码我是在时代互联提供的免费试用主机上测试的,感觉效果还不错,性能很稳定,不信的话你也可以去试试。当然,记得指出我这个程序中的不足先哦。! R5 T. P# ~* z6 u& W
时代互联是行业内最早开始提供PHP 虚拟主机的公司之一,现在已经是的金牌域名注册商和中国互联网客户满意度十佳单位,产品功能已经非常完善 ,特别提一下几个特有用的功能:数据库自动备份、免费集成繁简通简装版、多域名绑定、多子网站支持、GCDN 网站加速器、镜像加速、高级访问统计系统、支持WAP、可选电信/网通/香港机房。
, g) ]$ [" ]9 k' c, ]# d我之前建站的时候选的是他们公司标准商务E型,因为这款机型还特别支持ASP.NET3.5(3.0/2.0/1.1)/ASP。) H# T3 ^* A4 P
当然啦,这两款主机也是相当不错的。( o% Z. M, x$ s( q7 x8 B
智强商务B型:Unix /Linux 操作系统+独立网页空间1000MB+送1000MB邮局空间+100MB MySQL数据库空间=1869元/年
& c6 {2 {7 r5 f# I标准商务B型:Unix /Linux 操作系统+独立网页空间500MB+送800MB邮局空间+60MB MySQL数据库空间=1365元/年
8 F4 K1 M0 Z( T% M" J% C2 D提供一下这个公司的联系方式:请见:http://www.now.cn/vhost/ 0 G6 @2 v9 g1 X' v
空间专线: 0756-2623871  QQ:168075865,好象还有全球免费网络电话:全球免费咨询电话 http://www.now.cn/callcenter/call.net?LineName=55
3 k( @* l4 K% E! k9 [7 o自己加QQ去问吧。

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