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

简介: 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!

相关文章
|
3月前
|
网络协议 PHP