\n";
exit;
}
$today=date("YmdH",time()+$timemiss*3600);
$yy=substr("$today", 0, 4);
$mm=substr("$today", 4, 2);
$dd=substr("$today", 6, 2);
$tt=substr("$today", 8, 2);
$linkptr=mysql_pconnect("$hostname","$username","$userpassword") OR DIE("無法連結MySQL資料庫");
mysql_select_db("$dbname",$linkptr) OR DIE("無法開啟資料庫$dbname");
$act = $_GET['act'];
$y = $_GET['y'];
$m = $_GET['m'];
$d = $_GET['d'];
switch($act){
case "day":
$msg="";
if ($y=="") $msg="請輸入年份 ";
if ($m=="") $msg=$msg."請輸入月份 ";
if ($d=="") $msg=$msg."請輸入日期 ";
$rs=mysql_query("select * from $tablename where yy='$y' and mm='$m' and dd='$d'") or die(mysql_error());
if (mysql_num_rows($rs)=="0") $msg=$msg."找不到該日期資料 ";
if ($msg!="") error($msg);
?>
echo $y ?>年 echo $m ?>月 echo $d ?>日
小時
瀏覽人次
$row=mysql_fetch_array($rs);
for ($i=0;$i<=23;$i++) {
$j=sprintf("%02d",$i);
?>
echo $j ?>:00~ echo $j ?>:59
echo $row[t.$j] ?>
}
?>
break;
case "mon":
$msg="";
if ($y=="") $msg="請輸入年份 ";
if ($m=="") $msg=$msg."請輸入月份 ";
$rs=mysql_query("select * from $tablename where yy='$y' and mm='$m' order by dd") or die(mysql_error());
if (mysql_num_rows($rs)=="0") $msg=$msg."找不到該月份資料 ";
if ($msg!="") error($msg);
?>
break;
case "year":
$msg="";
if ($y=="") $msg="請輸入年份 ";
$result=mysql_query("select * from $tablename where yy='$y'");
$num=mysql_num_rows($result);
if ($num=="0") $msg=$msg.$y."年沒有資料 ";
if ($msg!="") error($msg);
$rs=mysql_query("select sum(today) as total from $tablename where yy='$y'");
$row=mysql_fetch_array($rs);
?>
$rs=mysql_query("select sum(today) as total from $tablename where yy='$y' and mm='$j'") or die(mysql_error());
$rows=mysql_fetch_array($rs);
$total=$rows[total];
if ($total=="") $total="0";
?>
echo $total ?>
}
?>
break;
case "time":
?>
分時流量
小時
瀏覽人次
for($i=0;$i<=23;$i++) {
$j=sprintf("%02d",$i);
?>
echo $j ?>:00~ echo $j ?>:59
$rs=mysql_query("select sum(t".$j.") as total from $tablename") or die(mysql_error());
$row=mysql_fetch_array($rs);
$total=$row[total];
if ($total=="") $total="0";
?>
echo $total ?>
}
?>
break;
default:
$rs=mysql_query("select sum(today) as total from $tablename");
$row=mysql_fetch_array($rs);
$rs1=mysql_query("select sum(today) as total from $tablename where yy='$yy'");
$row1=mysql_fetch_array($rs1);
?>
}
function dateToDays($day,$month,$year)
{
$century = substr($year,0,2);
$year = substr($year,2,2);
if($month > 2)
$month -= 3;
else
{
$month += 9;
if($year)
$year--;
else
{
$year = 99;
$century --;
}
}
return ( floor(( 146097 * $century) / 4 ) +
floor(( 1461 * $year) / 4 ) +
floor(( 153 * $month + 2) / 5 ) +
$day + 1721119);
} // end func dateToDays
?>