laravel - 如何在laravel中添加对关系数据的查询

Question

标签： laravel

Answer 1

据我了解，您的关闭错误是由第二个参数引起的-您使用$requestas 第二个参数是错误的..

代替

function($query,$request) 

而应该是

function($query) use($request)

不是你做的那样..

$payment_history=User::where('name','like','%'.$search.'%')
->orWhere('email','like','%'.$search.'%')
->with(
     ['payment_history'=>function($query) use($request){
         $query->whereBetween('date', array($request->from, $request->to))
         ->orderBy('id','Desc');
  }]
)
->paginate(30);