thinkphp 中关联查询 like 查询失效

Go的神秘男朋友

已于 2023-12-13 14:42:52 修改

阅读量173

点赞数

文章标签：前端 javascript php

于 2023-12-13 14:25:56 首次发布

本文链接：https://blog.csdn.net/qq_51110402/article/details/134971206

版权

controller:

   public function goodsList()
    {
        if (request()->isGet()) {
            //表单验证
            //调用发布
            $where = [];
            $goodname = $this->request->param('goodname', '');
            if(!empty($goodname)){
                    $where[] = ['name','like',$goodname];
            }
            return $this->logic->goodsList($where, $this->page, $this->size);
        }
        return '';
    }

logic：

  public function goodsList($search = null, $page = 1, $limit = 10)
    {
        $lists = Goods::when(($search && is_array($search)), function ($query) use ($search) {
            $query->where($search);
        })->alias('good')->field("good.id,good.type,good.name,good.photo,good.price,good.introduction,good.tag")->order('id', 'desc')->paginate($limit, false, ['page' => $page]);
        return $this->success("获取数据成功", $lists);
    }

测试的结果：

奇怪的是当我直接搜：马抗无数据

解决办法：加上通配符

    public function goodsList()
    {
        if (request()->isGet()) {
            //表单验证
            //调用发布
            $where = [];
            $goodname = $this->request->param('goodname', '');
            if(!empty($goodname)){
                $goodname = '%' . $goodname . '%';
                $where[] = ['good.name','like',$goodname];
            }
            return $this->logic->goodsList($where, $this->page, $this->size);
        }
        return '';
    }