如何正确更新PHP多维数组中指定元素的s_inbox/s_spam值？

生成数组的代码 #

从数据库获取数据并构建多维数组的代码如下：

$sender_array = [];

$qq = "SELECT * FROM tbl_senders WHERE s_status = 0 LIMIT 5";
$res = mysqli_query($conn,$qq);
$totals = mysqli_num_rows($res);
if($totals==0){
    //exit();
}else{
   while($row=mysqli_fetch_array($res)){
        $s_email = $row['s_email'];
        $s_user = $row['s_user'];
        $s_id = $row['s_id'];
        $sender_array[] = [
            's_id' => $s_id,
            's_user' => $s_user,
            's_email' => $s_email,
            's_inbox'      => 0,
            's_spam'      => 0
        ];
        
        $mysenders[]=$s_email;
    }
}

生成的数组结构 #

最终得到的数组结构示例：

Array
(
    [0] => Array
        (
            [s_id] => 2
            [s_user] => 4
            [s_email] => claire@example.com
            [s_inbox] => 0
            [s_spam] => 0
        )

    [1] => Array
        (
            [s_id] => 3
            [s_user] => 4
            [s_email] => ella@example.com
            [s_inbox] => 0
            [s_spam] => 0
        )

    [2] => Array
        (
            [s_id] => 4
            [s_user] => 4
            [s_email] => amelia@example.com
            [s_inbox] => 0
            [s_spam] => 0
        )

    [3] => Array
        (
            [s_id] => 6
            [s_user] => 4
            [s_email] => sarah@example.com
            [s_inbox] => 0
            [s_spam] => 0
        )

    [4] => Array
        (
            [s_id] => 7
            [s_user] => 4
            [s_email] => victoria@example.com
            [s_inbox] => 0
            [s_spam] => 0
        )

)

需求说明 #

需要实现的功能：根据指定邮箱，将对应子数组中的s_inbox或s_spam值加1。例如给ella@example.com的s_inbox加1，或给amelia@example.com的s_spam加1。

尝试的递归函数（无法正常工作） #

之前尝试的递归函数会返回错误数据，代码如下：

function findandReplace(&$array,$s_email,$type) {
        foreach($array as $key => &$value)
        { 
            if(is_array($value))
            { 
                findandReplace($value,$s_email,$type); 
            }
            else{
                
                if ($key == 's_email' && $value == $s_email) {
                  
                    if($type=="s_inbox"){
                        //echo $array['s_spam'];echo "<br>";
                        $array['s_inbox'] = intval($array['s_inbox'])+1;
                    }else{
                         //echo $array['s_spam'];echo "<br>";
                        $array['s_spam'] = intval($array['s_spam'])+1;
                    }
                    
                    break;
                }
            } 
        }

        return $array;
    }

调用方式：

$sender_arrays = findandReplace($sender_array,$fromAddress,"s_inbox");

解决方案 #

方法：直接遍历外层数组（简单高效） #

由于目标数组的结构是外层为索引数组，每个元素是结构固定的关联数组，完全不需要递归，直接遍历外层数组即可完成更新，代码如下：

function updateSenderCount(&$array, $targetEmail, $type) {
    // 遍历每个发送者子数组
    foreach ($array as &$sender) {
        // 匹配目标邮箱
        if ($sender['s_email'] === $targetEmail) {
            // 校验类型合法性，避免非法字段修改
            if (in_array($type, ['s_inbox', 's_spam'])) {
                $sender[$type] = intval($sender[$type]) + 1;
            }
            // 找到匹配项后提前退出循环，提升效率
            break;
        }
    }
    return $array;
}

调用示例：

// 给ella@example.com的s_inbox加1
$sender_array = updateSenderCount($sender_array, 'ella@example.com', 's_inbox');

// 给amelia@example.com的s_spam加1
$sender_array = updateSenderCount($sender_array, 'amelia@example.com', 's_spam');

原递归函数的问题分析 #

原递归函数的核心问题是过度设计：当前数组结构不需要递归遍历，递归会进入不必要的层级，且在遍历子数组的键值对时，$array的上下文容易出现混淆，导致更新逻辑出错。直接遍历外层数组是最适配当前场景的方案。

内容的提问来源于stack exchange，提问作者Manisha