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

主机, 虚拟主机

刚用PHP写了一个网站在线人数的程序，请大家进来指点下！
我是用PHP+MYSQL来写的，原理：网站在线人数的程序代码+后台有MYSQL数据库支持，可以直接统计出网站当前的在线人数。  S, g, Y/ P8 s: [: P* B( l
首先我创建MYSQL数据库表。
CREATE TABLE tablename () ]2 \6 B1 |3 h9 Y7 J
field type(max_length) DEFAULT 'default_value' (NOT) NULL# `" D1 P; x' Y# |
}可以使用的SQL语句。
CREATE TABLE useronline (
timestamp int(15) DEFAULT '0' NOT NULL,6 U' D" }, Y3 p1 H
ip varchar(40) NOT NULL,
file varchar(100) NOT NULL,2 h2 g; |. f' q. V6 n4 K, ~0 |  B- j
PRIMARY KEY (timestamp),6 D7 O4 M5 c# E4 Z4 N  |
KEY ip (ip),4 O. w+ V  H* N6 k
KEY file (file)+ v1 K9 d# a. R
);下面我们是PHP脚本，首先我定义MYSQL的信息。; s6 s/ h4 C7 o+ R4 ]
$server = "localhost"; //你的服务器
$db_user = "root"; //你的mysql的用户名+ ]0 e$ Q8 ^3 f8 Z% ]4 r& F8 J
$db_pass = "password"; //你的mysql的密码
$database = "users"; //表的名字设置统计的时间(多少秒内在线人数)
$timeoutseconds = 300;取当前时间。% B' g. d0 F4 i, ?( ?# v
$timestamp = time();上面的完整代码：
<?php' p% U  g2 V2 K' Q: r( i
$server = "localhost"; //your server
$db_user = "root"; //your mysql database username
$db_pass = "password"; //your mysql database password if any
$database = "users"; //the db name8 f2 k) e+ H. Q& V: V. b
$timeoutseconds = 300;//timeoutseconds limit2 N' m8 f. d$ ^- V7 n+ T' ?8 T
//get the current time# k! h6 w* z/ G
$timestamp = time();
//calculate the lowest timestamp allowed
$timeout = $timestamp-$timeoutseconds;
?>连接mysql
mysql_connect('localhost', 'username', 'password');也允许使用变量形式。
mysql_connect($server, $db_user, $db_pass);如果mysql数据库没有密码的话可以使用下面代码连接
mysql_connect($server, $db_user);查询数据库的代码：" v: [, y- T1 N2 }+ L
mysql_db_query('database', 'query');我们只要有访客就要增加一条记录。& h, b- \6 T; u# G! j, K' ~
$insert = mysql_db_query($database, "INSERT INTO useronline VALUES: }& `( w/ {3 G
('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");
如果用户用错误信息的话，这样处理。
if(!($insert)) {. ~' {, t4 U$ \) j' k; B- @  Q
print "Useronline Insert Failed > ";
}然后实现当超过设置的时间就删除该用户记录。* o) p. ~. l- X% G, [
$delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");同样给出删除记录出错的处理。/ h1 F# y5 r' j1 u% _2 P+ D  K' O! A
if(!($delete)) {
print "Useronline Delete Failed > ";
}下面我们解决数据库中不同IP的问题' p9 j% a0 s+ B: F, N- H" @+ Q
$result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");使用/ k! E! J$ C( q% v9 e5 f" @
mysql_num_rows(query);来统计用户，代码如下。# b) r  o6 w) M$ H4 I
$user = mysql_num_rows($result);最后关闭数据库。
mysql_close();显示在线的人数。
if($user == 1) {
print("1 user online\n");7 `" m3 B$ t0 |# q. v
} else {  Z) A, I7 k8 k/ H& b' R
print("$user users online\n");
}最终把上面代码写成一个PHP文件如下。! g" a4 _; H, n# w4 K
<?php
//Put your basic server info here" N1 i) u; z3 @2 |
$server = "localhost"; //normally localhost
$db_user = "root"; //your MySQL database username# U7 `$ p0 N9 G% {6 ~/ e0 Y
$db_pass = "password"; //your MySQL database password. |3 u1 U. ]8 l9 J
$database = "users";
$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* Q% x4 R- z' N- _9 g& S  N9 Z: R
// $timeoutseconds seconds)
//this is where PHP gets the time6 T4 p% F3 i# j2 @2 R/ t* v
$timestamp = time();
//counts the timeout, all people which have been seen last online in earlier than this timestamp, will get removed
$timeout = $timestamp-$timeoutseconds;* S5 K" p8 C$ T' e* S; E
//connect to database6 {6 g7 k3 A, h3 p5 d, t9 K' z* @
mysql_connect($server, $db_user);* `+ S/ y5 P, X: u4 W
//add the timestamp from the user to the online list
$insert = mysql_db_query($database, "INSERT INTO useronline VALUES% X( `$ X+ v* Y
('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");
if(!($insert)) {
print "Useronline Insert Failed > ";( ^* {6 Q* l" ~6 x" _8 Y3 ?; M3 f* H
}
//delete the peoples which haven't been online/active in the last $timeoutseconds seconds./ T  Y8 }' }: m
$delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");! M) G: K6 Y2 U% [3 R/ [  X
if(!($delete)) {: b- }/ j. d8 [
print "Useronline Delete Failed > ";
}% ?( X; D) U# `3 A8 G- q
//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']."' ");
if(!($result)) {5 }' ~1 P$ D) g% C( P
print "Useronline Select Error > ";
}
//Count the number of rows = the number of people online
$user = mysql_num_rows($result);
//spit out the results
mysql_close();
if($user == 1) {  U$ C& p5 w$ B; v7 M0 S- J! Y. @
print("1 user online\n");0 J$ I, P+ r7 Q( J
} else {
print("$user users online\n");
}
?>4 ]; o3 Y* Z9 K! R, h

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

返回列表

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

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

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