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

主机, 虚拟主机

刚用PHP写了一个网站在线人数的程序，请大家进来指点下！
我是用PHP+MYSQL来写的，原理：网站在线人数的程序代码+后台有MYSQL数据库支持，可以直接统计出网站当前的在线人数。
首先我创建MYSQL数据库表。
CREATE TABLE tablename (
field type(max_length) DEFAULT 'default_value' (NOT) NULL
}可以使用的SQL语句。6 ?. g6 ^/ `% }
CREATE TABLE useronline (( c' _% H8 }0 l
timestamp int(15) DEFAULT '0' NOT NULL,7 p( w! Y; j. [. H
ip varchar(40) NOT NULL,* I6 J+ x; u  t* w' m
file varchar(100) NOT NULL,- C0 x4 B+ p- r7 Q6 D
PRIMARY KEY (timestamp),9 H6 [/ j$ ?- h& J3 k( X
KEY ip (ip),
KEY file (file)
);下面我们是PHP脚本，首先我定义MYSQL的信息。! T) c3 Z, D' k9 I' Q7 ~
$server = "localhost"; //你的服务器
$db_user = "root"; //你的mysql的用户名
$db_pass = "password"; //你的mysql的密码
$database = "users"; //表的名字设置统计的时间(多少秒内在线人数)% ]# E, P  ]) c' e' E/ s. t$ n- i  o
$timeoutseconds = 300;取当前时间。4 n+ X  Y* J$ ~: p+ k
$timestamp = time();上面的完整代码：
<?php2 r, ~' a$ L! ?- j
$server = "localhost"; //your server
$db_user = "root"; //your mysql database username
$db_pass = "password"; //your mysql database password if any
$database = "users"; //the db name
$timeoutseconds = 300;//timeoutseconds limit1 K6 F3 e3 z5 F( U7 F) e
//get the current time
$timestamp = time();
//calculate the lowest timestamp allowed" ?+ e( _5 d; C$ j7 C
$timeout = $timestamp-$timeoutseconds;/ i, _8 I4 N- m# P7 v
?>连接mysql
mysql_connect('localhost', 'username', 'password');也允许使用变量形式。
mysql_connect($server, $db_user, $db_pass);如果mysql数据库没有密码的话可以使用下面代码连接& a7 l, F' l: k) z- T6 H
mysql_connect($server, $db_user);查询数据库的代码：/ @, ?/ i( q7 n) u. ~" v7 A5 E# `
mysql_db_query('database', 'query');我们只要有访客就要增加一条记录。0 ]. d: l/ y- F
$insert = mysql_db_query($database, "INSERT INTO useronline VALUES! D' t' I* y( n1 O  S! ~
('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");
如果用户用错误信息的话，这样处理。6 N6 M9 E) \% B9 h
if(!($insert)) {
print "Useronline Insert Failed > ";
}然后实现当超过设置的时间就删除该用户记录。( |/ i8 u( t6 |
$delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");同样给出删除记录出错的处理。' L0 [4 S7 B4 B9 j! Y' P" n6 E
if(!($delete)) {
print "Useronline Delete Failed > ";9 D: l' [7 O1 m( t6 \
}下面我们解决数据库中不同IP的问题4 V2 j" N' M/ Y
$result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");使用
mysql_num_rows(query);来统计用户，代码如下。2 W% b5 Y; X5 f: O# `( x
$user = mysql_num_rows($result);最后关闭数据库。
mysql_close();显示在线的人数。2 \0 K* _- J9 F! z
if($user == 1) {# M0 l8 W  c% J' V! g$ E: ^  a8 H' V; K
print("1 user online\n");& x( t: P9 A. d( @
} else {* T% C* @  q! p( l4 v! N
print("$user users online\n");: R$ V8 H8 g5 T: B2 |' s5 d
}最终把上面代码写成一个PHP文件如下。: C( [3 C* n" t6 X& B2 V- x7 O
<?php
//Put your basic server info here
$server = "localhost"; //normally localhost# u6 L* F$ G7 w. K: j* c6 N, T
$db_user = "root"; //your MySQL database username) {! a6 n, }, o; L
$db_pass = "password"; //your MySQL database password
$database = "users";' G/ \! `2 n0 @/ {9 |% R" }" r7 i
$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 last
// $timeoutseconds seconds)
//this is where PHP gets the time6 s5 O" x7 t7 m2 x1 ]
$timestamp = time();4 n1 {  l. U: x% b
//counts the timeout, all people which have been seen last online in earlier than this timestamp, will get removed1 E9 g: X- m) J% @# m% |
$timeout = $timestamp-$timeoutseconds;/ \& c! v' `" N. m5 n
//connect to database
mysql_connect($server, $db_user);
//add the timestamp from the user to the online list
$insert = mysql_db_query($database, "INSERT INTO useronline VALUES. g  K6 k, Y" s0 q
('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");
if(!($insert)) {
print "Useronline Insert Failed > ";7 ]3 M& P4 z5 C
}' B( e0 ~( b/ p
//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");% e. a3 M" Z7 p/ d# i( K0 p$ K. L
if(!($delete)) {
print "Useronline Delete Failed > ";
}
//select the amount of people online, all uniques, which are online on THIS page
$result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");* {9 f8 J- \4 {' ^* t8 b5 c2 o6 n
if(!($result)) {1 k+ y* `  k' I, M! k2 D; z  j
print "Useronline Select Error > ";! _# @. h/ V; C; ^- K! ?' Y
}0 q' D/ s2 v4 f. |3 d# n* d
//Count the number of rows = the number of people online/ d/ q  p1 Z! B+ A2 ~
$user = mysql_num_rows($result);
//spit out the results
mysql_close();
if($user == 1) {4 q% V- P5 o, V- o7 t( s6 ^
print("1 user online\n");; U) b: ]0 ^# e; h2 R& ]! q+ i4 m+ B1 m
} else {
print("$user users online\n");/ h. ^: v- [1 m% ^  z& e1 ^
}( Z# H6 \1 n0 V; G% _
?>

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

返回列表

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

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

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