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

主机, 虚拟主机

刚用PHP写了一个网站在线人数的程序，请大家进来指点下！( Z2 F) z3 N' L$ i
我是用PHP+MYSQL来写的，原理：网站在线人数的程序代码+后台有MYSQL数据库支持，可以直接统计出网站当前的在线人数。
首先我创建MYSQL数据库表。2 s9 E! x0 M1 a" E
CREATE TABLE tablename (4 p9 E/ u. x( L/ Z% W' k0 f+ E
field type(max_length) DEFAULT 'default_value' (NOT) NULL6 @2 |1 A! U- I9 i% x
}可以使用的SQL语句。
CREATE TABLE useronline (
timestamp int(15) DEFAULT '0' NOT NULL,  J; s8 X5 r% q6 v! B" w
ip varchar(40) NOT NULL,
file varchar(100) NOT NULL,2 n+ W% x% n& P% c' j; A( y5 S
PRIMARY KEY (timestamp),
KEY ip (ip),9 X( D# V: t: Z- u, k/ g# j2 F
KEY file (file)
);下面我们是PHP脚本，首先我定义MYSQL的信息。! H) S6 h6 Z7 C- r" n
$server = "localhost"; //你的服务器
$db_user = "root"; //你的mysql的用户名) v8 D+ r" g, B
$db_pass = "password"; //你的mysql的密码( g, M7 t( \6 W) j% }
$database = "users"; //表的名字设置统计的时间(多少秒内在线人数)2 B' j6 T4 O5 z& U, H; {
$timeoutseconds = 300;取当前时间。
$timestamp = time();上面的完整代码：  t# N* ]" o  a3 D
<?php
$server = "localhost"; //your server$ T, Y0 ?4 a) b% C4 M& P3 z  D
$db_user = "root"; //your mysql database username, N5 A$ |, o, @, |
$db_pass = "password"; //your mysql database password if any
$database = "users"; //the db name
$timeoutseconds = 300;//timeoutseconds limit- h/ N2 N- N" ], Q3 x1 t/ l
//get the current time
$timestamp = time();
//calculate the lowest timestamp allowed
$timeout = $timestamp-$timeoutseconds;; o( f8 `! H: n6 x3 v; M
?>连接mysql! w* b9 H- k: \' o
mysql_connect('localhost', 'username', 'password');也允许使用变量形式。3 Z) ]" y  J( A6 X% Y
mysql_connect($server, $db_user, $db_pass);如果mysql数据库没有密码的话可以使用下面代码连接
mysql_connect($server, $db_user);查询数据库的代码：" y/ e6 p% p* T  X' b" Z
mysql_db_query('database', 'query');我们只要有访客就要增加一条记录。# {/ E/ J/ m9 U. O7 ^# c5 G
$insert = mysql_db_query($database, "INSERT INTO useronline VALUES
('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");
如果用户用错误信息的话，这样处理。* n+ t0 L' y" C! n1 \
if(!($insert)) {
print "Useronline Insert Failed > ";
}然后实现当超过设置的时间就删除该用户记录。0 m' \, @- G/ L1 G' y; M' A
$delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");同样给出删除记录出错的处理。9 h( f0 }8 m2 ?9 H1 S
if(!($delete)) {0 o' l- V& X0 l' `6 P
print "Useronline Delete Failed > ";: K  Q& s; H* e/ ]6 ?
}下面我们解决数据库中不同IP的问题
$result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");使用# m' c9 N0 e( J- t. E' F0 H( |
mysql_num_rows(query);来统计用户，代码如下。5 L# x1 @7 X" s
$user = mysql_num_rows($result);最后关闭数据库。7 ]! t. y0 Q3 |$ o5 M$ ], u3 o
mysql_close();显示在线的人数。$ `. j/ R! I3 _2 e
if($user == 1) {- z5 P/ {, c8 F' }
print("1 user online\n");
} else {
print("$user users online\n");) a( w* f+ j! |/ z
}最终把上面代码写成一个PHP文件如下。
<?php4 J, s$ q+ g" b7 ?
//Put your basic server info here1 m' r" _* Q2 C3 V- @& k
$server = "localhost"; //normally localhost- c  N4 T# i: }0 X
$db_user = "root"; //your MySQL database username
$db_pass = "password"; //your MySQL database password/ L' d6 a& _4 u- y- a
$database = "users";4 y1 c$ |9 g/ E1 {2 ?" e4 C
$timeoutseconds = 300; //it will delete all people which haven't refreshed(so probbably are
// offline or inactive) in $timieoutseconds time (so it actually checks the people that are active in the last9 O$ [3 G7 v  Q* W( Z
// $timeoutseconds seconds)" G6 L2 Q6 B! [! r
//this is where PHP gets the time( g  A+ g8 \/ y$ u6 Q5 H, r; a' }4 Z
$timestamp = time();
//counts the timeout, all people which have been seen last online in earlier than this timestamp, will get removed; l$ P) r" E2 n8 _; f8 K4 w
$timeout = $timestamp-$timeoutseconds;# Y' [8 w( ^" Z! U1 B6 j* e9 w% k
//connect to database
mysql_connect($server, $db_user);% Q; s1 w/ s1 H6 J4 |4 _$ f) C  O; J
//add the timestamp from the user to the online list
$insert = mysql_db_query($database, "INSERT INTO useronline VALUES, B. @$ v& [: i2 J: s8 q
('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");
if(!($insert)) {( k, x) N! ^2 L; ~0 }3 C
print "Useronline Insert Failed > ";" F4 E7 R+ H( R4 c
}/ j4 }8 l  w3 j$ I1 Q8 k
//delete the peoples which haven't been online/active in the last $timeoutseconds seconds.
$delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");
if(!($delete)) {
print "Useronline Delete Failed > ";! _+ j* {5 a+ _+ S
}( h; g8 m0 T5 q/ U  y
//select the amount of people online, all uniques, which are online on THIS page# b( k# {5 M) r9 L! q
$result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");- ]9 Z# S" P" h" x" q5 x. s8 F& F- {
if(!($result)) {
print "Useronline Select Error > ";
}! {/ Y# c1 F* ^4 p( v! t4 l* n
//Count the number of rows = the number of people online
$user = mysql_num_rows($result);" \/ M( v1 o1 o& A) l
//spit out the results* B5 ?4 W8 \( S. L
mysql_close();
if($user == 1) {) e% f# G7 b+ m
print("1 user online\n");
} else {+ g5 i" i* m5 g! p7 g1 F
print("$user users online\n");; L# X' z* I& e
}
?>2 h6 A) f! h; j2 J/ L

以上代码我是在时代互联提供的免费试用主机上测试的，感觉效果还不错，性能很稳定，不信的话你也可以去试试。当然，记得指出我这个程序中的不足先哦。
时代互联是行业内最早开始提供PHP 虚拟主机的公司之一，现在已经是的金牌域名注册商和中国互联网客户满意度十佳单位，产品功能已经非常完善，特别提一下几个特有用的功能：数据库自动备份、免费集成繁简通简装版、多域名绑定、多子网站支持、GCDN 网站加速器、镜像加速、高级访问统计系统、支持WAP、可选电信/网通/香港机房。
我之前建站的时候选的是他们公司标准商务E型，因为这款机型还特别支持ASP.NET3.5(3.0/2.0/1.1)/ASP。; P S% [# \% C! A& V h& D& v |6 O
当然啦，这两款主机也是相当不错的。1 z+ B8 x5 P; M
智强商务B型：Unix /Linux 操作系统+独立网页空间1000MB+送1000MB邮局空间+100MB MySQL数据库空间=1869元/年
标准商务B型：Unix /Linux 操作系统+独立网页空间500MB+送800MB邮局空间+60MB MySQL数据库空间=1365元/年
提供一下这个公司的联系方式：请见：http://www.now.cn/vhost/ - q' _% ~. C: H5 g3 D7 Q& o9 I
空间专线： 0756-2623871 QQ：168075865，好象还有全球免费网络电话:全球免费咨询电话 http://www.now.cn/callcenter/call.net?LineName=55
自己加QQ去问吧。

返回列表

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

[收藏此主题] [关注此主题的新回复]

[通过 QQ、MSN 分享给朋友]