|

- UID
- 455
- 帖子
- 3
- 精华
- 0
- 积分
- 8
- 金币
- 3
- 威望
- 0
- 贡献
- 0
|
刚用PHP写了一个网站在线人数的程序,请大家进来指点下!
刚用PHP写了一个网站在线人数的程序,请大家进来指点下!
( n% @7 Y6 q1 c: \1 N我是用PHP+MYSQL来写的,原理:网站在线人数的程序代码+后台有MYSQL数据库支持,可以直接统计出网站当前的在线人数。' n2 L9 v* d5 G3 I( \$ |
首先我创建MYSQL数据库表。
4 N4 a) x5 D& bCREATE TABLE tablename (# ]/ o, L* d$ N; f4 ?/ G
field type(max_length) DEFAULT 'default_value' (NOT) NULL( P" e9 E- s; X
}可以使用的SQL语句。
: w- s2 f U0 r7 ?0 S/ iCREATE TABLE useronline (, `$ r4 T% {5 |/ F& N: Y) J
timestamp int(15) DEFAULT '0' NOT NULL," R7 Z. ]0 A) b5 r# K/ T- H& o
ip varchar(40) NOT NULL,3 H0 R0 q! Y! s% E1 c) ?" }8 W; Z1 [
file varchar(100) NOT NULL,0 Y. a' |8 j+ J' P! w- o6 y7 H% a0 t
PRIMARY KEY (timestamp)," y. g- ^" k0 S
KEY ip (ip),
' m+ j3 O# t) U& TKEY file (file)
$ B+ |; J- p: `7 Y1 j);下面我们是PHP脚本,首先我定义MYSQL的信息。
* |; W1 A0 e3 U$server = "localhost"; //你的服务器+ Z. z/ s( x4 C: ^) Z+ x+ N
$db_user = "root"; //你的mysql的用户名
! ?9 E* ^- ?; h: q, S/ f' h( o$db_pass = "password"; //你的mysql的密码
7 S0 Y6 G8 r, o4 B# q$database = "users"; //表的名字设置统计的时间(多少秒内在线人数)
3 G! r$ O" J9 L' i# m$timeoutseconds = 300;取当前时间。
" H. p b& Y D* q* y d" M$timestamp = time();上面的完整代码:3 l0 a/ F, Z1 k! k
<?php: m$ V4 j5 j" o$ ?8 t
$server = "localhost"; //your server, _: c( f1 M1 k6 ^- J9 O" L6 c
$db_user = "root"; //your mysql database username
5 Q. b# R/ t l6 ^% {) w$db_pass = "password"; //your mysql database password if any% I: ^! d& h% |& q5 V/ `
$database = "users"; //the db name
0 s; @- n3 M# [2 J" k$ r$timeoutseconds = 300;//timeoutseconds limit
. D' d8 h* V7 ~3 S//get the current time
/ {7 H( h! l; d: G6 q( x$timestamp = time();
r1 I* O' [% [3 |" j+ k//calculate the lowest timestamp allowed
" J& ^% m# W; y2 n0 e6 ?) t$timeout = $timestamp-$timeoutseconds;: e/ b9 `. i7 R1 O) q! s" D
?>连接mysql: C, F' S1 P+ G' P5 t
mysql_connect('localhost', 'username', 'password');也允许使用变量形式。- S; q' q: J: K. Q* D2 _5 _& \
mysql_connect($server, $db_user, $db_pass);如果mysql数据库没有密码的话可以使用下面代码连接
# I% j# E& v' |! Qmysql_connect($server, $db_user);查询数据库的代码:) T K/ _5 d1 ^ r* e! B# m
mysql_db_query('database', 'query');我们只要有访客就要增加一条记录。; D9 \' N/ O; k$ Z
$insert = mysql_db_query($database, "INSERT INTO useronline VALUES
2 B( d/ H! n. y/ d1 u! f+ _('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");. f3 ^ d, z# g9 a* N# P6 C i5 i
如果用户用错误信息的话,这样处理。+ k0 y+ l( i! F: r5 t: t
if(!($insert)) {
- L% v, W0 M" B, d! Vprint "Useronline Insert Failed > ";# v) Q$ j8 x- ?1 _. O) O
}然后实现当超过设置的时间就删除该用户记录。1 { m* r( i1 [" X$ ~( F$ q
$delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");同样给出删除记录出错的处理。
& G- d& \/ f0 O5 }: w* W Oif(!($delete)) {
! G" [) p: K8 D: u, p' Bprint "Useronline Delete Failed > ";" I+ `* l& L; ]% e
}下面我们解决数据库中不同IP的问题
$ x9 \6 i7 U Y4 ]" F$result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");使用, B- H# `( C0 ]7 q9 n3 J; }
mysql_num_rows(query);来统计用户,代码如下。
6 `/ p6 H6 w7 w$user = mysql_num_rows($result);最后关闭数据库。
) {/ L) `7 o$ lmysql_close();显示在线的人数。
+ M% l% o; G& u- a- Xif($user == 1) {! A7 ?6 O& D" X% E
print("1 user online\n");
1 _/ D( J- C# @* ]} else {, Y8 f6 G/ @- i, w1 ^
print("$user users online\n");
: l( ?" l# y, @}最终把上面代码写成一个PHP文件如下。2 w, c4 l5 q+ g) ]
<?php9 R$ g' O( B' W" ?6 b# F9 T' G8 A
//Put your basic server info here
, Q# p; d V8 j$ z4 r& A- i( N$server = "localhost"; //normally localhost) y7 m' C* A5 d/ Q1 @0 B0 C
$db_user = "root"; //your MySQL database username/ w4 {& ^* j! P( x9 P* M, K3 d0 t- t
$db_pass = "password"; //your MySQL database password
* C4 a) F1 a$ l3 Z9 `9 F1 I$database = "users";% p& E! r" M; @. ]2 s/ z# O
$timeoutseconds = 300; //it will delete all people which haven't refreshed(so probbably are
: A7 D" V/ I( k% i// offline or inactive) in $timieoutseconds time (so it actually checks the people that are active in the last" p- [) I8 g) Y
// $timeoutseconds seconds)! t- o2 p& G1 H3 h3 p9 ~6 y( ]
//this is where PHP gets the time8 }8 F# B) e# p
$timestamp = time();( p. Z8 {/ M9 L$ g
//counts the timeout, all people which have been seen last online in earlier than this timestamp, will get removed' M. m- r) [& A$ A' j0 l: o
$timeout = $timestamp-$timeoutseconds;
6 e, V, i- q* m. m3 L' ?+ @//connect to database
+ z/ b1 X; F# ?0 Z" L _mysql_connect($server, $db_user);
+ _+ { s! G7 V5 |% v; A" I//add the timestamp from the user to the online list* j3 y5 ^" K4 y8 C
$insert = mysql_db_query($database, "INSERT INTO useronline VALUES9 p$ D( N" q. N7 Z
('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");9 V* L& D+ O" y0 K) [# i
if(!($insert)) {# S7 {. t/ {/ D, K0 u
print "Useronline Insert Failed > ";% }/ d2 H; {4 O q4 j
}0 Q/ t, O: J' b E
//delete the peoples which haven't been online/active in the last $timeoutseconds seconds.7 O; s0 a& S1 l) S% ?
$delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");
2 S5 e- ]8 B8 b+ fif(!($delete)) {' t5 |$ y q# I% |4 U8 Z4 ^4 ~% }
print "Useronline Delete Failed > ";
7 H: x& P, R! i% ^! |}
. P$ I) W1 r6 u5 a% g//select the amount of people online, all uniques, which are online on THIS page
& N! v; w& c- c# |$result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");% t1 O: [! G2 _
if(!($result)) {
: Y* N2 m% k: }2 R! ^1 ]print "Useronline Select Error > ";
9 H' v: }1 k+ S- Z1 @}% m; L' X, {' y) N1 X3 k8 F" k
//Count the number of rows = the number of people online
; L1 H' e6 t. R( c9 u$user = mysql_num_rows($result);% w1 ?* ^7 w' t- U4 f" ?
//spit out the results% x( i! A& b. r, M$ W3 @. H* N
mysql_close();$ S, z5 P- `2 D; U3 T
if($user == 1) {: a5 Z7 Z1 v" s+ N0 x# e, i! L
print("1 user online\n");3 l# p$ ]! W5 h5 n \
} else {( y7 J; m0 x! z+ A2 W. i
print("$user users online\n");
# B! i1 D+ p1 c$ \}- C) J. l0 D8 P
?>
. G% e6 q. [1 O7 D
( x7 o- w& d L+ R: {' b4 j H以上代码我是在时代互联提供的免费试用主机上测试的,感觉效果还不错,性能很稳定,不信的话你也可以去试试。当然,记得指出我这个程序中的不足先哦。
4 J e+ @; p. O$ h! f! B2 C, h; W时代互联是行业内最早开始提供PHP 虚拟主机的公司之一,现在已经是的金牌域名注册商和中国互联网客户满意度十佳单位,产品功能已经非常完善 ,特别提一下几个特有用的功能:数据库自动备份、免费集成繁简通简装版、多域名绑定、多子网站支持、GCDN 网站加速器、镜像加速、高级访问统计系统、支持WAP、可选电信/网通/香港机房。
/ y4 ~2 }( f. ]* d& _: r我之前建站的时候选的是他们公司标准商务E型,因为这款机型还特别支持ASP.NET3.5(3.0/2.0/1.1)/ASP。9 r# x1 m7 _8 U) s
当然啦,这两款主机也是相当不错的。
$ b& ^$ W% }5 [. |# S智强商务B型:Unix /Linux 操作系统+独立网页空间1000MB+送1000MB邮局空间+100MB MySQL数据库空间=1869元/年
1 y1 O% U* M7 s g' I标准商务B型:Unix /Linux 操作系统+独立网页空间500MB+送800MB邮局空间+60MB MySQL数据库空间=1365元/年
6 h0 D. \- ?7 A5 \8 ?提供一下这个公司的联系方式:请见:http://www.now.cn/vhost/ $ E( t. V$ L: f0 K1 w6 r
空间专线: 0756-2623871 QQ:168075865,好象还有全球免费网络电话:全球免费咨询电话 http://www.now.cn/callcenter/call.net?LineName=55
6 P* G$ _# |' g# j w0 x! \+ ^自己加QQ去问吧。 |
|