我在business_items表的视图中,在这个表中,我获得id,而我正在检索的id是业务项控制器中的data.Below函数。
public function actionTest()
{
$this->layout='main';
$modelitems = BusinessItems::model()->findAll(); //getting all data of businessitems
$rate = ItemReview::model()->findAll(); //getting all data of businessitems
$this->render(
'test',
array(
'rate' => $rate,
'modelitems' => $modelitems,
)
);
}这是我的视图文件,我调用了test。其中我想得到平均评级和商业身份。
/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
$value = $_POST["business_id"];
$matchFound = false;
$ratematch = false;
$save = 0;
foreach ($modelitems as $ba) {
$bizitems = $ba->id; //getting id of business items
$biz = $ba->business_id; //business id from model business items
if ($value == $biz) { //matching posted id of business with ids in business items table
$image = $ba->image; //geting image from business items table
$item_name = $ba->items->item_name; //geting item name from business items table
foreach ($rate as $ab) {
$ratebiz = $ab->business_items_id; //getting business items id from item review
if ($ratebiz == $bizitems) { //comparing business items id with business items id in item review
echo "business items id:" . $bizitems;echo " ";
echo "rating of business items" . $ab->rating;
echo "<br.>";
}
}
}
}我的输出类似于这个业务项目id:52级的业务items4
business items id:52 rating of business items5
business items id:52 rating of business items5
business items id:52 rating of business items3
business items id:52 rating of business items3
business items id:53 rating of business items2
business items id:53 rating of business items5
business items id:54 rating of business items2
business items id:54 rating of business items1
business items id:54 rating of business items4
business items id:54 rating of business items3
business items id:55 rating of business items5
business items id:55 rating of business items4
business items id:55 rating of business items3
business items id:55 rating of business items2我想要这样的输出
business items id:52 rating of business items20 //20 is the total rating
business items id:53 rating of business items7 //7 is the total rating
business items id:54 rating of business items10 //10 is total rating
business items id:55 rating of business items14 //14 is total rating我该怎么办?
发布于 2015-11-15 22:46:14
对于每个循环,添加以下sum变量并修改循环如下:
$sum=0;
foreach ($rate as $ab){
$ratebiz=$ab->business_items_id; //getting business items id from item review
if($ratebiz==$bizitems){ //comparing business items id with business items id in item review
$sum=$sum+$ab->rating;
}
}
echo "business items id:".$bizitems;echo " "; echo "rating of business items".$sum;
echo "</br>";https://stackoverflow.com/questions/33725885
复制相似问题