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

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

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

刚用PHP写了一个网站在线人数的程序，请大家进来指点下！
&q}ry.oR^?T.\nH-] 我是用PHP+MYSQL来写的，原理：网站在线人数的程序代码+后台有MYSQL数据库支持，可以直接统计出网站当前的在线人数。
,CbX y6AR 首先我创建MYSQL数据库表。
8sbO
uQ)f0I'~ CREATE TABLE tablename (
Cy1T geTR,w field type(max_length) DEFAULT 'default_value' (NOT) NULL#sezD9RBZ*Ae_
}可以使用的SQL语句。
O6ssCv CREATE TABLE useronline (n3H9G#[}aV'[%Y!c#V0R
timestamp int(15) DEFAULT '0' NOT NULL,
uy~Z"izYbN w ip varchar(40) NOT NULL,
o&R]7I)j file varchar(100) NOT NULL,
p}XMN@d#z }8jW'w PRIMARY KEY (timestamp),
4r3v(f&|-p KEY ip (ip),KK,_S3vFC
KEY file (file)
k$H8VzM'Q)\.y );下面我们是PHP脚本，首先我定义MYSQL的信息。
5`+ihAu7r"p V(V*v'] $server = "localhost"; //你的服务器
\&BvOXK [E $db_user = "root"; //你的mysql的用户名
Tv$AT1vZ)I qQw $db_pass = "password"; //你的mysql的密码
"r
R\j8hr3g7u $database = "users"; //表的名字设置统计的时间(多少秒内在线人数){0m&~?}DUXJ
$timeoutseconds = 300;取当前时间。
{m)^a hU;PDY $timestamp = time();上面的完整代码：
.c aE:Rf&W <?php
']gHw+n|1O $server = "localhost"; //your server:Z3u4Q1Nk:?xd
$db_user = "root"; //your mysql database username\"Rk/b,D/j1]ViU!G`p
$db_pass = "password"; //your mysql database password if any
d8ODi'd A5V $database = "users"; //the db name-t8mX7Mu.Y'm
$timeoutseconds = 300;//timeoutseconds limitM zD1Z|-J2F*Uk(i
//get the current time1d+^ Jc x2I(s^
$timestamp = time();
ijTTaVfcv //calculate the lowest timestamp allowed
'Ei%qn ? $timeout = $timestamp-$timeoutseconds;RG(N8KUO
?>连接mysql
`S8M/R-O4lz3t mysql_connect('localhost', 'username', 'password');也允许使用变量形式。
}.v3o'U$_'P*C mysql_connect($server, $db_user, $db_pass);如果mysql数据库没有密码的话可以使用下面代码连接
wR:L.{ P*_ mysql_connect($server, $db_user);查询数据库的代码："\ iQ8{4l+EhSh
~
mysql_db_query('database', 'query');我们只要有访客就要增加一条记录。fG2LH|8]
$insert = mysql_db_query($database, "INSERT INTO useronline VALUES
M \"]`W ('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");+I F6mxP+Qa
如果用户用错误信息的话，这样处理。HFV#{?\
if(!($insert)) {.N,[ T ? ULzs2o*W
print "Useronline Insert Failed > ";
jz|$@ QB3y+p
h }然后实现当超过设置的时间就删除该用户记录。E#Q;rKt'Q)Y#r
$delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");同样给出删除记录出错的处理。P1G4`:y7K6HUl
if(!($delete)) {
5U/b?"aW/s-J#h*m7xZb print "Useronline Delete Failed > ";
\pva3_~ }下面我们解决数据库中不同IP的问题
1v7?,sr*aGB+V,i1]@ $result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");使用4KHKT!^W7jy
mysql_num_rows(query);来统计用户，代码如下。
/xW1D7M&H&h $user = mysql_num_rows($result);最后关闭数据库。w*W-y-@(Be*[
mysql_close();显示在线的人数。C1o-g/V"k
if($user == 1) {olO l6]*HMl`
print("1 user online\n"); U[? v
G*bs'O
} else {$Iqal'g,DE(]#Qf
print("$user users online\n");
GB'?Lz;OUZ }最终把上面代码写成一个PHP文件如下。
I
?t^ D%_T_ <?php
[Uh|;o ef //Put your basic server info herev7QwKv
$server = "localhost"; //normally localhostn~x KY4]Fb7{
$db_user = "root"; //your MySQL database usernameq7yt;@;[m3o\
$db_pass = "password"; //your MySQL database password;cLH6R%c&Z9w4D
$database = "users";
`^rq#SjS} $timeoutseconds = 300; //it will delete all people which haven't refreshed(so probbably are2w"W+U!xQ,m.?O
// offline or inactive) in $timieoutseconds time (so it actually checks the people that are active in the last
WI$]%]-h$V // $timeoutseconds seconds)q#Si$b Q"}6\}Y
//this is where PHP gets the timeu'yl R5D}(d'{s
$timestamp = time();p;T9?,u^GhD*F-\@
//counts the timeout, all people which have been seen last online in earlier than this timestamp, will get removedr+mFY8p/J)e
$timeout = $timestamp-$timeoutseconds;
~@gz6}1W F //connect to database)ea}f6B!Z,l
mysql_connect($server, $db_user);1JJ'C
T0{[
//add the timestamp from the user to the online list.r+]QB$u@ B"h*}
$insert = mysql_db_query($database, "INSERT INTO useronline VALUES
K'iW'b(E\g ('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");'_^*Go1B,J-}s
if(!($insert)) {
!O\*\yM print "Useronline Insert Failed > ";'U6dT;]
[7jkKi
}V"S~rE
//delete the peoples which haven't been online/active in the last $timeoutseconds seconds.
n)c:F|5Q_'iOn $delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");Ah&t+jO#n:q
if(!($delete)) {
O1a0Ga:Q7rQnH,b print "Useronline Delete Failed > ";r
E:M+h#EB
}
W0WsUGM
//select the amount of people online, all uniques, which are online on THIS pagehb8y.k DA)M-a7c
$result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");
V@-k7E dL-qQ if(!($result)) {
^~b5m"i.Z:Z R print "Useronline Select Error > ";4WD+v~6_ vTrbG
} a Z_\(HIU
//Count the number of rows = the number of people online
(Ak2M;@!K"iB] $user = mysql_num_rows($result);5sRMoH
//spit out the results
5[l!X.e2g mysql_close(); fR$R;G6d
if($user == 1) {b!HtU7| Z OF4eQ
print("1 user online\n");
.y
PK,N.M@Z$U_X3eR m } else {
Y*M.Rw] print("$user users online\n");
4Z3k5P] H*h#oxd?Y }#b}A%}s;j3F
?>Q'QBY[!u8r9JW]
[url=http://www.now.cn/vhost/][img]http://b.todayisp.com/bbs/760x90h.gif[/img][/url]
QoRQ^ e'I} 以上代码我是在时代互联提供的免费试用主机上测试的，感觉效果还不错，性能很稳定，不信的话你也可以去试试。当然，记得指出我这个程序中的不足先哦。
y+h boC0_ 时代互联是行业内最早开始提供PHP 虚拟主机的公司之一，现在已经是的金牌域名注册商和中国互联网客户满意度十佳单位，产品功能已经非常完善 ，特别提一下几个特有用的功能：数据库自动备份、免费集成繁简通简装版、多域名绑定、多子网站支持、GCDN 网站加速器、镜像加速、高级访问统计系统、支持WAP、可选电信/网通/香港机房。3M!\%ws0qI(e [
我之前建站的时候选的是他们公司标准商务E型，因为这款机型还特别支持ASP.NET3.5(3.0/2.0/1.1)/ASP。A&G L"n#R,p*i*y
当然啦，这两款主机也是相当不错的。
^ \u7B0ub 智强商务B型：Unix /Linux 操作系统+独立网页空间1000MB+送1000MB邮局空间+100MB MySQL数据库空间=1869元/年~B([v7Gxl BP _%c.a
标准商务B型：Unix /Linux 操作系统+独立网页空间500MB+送800MB邮局空间+60MB MySQL数据库空间=1365元/年"O FN$a2Ner@i7N
提供一下这个公司的联系方式：请见：[url=http://www.now.cn/vhost/]http://www.now.cn/vhost/[/url]
A9FlE1E.WB 空间专线： 0756-2623871  QQ：168075865，好象还有全球免费网络电话:全球免费咨询电话 [url=http://www.now.cn/callcenter/call.net?LineName=55]http://www.now.cn/callcenter/call.net?LineName=55[/url]
x L0c6?+w#o3c$[G 自己加QQ去问吧。

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