How to select in Laravel 5.6 Eloquent with parameters on multiple tables?

Question

I need to run a select on multiple database tables using Laravel 5.6 and I get parameters from the post $request. Now I need get back the records only if the give values are equvalent the record's values.

I want to do something like this, but this get back every client and section data, no matter what's happening in loan's query part:

Casefile::with([
    'client',
    'loan' => function($query) use($request) {
         $query->where('bank_name','REGEXP',$request->bank_name)
    },
    'section'
])->where($find)->get();

I want get back the entire record only if the bank_name is match with the $request->bank_name.

How can I do this?

Try using whereHas: https://stackoverflow.com/a/30232227/1672261 — Alen, Apr 01 '18 at 20:30
It seems good, but I need to use multiple tables in the select. Do you have any idea? — netdjw, Apr 01 '18 at 20:37

score 2 · Accepted Answer · answered Apr 01 '18 at 20:49

2

Try this:

Casefile::with([
    'client',
    'section'
])->whereHas('loan', function($query) use($request) {
     $query->where('bank_name','REGEXP', $request->bank_name)
})->where($find)->get();

answered Apr 01 '18 at 20:49

Jonas Staudenmeir

24,815
6
63
109

How to select in Laravel 5.6 Eloquent with parameters on multiple tables?

1 Answers1