|

- UID
- 455
- 帖子
- 3
- 精华
- 0
- 积分
- 8
- 金币
- 3
- 威望
- 0
- 贡献
- 0
|
刚用PHP写了一个网站在线人数的程序,请大家进来指点下!
刚用PHP写了一个网站在线人数的程序,请大家进来指点下!( g. t# C- k0 Q( `, c. h
我是用PHP+MYSQL来写的,原理:网站在线人数的程序代码+后台有MYSQL数据库支持,可以直接统计出网站当前的在线人数。
+ T! ]* A0 z; K f4 }6 p# A首先我创建MYSQL数据库表。
/ e# i5 J8 @# c- Z; Y7 R. |CREATE TABLE tablename (
; n& k: d2 q) l/ j, z' ?; f9 t0 Ffield type(max_length) DEFAULT 'default_value' (NOT) NULL
3 R, p( {( g7 J1 l}可以使用的SQL语句。
8 T- \, M$ W. C6 d) a7 QCREATE TABLE useronline (
' {9 U) [3 d4 d" s; Jtimestamp int(15) DEFAULT '0' NOT NULL,2 n8 S9 d& k# W* \& y
ip varchar(40) NOT NULL,
( e9 a$ g1 Z5 o1 J* w9 ?$ @file varchar(100) NOT NULL,. v& j1 X( r8 l7 W# e$ c
PRIMARY KEY (timestamp),
6 a" M0 ^/ v) zKEY ip (ip),
' l$ A, x$ ?3 B; z! a$ V' w) SKEY file (file)8 W0 a- {2 W& n8 G) H4 e
);下面我们是PHP脚本,首先我定义MYSQL的信息。# j8 V6 Y" S7 |
$server = "localhost"; //你的服务器
2 q1 [; l w" M: M) M' h$db_user = "root"; //你的mysql的用户名
' n' R4 D! s: y$db_pass = "password"; //你的mysql的密码# q t# v% T. \2 U
$database = "users"; //表的名字设置统计的时间(多少秒内在线人数)
. ^$ x" C; S2 Y2 V3 z* @4 v& N3 v8 c4 G$timeoutseconds = 300;取当前时间。
$ O/ u5 G5 s* q4 X$timestamp = time();上面的完整代码:& R2 a. D/ G; u+ U, P- X+ i
<?php* [; P* a) |4 H- u. T9 Y* O( a5 A
$server = "localhost"; //your server+ j) `$ K* r2 P- w- d
$db_user = "root"; //your mysql database username
' S7 f* L. m) k8 F$db_pass = "password"; //your mysql database password if any! C" v/ D, G/ N0 [
$database = "users"; //the db name" s0 }8 [# H% e$ w
$timeoutseconds = 300;//timeoutseconds limit
& F& t. P% r* x; t& s$ d9 |3 Q+ a& a//get the current time
( W. }6 J; _( H0 j, u% _+ j5 a$timestamp = time();
* c7 e: e* U! ?7 S) D/ Y5 u//calculate the lowest timestamp allowed# O- {* p N; B C' p
$timeout = $timestamp-$timeoutseconds;, G- F3 D9 o" f4 A7 e' U
?>连接mysql
1 A+ r" R3 u: F S: S# xmysql_connect('localhost', 'username', 'password');也允许使用变量形式。
[5 i4 G# X) R5 X& ~. b% nmysql_connect($server, $db_user, $db_pass);如果mysql数据库没有密码的话可以使用下面代码连接
, N1 [' ]/ P5 v: c! z3 o0 wmysql_connect($server, $db_user);查询数据库的代码:
5 G- c) U c9 ^0 T1 d7 ~mysql_db_query('database', 'query');我们只要有访客就要增加一条记录。
/ u6 l- B# m4 X9 s1 b0 k: W2 o$insert = mysql_db_query($database, "INSERT INTO useronline VALUES
# A2 \* S3 L+ j1 R% x/ A! B('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");" |2 I* B4 `7 |* h7 _: J( A( _
如果用户用错误信息的话,这样处理。5 g6 d1 c1 Z1 g v* B( N
if(!($insert)) {6 [* Z* J) y3 |! G. R; h% ]
print "Useronline Insert Failed > ";7 T' g: M2 W u4 Y" _' M
}然后实现当超过设置的时间就删除该用户记录。+ K! X1 E* P% W% X$ J' M- s5 o
$delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");同样给出删除记录出错的处理。
; c" [- g" ` Wif(!($delete)) {/ \! O& y3 \: e- B# u1 d- k/ h
print "Useronline Delete Failed > ";
; w& z+ k1 e! c3 n3 e- w}下面我们解决数据库中不同IP的问题
( I0 k7 S2 P& R/ E0 A, |$result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");使用" e8 T& G$ ]2 N3 _* n1 g' w6 q
mysql_num_rows(query);来统计用户,代码如下。
$ z( Q: Y" W) e/ @: b" u+ H$user = mysql_num_rows($result);最后关闭数据库。
* x, X8 Q# M# W% l, j4 q' i4 G% `mysql_close();显示在线的人数。
0 M$ }5 B0 e+ U1 M$ s4 G. Hif($user == 1) {, t; B+ \( ?- _+ U0 }; O+ ]
print("1 user online\n");1 }, q- o) k( V. p5 ]
} else {
, x8 Q7 A6 c/ j) iprint("$user users online\n");
; @# R" A/ f' n [}最终把上面代码写成一个PHP文件如下。
! w n0 |4 M% Y+ m1 y/ E<?php
/ S @8 o( A# j7 x' e# i//Put your basic server info here, W8 @( P& i4 o7 V2 A: X2 k
$server = "localhost"; //normally localhost
' n& e0 P, Q: G0 W; g, ?; m$db_user = "root"; //your MySQL database username8 v. h) ]/ i2 \- |( v; R2 r
$db_pass = "password"; //your MySQL database password2 A V8 O. R: L+ c! @# [. c3 P/ o2 v
$database = "users";$ z ]% n2 T, f @4 y6 I' ^
$timeoutseconds = 300; //it will delete all people which haven't refreshed(so probbably are) c O( T2 |$ J V! ~9 B
// offline or inactive) in $timieoutseconds time (so it actually checks the people that are active in the last
, c+ b, x3 Y1 @9 `6 q" e// $timeoutseconds seconds)/ O8 C. `1 u/ ~& y5 h. P
//this is where PHP gets the time# o% y5 U) h; ~6 u; r3 B! z
$timestamp = time();
6 A% X2 x1 e) d" [$ n8 h//counts the timeout, all people which have been seen last online in earlier than this timestamp, will get removed" k1 Q9 U$ Z7 }. t, I2 ]4 r
$timeout = $timestamp-$timeoutseconds;
7 |0 c2 E8 \( S) X9 j! a, t//connect to database
) G8 R2 @5 Y; ~6 {4 V6 h' Zmysql_connect($server, $db_user);
) w. K9 V# P0 m4 k i# }//add the timestamp from the user to the online list
; G7 U! k; E4 e/ G# l6 V" e5 {$insert = mysql_db_query($database, "INSERT INTO useronline VALUES4 a& D- Q& c c; {$ O; |$ j8 A/ h% K
('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");! o7 H0 ]% ?' H* S
if(!($insert)) {
, `: ^$ t6 O2 ]( vprint "Useronline Insert Failed > ";
! T# s. E! T5 L" u9 m0 c}2 n( a6 T- }. W. D. b
//delete the peoples which haven't been online/active in the last $timeoutseconds seconds.8 ?4 m( |8 s5 k+ i7 G7 j
$delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");
, O' f1 u* t4 p3 ]: ^3 p" {if(!($delete)) { p ]! E6 A+ z. }
print "Useronline Delete Failed > ";, w( P5 Z! J9 y3 L
}
% v/ R& Z1 J! y8 D2 [9 F6 L//select the amount of people online, all uniques, which are online on THIS page
K& m" Z' a v* v9 f$result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");8 L1 F# |7 Z* X1 d$ x9 k
if(!($result)) {5 X7 Q) w$ J; w; l6 D
print "Useronline Select Error > ";7 M, Q- r3 A1 m4 \' O9 g
}7 b: J% [& j/ ^% V2 I; j" y. Y
//Count the number of rows = the number of people online8 S" v/ n0 `2 N5 v0 g( K- p
$user = mysql_num_rows($result);" N. W$ m6 T; l! H2 ]) y
//spit out the results
1 \' P, B5 }0 D6 @% Nmysql_close();7 v% \2 R8 |; |5 E; j
if($user == 1) {+ `6 O/ [' g8 s% T
print("1 user online\n");
8 m* u: M, s+ D+ n} else {
' Z( G z: X- vprint("$user users online\n");
) x3 u; I' n# Y0 C# p}6 b" D' `5 {0 |6 K
?>( |( u/ A8 X2 b3 y
, _; S1 j; P) t+ r( H6 a8 K
以上代码我是在时代互联提供的免费试用主机上测试的,感觉效果还不错,性能很稳定,不信的话你也可以去试试。当然,记得指出我这个程序中的不足先哦。 a. z/ p H5 g6 h H' E9 ~/ q
时代互联是行业内最早开始提供PHP 虚拟主机的公司之一,现在已经是的金牌域名注册商和中国互联网客户满意度十佳单位,产品功能已经非常完善 ,特别提一下几个特有用的功能:数据库自动备份、免费集成繁简通简装版、多域名绑定、多子网站支持、GCDN 网站加速器、镜像加速、高级访问统计系统、支持WAP、可选电信/网通/香港机房。
" d* ?, ?! |; h1 [7 ^' i& g* I0 f我之前建站的时候选的是他们公司标准商务E型,因为这款机型还特别支持ASP.NET3.5(3.0/2.0/1.1)/ASP。
( P/ \; f2 B- s" S. Q8 Q3 Z当然啦,这两款主机也是相当不错的。0 z- R, N. J- ^7 @# h! a8 o
智强商务B型:Unix /Linux 操作系统+独立网页空间1000MB+送1000MB邮局空间+100MB MySQL数据库空间=1869元/年( I$ r- {/ H5 m2 v1 k
标准商务B型:Unix /Linux 操作系统+独立网页空间500MB+送800MB邮局空间+60MB MySQL数据库空间=1365元/年( W- a& f2 }* L; h
提供一下这个公司的联系方式:请见:http://www.now.cn/vhost/
4 p' f& E* C( S, ^" i7 t空间专线: 0756-2623871 QQ:168075865,好象还有全球免费网络电话:全球免费咨询电话 http://www.now.cn/callcenter/call.net?LineName=55) {) A& n8 v6 r. u. y. k% Y' I
自己加QQ去问吧。 |
|