|

- UID
- 455
- 帖子
- 3
- 精华
- 0
- 积分
- 8
- 金币
- 3
- 威望
- 0
- 贡献
- 0
|
刚用PHP写了一个网站在线人数的程序,请大家进来指点下!
刚用PHP写了一个网站在线人数的程序,请大家进来指点下!
r- R% O$ O& I: E我是用PHP+MYSQL来写的,原理:网站在线人数的程序代码+后台有MYSQL数据库支持,可以直接统计出网站当前的在线人数。 |/ h3 ~% ^$ s3 X
首先我创建MYSQL数据库表。
2 S' ^0 O) Y$ i; Q8 D4 wCREATE TABLE tablename (
+ e6 X& _. s! a+ }8 tfield type(max_length) DEFAULT 'default_value' (NOT) NULL6 A( K/ J2 g( Y3 ?
}可以使用的SQL语句。- P/ i5 j& }" ?
CREATE TABLE useronline (
3 I5 L; M( {. v5 z, o# Ttimestamp int(15) DEFAULT '0' NOT NULL,
~ |/ h1 K4 u7 \: v/ Cip varchar(40) NOT NULL,
# a; X( b% A- v- x1 c% {file varchar(100) NOT NULL, U8 o2 W X. w: w. p# Z
PRIMARY KEY (timestamp),
* _( ?) ~$ z( O0 w& f$ \KEY ip (ip),
2 k/ u2 F+ {4 F0 l% r, w% |KEY file (file)8 E' D$ u+ Z- U0 y5 J2 F0 G# p2 l
);下面我们是PHP脚本,首先我定义MYSQL的信息。( J6 i$ ?2 X, R% Z' j/ f& G
$server = "localhost"; //你的服务器+ i' F$ N$ m8 M9 e6 u, s
$db_user = "root"; //你的mysql的用户名
. }7 G0 g# B/ M8 [( m$db_pass = "password"; //你的mysql的密码/ h$ F( N" X7 V8 b
$database = "users"; //表的名字设置统计的时间(多少秒内在线人数)
7 o' r2 e0 D8 |8 P9 Q7 k' E9 N, }0 U$timeoutseconds = 300;取当前时间。
" e8 q3 g, H- \$timestamp = time();上面的完整代码:, r& x1 G( p1 i* L" @; z; v
<?php
# f/ D$ |9 |; c5 Y; P$server = "localhost"; //your server+ _+ W* q$ J5 s8 f5 Q0 t
$db_user = "root"; //your mysql database username
$ f$ W9 [- m/ ]6 X; b$db_pass = "password"; //your mysql database password if any
* ?5 o2 B8 W% _* }$database = "users"; //the db name
* j' j' R( A* f( @( E" j$timeoutseconds = 300;//timeoutseconds limit
, I5 Z/ @2 N' o& m/ u! a: M7 {% x//get the current time9 l$ D3 G7 m6 F7 L0 ]* K8 u
$timestamp = time();3 y5 ~# m4 K4 z5 Q j! v
//calculate the lowest timestamp allowed
- t: S/ R, ?6 K, J6 f* S& z$timeout = $timestamp-$timeoutseconds;
3 Q( R- Z0 m' v6 m. g?>连接mysql
1 |( j& C) |4 hmysql_connect('localhost', 'username', 'password');也允许使用变量形式。
3 i7 P; `! A; R* U! [+ c7 Cmysql_connect($server, $db_user, $db_pass);如果mysql数据库没有密码的话可以使用下面代码连接
+ \6 r: w+ }. A V: B- v# q7 P/ }mysql_connect($server, $db_user);查询数据库的代码:
/ T: }: W# m* Vmysql_db_query('database', 'query');我们只要有访客就要增加一条记录。9 S3 q! `' M9 B3 R- k4 ]$ T# K
$insert = mysql_db_query($database, "INSERT INTO useronline VALUES7 g5 Y3 @) N* R+ I# i5 c6 Y$ \9 g' f
('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");' D" C. ^6 s$ ]. z/ U x; \
如果用户用错误信息的话,这样处理。* |* }. k8 B. W7 j" `
if(!($insert)) {
3 Z+ c5 b* a) o; |9 S+ @8 z6 Y, _! cprint "Useronline Insert Failed > ";
$ u9 i/ W3 ?2 `}然后实现当超过设置的时间就删除该用户记录。* m/ b4 s; A& ?
$delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");同样给出删除记录出错的处理。
: ?( W) D7 ]( P/ c d$ l# Sif(!($delete)) {& V* w! p V8 l: m! G' ^
print "Useronline Delete Failed > ";6 [, e$ k# [9 R
}下面我们解决数据库中不同IP的问题$ M5 [7 K: u8 p: D% u% `% m
$result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");使用
7 H* j9 K$ [4 | C2 B: N& Vmysql_num_rows(query);来统计用户,代码如下。
8 A/ Z+ U* \) L( ?$ C$user = mysql_num_rows($result);最后关闭数据库。
& D8 w0 M2 W& ?2 [mysql_close();显示在线的人数。
" M) i( r+ n( e9 s, k! Qif($user == 1) {) p9 Z5 L" }1 c/ m/ R: R0 ]
print("1 user online\n");3 N& L4 E I3 v0 q
} else {
# e. T( U4 F' v+ r# R4 ^print("$user users online\n");
9 }; y- d) h: a}最终把上面代码写成一个PHP文件如下。0 E! e: g% P3 A$ J1 C
<?php
$ w' N" s4 f3 ?//Put your basic server info here
; a( r0 m/ z6 n7 X9 ~$server = "localhost"; //normally localhost
_" R; x& s. z+ h* Z# f$db_user = "root"; //your MySQL database username
# k: o9 l2 E# H/ r; ~, p! J7 o$db_pass = "password"; //your MySQL database password
0 e) h$ S. Q4 ~" g$database = "users";0 W' ~8 @3 p- h/ o' a
$timeoutseconds = 300; //it will delete all people which haven't refreshed(so probbably are
' A$ e2 U* Y6 }/ C0 [4 S// offline or inactive) in $timieoutseconds time (so it actually checks the people that are active in the last
. f( m7 G8 T7 B) |9 b2 ^// $timeoutseconds seconds)
7 _4 {' Z9 a) W) o( o' Z8 `) y//this is where PHP gets the time
& M; b+ O: j+ C' `$timestamp = time();
- m4 D% z/ H/ ?//counts the timeout, all people which have been seen last online in earlier than this timestamp, will get removed( X1 k7 F/ u: M
$timeout = $timestamp-$timeoutseconds;2 K. L4 I6 ] C/ k& Z
//connect to database. K3 ~7 ^9 j* ?/ {
mysql_connect($server, $db_user);
7 @0 ^+ P7 x7 I9 R3 {3 ^//add the timestamp from the user to the online list
7 \# ~" F+ @* J$insert = mysql_db_query($database, "INSERT INTO useronline VALUES7 } G1 O( |; [" l1 R- }9 r3 A! k
('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");
$ h5 m6 ]" X, g. Y) Hif(!($insert)) { E: Y; w) k; O# v
print "Useronline Insert Failed > ";/ f( E$ d) d+ U0 H
}
6 z0 s* Q' ^* `' z' y//delete the peoples which haven't been online/active in the last $timeoutseconds seconds.
) |) K) ?' e8 E) `/ }% ?8 P$delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");
6 y! z6 f$ _( p' @+ ?if(!($delete)) {4 @+ I2 P, e& s( M; |$ p
print "Useronline Delete Failed > ";4 [. V# ]: a7 V- e* s) k: ]
}
6 s" \+ x7 d: B& }2 x* R//select the amount of people online, all uniques, which are online on THIS page: O5 P6 Z$ m4 d0 r
$result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");; r/ c; U4 m- _" x
if(!($result)) {
5 n9 r9 i+ {+ w4 \print "Useronline Select Error > ";
9 s" q: \5 E9 L4 ]4 j}
4 Y, `/ d9 J/ N6 S3 c# o0 a//Count the number of rows = the number of people online
a! L% M1 V J$user = mysql_num_rows($result);
- _ G l: H' a8 h- ]' N2 b( K//spit out the results* r* |" P: O3 k6 S
mysql_close();
" b1 [* E0 { Z" X! Iif($user == 1) {
( G) I& q1 a3 S3 e/ _print("1 user online\n");5 T5 W6 ] ~! L( i0 L
} else {% w; k" k; ~& J% p8 H/ s. M! a( ~
print("$user users online\n");2 f/ _5 V! p) P/ ?
}
. k6 Z* N" W% X. l- h5 x?># {- j( q+ I) r$ h: d5 O
% {# H2 z6 T/ b8 l+ t7 @
以上代码我是在时代互联提供的免费试用主机上测试的,感觉效果还不错,性能很稳定,不信的话你也可以去试试。当然,记得指出我这个程序中的不足先哦。
& P8 U" ^0 @& K时代互联是行业内最早开始提供PHP 虚拟主机的公司之一,现在已经是的金牌域名注册商和中国互联网客户满意度十佳单位,产品功能已经非常完善 ,特别提一下几个特有用的功能:数据库自动备份、免费集成繁简通简装版、多域名绑定、多子网站支持、GCDN 网站加速器、镜像加速、高级访问统计系统、支持WAP、可选电信/网通/香港机房。
9 `, G! h' f$ q7 n我之前建站的时候选的是他们公司标准商务E型,因为这款机型还特别支持ASP.NET3.5(3.0/2.0/1.1)/ASP。, l) o3 B" x; }1 g( }3 [
当然啦,这两款主机也是相当不错的。
4 g! D5 D( m+ d* \9 k智强商务B型:Unix /Linux 操作系统+独立网页空间1000MB+送1000MB邮局空间+100MB MySQL数据库空间=1869元/年* d4 P; f, e" o- v# n) m; W
标准商务B型:Unix /Linux 操作系统+独立网页空间500MB+送800MB邮局空间+60MB MySQL数据库空间=1365元/年
. C0 q! A6 n0 E0 e提供一下这个公司的联系方式:请见:http://www.now.cn/vhost/
' j4 C" ?; P8 t7 z; W* d* }空间专线: 0756-2623871 QQ:168075865,好象还有全球免费网络电话:全球免费咨询电话 http://www.now.cn/callcenter/call.net?LineName=55
1 a& H6 `5 ]# J( d& ?自己加QQ去问吧。 |
|