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

主机, 虚拟主机

刚用PHP写了一个网站在线人数的程序，请大家进来指点下！
我是用PHP+MYSQL来写的，原理：网站在线人数的程序代码+后台有MYSQL数据库支持，可以直接统计出网站当前的在线人数。& s  r/ j" o' W# r& L+ @6 f1 i- i- [
首先我创建MYSQL数据库表。
CREATE TABLE tablename (
field type(max_length) DEFAULT 'default_value' (NOT) NULL
}可以使用的SQL语句。$ F' t2 c1 X" a/ |
CREATE TABLE useronline (& H% @1 B. D+ s$ z0 I
timestamp int(15) DEFAULT '0' NOT NULL,
ip varchar(40) NOT NULL,: m7 b& J5 T) s$ F: x9 c7 S' w! l7 H
file varchar(100) NOT NULL,! w  s3 e0 ]8 ]4 i
PRIMARY KEY (timestamp),
KEY ip (ip),+ j( t: T; S1 `- J
KEY file (file)' V: d" G- O/ v4 O+ d
);下面我们是PHP脚本，首先我定义MYSQL的信息。* w7 r0 g5 ^  K# t, P' @
$server = "localhost"; //你的服务器
$db_user = "root"; //你的mysql的用户名
$db_pass = "password"; //你的mysql的密码
$database = "users"; //表的名字设置统计的时间(多少秒内在线人数)" K: w( @2 r# c6 g5 n
$timeoutseconds = 300;取当前时间。# ^* U7 A8 E) V/ H
$timestamp = time();上面的完整代码：" f3 e. H: W+ d" f
<?php
$server = "localhost"; //your server9 J1 M1 R- x: \+ K
$db_user = "root"; //your mysql database username
$db_pass = "password"; //your mysql database password if any
$database = "users"; //the db name) c& E" q5 g1 j
$timeoutseconds = 300;//timeoutseconds limit7 ^* }# Z1 a; d: j, e$ ?9 z+ Y) N9 j
//get the current time
$timestamp = time();! J' Q3 [: [  n
//calculate the lowest timestamp allowed1 D) d. m/ v. ~9 D/ Z
$timeout = $timestamp-$timeoutseconds;9 L7 x& ^, m5 S$ H& r& x7 G
?>连接mysql. O1 b% E! z  P5 z. A& l: \7 |0 b6 D
mysql_connect('localhost', 'username', 'password');也允许使用变量形式。! L" G7 G/ N  F- Y$ Y
mysql_connect($server, $db_user, $db_pass);如果mysql数据库没有密码的话可以使用下面代码连接: `- U  I* V, V8 ~  y) B1 \9 d
mysql_connect($server, $db_user);查询数据库的代码：8 p3 s( A" m- ^& _2 v  N
mysql_db_query('database', 'query');我们只要有访客就要增加一条记录。0 c% f5 t7 e( _. R/ s1 R9 C
$insert = mysql_db_query($database, "INSERT INTO useronline VALUES
('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");8 M- |' n7 G1 c
如果用户用错误信息的话，这样处理。
if(!($insert)) {
print "Useronline Insert Failed > ";
}然后实现当超过设置的时间就删除该用户记录。8 d* d8 h4 D) z1 B
$delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");同样给出删除记录出错的处理。
if(!($delete)) {
print "Useronline Delete Failed > ";
}下面我们解决数据库中不同IP的问题7 X6 U; q3 w" ?7 z
$result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");使用
mysql_num_rows(query);来统计用户，代码如下。% P  H8 D" f3 g- N- G" w3 ]/ D
$user = mysql_num_rows($result);最后关闭数据库。( h9 x# O9 }/ h+ E" f, E
mysql_close();显示在线的人数。
if($user == 1) {; [3 Z. Z" f+ g
print("1 user online\n");
} else {
print("$user users online\n");
}最终把上面代码写成一个PHP文件如下。
<?php3 ^2 Q. k8 O' e# L7 ]! {" @5 [
//Put your basic server info here% Y) @5 ]) j/ v9 P' u/ |
$server = "localhost"; //normally localhost
$db_user = "root"; //your MySQL database username
$db_pass = "password"; //your MySQL database password
$database = "users";
$timeoutseconds = 300; //it will delete all people which haven't refreshed(so probbably are" `' H' k' u( W$ P
// offline or inactive) in $timieoutseconds time (so it actually checks the people that are active in the last( @3 o7 u8 x3 V' t: ?) D6 ?/ u" [
// $timeoutseconds seconds)+ P, y6 w5 ]6 R- C8 I: k$ e
//this is where PHP gets the time9 c; f8 D# I2 C% ^; C" G7 h* e; e
$timestamp = time();1 O% s; k1 ]" o* @1 Q, B" I8 i
//counts the timeout, all people which have been seen last online in earlier than this timestamp, will get removed: W+ j5 I( T4 J7 o# y2 G# j
$timeout = $timestamp-$timeoutseconds;$ r7 B. I4 A8 o* A, T
//connect to database4 i. {" G4 C; ^7 e. v
mysql_connect($server, $db_user);, N* ~) z7 R& s0 w
//add the timestamp from the user to the online list$ D# s; F7 L, \; U
$insert = mysql_db_query($database, "INSERT INTO useronline VALUES7 T4 n/ ^1 ^: v8 ?
('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");0 b/ [- p: }4 I" ?  s! M
if(!($insert)) {9 u9 F; x* n8 X
print "Useronline Insert Failed > ";$ D# v. q1 D) l8 ^# {8 {4 x+ i
}
//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");+ l8 ?' U) u0 }8 U4 I* ~
if(!($delete)) {
print "Useronline Delete Failed > ";
}6 |/ L& }% w! g/ |
//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']."' ");0 K7 _3 |6 n% Z0 R2 G
if(!($result)) {
print "Useronline Select Error > ";. e8 `+ D7 o1 P7 M7 a
}- [/ L# t& r& {2 y  ?- k6 ?
//Count the number of rows = the number of people online9 }5 a% I* p4 \5 |
$user = mysql_num_rows($result);
//spit out the results$ v" ^% f5 c2 Z7 |( a: f
mysql_close();
if($user == 1) {/ S3 L$ l# C; n! _  ~1 t$ {5 i
print("1 user online\n");
} else {% e6 u* e9 K* d* j! U: U
print("$user users online\n");  `: |* W, w  q
}
?>

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

返回列表

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

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

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