php - zend 框架和 php，仅当两个数组中的值集相等时才递增

Question

我有 2 个数组。第一个数组包含数据库查询的结果。本质上它是一个信息数据库。第二个数组包含在屏幕上选择的用户定义值。我的目标是将用户单击的某些元素与数据库结果集进行协调。我试图实现的最终结果是以下“规则”:如果一组元素与每个数组中的某个组匹配，则 id 会增加一个计数器。并非所有键值都需要匹配，只有某些键值需要匹配。例如，如果数据库结果数组包含 3 个值，而用户数组仅包含 2 个匹配值，则不递增。如果数据库结果数组包含 3 个值，并且用户数组包含所有 3 个匹配值，则 DO 递增。

提供了每个多维数组的示例:

//DB results - $result()
Array ( 

   [0] => Array ( 
      [id] => 115 
      [q_id] => question-1 
      [course_id] => 1 
      [course_section] => unit-2-section-2 
      [a_id] => question-1-drop-down-answer-1-input 
      [a_body] => August [answer] => yes 
      [timestamp] => 2014-11-30 21:36:02 
   ) 
[1] => Array ( 
      [id] => 117 
      [q_id] => question-1 
      [course_id] => 1 
      [course_section] => unit-2-section-2 
      [a_id] => question-1-drop-down-answer-3-input [a_body] => 10 
      [answer] => yes [timestamp] => 2014-11-30 21:36:02 
) 
[2] => Array ( 
      [id] => 119 
      [q_id] => question-1 
      [course_id] => 1 
      [course_section] => unit-2-section-2 
      [a_id] => question-1-drop-down-answer-5-input 
      [a_body] => 2013 [answer] => yes [timestamp] => 2014-11-30 21:36:02 
) 
[3] => Array ( 
      [id] => 136 
      [q_id] => question-2 
      [course_id] => 1 
      [course_section] => unit-2-section-2 
      [a_id] => question-2-drop-down-answer-1-input 
      [a_body] => December [answer] => yes 
      [timestamp] => 2014-11-30 21:36:02 
) 
[4] => Array ( 
      [id] => 139 
      [q_id] => question-2 
      [course_id] => 1 
      [course_section] => unit-2-section-2 
      [a_id] => question-2-drop-down-answer-4-input 
      [a_body] => 23 
      [answer] => yes 
      [timestamp] => 2014-11-30 21:36:02 
) 
[5] => Array ( 
      [id] => 141 
      [q_id] => question-2 
      [course_id] => 1 
      [course_section] => unit-2-section-2 
      [a_id] => question-2-drop-down-answer-6-input 
      [a_body] => 1984 
      [answer] => yes 
      [timestamp] => 2014-11-30 21:36:02 
) 
[6] => Array ( 
      [id] => 149 [q_id] => question-3 
      [course_id] => 1 
      [course_section] => unit-2-section-2 
      [a_id] => question-3-drop-down-answer-1-input 
      [a_body] => Febraury 
      [answer] => yes 
      [timestamp] => 2014-11-30 21:36:02 
) 
[7] => Array ( 
      [id] => 150 
      [q_id] => question-3 
      [course_id] => 1 
      [course_section] => unit-2-section-2 
      [a_id] => question-3-drop-down-answer-2-input 
      [a_body] => 14 
      [answer] => yes 
      [timestamp] => 2014-11-30 21:36:02 
      ) 
)

//User input array - $dataAnswers()
Array ( 
        [0] => Array ( 
                [questionID] => question-1 
                [courseID] => 1 
                [courseSection] => unit-2-section-2 
                [questionType] => select-all 
                [selectedAnswer] => August 
        ) 

        [1] => Array ( 
                [questionID] => question-2 
                [courseID] => 1 
                [courseSection] => unit-2-section-2 
                [questionType] => select-all 
                [selectedAnswer] => December 
        ) 
        [2] => Array ( 
                [questionID] => question-3 
                [courseID] => 1 
                [courseSection] => unit-2-section-2 
                [questionType] => select-all 
                [selectedAnswer] => Febraury 
        ) 
        [3] => Array ( 
                [questionID] => question-3 
                [courseID] => 1 
                [courseSection] => unit-2-section-2 
                [questionType] => select-all 
                [selectedAnswer] => 14 
        ) 
)

这是我的第一次尝试，但我似乎无法从逻辑上理解这一点。任何建议将不胜感激:

//counters
    $i = 0; 
    $f = 0; 

    foreach ($dataAnswers as $a){

        $e = 0;

        foreach ($result as $r){

            if ($a['questionID'] == $r['q_id']) {
                $e++;
            }

            if ($a['questionID'] == $r['q_id'] && $a['selectedAnswers'] == $r['a_body']) {
                $f++;
            }

            if($e == $f){
                $i++;
            }

        }


    }

我应该得出结论，上面的示例预计会提供 $i = 1 的值。

Answer 1

这个想法是创建两个数组，并计算这两个数组之间有多少具有相同键的元素具有相同的值。第一个数组 ( $res ) 包含所有 q_id值来自$result作为键和每个 q_id 的计数值作为相应的值。这就是 $res如果我们使用您的示例，看起来会像这样:

Array {
  [question-1] => 3
  [question-2] => 3
  [question-3] => 2
}

第二个数组 ( $ans ) 包含所有 questionID值来自$dataAnswers作为键和每个 questionID 的匹配元素的数量值作为相应的值。这就是 $ans根据您的示例，看起来像:

Array {
  [question-1] => 1
  [question-2] => 1
  [question-3] => 2
}

从上面两个数组可以看出，只有第三个元素的key等于question-3具有相同的值，因此您得到预期的计数，即 1。下面是实现上述想法的完整代码。您要查找的计数器是 $matching_count .

// get all q_id from $result and its count
$res = Array();
foreach ($result as $r){
    if (array_key_exists($r['q_id'], $res)) {
        $res[$r['q_id']]++;
    }
    else {
        $res[$r['q_id']] = 1;
    }
}

// get all questionID from $dataAnswers
$ans = Array();

foreach ($dataAnswers as $a){
    if (!array_key_exists($a['questionID'], $ans)) {
        $ans[$a['questionID']] = 0;
    }
}

foreach ($dataAnswers as $a){
    foreach ($result as $r){
        if ($a['questionID'] == $r['q_id'] && $a['selectedAnswer'] == $r['a_body']) {
            // increase the count in $ans
            $ans[$a['questionID']]++;
        }
    }
}

// check how many elements of $ans have the same value as $res with the same key
$matching_count = 0;
foreach ($ans as $key => $value) {
    if (array_key_exists($key, $res)
        && $ans[$key] == $res[$key]) {
        $matching_count++;
    }
}

echo $matching_count;

输出

1

工作演示:http://codepad.org/5EzYaB8l