Laravel Eloquent Query WITH parameters

Question

Morning,

il would like to use Eloquent to make this request but i have an error.

$ModelVars=Model1::with(['Model2' => function($query,$var){
                            return $query->where('field1', 'like', '%'.$var.'%');}])->get();

Could somebody help me. Thks in advance.

Tks @Jackowski, See below error : Too few arguments to function App\Http\Controllers\Achat\DemandeachatsController::App\Http\Controllers\Achat\{closure}(), 1 passed in ..\vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php on line 431 and exactly 2 expected — Black-Rabbit
– Black-Rabbit, Commented Oct 28, 2020 at 17:10

STA · Accepted Answer · 2020-10-28 17:15:11Z

1

Change your code to :

$ModelVars = Model1::with(['Model2' => function($query) use ($var){
    return $query->where('field1', 'like', '%'.$var.'%'); }])
->get();

use is not a function, it's part of the Closure syntax It simply makes the specified variables of the outer scope available inside the closure.

answered Oct 28, 2020 at 17:15

STA

35.3k9 gold badges49 silver badges62 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Laravel Eloquent Query WITH parameters

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related