ThinkPHP5.1 多字段相同查询条件+带参数分页

最新推荐文章于 2022-04-16 09:44:13 发布

凉半杯咖啡

最新推荐文章于 2022-04-16 09:44:13 发布

阅读量874

点赞数

本文链接：https://blog.csdn.net/qq_41821881/article/details/83828449

版权

ThinkPHP5.1 多字段相同查询条件+带参数分页

例：

public function three_porduct_list(Request $request)
    {
        $tiaojian = $request->param("tiaojian",null);


        $list = Db::name("three_level_column",true)
            ->where("three_name|one_name|tow_name",'like',"%".$tiaojian."%")
            ->order("id desc")
            ->paginate(8,false,['query'=>request()->param()]);

        $num = count($list);

        return view("admin/three_porduct_list",["list"=>$list,"num"=>$num]);
    }