使用一个关联数组中的值来测试另一个关联数组中的值

Question

我需要帮助，尝试了好几天没有成功，PHP新手，所以请原谅我，我有一个从数据库表评分系统返回的关联数组，我想实现的是尝试来自另一个关联数组的“分数”，迭代评分系统，直到我找到一个分数，该分数落在评分系统中连续的值之间，然后返回字母等级和备注， 看到下面已经尝试过什么，我筋疲力尽，任何帮助将不胜感激。我尝试过的代码while ($row = $grade->fetch(PDO::FETCH_ASSOC)) {        $data = $row;        var_export($data);    } //fetches the grading system whose array is seen belowwhile($row = $stmt->fetch(PDO::FETCH_ASSOC)){    $scores = $row;    var_export($scores);}// fetches scores of students in testforeach($data as $key=> $grading) {    foreach($scores as $key =>$values){    if($values["marks"]>=$grading["grade_min"] && $values["marks"]<=$grading["grade_max"])    print_r($values["marks"]);    print_r($grading["grade"]);    print_r($grading["remarks"]);}} Am trying to iterate each scores against the grading system but not successful, please help.Array(    [0] => Array        (            [id] => 2            [grade_min] => 1            [grade_max] => 39            [grade] => E            [remarks] => Fail        )    [1] => Array        (            [id] => 3            [grade_min] => 40            [grade_max] => 49            [grade] => D            [remarks] => Pass        )    [2] => Array        (            [id] => 4            [grade_min] => 50            [grade_max] => 59            [grade] => C            [remarks] => Credit        )    [3] => Array        (            [id] => 5            [grade_min] => 60            [grade_max] => 69            [grade] => B            [remarks] => Good        )    [4] => Array        (            [id] => 6            [grade_min] => 70            [grade_max] => 79            [grade] => A            [remarks] => Very Good        )    [5] => Array        (            [id] => 7            [grade_min] => 80            [grade_max] => 100            [grade] => A+            [remarks] => Excellent        ))我想根据评分系统数组迭代这些分数数组，并仅返回与分数介于“grade_min”和“grade_max”之间的“等级”和“备注”相匹配的“分数”

Answer 1

最好迭代分数，然后迭代评分以找到分数所属的分数。

此外，您的 if 没有大括号，因此它将仅执行它之后的第一个句子。

// fetches the grading system whose array is seen below

while ($row = $grade->fetch(PDO::FETCH_ASSOC)) {

    $data = $row;

    // var_export($data); // No need to se this anymore

}

// fetches scores of students in test

while($row = $stmt->fetch(PDO::FETCH_ASSOC)){

    $scores = $row;

    // var_export($scores); // No need to see this anymore

}

// Iterate scores first (I don't know if you need the index or not)

foreach($scores as $scoreIndex => $score) {

    // Search grading for this score (Index not needed here, just values)

    foreach($data as $grading) {

        if($score['marks'] >= $grading['grade_min'] && $score['marks'] <= $grading['grade_max']) {

            // Score is inside this grading

            // Echo, print or assign what you need here

            // Then exit the loop for grading

            break;

        }

    }

}

根据 的输出，该数组只是一个值，没有关联数组，因此循环应为：$scores

// Iterate scores first (I don't know if you need the index or not)

foreach($scores as $scoreIndex => $score) {

    // Search grading for this score (Index not needed here, just values)

    foreach($data as $grading) {

        // $score is an integer, not an array

        if($score >= $grading['grade_min'] && $score <= $grading['grade_max']) {

            // Score is inside this grading

            // Echo here what you need

            // Then exit the loop for grading

            break;

        }

    }

}