Пример #1
0
 // 総アクセス件数取得
 $totalAccess = $db->query($totalAccessSql, $param);
 // 平均値取得
 $average = $db->query($averageSql, $param);
 // 1日最高値取得(access)
 $dayMaxAccess = $db->query($dayMaxAccessSql, $param);
 // 1日最高値取得(traffic)
 $dayMaxTraffic = $db->query($dayMaxTrafficSql, $param);
 // 1日最高値取得(web_cpu)
 $dayMaxWebCpu = $db->query($dayMaxWebCpuSql, $param);
 // 1日最高値取得(db_cpu)
 $dayMaxDbCpu = $db->query($dayMaxDbCpuSql, $param);
 // 時間別最高値取得
 $hourMaxList = $db->query($hourMaxSql, $param);
 // DB切断
 $db->close();
 //-------------------------------------------
 // メール文面作成
 //-------------------------------------------
 $mailMassage = "";
 $mailMassage .= "--------------------------------------------------------\n";
 $mailMassage .= " {$unit}総アクセス件数\n";
 $mailMassage .= "--------------------------------------------------------\n";
 $mailMassage .= $totalAccess[0]['total_access'] . "\n\n\n";
 $mailMassage .= "--------------------------------------------------------\n";
 $mailMassage .= " {$unit}平均値\n";
 $mailMassage .= "--------------------------------------------------------\n";
 $mailMassage .= sprintf("%7s %10s %8s %8s", "access", "traffic", "web_cpu", "db_cpu") . "\n";
 $access = ceil($average[0]['ave_access']);
 $traffic = sprintf("%0.2f", round($average[0]['ave_traffic'], 2));
 $webCpu = sprintf("%0.1f", round($average[0]['ave_web_cpu'], 1));