To chiev(蓝色飞翼) 问题都没问完就给分~~~你这人真好玩~~:)
我接着说
首先是库结构
ID 唯一标志
WebName 页面名称
StayTimeAmount 访问时间
然后是那个脚本文件,这个文件在每个需要统计的页面头部都要无参数的require进来,并且在每个页面unload()的时候用JS有参数(action=logout)激发。
脚本文件内容大致如下:
session_start();
session_register("LoginTime");
$now = date("Y").date("m").date("d").date("H").date("i").date("s");
$LoginTime = $now;
$WebName = $PHP_SELF; //注意这里必须大写
if (action == "logout") {
$LogoutTime = date("Y").date("m").date("d").date("H").date("i").date("s");
$StayTime = $LogoutTime - $LoginTime;
$conn=mysql_connect("host","user","pass");
mysql_select_db("yourDB");
$res = mysql_query("select * from TableName where WebName = '".$WebName."'");
if (mysql_num_rows($res) <> 0) { //该页以前被访问过
$res_tmp = mysql_query("select StayTimeAmount from TableName where WebName = '".$WebName."'");
$new_StayTimeAmount = mysql_result($res_tmp,0) + $StayTime;
mysql_query("update TableName set StayTimeAmount = '".$new_StayTimeAmount."' where WebName = '".$WebName."'");
}
else { //该页以前未被访问过
mysql_query("update TableName set StayTimeAmount = '".$StayTime."' where WebName = '".$WebName."'");
}
}