php如何将一个长array数组循环插入数据库

Question

这样一个数组，如何三个字段为一条数据循环插入数据库？

Answer 1

$keys = array_keys($arr);
$key_tmp = [];
foreach ($keys as $v){ $key_tmp[] = substr($v,0,strrpos($v,'_')); }
$key_tmp = array_unique($key_tmp);

    $temp_arr = [];
    foreach ($arr as $k => $v){
        $num = substr($k,strrpos($k,'_')+1);
        foreach ($key_tmp as  $value){
            if(strstr($k,$value)){
                $temp_arr[$num][$value] = $v;
            }
        }
    }
    print_r($temp_arr);