用foreach php进行动态评估

Question

我想做一个动态评估。这个想法是这样的：

我的数据库中的

• 包含‘score’，
• 和分类表包含字段'minScore‘和’categoryName(坏的，好的，很棒的)‘
• ，最后我想得到类似于这个minScore的结果

我这样想：

function valuation(){
$allScore = $this->db->select('score')->get('user')->result();
$category = $this->db->get('categori')->result();

$arrCategori = array();

foreach ($allScore as $value) {
  foreach($categori as $row){
    if($value->score <= $row->minScore){
      array_push($arrCategori, )
      //I don't know what should I do
    }
  }
}

}

有谁可以帮我？

编辑：

• 现在我将maxScore添加到类别表字段.

• 和我更改了if语句。变成这样

如果( $value->score <= $row->minScore &$value->score >= $row->maxScore){ array_push($arrCategori，$arrCategori$row->)

• I . var_dump .结果如我所料。现在的问题是，我怎样才能算出有多少人是好的，坏的，还是好的，

编辑：

• 这里是$allscore的var_dump (为了简单起见，我将bsc转换为bsc)：

数组(11){ => object(stdClass)#42 (1) { "bsc"=> string(6) "100.00“} 1=> object(stdClass)#43 (1) { "bsc"=> string(5) "40.00”} 2=> object(stdClass)#44 (1) { "bsc"=> string(6) "100.00“} 3=> object(stdClass)#45 (1) { "bsc"=>字符串(6) "100.00”} 4=> object(stdClass)#46 (1) { "bsc"=> string(5) "40.00“} 5=> object(stdClass)#47 (1) { "bsc"=> string(5) "40.00”} 6=> object(stdClass)#48 (1) { "bsc"=> string(5) "40.00“} 7=> object(stdClass)#49 (1) { "bsc"=>字符串(5) "40.00”} 8=>对象(stdClass)#50 (1) { "bsc"=>字符串(5) "40.00“} 9=> object(stdClass)#51 (1) { "bsc"=> string(5) "60.00”} 10=> object(stdClass)#52 (1) { "bsc"=> string(4) "0.00“}

• var_dump $category (bxnak = maxScore，bxnaw = minScore)

数组(9){ =>对象(StdClass)#53 (4) { "id"=> string(1) "1“"bxnaw"=> string(1) "0”"bxnak"=> string(2) "25“"kategori"=> string(5) "GAGAL”} 1=> object(stdClass)#54 (4) { "id"=> string(1) "2“"bxnaw"=> string(2) "26”"bxnak"=> string(2)"40“"kategori"=> string(16) "DALAM PENGAWASAN”} 2=> object(stdClass)#55 (4) { "id"=> string(1) "3“"bxnaw"=> string(2) "41”"bxnak"=> string(2) "50“"kategori"=> string(18) "PERLU PENGEMBANGAN”} 3=> object(stdClass)#56 (4) { "id"=> string(1) "4“"bxnaw"=> string(2)"51“"bxnak"=>字符串(2) "60”"kategori"=> string(5) "BURUK“} 4=> object(stdClass)#57 (4) { "id"=> string(1) "5”"bxnaw"=> string(2) "61“"bxnak"=> string(2) "75”kategori"=> string(11) "KURANG } 5=> object(stdClass)#58 (4) {id“=> string(1)”"6“=>字符串(2) "76”"bxnak"=> string(2) "80“kategori"=> string(10) "CUKUP BAIK”} 6=> object(stdClass)#59 (4) { "id"=> string(1) "7“bxnaw "bxnaw"=> string(2) "81”bxnak "bxnak"=> string(2) "90“kategori"=> string(4) "BAIK”} 7=> object(stdClass)#60 (StdClass)(4) { "id"=>字符串(1) "8“"bxnaw"=> string(2) "91”"bxnak"=> string(2) "99“"kategori"=> string(11) "SANGAT BAIK”} 8=> object(stdClass)#61 ( 4) { "id"=> string(1) "9“bxnaw"=> string(3) "100”bxnak"=> string(4) "1000“"kategori"=> string(8) "ISTIMEWA”}

Answer 1

我终于做到了！

这是我的函数的最后代码

function valuation(){
$allBsc = $this->db->select('bsc')->get('kpi')->result();
$kategori = $this->db->get('kategori')->result();


$arrKategori = [];

foreach ($allBsc as $value) {
  foreach($kategori as $row){
    if($value->bsc <= $row->bxnak && $value->bsc >= $row->bxnaw){
      if(array_key_exists($row->kategori, $arrKategori)){
        array_push($arrKategori[$row->kategori], $value->bsc);
      }else{
        array_push($arrKategori, $arrKategori[$row->kategori] = array($value->bsc));
      }
    }
  }
}
var_dump(count($arrKategori));
die();

}

谢谢你帮我！

$score

• $kategori = $category

• $arrKategori = $allCategory