php清洗数据实战案例(4)：按照关联数组相同值名称进行筛选后对不同的指标予以合并计算的解决方案

$arr = [[
    "objid" => "22249",
    "device" => "192.168.0.202",
    "datetime" => "2021/3/15 12:52:17",
    "datetime_raw" => 44270.2029801968,
    "sensor" => "内存1",
    "status" => "正常运行",
    "status_raw" => 3,
    "lastvalue" => "89",
    "lastvalue_raw" => "89"
], [
    "objid" => "22250",
    "device" => "192.168.0.202",
    "datetime" => "2021/3/15 12:52:17",
    "datetime_raw" => 44270.2029801968,
    "sensor" => "内存2",
    "status" => "正常运行",
    "status_raw" => 3,
    "lastvalue" => "74",
    "lastvalue_raw" => "89"
], [
    "objid" => "22250",
    "device" => "192.168.0.202",
    "datetime" => "2021/3/15 12:52:17",
    "datetime_raw" => 44270.2029801968,
    "sensor" => "内存2",
    "status" => "正常运行",
    "status_raw" => 3,
    "lastvalue" => "34",
    "lastvalue_raw" => "89"
]];

项目需求

遍历数据，求包含“内存”字段的lastvalue，求和。

for ($i = 0; $i < count($arr); $i++) {
    if (stripos($arr[$i]["sensor"], "内存") !== false) {
        $cpu[$i] = $arr[$i]["lastvalue"];
    }
}

echo "<pre>";
var_dump($cpu);
$data["cpu"] = round(array_sum($cpu) / count($cpu), 1);

lockdatav Done!