捌玖网络工作室 » 电脑软件 » 刚用PHP写了一个网站在线人数的程序，请大家进来指点下！

lilcy88 发表于 2008-5-28 10:40

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

刚用PHP写了一个网站在线人数的程序，请大家进来指点下！
3}S"~7Yo 我是用PHP+MYSQL来写的，原理：网站在线人数的程序代码+后台有MYSQL数据库支持，可以直接统计出网站当前的在线人数。](K:b&{}!A@y3c
TI3~
首先我创建MYSQL数据库表。
$IErQ;j5dN
a-y CREATE TABLE tablename (z5ZN#fQG%Q*e7F:D
field type(max_length) DEFAULT 'default_value' (NOT) NULL
1Yf"y5^J&R&Y }可以使用的SQL语句。0g XaH+dl,~:~
CREATE TABLE useronline (
:^@AUlRjP timestamp int(15) DEFAULT '0' NOT NULL,w&x(@y O
ip varchar(40) NOT NULL,
j c9m ul8c yO file varchar(100) NOT NULL,
Qw9g!SY-O_,l A PRIMARY KEY (timestamp),
;y6m7T Oz KEY ip (ip),
e&xy*UZXV ]:}gZ KEY file (file)
L^ ~F}B:]UQ );下面我们是PHP脚本，首先我定义MYSQL的信息。
X.v
xE9T b'Go $server = "localhost"; //你的服务器1wq&}P!A^L qs
$db_user = "root"; //你的mysql的用户名Zch5qhEw
$db_pass = "password"; //你的mysql的密码0tB#w K9jd~
$database = "users"; //表的名字设置统计的时间(多少秒内在线人数)
*j2u$d-E5w_q $timeoutseconds = 300;取当前时间。 cHW7{c~0]7y
$timestamp = time();上面的完整代码：u't"d"Ce7`3`
<?phpMa
HK1h(Y:b
$server = "localhost"; //your server
O x%AWmh2{
$db_user = "root"; //your mysql database username|VdaG
$db_pass = "password"; //your mysql database password if any6q3G~.R{
$database = "users"; //the db name7y+]It&m+wB;| f
$timeoutseconds = 300;//timeoutseconds limit V#P bl+`kO
//get the current time
y&P+cor5N $timestamp = time();
#G?FB3M~0e //calculate the lowest timestamp allowedqc-?-\7c@~s1ih6X
$timeout = $timestamp-$timeoutseconds;9G uX\w6Q,K
?>连接mysql
]F%m,FUJ9e mysql_connect('localhost', 'username', 'password');也允许使用变量形式。
!t9G?i)eH8hF:XO:] mysql_connect($server, $db_user, $db_pass);如果mysql数据库没有密码的话可以使用下面代码连接f5g\5i'nL
mysql_connect($server, $db_user);查询数据库的代码：4R;{&c4c H#U_7F
mysql_db_query('database', 'query');我们只要有访客就要增加一条记录。
IN,O
W$LVi@M)}5Z $insert = mysql_db_query($database, "INSERT INTO useronline VALUES
~ A&OC)H[3im+wqhN ('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");we,S zBN!`
如果用户用错误信息的话，这样处理。)h(tzLS`8LBs
if(!($insert)) {\ WyL6l&t'{9q6_
print "Useronline Insert Failed > ";
W/v
VK]m*C6P,B+I }然后实现当超过设置的时间就删除该用户记录。
&m)Y!JbyB*zt z $delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");同样给出删除记录出错的处理。
.u$n#ir\ if(!($delete)) {
nhC5~^ print "Useronline Delete Failed > ";
6~zI(E~ N/Y:J'H }下面我们解决数据库中不同IP的问题`:{6ID;f4B6@ V0y]
$result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");使用
1L[7Fg9Qh9S mysql_num_rows(query);来统计用户，代码如下。)S#nNA%w1O6x
$user = mysql_num_rows($result);最后关闭数据库。
i1L l/w#T%b;Nj mysql_close();显示在线的人数。y+}l,YM0`b
if($user == 1) {
u@
JU[[ print("1 user online\n");3To"} h}F6r.z%[\7l
} else {
W(~"E
]\] print("$user users online\n");
w(h\r'M/N[v g }最终把上面代码写成一个PHP文件如下。'Sh ya\oT7O
<?php
WT-l)Y
z-^ //Put your basic server info here
G+Gg7ohel!Y*?J $server = "localhost"; //normally localhost7e:Mg)dE8cs'b
$db_user = "root"; //your MySQL database username
8C&i,HxLXK $db_pass = "password"; //your MySQL database password
;rW7csh sZz $database = "users";y%IK8P)_vY!t/},E
$timeoutseconds = 300; //it will delete all people which haven't refreshed(so probbably are0r$~&_jr`e1`v
// offline or inactive) in $timieoutseconds time (so it actually checks the people that are active in the last#E5P[aQh*~ bo
// $timeoutseconds seconds)
@$]*m$VG //this is where PHP gets the time_?*DQ%K ?O
$timestamp = time();fq"{FC6J} i0r$m0w j f
//counts the timeout, all people which have been seen last online in earlier than this timestamp, will get removed0xv
EL-cg@j(OD)N(]
$timeout = $timestamp-$timeoutseconds;
q5P0K)l%])R //connect to database
@ Y Co G:o&Q"s mysql_connect($server, $db_user);
F;vBG+?3W` //add the timestamp from the user to the online list
5w JlBo8Pa/gJ0i $insert = mysql_db_query($database, "INSERT INTO useronline VALUESKCfGA5\%OhG
('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");5UTEC)B$^O^j
if(!($insert)) {
!i7\ RD1xQ print "Useronline Insert Failed > ";
i~9v!]m:sbMt }
\6U { o#W^0Nm1PL2m //delete the peoples which haven't been online/active in the last $timeoutseconds seconds.
gw iQ~(^6K+jfNIZ $delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");J:Vm?%b Zxc
if(!($delete)) {
n.}!AAO print "Useronline Delete Failed > ";
4C P$Db U0Ql9g }
W dj!E` r2B //select the amount of people online, all uniques, which are online on THIS page
^`9R-^
B$Cy:k
$result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");
|,g;V1m'u%H if(!($result)) { brdF$`?n|E
print "Useronline Select Error > ";"~{.U7v dw l C+A
}3L~%p zFs(?#b,A
//Count the number of rows = the number of people online
9BOe*i-J/x7}7o $user = mysql_num_rows($result);Y
g;D%Fq:P4m@/GykTE
//spit out the resultsq7G.xLtE*C;[
mysql_close();@E$Yf*I"CnL
if($user == 1) {
QJkFH9j6K print("1 user online\n");
? p@ V$]s } else {l;eC.Ed)T+@`G#}
print("$user users online\n");7p}[nLj
}-n^
YMi3w
?>$T+m:F Uy&Br-A
[url=http://www.now.cn/vhost/][img]http://b.todayisp.com/bbs/760x90h.gif[/img][/url]
^D/N(c%{ @(\/b 以上代码我是在时代互联提供的免费试用主机上测试的，感觉效果还不错，性能很稳定，不信的话你也可以去试试。当然，记得指出我这个程序中的不足先哦。
j,y2]-j5b+r YTu*ae 时代互联是行业内最早开始提供PHP 虚拟主机的公司之一，现在已经是的金牌域名注册商和中国互联网客户满意度十佳单位，产品功能已经非常完善 ，特别提一下几个特有用的功能：数据库自动备份、免费集成繁简通简装版、多域名绑定、多子网站支持、GCDN 网站加速器、镜像加速、高级访问统计系统、支持WAP、可选电信/网通/香港机房。
3xQY/yD4o)s 我之前建站的时候选的是他们公司标准商务E型，因为这款机型还特别支持ASP.NET3.5(3.0/2.0/1.1)/ASP。
D'o-e0CH 当然啦，这两款主机也是相当不错的。
#K,i1pfm 智强商务B型：Unix /Linux 操作系统+独立网页空间1000MB+送1000MB邮局空间+100MB MySQL数据库空间=1869元/年\#x1lQ?o&l
v
标准商务B型：Unix /Linux 操作系统+独立网页空间500MB+送800MB邮局空间+60MB MySQL数据库空间=1365元/年,J{Hj$g8EI7c:V Fi
提供一下这个公司的联系方式：请见：[url=http://www.now.cn/vhost/]http://www.now.cn/vhost/[/url] .G.zW*?#@.^G
空间专线： 0756-2623871  QQ：168075865，好象还有全球免费网络电话:全球免费咨询电话 [url=http://www.now.cn/callcenter/call.net?LineName=55]http://www.now.cn/callcenter/call.net?LineName=55[/url]
M8P,pY1s0v/^(B 自己加QQ去问吧。

查看完整版本: 刚用PHP写了一个网站在线人数的程序，请大家进来指点下！