【已解决】分组查询问题求助!!!

浏览:1734 发布日期:2016/04/05 分类:求助交流 关键字: 分组查询 group
我有两张表,一张是班级表,一张是学生表。
学生关联到班级,现在打算在班级视图中显示出该班级总的有几个学生 该怎么实现
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>
最佳答案
评论( 相关
后面还有条评论,点击查看>>