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

主机, 虚拟主机

刚用PHP写了一个网站在线人数的程序，请大家进来指点下！8 w! m5 |" _- B' k& V$ h0 p4 y
我是用PHP+MYSQL来写的，原理：网站在线人数的程序代码+后台有MYSQL数据库支持，可以直接统计出网站当前的在线人数。& [4 F% Q* C6 |+ |! m/ ^
首先我创建MYSQL数据库表。+ Y- y! J" @7 |
CREATE TABLE tablename (
field type(max_length) DEFAULT 'default_value' (NOT) NULL2 b' k/ |% b$ p3 j
}可以使用的SQL语句。
CREATE TABLE useronline (
timestamp int(15) DEFAULT '0' NOT NULL,
ip varchar(40) NOT NULL,
file varchar(100) NOT NULL,; E+ n2 C) O  ~9 }7 ^
PRIMARY KEY (timestamp),7 C! c$ `1 {4 ~9 g
KEY ip (ip),
KEY file (file)# _+ J- T+ d6 L
);下面我们是PHP脚本，首先我定义MYSQL的信息。& _9 R% d( @5 h- O
$server = "localhost"; //你的服务器
$db_user = "root"; //你的mysql的用户名
$db_pass = "password"; //你的mysql的密码2 v% g7 |8 W5 f% ?& Z
$database = "users"; //表的名字设置统计的时间(多少秒内在线人数)) S7 M9 w, P5 O$ g2 C" }
$timeoutseconds = 300;取当前时间。0 g4 X% ?8 M5 o6 \; w
$timestamp = time();上面的完整代码：) i( b, e+ N8 b/ V) d
<?php" e+ x7 a5 i8 d: |
$server = "localhost"; //your server
$db_user = "root"; //your mysql database username- f9 N0 w* f2 E7 F, {
$db_pass = "password"; //your mysql database password if any
$database = "users"; //the db name7 E+ ^# E2 a. p+ B4 \
$timeoutseconds = 300;//timeoutseconds limit/ ^0 L6 B7 X) ^+ w' S9 ~/ r
//get the current time6 l% f! S+ R; }" g4 o1 q) i# S
$timestamp = time();
//calculate the lowest timestamp allowed
$timeout = $timestamp-$timeoutseconds;6 S; e- Z) q0 N" H8 Q& I, @' e
?>连接mysql
mysql_connect('localhost', 'username', 'password');也允许使用变量形式。
mysql_connect($server, $db_user, $db_pass);如果mysql数据库没有密码的话可以使用下面代码连接
mysql_connect($server, $db_user);查询数据库的代码：
mysql_db_query('database', 'query');我们只要有访客就要增加一条记录。
$insert = mysql_db_query($database, "INSERT INTO useronline VALUES; Q7 ]  l! r# ~
('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");$ |" t4 ]3 f7 E  M* l3 t
如果用户用错误信息的话，这样处理。/ Z4 w; r$ j6 y8 Q* @' T7 O
if(!($insert)) {
print "Useronline Insert Failed > ";
}然后实现当超过设置的时间就删除该用户记录。: H% V; o) z0 n. ]* Q3 s# ^
$delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");同样给出删除记录出错的处理。, k0 C# I: m+ W8 z$ ~6 A. h
if(!($delete)) {
print "Useronline Delete Failed > ";" y4 u6 ]7 T: a& L" U1 L, u  Q
}下面我们解决数据库中不同IP的问题; E# O& s* t% ]& D
$result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");使用- X: |$ Q0 Q4 {8 K; ~
mysql_num_rows(query);来统计用户，代码如下。4 D) H- w8 R0 |& l
$user = mysql_num_rows($result);最后关闭数据库。
mysql_close();显示在线的人数。
if($user == 1) {
print("1 user online\n");
} else {
print("$user users online\n");! [  p. R. \" x$ W( P" `3 t
}最终把上面代码写成一个PHP文件如下。) l; n$ b  n( x/ {7 _6 f. o
<?php- \8 P* Q$ j/ b
//Put your basic server info here
$server = "localhost"; //normally localhost6 Z% l( d" J8 k( f0 _0 ~4 m
$db_user = "root"; //your MySQL database username
$db_pass = "password"; //your MySQL database password# [. R3 Y3 J* i# Y* H8 w
$database = "users";
$timeoutseconds = 300; //it will delete all people which haven't refreshed(so probbably are4 `" @1 D1 _6 {" o+ f" C
// offline or inactive) in $timieoutseconds time (so it actually checks the people that are active in the last' i- Z4 y0 p, s0 t7 k
// $timeoutseconds seconds); B  Z7 ?; C9 u7 `
//this is where PHP gets the time" J: G8 d. s* Y/ r" s* B
$timestamp = time();; x1 [/ s  S- S0 M2 w( ?
//counts the timeout, all people which have been seen last online in earlier than this timestamp, will get removed! K0 \# D) p0 p  j
$timeout = $timestamp-$timeoutseconds;: q# {3 ^5 z( L+ Q
//connect to database! L! K7 l3 \( c' E; k- \
mysql_connect($server, $db_user);
//add the timestamp from the user to the online list
$insert = mysql_db_query($database, "INSERT INTO useronline VALUES
('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");8 e1 f! o  C; W
if(!($insert)) {
print "Useronline Insert Failed > ";
}* {$ Q% Q, _% ?& t7 a1 }, v8 U
//delete the peoples which haven't been online/active in the last $timeoutseconds seconds.9 m- N' T. ^' K9 E0 D) P9 }
$delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");
if(!($delete)) {! M2 m$ w) A7 \9 o7 X8 T, J
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']."' ");7 K" B/ @& D/ p$ y# J/ j# Q" U% }) d
if(!($result)) {
print "Useronline Select Error > ";; z5 D4 G- [1 v; O8 Y$ O$ ?+ \
}
//Count the number of rows = the number of people online; E: L; g2 o5 S$ [8 n
$user = mysql_num_rows($result);0 J& d4 u1 G3 f2 q0 _  u
//spit out the results
mysql_close();
if($user == 1) {% S( W0 J/ z0 N; a1 ]
print("1 user online\n");* T6 {. ]" \# }
} else {- ^; B7 |5 p0 v0 l  S. e
print("$user users online\n");
}- P& o4 u' ^) m# l" u. Y
?>2 N* g0 b2 n- C4 I% x

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

返回列表

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

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

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