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

主机, 虚拟主机

刚用PHP写了一个网站在线人数的程序，请大家进来指点下！
我是用PHP+MYSQL来写的，原理：网站在线人数的程序代码+后台有MYSQL数据库支持，可以直接统计出网站当前的在线人数。+ |6 R3 e' f- i. `$ \' c+ M4 A
首先我创建MYSQL数据库表。
CREATE TABLE tablename (
field type(max_length) DEFAULT 'default_value' (NOT) NULL
}可以使用的SQL语句。
CREATE TABLE useronline (
timestamp int(15) DEFAULT '0' NOT NULL,
ip varchar(40) NOT NULL,
file varchar(100) NOT NULL,
PRIMARY KEY (timestamp),
KEY ip (ip),
KEY file (file)
);下面我们是PHP脚本，首先我定义MYSQL的信息。4 G6 `+ `/ k" Q  m! _
$server = "localhost"; //你的服务器8 _+ ], `/ w  [5 i) r4 \6 I1 ~3 o
$db_user = "root"; //你的mysql的用户名
$db_pass = "password"; //你的mysql的密码% X& Y1 A% F8 k8 `) U
$database = "users"; //表的名字设置统计的时间(多少秒内在线人数)
$timeoutseconds = 300;取当前时间。2 w$ g9 d3 \# O# k
$timestamp = time();上面的完整代码：0 ^6 ^: K+ c! y2 H
<?php
$server = "localhost"; //your server, C% ?3 _) Z1 I
$db_user = "root"; //your mysql database username
$db_pass = "password"; //your mysql database password if any
$database = "users"; //the db name
$timeoutseconds = 300;//timeoutseconds limit
//get the current time, P8 Z. L7 G! _! Q( _& f( H4 m
$timestamp = time();
//calculate the lowest timestamp allowed7 c3 S5 n3 b) v! C
$timeout = $timestamp-$timeoutseconds;
?>连接mysql
mysql_connect('localhost', 'username', 'password');也允许使用变量形式。, H0 Y$ h7 L3 p
mysql_connect($server, $db_user, $db_pass);如果mysql数据库没有密码的话可以使用下面代码连接
mysql_connect($server, $db_user);查询数据库的代码：+ o; S8 r* p4 G( p1 s$ c; P
mysql_db_query('database', 'query');我们只要有访客就要增加一条记录。/ c1 `  O; G3 W: A; L; e6 H
$insert = mysql_db_query($database, "INSERT INTO useronline VALUES
('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");
如果用户用错误信息的话，这样处理。
if(!($insert)) {
print "Useronline Insert Failed > ";
}然后实现当超过设置的时间就删除该用户记录。
$delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");同样给出删除记录出错的处理。+ U9 x+ }2 |' p) g# q
if(!($delete)) {) u  Y9 m7 i4 }3 l$ ]
print "Useronline Delete Failed > ";
}下面我们解决数据库中不同IP的问题9 t( m' W& v! r$ L
$result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");使用' N* h; P; i* C$ ^9 b! k; P; c# {7 J
mysql_num_rows(query);来统计用户，代码如下。
$user = mysql_num_rows($result);最后关闭数据库。( P% o! i% {( o
mysql_close();显示在线的人数。& N  a; \. T9 _
if($user == 1) {
print("1 user online\n");( l' J' H& n$ n
} else {& |6 f# r- ^$ Z7 {3 Z
print("$user users online\n");
}最终把上面代码写成一个PHP文件如下。
<?php
//Put your basic server info here( M- z7 n& d& D* Q/ D5 ~# L+ P- U
$server = "localhost"; //normally localhost
$db_user = "root"; //your MySQL database username
$db_pass = "password"; //your MySQL database password; i% r6 r" Z9 C3 F& r5 C* v
$database = "users";4 s$ B- ]9 ]' w
$timeoutseconds = 300; //it will delete all people which haven't refreshed(so probbably are7 L6 w. C; v4 q# @
// 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 time1 @+ F1 i4 P0 y/ l) l9 {8 n  \
$timestamp = time();8 m) S6 a7 y2 A3 q7 ~
//counts the timeout, all people which have been seen last online in earlier than this timestamp, will get removed
$timeout = $timestamp-$timeoutseconds;  f. u* F9 K2 m- \
//connect to database& _- x( `2 [+ q7 ^  Z) ^) ^& J' q, K
mysql_connect($server, $db_user);
//add the timestamp from the user to the online list1 o  r5 c, P1 J  n; `% \
$insert = mysql_db_query($database, "INSERT INTO useronline VALUES0 X( S  ?3 _; _, Z0 v! g$ L
('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");/ T3 ^/ }8 \4 P$ ?# K
if(!($insert)) {
print "Useronline Insert Failed > ";
}
//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");( Y7 J, I0 Z+ \' z
if(!($delete)) {" Y- l( [  S7 ]: \
print "Useronline Delete Failed > ";
}% w6 L. ]3 R' |! `
//select the amount of people online, all uniques, which are online on THIS page7 l4 @5 y3 d& `, b7 A8 F6 T# A, l
$result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");) ~6 U- g1 G1 Q' a8 _& `
if(!($result)) {# |+ X2 I6 N6 ^  ?6 b% I# {! l" L
print "Useronline Select Error > ";
}; b9 a/ b( j- L& v
//Count the number of rows = the number of people online
$user = mysql_num_rows($result);
//spit out the results* v6 |8 h3 ]+ p  T1 _) V
mysql_close();
if($user == 1) {. I/ Q) J4 x$ Z- D( O
print("1 user online\n");
} else {
print("$user users online\n");
}
?>! C. U8 B  v3 y

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

返回列表

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

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

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