返回列表 发帖

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

刚用PHP写了一个网站在线人数的程序,请大家进来指点下!
' t3 ?) `3 q6 C我是用PHP+MYSQL来写的,原理:网站在线人数的程序代码+后台有MYSQL数据库支持,可以直接统计出网站当前的在线人数。
# k' \5 Q1 F' z; x% b* Y! E2 R) u& }首先我创建MYSQL数据库表。
. O; h8 R2 M7 h* _8 yCREATE TABLE tablename (* r9 ^  h4 _) e4 [8 M7 f+ y6 K
field type(max_length) DEFAULT 'default_value' (NOT) NULL
" X* Q2 p8 Y$ Y+ V}可以使用的SQL语句。$ j5 F; |4 D6 q, z
CREATE TABLE useronline (
4 [. a$ U- g# A0 Z5 C4 m% K0 otimestamp int(15) DEFAULT '0' NOT NULL,5 O& ^9 I) z% b) I- \' B1 |
ip varchar(40) NOT NULL,
" x  n6 i- S7 K1 s. K1 ]. g( Ofile varchar(100) NOT NULL,
% i1 i! o7 ?% `4 P* S0 c' m8 W' pPRIMARY KEY (timestamp),9 O: {; h$ |& |4 z/ b! R
KEY ip (ip),
  D* E3 f( w" G5 W% R3 o5 L  uKEY file (file)
* y2 `# x  h2 R3 H" C);下面我们是PHP脚本,首先我定义MYSQL的信息。
& b$ ^5 o" j  D7 \( x$server = "localhost"; //你的服务器! g$ P& I. ^0 l  u+ a6 ?
$db_user = "root"; //你的mysql的用户名; a/ }2 P) p' ^7 l
$db_pass = "password"; //你的mysql的密码
5 @2 c; S. D* N% r$database = "users"; //表的名字设置统计的时间(多少秒内在线人数)9 r  z! p+ d8 M
$timeoutseconds = 300;取当前时间。7 {9 ?" X1 x) e
$timestamp = time();上面的完整代码:
; V* h! a! P, `) N0 S# f<?php# {- _' @# [( }! S
$server = "localhost"; //your server( c2 b: \) s1 }) C1 N6 b$ v
$db_user = "root"; //your mysql database username
0 {$ ]  N; f  f, e7 b  Z$db_pass = "password"; //your mysql database password if any
( p0 u9 c9 \* p$database = "users"; //the db name" s- T( ?  \( o6 X' D; s  u) k- {
$timeoutseconds = 300;//timeoutseconds limit! E9 _% U5 t2 }  X3 G- i( Z
//get the current time$ H) G5 U4 y5 T5 m* j7 b# Q
$timestamp = time();% x; H4 _0 F- p- e9 L
//calculate the lowest timestamp allowed8 W; x$ t% Y$ X; v6 ^
$timeout = $timestamp-$timeoutseconds;
- n# s: \  q. [* [# l?>连接mysql
. v) q( t6 R& z) L/ q# M2 b$ Pmysql_connect('localhost', 'username', 'password');也允许使用变量形式。- W: o5 ?4 x& K$ R
mysql_connect($server, $db_user, $db_pass);如果mysql数据库没有密码的话可以使用下面代码连接
, q" s9 o3 V9 @" ?mysql_connect($server, $db_user);查询数据库的代码:; m) M  d8 i7 Z! O& n" \4 q4 ]
mysql_db_query('database', 'query');我们只要有访客就要增加一条记录。
. Y( d% j5 F  u$insert = mysql_db_query($database, "INSERT INTO useronline VALUES, e3 W' i; k" V. J7 u& I
('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");: u7 d5 I; `8 y' I0 b8 M) J
如果用户用错误信息的话,这样处理。5 |2 T( ]& e9 s0 D
if(!($insert)) {' |) s2 o; V4 m1 C( i" |
print "Useronline Insert Failed > ";1 X# G5 j0 j6 t( U
}然后实现当超过设置的时间就删除该用户记录。: U/ r, U- Z  s; a/ V" F' ?
$delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");同样给出删除记录出错的处理。
9 O1 @( \' c) \2 s# \* b6 l! G" ]% O/ Kif(!($delete)) {3 ?$ c+ W/ v6 Y8 V" m
print "Useronline Delete Failed > ";
0 h0 T7 M$ O3 v: Y4 I' _}下面我们解决数据库中不同IP的问题
7 @1 B4 G% V8 ]$result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");使用
) W6 y3 w: y8 jmysql_num_rows(query);来统计用户,代码如下。$ d% G; P! \& h/ Q2 s9 N" {( j
$user = mysql_num_rows($result);最后关闭数据库。* ~) j1 C- R( w( d' r
mysql_close();显示在线的人数。
7 L) E$ S% B% `$ |if($user == 1) {
. s/ Y/ M; |  V. Cprint("1 user online\n");
! n/ M: K& F' |} else {4 t% N7 N  ?) p9 A" F9 X( J
print("$user users online\n");# [% n$ [: q2 V  l* f, H8 x% l
}最终把上面代码写成一个PHP文件如下。
. {# @8 D" G; c' \9 u6 b  I( B4 q<?php- A) I& F9 L+ V. l
//Put your basic server info here* [; b. N( ]$ t# {
$server = "localhost"; //normally localhost
# d9 e/ E8 U, g$db_user = "root"; //your MySQL database username( `% x5 T: p+ N2 R
$db_pass = "password"; //your MySQL database password+ x0 K! d5 \3 d4 N
$database = "users";
$ x  n/ c) N4 M0 s$timeoutseconds = 300; //it will delete all people which haven't refreshed(so probbably are
& N1 {7 q1 J, s0 w# R// offline or inactive) in $timieoutseconds time (so it actually checks the people that are active in the last( M3 b# P1 r' N1 B7 ?3 P9 t  T0 t
// $timeoutseconds seconds)
& e" G7 }3 f4 M1 i7 z5 V! X- V//this is where PHP gets the time
' d9 |# \4 o9 _" r( Q$timestamp = time();
  ^3 o' u# m) W7 t//counts the timeout, all people which have been seen last online in earlier than this timestamp, will get removed
) J( n, r- q5 n9 O! z; e$timeout = $timestamp-$timeoutseconds;
) Y3 n3 t+ d1 A7 x6 l! X2 u5 Y//connect to database
9 O$ z% {6 ?; Nmysql_connect($server, $db_user);
' U* u2 E  ?7 X3 U) p//add the timestamp from the user to the online list* h+ R; z+ N1 E% n! T4 B
$insert = mysql_db_query($database, "INSERT INTO useronline VALUES' S# G4 z( h  Q7 }! s4 t$ ~' x
('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");) G- w: i. B9 i; H3 D7 \" D
if(!($insert)) {
& J6 U; G( A1 Vprint "Useronline Insert Failed > ";
! b# r, T% v( z' p1 K2 k+ R" V- f7 H}& `" f8 \& e8 ], K
//delete the peoples which haven't been online/active in the last $timeoutseconds seconds.
1 E- Q! O$ E+ T3 `6 U$delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");
; X% {8 ~- L- T" mif(!($delete)) {
" Y: h7 r/ u& [; e* Iprint "Useronline Delete Failed > ";8 p9 j$ K# X: `% w
}# E, n/ K" k$ ]! X1 U/ }
//select the amount of people online, all uniques, which are online on THIS page
1 E0 k% h9 n& t5 N; K' D. l$result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");
7 q+ M0 n. S# K* D( y7 p9 jif(!($result)) {
3 a2 T2 y; o4 Nprint "Useronline Select Error > ";6 e3 o( l$ e7 m- P; q, O
}
/ L* |* ^- \% Z, m2 w; f//Count the number of rows = the number of people online6 ]6 I) f2 ?7 O% w8 a, B
$user = mysql_num_rows($result);
' }2 P* P. j1 F  C//spit out the results
* w6 J6 ]0 B  w# gmysql_close();4 f  d% H. i0 k9 q
if($user == 1) {' ?4 T6 L" x( A  b8 P
print("1 user online\n");( W1 t4 v6 g8 M0 ^. q. z( i
} else {# M' E5 M# e+ G. T: ~
print("$user users online\n");
0 a, Z1 ^7 ^- k: M}
: O6 d$ ?7 O! R/ ^% Z0 T; y6 D  w?>" [( a1 J; H) D+ R. t) f
( w6 k4 z+ C' t% @# n# h& F/ \
以上代码我是在时代互联提供的免费试用主机上测试的,感觉效果还不错,性能很稳定,不信的话你也可以去试试。当然,记得指出我这个程序中的不足先哦。
' B  R0 t' }& e# ]时代互联是行业内最早开始提供PHP 虚拟主机的公司之一,现在已经是的金牌域名注册商和中国互联网客户满意度十佳单位,产品功能已经非常完善 ,特别提一下几个特有用的功能:数据库自动备份、免费集成繁简通简装版、多域名绑定、多子网站支持、GCDN 网站加速器、镜像加速、高级访问统计系统、支持WAP、可选电信/网通/香港机房。& h- a8 ?+ K  R3 f* `4 I% H. H
我之前建站的时候选的是他们公司标准商务E型,因为这款机型还特别支持ASP.NET3.5(3.0/2.0/1.1)/ASP。' V1 x4 |7 {0 m6 d% g5 O
当然啦,这两款主机也是相当不错的。' }1 w4 X% B. a9 G5 c& P2 ~6 ~
智强商务B型:Unix /Linux 操作系统+独立网页空间1000MB+送1000MB邮局空间+100MB MySQL数据库空间=1869元/年. D! _9 D( I' b' ^6 Q) x7 h
标准商务B型:Unix /Linux 操作系统+独立网页空间500MB+送800MB邮局空间+60MB MySQL数据库空间=1365元/年
% r$ e1 r- V) E  s( ]提供一下这个公司的联系方式:请见:http://www.now.cn/vhost/
" Z/ c5 H* t0 n, ~0 S2 }, Z空间专线: 0756-2623871  QQ:168075865,好象还有全球免费网络电话:全球免费咨询电话 http://www.now.cn/callcenter/call.net?LineName=55
& h( X1 J6 z7 J5 ~7 _% A, g0 ^自己加QQ去问吧。

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