|

- UID
- 455
- 帖子
- 3
- 精华
- 0
- 积分
- 8
- 金币
- 3
- 威望
- 0
- 贡献
- 0
|
刚用PHP写了一个网站在线人数的程序,请大家进来指点下!
刚用PHP写了一个网站在线人数的程序,请大家进来指点下!! U$ t' O) Z. x2 N9 m
我是用PHP+MYSQL来写的,原理:网站在线人数的程序代码+后台有MYSQL数据库支持,可以直接统计出网站当前的在线人数。
9 F2 T# z2 } r首先我创建MYSQL数据库表。
% `+ q$ Z3 t6 bCREATE TABLE tablename (7 t d ]2 v/ C
field type(max_length) DEFAULT 'default_value' (NOT) NULL/ {2 W- A! B, w
}可以使用的SQL语句。
& w$ s+ {9 G* L/ r1 r# ZCREATE TABLE useronline (4 k5 Z% h a! h' ~9 U8 k) c% W
timestamp int(15) DEFAULT '0' NOT NULL,
: n4 ^: G5 C$ ]7 zip varchar(40) NOT NULL,5 t$ F1 F9 m0 t8 W$ J% h Y
file varchar(100) NOT NULL,2 L, I* E+ e0 E' ]: L
PRIMARY KEY (timestamp),; @3 m( b9 ]! L0 C& e
KEY ip (ip),/ l P1 T" I' K) T9 o8 x
KEY file (file)
! w6 U- R2 Z! w. h4 l; I7 r! s);下面我们是PHP脚本,首先我定义MYSQL的信息。+ [$ F; v0 |* j2 T2 l: T
$server = "localhost"; //你的服务器
4 [' d! v8 r7 _2 c% q$db_user = "root"; //你的mysql的用户名
( `" L! B. O1 ^3 d4 @6 ?3 ]0 o$db_pass = "password"; //你的mysql的密码
7 Z) q Y+ q4 ^5 W$database = "users"; //表的名字设置统计的时间(多少秒内在线人数). ~" L) ]$ T4 r, \9 Q" {- J
$timeoutseconds = 300;取当前时间。
; |9 U4 {" J" u& a7 W2 M' |8 n6 b$timestamp = time();上面的完整代码:7 K0 B+ Q* }& [# G
<?php9 H/ S) v: u2 C: m7 I* d
$server = "localhost"; //your server
% x) |6 i$ Q c$ j$db_user = "root"; //your mysql database username, D. U# O; Q& x) s8 g
$db_pass = "password"; //your mysql database password if any$ G7 H) U% `7 T) @+ D5 A
$database = "users"; //the db name
# n0 q* W2 e% ^$timeoutseconds = 300;//timeoutseconds limit
& h6 U2 i- f5 ?4 p! K6 Q3 S" q- m//get the current time) `* v9 H7 u# a8 ? ]7 c
$timestamp = time();2 _' u' `$ `- |5 ^4 {& {
//calculate the lowest timestamp allowed
( t; b0 {9 t$ r: M* P$timeout = $timestamp-$timeoutseconds;
# v' j) p$ y; k H+ x: y: L?>连接mysql
2 V7 b# d3 b9 U$ E vmysql_connect('localhost', 'username', 'password');也允许使用变量形式。
& F& a$ x! l9 H" kmysql_connect($server, $db_user, $db_pass);如果mysql数据库没有密码的话可以使用下面代码连接
9 m9 x) s5 u4 a5 W& Gmysql_connect($server, $db_user);查询数据库的代码:
) q Q; l: p6 b3 Z3 gmysql_db_query('database', 'query');我们只要有访客就要增加一条记录。6 N7 Q0 ~+ ]$ d* w3 ]4 q5 y
$insert = mysql_db_query($database, "INSERT INTO useronline VALUES& X5 U3 y5 y$ \# E7 v
('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");
, M, @8 k2 ~/ M, X( z; c' i如果用户用错误信息的话,这样处理。
2 }+ u$ |/ i. B' I, W9 dif(!($insert)) {
3 ^, Q& R" t% Gprint "Useronline Insert Failed > ";
; S- B D4 v, _' Q6 v, s}然后实现当超过设置的时间就删除该用户记录。; {6 o* W- ~- d
$delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");同样给出删除记录出错的处理。% X* c9 K2 ]3 B$ K/ H
if(!($delete)) {
1 K) ^% ^. ^/ `0 j, {print "Useronline Delete Failed > ";$ a6 p; l2 H% k+ k: c
}下面我们解决数据库中不同IP的问题
& X3 B5 [# p& Q, C: ]2 \6 {$result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");使用 o7 D# M9 {2 W/ G+ }
mysql_num_rows(query);来统计用户,代码如下。
; Q! W# Q" G7 U+ q$user = mysql_num_rows($result);最后关闭数据库。
3 |% g* |8 k) N8 X3 s, y; N+ wmysql_close();显示在线的人数。7 F1 ]* g/ u- T: @
if($user == 1) {$ q6 U9 x {! p# N4 B: f. J9 R
print("1 user online\n");3 F( f5 m) x) t
} else {
" k! y5 Q, y* Gprint("$user users online\n");
3 L$ X, Z# n! Q, P}最终把上面代码写成一个PHP文件如下。
; b0 }' I4 |7 v7 r$ w& Z k5 d<?php
$ C) ?: n: C8 @1 H( Z//Put your basic server info here- T4 I# e$ g# l: ^4 ~3 N
$server = "localhost"; //normally localhost3 K- `" _" p: i
$db_user = "root"; //your MySQL database username4 z! n) z" ?. R! h
$db_pass = "password"; //your MySQL database password
, w% ]* o' G- l& [; `$database = "users";
5 R% z \; z0 y1 A$timeoutseconds = 300; //it will delete all people which haven't refreshed(so probbably are3 W( w* C" s7 l3 i8 g* F
// offline or inactive) in $timieoutseconds time (so it actually checks the people that are active in the last) a/ \; E, h: s; k m& S
// $timeoutseconds seconds)
- \) N1 u$ X6 P2 c, ?//this is where PHP gets the time) j+ Y, j- X4 `6 V( ~- e
$timestamp = time();
" f( j, k' y+ L" ^6 E//counts the timeout, all people which have been seen last online in earlier than this timestamp, will get removed
& V; u( J/ |5 p/ O+ I: N2 A$timeout = $timestamp-$timeoutseconds;
; d. N5 ^' w' D# F2 o. u//connect to database& [- d1 H, c" a, v4 E9 u9 x
mysql_connect($server, $db_user);+ H8 `" b( C* H% W" N$ d( r
//add the timestamp from the user to the online list
|2 K4 U" c+ t) b) p0 G% O( k$insert = mysql_db_query($database, "INSERT INTO useronline VALUES
) d# v% P' n8 |) s$ e('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");* l4 ^& Z; z( X, {
if(!($insert)) {- o* _3 {% Y( D- k8 Y0 d; Y
print "Useronline Insert Failed > ";% Z& L9 N$ k, q0 w- R' v
}
4 \8 c6 B `- [2 u4 ~//delete the peoples which haven't been online/active in the last $timeoutseconds seconds.5 d( Y+ Z" e( b) h
$delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");
6 b7 p) ]% Q; P$ w( {9 Nif(!($delete)) {! `1 D) r- W3 U
print "Useronline Delete Failed > ";
) [7 _7 X+ C& p6 I3 D/ ?: R, l}) J* h) K9 ?0 ?7 k. ~& r
//select the amount of people online, all uniques, which are online on THIS page: G% Q4 e+ y8 {! b
$result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");
- k: d$ |3 y1 D9 C5 X# {: @if(!($result)) {
8 l" \7 b4 _+ h- Vprint "Useronline Select Error > ";
, O# q* H7 \' k} N# q9 _# D0 F$ C
//Count the number of rows = the number of people online
+ G1 t0 K) `6 `9 ]: k6 P, H$user = mysql_num_rows($result);5 o6 [, E7 W5 L5 f4 A
//spit out the results
1 ]: M$ T4 N! Y( {% n9 V2 ]1 jmysql_close();
9 x; G5 J& F4 x3 Z1 _, i$ Tif($user == 1) {
: m2 h& r( B1 [) r" y5 nprint("1 user online\n");4 I- Q' X( U, I, J5 G- v7 w
} else {4 i) D. M8 v: ~2 ^) ?
print("$user users online\n");* j! T7 ^* R$ A. |
}! }4 |( O8 ?% T! c" A
?>; p! \! I6 r' b
5 z4 { q! H9 ?
以上代码我是在时代互联提供的免费试用主机上测试的,感觉效果还不错,性能很稳定,不信的话你也可以去试试。当然,记得指出我这个程序中的不足先哦。5 ~0 x+ k! L" d, c3 C) ^& @: a
时代互联是行业内最早开始提供PHP 虚拟主机的公司之一,现在已经是的金牌域名注册商和中国互联网客户满意度十佳单位,产品功能已经非常完善 ,特别提一下几个特有用的功能:数据库自动备份、免费集成繁简通简装版、多域名绑定、多子网站支持、GCDN 网站加速器、镜像加速、高级访问统计系统、支持WAP、可选电信/网通/香港机房。
* E1 }' m% o6 ^* I( t r0 l我之前建站的时候选的是他们公司标准商务E型,因为这款机型还特别支持ASP.NET3.5(3.0/2.0/1.1)/ASP。/ I# T; X) n* G
当然啦,这两款主机也是相当不错的。' U8 K7 Y6 g9 y1 z; Q5 N
智强商务B型:Unix /Linux 操作系统+独立网页空间1000MB+送1000MB邮局空间+100MB MySQL数据库空间=1869元/年
7 d- D l6 F- g) ]1 ~& L标准商务B型:Unix /Linux 操作系统+独立网页空间500MB+送800MB邮局空间+60MB MySQL数据库空间=1365元/年% s/ j2 }& Z# G2 l9 c
提供一下这个公司的联系方式:请见:http://www.now.cn/vhost/ & {5 S3 N, H1 Q; _4 J! i g; `
空间专线: 0756-2623871 QQ:168075865,好象还有全球免费网络电话:全球免费咨询电话 http://www.now.cn/callcenter/call.net?LineName=55, S3 [+ Z6 e3 B6 m; Z
自己加QQ去问吧。 |
|