学生关联到班级,现在打算在班级视图中显示出该班级总的有几个学生 该怎么实现


class xxbjglController extends BaseController {
public function index(){
$where['schoolid']=session('schoolid');
$schoolbjgl=D('SchoolBjgl');
$list=$schoolbjgl->where($where)->select();
//$this->assign('schoolbjgl',$list);
//读出班级学生数量
for($i=0;$i<count($list);$i++){
$where='';
$where['schoolid']=session('schoolid');
$bjid=$list[$i]['id'];
$xssl=D('SchoolStudent')->field('bjid,count(bjid)')->group('bjid')->select();
}
$this->assign('xssl',$list);
dump($xssl);
$this->display();
}————————————————————————————解决方法:
控制器
public function index(){
$where['schoolid']=session('schoolid');
$schoolbjgl=D('SchoolBjgl');
$list=$schoolbjgl->where($where)->select();
//$this->assign('schoolbjgl',$list);
//读出班级学生数量
for($i=0;$i<count($list);$i++){
$where='';
$where['schoolid']=session('schoolid');
$bjid=$list[$i]['id'];
$xssl=D('SchoolStudent')->field('bjid,count(bjid)')->group('bjid')->select();
}
$this->assign('xssl',$list);
$this->assign('xssl1',$xssl);
$this->display();模板: <div class="block-content text-center">
<div class="row items-push">
<div class="col-xs-6">
<div class="h3 push-5">{$xssl1[$key]['count(bjid)']}</div>
<div class="h5 font-w300 text-muted">学生</div>
</div>
<div class="col-xs-6">
<div class="h3 push-5">450</div>
<div class="h5 font-w300 text-muted">老师</div>
</div>
</div>
</div>
最佳答案