刚用PHP写了一个网站在线人数的程序，请大家进来指点下！
刚用PHP写了一个网站在线人数的程序，请大家进来指点下！我是用PHP+MYSQL来写的，原理：网站在线人数的程序代码+后台有MYSQL数据库支持，可以直接统计出网站当前的在线人数。3Ik-{ V:~-e aZ
首先我创建MYSQL数据库表。#M S C6f CE4u u
CREATE TABLE tablename (
field type(max_length) DEFAULT 'default_value' (NOT) NULL
}可以使用的SQL语句。
CREATE TABLE useronline (t z'm,OqQ,n/u
timestamp int(15) DEFAULT '0' NOT NULL,
ip varchar(40) NOT NULL,
file varchar(100) NOT NULL,
PRIMARY KEY (timestamp),#c i wG5~ Pu v
KEY ip (ip),
KEY file (file) X*l1M v i"p)l0Mi
);下面我们是PHP脚本，首先我定义MYSQL的信息。
$server = "localhost"; //你的服务器A{L.gu"\ m
$db_user = "root"; //你的mysql的用户名 S a'O z u}
$db_pass = "password"; //你的mysql的密码
$database = "users"; //表的名字设置统计的时间(多少秒内在线人数)
$timeoutseconds = 300;取当前时间。 bb3vNm(?
$timestamp = time();上面的完整代码：
<?php
$server = "localhost"; //your serverF&dO,gf/h2aG T|
$db_user = "root"; //your mysql database username)b H l |j.v0X
$db_pass = "password"; //your mysql database password if any
$database = "users"; //the db name
$timeoutseconds = 300;//timeoutseconds limit
//get the current time
$timestamp = time();'b+v El?/X1Z"_
//calculate the lowest timestamp allowed
$timeout = $timestamp-$timeoutseconds;
?>连接mysql
mysql_connect('localhost', 'username', 'password');也允许使用变量形式。
mysql_connect($server, $db_user, $db_pass);如果mysql数据库没有密码的话可以使用下面代码连接*s8z6f$KHJ
mysql_connect($server, $db_user);查询数据库的代码：4[$@ ` k8\Q1K
mysql_db_query('database', 'query');我们只要有访客就要增加一条记录。tX*u r-k6c J IX7{O
$insert = mysql_db_query($database, "INSERT INTO useronline VALUES
('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");A1q!__/O/T4AG R |
如果用户用错误信息的话，这样处理。
if(!($insert)) {rPR8i k!bi c+cQ!@k
print "Useronline Insert Failed > "; J RG#|Z]wU2\!J
}然后实现当超过设置的时间就删除该用户记录。t@%J5l#n5b0GT9J C
$delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");同样给出删除记录出错的处理。s2\9@NW6x H
if(!($delete)) {
print "Useronline Delete Failed > ";
}下面我们解决数据库中不同IP的问题 ?;\kj0P}_x
$result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");使用
mysql_num_rows(query);来统计用户，代码如下。Km(k,J \+Y
$user = mysql_num_rows($result);最后关闭数据库。
mysql_close();显示在线的人数。\(^_ C_&X8T[)J
if($user == 1) { R3R N3f+l5U?{ X
print("1 user online\n");4E+wM5} o YZ
} else {
print("$user users online\n");
}最终把上面代码写成一个PHP文件如下。
<?phpj'QJ'_9d%E"a
//Put your basic server info here~*ol GV8y p2WC%D
$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
// offline or inactive) in $timieoutseconds time (so it actually checks the people that are active in the last
// $timeoutseconds seconds)9h x&^6e m)} N)V7V ~Nf!n
//this is where PHP gets the timel2x ~*?9Kc\#}*a `2D
$timestamp = time();
//counts the timeout, all people which have been seen last online in earlier than this timestamp, will get removed@2H C xp/`1r`w7C
$timeout = $timestamp-$timeoutseconds;
//connect to database
mysql_connect($server, $db_user);V5w i(G$`lg
//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']."')");r{o pm$T1?5e
if(!($insert)) { ip+]M RS$I!T$E
print "Useronline Insert Failed > ";QeG3Rr4`2y(} r
}
//delete the peoples which haven't been online/active in the last $timeoutseconds seconds.y `&xp*QE ],d `2Y
$delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");B3YZLJ!\ @^ }
if(!($delete)) {
print "Useronline Delete Failed > ";
} V8R(g,rNQ"jO
//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)) { fB)x'{ xFx
print "Useronline Select Error > ";
} Bu;FKuS
//Count the number of rows = the number of people online
$user = mysql_num_rows($result);0Hv#EE x!ac U
//spit out the results
mysql_close();$e2BW8G"Xy!f3i#s
if($user == 1) {1DO!u Aa9H;S
print("1 user online\n");
} else {
print("$user users online\n");
}"_ eu5e|.I'`2g#C4V
?>
[url=http://www.now.cn/vhost/][img]http://b.todayisp.com/bbs/760x90h.gif[/img][/url])a:\ H!BN5B.P4h
以上代码我是在时代互联提供的免费试用主机上测试的，感觉效果还不错，性能很稳定，不信的话你也可以去试试。当然，记得指出我这个程序中的不足先哦。
时代互联是行业内最早开始提供PHP 虚拟主机的公司之一，现在已经是的金牌域名注册商和中国互联网客户满意度十佳单位，产品功能已经非常完善 ，特别提一下几个特有用的功能：数据库自动备份、免费集成繁简通简装版、多域名绑定、多子网站支持、GCDN 网站加速器、镜像加速、高级访问统计系统、支持WAP、可选电信/网通/香港机房。
我之前建站的时候选的是他们公司标准商务E型，因为这款机型还特别支持ASP.NET3.5(3.0/2.0/1.1)/ASP。9sa F s/m;H3X
当然啦，这两款主机也是相当不错的。!R-K'A:K ^
智强商务B型：Unix /Linux 操作系统+独立网页空间1000MB+送1000MB邮局空间+100MB MySQL数据库空间=1869元/年
标准商务B型：Unix /Linux 操作系统+独立网页空间500MB+送800MB邮局空间+60MB MySQL数据库空间=1365元/年
提供一下这个公司的联系方式：请见：[url=http://www.now.cn/vhost/]http://www.now.cn/vhost/[/url] D!z(LB I`-D
空间专线： 0756-2623871 QQ：168075865，好象还有全球免费网络电话:全球免费咨询电话 [url=http://www.now.cn/callcenter/call.net?LineName=55]http://www.now.cn/callcenter/call.net?LineName=55[/url]
自己加QQ去问吧。
页:
[1]
