我发现Sum values in foreach loop php
但我需要把它适应我的情况。我有一张有三个等级和user_id
的桌子。我需要从管理表中每个用户的所有评分中获得平均值。例如,如果用户制作了两个作品,并且有5,5,5和5,5,4,我想显示4.835,但是我得到的不是这个:
用户id—平均值
200--4.67 | 4.835|
我需要:
200——4.835
控制器:
$feedbacks = DB::table('feedback')->groupBy('user_id')->paginate(100);
$feedbacks_get = DB::table('feedback')->get();
刀片:
@foreach( $feedbacks as $wrk)
<tr>
<td>
{{$wrk->user_id}}
</td>
<td>
<?php $sum = 0;$i = 0;?>
@foreach($feedbacks_get as $e)
@if ( $e->user_id == $wrk->user_id)
<?php
$i++;
$sum+= (($e->rating1 + $e->rating2 + $e->rating3 ))/3;
$result= round($sum,2)/$i .' | ';
if($result<=4){
echo '<span class="red;">'.$result.'</span>' ;
}
elseif($result>4){
echo $result;
}
?>
@endif
@endforeach
</td>
</tr>
@endforeach
最佳答案
@foreach( $feedbacks as $wrk)
<tr>
<td>
{{$wrk->user_id}}
</td>
<td>
<?php $sum = 0;$i = 0;?>
@foreach($feedbacks_get as $e)
@if ( $e->user_id == $wrk->user_id)
<?php
$i++;
$sum+= (($e->rating1 + $e->rating2 + $e->rating3 ))/3;
?>
@endif
@endforeach
$result= round($sum,2)/$i ;
if($result<=4){
echo '<span class="red;">'.$result.'|</span>' ;
}
elseif($result>4){
echo $result.' | ';
}
</td>
</tr>
@endforeach