|

- UID
- 455
- 帖子
- 3
- 精华
- 0
- 积分
- 8
- 金币
- 3
- 威望
- 0
- 贡献
- 0
|
刚用PHP写了一个网站在线人数的程序,请大家进来指点下!
刚用PHP写了一个网站在线人数的程序,请大家进来指点下!' z& I( b, ]% h9 z
我是用PHP+MYSQL来写的,原理:网站在线人数的程序代码+后台有MYSQL数据库支持,可以直接统计出网站当前的在线人数。
: @4 b' a3 w/ V7 r6 D首先我创建MYSQL数据库表。) a' B) T6 a6 h/ Z! I
CREATE TABLE tablename (
1 M' {/ o4 D/ Y k' T. Pfield type(max_length) DEFAULT 'default_value' (NOT) NULL, t1 O5 V7 h7 E0 J/ ]; L/ v+ _/ @
}可以使用的SQL语句。
7 ~7 C f5 b0 d X1 ^CREATE TABLE useronline (
- {' N5 M7 a: W8 B* a- l. e* t: |timestamp int(15) DEFAULT '0' NOT NULL,
6 C. f0 C: D9 G6 i" m- Lip varchar(40) NOT NULL,% c& s/ G& j% o; q/ T! [! w
file varchar(100) NOT NULL,3 {) l* o; L* x& p7 ]& g1 n
PRIMARY KEY (timestamp),3 }1 E s( M' H
KEY ip (ip),
4 V m4 T. ^; e' a1 JKEY file (file)
& U% P% t: v$ L) \0 s);下面我们是PHP脚本,首先我定义MYSQL的信息。+ O/ W% C2 }( V( n, J6 Q
$server = "localhost"; //你的服务器
) T& w: N6 G9 t' J+ c5 u, u& c4 V$db_user = "root"; //你的mysql的用户名
3 ?1 v) ? Z0 ^5 e$db_pass = "password"; //你的mysql的密码
6 w6 u& t- d* W! f$database = "users"; //表的名字设置统计的时间(多少秒内在线人数)
2 o$ V/ v! l ^; l+ H$timeoutseconds = 300;取当前时间。$ ^3 ] G4 L# X( _
$timestamp = time();上面的完整代码:; H% ]* R* u8 \0 T) q
<?php
+ I1 d+ m. A0 R1 b# m2 q L# B$server = "localhost"; //your server6 B2 m+ K0 F/ l/ T$ q S) S
$db_user = "root"; //your mysql database username
4 f/ M" H7 \% u7 q$db_pass = "password"; //your mysql database password if any2 _0 v6 K1 n/ m! }& t6 V
$database = "users"; //the db name
: s( G0 _' b* P- h9 U( T5 P$timeoutseconds = 300;//timeoutseconds limit7 v9 Y, ?; r5 {" c7 a! C
//get the current time& c& ~/ Z0 z. ?) E/ G M; {4 S
$timestamp = time();
& G7 |# j+ Y6 ]: t# s' p//calculate the lowest timestamp allowed
& i0 A4 k% H3 |$timeout = $timestamp-$timeoutseconds;
: Y0 f9 i( g x# @8 ?7 T; q! w) ??>连接mysql" Z1 }* F5 X/ o
mysql_connect('localhost', 'username', 'password');也允许使用变量形式。
, Y7 t- A/ t' ~& emysql_connect($server, $db_user, $db_pass);如果mysql数据库没有密码的话可以使用下面代码连接# l3 k4 p! j% C9 V- n, ^
mysql_connect($server, $db_user);查询数据库的代码:
' _5 ` v5 \3 N2 q+ M3 Rmysql_db_query('database', 'query');我们只要有访客就要增加一条记录。) Z5 h5 y/ A0 D9 s! A# @9 ~
$insert = mysql_db_query($database, "INSERT INTO useronline VALUES
5 U8 h0 s$ {# C('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");
2 L8 Q p: Y; ]* E4 z. ?5 ^如果用户用错误信息的话,这样处理。, M1 D0 H( W1 O$ ~, \
if(!($insert)) {% o, W0 j# p" ^' s& v* n% ^6 g0 _
print "Useronline Insert Failed > ";" Z0 U; R3 e, N- `2 x( b
}然后实现当超过设置的时间就删除该用户记录。! N& K2 R1 p2 A# M5 k- }
$delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");同样给出删除记录出错的处理。$ a' r! c6 t! ^ Z; S. |. h
if(!($delete)) {
v: k( R$ ?: S7 xprint "Useronline Delete Failed > ";& V( ^7 F' a7 h& O
}下面我们解决数据库中不同IP的问题
& B# w* N* ^1 Z; ], m$result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");使用
: H8 |, c' {8 o/ dmysql_num_rows(query);来统计用户,代码如下。
) \1 A6 r- z$ Q: |$user = mysql_num_rows($result);最后关闭数据库。' j' G9 f- m4 b& S
mysql_close();显示在线的人数。
4 p ^4 w. k. k4 _/ c& a2 M; Kif($user == 1) {, N( a( B# O6 e- z0 W* ?; A+ Y
print("1 user online\n");
/ D& E$ r; d: r2 A1 D} else {
. g) g: g7 k* {0 e+ ~3 x/ F- fprint("$user users online\n");, V2 @7 x5 c6 n* m+ X' O" @
}最终把上面代码写成一个PHP文件如下。
( k1 g2 A, o3 O! {; T<?php+ [% @; U7 \" Q; Z+ d
//Put your basic server info here
& a. L( ?6 s/ x7 D; K$server = "localhost"; //normally localhost9 f* C) ] r0 k+ d V/ W
$db_user = "root"; //your MySQL database username
, _# W8 o; }) x, l$db_pass = "password"; //your MySQL database password- y' i5 R: D# J" ~: L8 F- {
$database = "users"; {, K5 O; V. d7 L
$timeoutseconds = 300; //it will delete all people which haven't refreshed(so probbably are- i% x0 v \- c, O# u" l/ I; Z) e1 u
// offline or inactive) in $timieoutseconds time (so it actually checks the people that are active in the last
B3 U% J/ c* j3 M! ]# ~// $timeoutseconds seconds)$ N9 H# C+ ~# X0 F" ]
//this is where PHP gets the time
/ I- S3 e& i' D, o) C, Z$timestamp = time();
3 _5 r4 g c0 u- v; b0 c//counts the timeout, all people which have been seen last online in earlier than this timestamp, will get removed
+ `. }7 @- E# j6 w4 B+ T1 V( `$timeout = $timestamp-$timeoutseconds;
) w* h0 e8 K; i8 I& a5 J: _3 d' z% F//connect to database
0 b2 y1 Z; M- ] L; |1 Hmysql_connect($server, $db_user);; M3 J( t% w- h* N* T1 k
//add the timestamp from the user to the online list' X5 E) U- I, X' U3 M( \# [# M
$insert = mysql_db_query($database, "INSERT INTO useronline VALUES( G/ h: @0 n: t6 V- O! w
('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");* o. C6 }7 \' w" w
if(!($insert)) {; X" H9 n3 ?2 L* P3 V# m3 ]+ M
print "Useronline Insert Failed > ";
! F p! E$ Y+ J}
) k) d o1 t1 [' O; c//delete the peoples which haven't been online/active in the last $timeoutseconds seconds.
8 ]6 Y( {5 B' N- }9 r: r$delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");1 q3 ~. Z( S1 p3 E9 a2 R6 J5 l: \$ x
if(!($delete)) {
. q: X1 X8 m" n+ a$ O6 lprint "Useronline Delete Failed > ";+ W J" c( s) ]# z C O+ h0 Z: I( [
}
% j; N5 y' b( ^# v//select the amount of people online, all uniques, which are online on THIS page
0 y5 b1 b, G; ]% ?2 |5 T7 c$result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");
0 ?& H) S5 }( C- R* ?if(!($result)) {
4 k3 O& C r q5 O) J Xprint "Useronline Select Error > ";& ^* j0 c: U0 }9 {
}
; l8 r. r2 [% u, m; m//Count the number of rows = the number of people online+ w2 X# h- N9 e3 y+ g5 O8 ], C
$user = mysql_num_rows($result);. N4 F { T% k9 S
//spit out the results5 x: [6 A% G& s% N; i
mysql_close();
5 s# y1 [* a8 V5 B) P2 Sif($user == 1) {
h% A, D) g6 |$ V) \print("1 user online\n");
3 S1 H7 H. e/ B} else {
; R9 k8 q" `$ i! {print("$user users online\n");
4 m! n! f7 F; q3 A: o. I; o}
) y$ o" f6 ?3 t9 H- z?>- _- ?9 R% Z7 _

/ R% @" l6 F/ b* R$ V& u以上代码我是在时代互联提供的免费试用主机上测试的,感觉效果还不错,性能很稳定,不信的话你也可以去试试。当然,记得指出我这个程序中的不足先哦。
' @, ~! |0 l+ P# I时代互联是行业内最早开始提供PHP 虚拟主机的公司之一,现在已经是的金牌域名注册商和中国互联网客户满意度十佳单位,产品功能已经非常完善 ,特别提一下几个特有用的功能:数据库自动备份、免费集成繁简通简装版、多域名绑定、多子网站支持、GCDN 网站加速器、镜像加速、高级访问统计系统、支持WAP、可选电信/网通/香港机房。0 [3 \! e$ J* k% T6 m" _
我之前建站的时候选的是他们公司标准商务E型,因为这款机型还特别支持ASP.NET3.5(3.0/2.0/1.1)/ASP。7 l! _1 [& m: N7 i% D; K
当然啦,这两款主机也是相当不错的。+ d7 R9 j" F/ Y, A7 T$ c. [) @
智强商务B型:Unix /Linux 操作系统+独立网页空间1000MB+送1000MB邮局空间+100MB MySQL数据库空间=1869元/年0 v6 u) j% U! q1 B) S
标准商务B型:Unix /Linux 操作系统+独立网页空间500MB+送800MB邮局空间+60MB MySQL数据库空间=1365元/年
: B# ]$ F+ G7 h8 u3 [8 u提供一下这个公司的联系方式:请见:http://www.now.cn/vhost/
& _2 ?0 {( r$ ~$ u& n$ S, l空间专线: 0756-2623871 QQ:168075865,好象还有全球免费网络电话:全球免费咨询电话 http://www.now.cn/callcenter/call.net?LineName=55
. j/ ], s% P# U" a: b; ]1 \* E自己加QQ去问吧。 |
|