// 総アクセス件数取得 $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));