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

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

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

刚用PHP写了一个网站在线人数的程序，请大家进来指点下！
Dng5d7Ej 我是用PHP+MYSQL来写的，原理：网站在线人数的程序代码+后台有MYSQL数据库支持，可以直接统计出网站当前的在线人数。
Dd/p)w2PE'i'a{ 首先我创建MYSQL数据库表。
&oIV5R/Q)cg[#h CREATE TABLE tablename (
.wV\$@4c0g field type(max_length) DEFAULT 'default_value' (NOT) NULL
*s+|Og8B;`1H }可以使用的SQL语句。]E,jaa4O~t'e^B
CREATE TABLE useronline (&W+_5m$OP
timestamp int(15) DEFAULT '0' NOT NULL,,u1|8NQ|
ip varchar(40) NOT NULL,%H:yO_&ff
file varchar(100) NOT NULL,
M O| P _ PRIMARY KEY (timestamp),
-b\a0H6e KEY ip (ip),
"}4?l{*Vm}Y KEY file (file)

Feke/Y );下面我们是PHP脚本，首先我定义MYSQL的信息。0k%kD)Xyf2lO
$server = "localhost"; //你的服务器
D!vUg,}Bk $db_user = "root"; //你的mysql的用户名:H O9K6ByW
$db_pass = "password"; //你的mysql的密码E3}.H|-di!{*MGo
$database = "users"; //表的名字设置统计的时间(多少秒内在线人数)
,DZ@x:DDz $timeoutseconds = 300;取当前时间。,S fbc#lB3B;l
$timestamp = time();上面的完整代码：WT_!b$B]$?d3E
<?php5c,}!dg`2~
$server = "localhost"; //your server)p)oeSSpq c(urr
$db_user = "root"; //your mysql database username
Ji"R@^
$db_pass = "password"; //your mysql database password if any
ip R7R7Hg&f|@]D $database = "users"; //the db name/A2d T0G d
$timeoutseconds = 300;//timeoutseconds limit+e9xZ{iI%f.A r-\$}
//get the current time
q(N%l"V X $timestamp = time();5N[%y.oE#BZX'~]
//calculate the lowest timestamp allowedL!N&o8i(M
$timeout = $timestamp-$timeoutseconds;V3o7~'hk&?:H1A6|
?>连接mysql!W`7Ruxh%^8wq/D
mysql_connect('localhost', 'username', 'password');也允许使用变量形式。
f6o2r1cs*mdZ5v mysql_connect($server, $db_user, $db_pass);如果mysql数据库没有密码的话可以使用下面代码连接7a R t$C3z9}lTQ
mysql_connect($server, $db_user);查询数据库的代码：rF?-[5L/d2]g9Y0k
mysql_db_query('database', 'query');我们只要有访客就要增加一条记录。

a+J \IXtioz $insert = mysql_db_query($database, "INSERT INTO useronline VALUES
.~3h:V:h+oX6b%N4|
} ('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");(kN0ep,LzHU
如果用户用错误信息的话，这样处理。oLk;z3K7ZM2YT
if(!($insert)) {f3r ~1L&}Kj{
print "Useronline Insert Failed > ";
u$k,a+`X8o }然后实现当超过设置的时间就删除该用户记录。O/`$a@9J;`
$delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");同样给出删除记录出错的处理。
G*S$^_Ef(Y if(!($delete)) {
f+NOHx)Fed9B print "Useronline Delete Failed > ";
ie~K4YE }下面我们解决数据库中不同IP的问题
`,F8Nk E }V7h $result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");使用,rWM!uA7q
mysql_num_rows(query);来统计用户，代码如下。 `+m_5eaR
$user = mysql_num_rows($result);最后关闭数据库。Ag9ny[
mysql_close();显示在线的人数。EkLCN,e$c
if($user == 1) {
.h ]2UQ+] j.T-j print("1 user online\n");!qAQ-?b2cDW
} else {\3IK.H#k"w
print("$user users online\n");
fBYc+F
^+B N D B }最终把上面代码写成一个PHP文件如下。
5Zigq-|p&k0C <?php$h{8Xj7m0~ ~U
//Put your basic server info here
[)pA(T_"X(g $server = "localhost"; //normally localhost
BE:e
H6M`{h $db_user = "root"; //your MySQL database usernameKRJP#P
$db_pass = "password"; //your MySQL database passwordI#?*_"NW-f
A9Y2QG
$database = "users";
X;CT2^Th0LF $timeoutseconds = 300; //it will delete all people which haven't refreshed(so probbably are5R'n$y$Iw e$F)^`%@
// offline or inactive) in $timieoutseconds time (so it actually checks the people that are active in the last b(| n:I{3J
// $timeoutseconds seconds)
L I]+w8]/F,H"k //this is where PHP gets the time
O0J:V$L6H c-l $timestamp = time();3xV:HN2d*Fctm _
//counts the timeout, all people which have been seen last online in earlier than this timestamp, will get removedy8Pl3S6MK
$timeout = $timestamp-$timeoutseconds;
tk;{m7jv //connect to database&S [pm/k#}X `y+I
mysql_connect($server, $db_user);
m9B9er!];N[] //add the timestamp from the user to the online list
5cKtK3a;Q2oc $insert = mysql_db_query($database, "INSERT INTO useronline VALUES
E d JT9gyE.U#z ('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')");p.a;nHN6V%PIz
if(!($insert)) {1}'~E.J2Cab#~d
print "Useronline Insert Failed > ";
.R;~/m*o4g t r*{4Q k }/a:Z XX:Iw/x
//delete the peoples which haven't been online/active in the last $timeoutseconds seconds.] aXy1u
$delete = mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout");0Z/up7f\eJvB$N
if(!($delete)) {
)Q6T0fW a3m&v7w`W print "Useronline Delete Failed > ";;QEH&]r]/py*K:pN
}
:XK;[-l~%h G //select the amount of people online, all uniques, which are online on THIS page
W6wFadU $result = mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='".$_SERVER['PHP_SELF']."' ");
XsCKq&_ey if(!($result)) {
8@#X/f*]&CQW print "Useronline Select Error > ";O4D i?RbwN5i
}x1_(rn7d1i@0~
//Count the number of rows = the number of people online'Yv|$x7CE6cw
$user = mysql_num_rows($result);#w1m.hp|?
//spit out the results*kRkg R9m(r ?`q
mysql_close();w]v DW Ves
if($user == 1) {
3u%@iul.[%U
R x4S print("1 user online\n");Y&l,O1e#xB%h
} else {
6C$A\ Wm print("$user users online\n");+S4_7v@ xA'Xz
}a9f6ArW+p
?>
ITRBHEN^tET [url=http://www.now.cn/vhost/][img]http://b.todayisp.com/bbs/760x90h.gif[/img][/url]7q,G'TTG:v%@J
以上代码我是在时代互联提供的免费试用主机上测试的，感觉效果还不错，性能很稳定，不信的话你也可以去试试。当然，记得指出我这个程序中的不足先哦。
o uH0Dl ]#T*^-e 时代互联是行业内最早开始提供PHP 虚拟主机的公司之一，现在已经是的金牌域名注册商和中国互联网客户满意度十佳单位，产品功能已经非常完善 ，特别提一下几个特有用的功能：数据库自动备份、免费集成繁简通简装版、多域名绑定、多子网站支持、GCDN 网站加速器、镜像加速、高级访问统计系统、支持WAP、可选电信/网通/香港机房。
p|3T;UwE/e 我之前建站的时候选的是他们公司标准商务E型，因为这款机型还特别支持ASP.NET3.5(3.0/2.0/1.1)/ASP。t%},T"K.rs;`2m9d
当然啦，这两款主机也是相当不错的。
W/]|u!cA1jA 智强商务B型：Unix /Linux 操作系统+独立网页空间1000MB+送1000MB邮局空间+100MB MySQL数据库空间=1869元/年
v1yO"e0di|5GG*k 标准商务B型：Unix /Linux 操作系统+独立网页空间500MB+送800MB邮局空间+60MB MySQL数据库空间=1365元/年%At%M(s1~rt
提供一下这个公司的联系方式：请见：[url=http://www.now.cn/vhost/]http://www.now.cn/vhost/[/url] E3F4O+yv f9r`
空间专线： 0756-2623871  QQ：168075865，好象还有全球免费网络电话:全球免费咨询电话 [url=http://www.now.cn/callcenter/call.net?LineName=55]http://www.now.cn/callcenter/call.net?LineName=55[/url]2emu[5^%@f%f*M
自己加QQ去问吧。

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