foreach循环中查询赋值问题( 条件 in）

最新推荐文章于 2024-02-22 17:44:41 发布

一只小菜鸡_

最新推荐文章于 2024-02-22 17:44:41 发布

阅读量1.2k

点赞数

分类专栏： PHP

本文链接：https://blog.csdn.net/icoo_lmj/article/details/86239788

版权

PHP 专栏收录该内容

15 篇文章 0 订阅

订阅专栏

不建议在循环中查询！！（虽然我还没找到什么好办法= =）
public function index()
{
    $where = $this->search('name');

    $where['del'] = false;
    $where['member_id'] = $this->member_id;

    $order = $this->sort_order(FamilyModel::getTableFields());

    $list = FamilyModel::page_list($where, $order);
//list中hobby_ids、hobby_class_ids存多个id，查询id对应的值。查询到还是要赋值到list中
    foreach ($list as $k => $v) {
        $where = ['hobby_id'=>['in',$v['hobby_ids']]];
        $res =  HobbyModel::all_list(['hobby_id','name'],$where);
        $v['hobby'] = $res;

        $where = ['hobby_class_id'=>['in',$v['hobby_class_ids']]];
        $res =  HobbyClass::all_list(['hobby_class_id','name'],$where);
        $v['hobby_class'] = $res;
    }

    if (!$list->isEmpty()) {
        $list->load(['EduGrade', 'Bracelet', 'School']);
        $list->append(['age']);
    }