Laravel error using with() method in Eloquent

Question

I'm trying to call using with() method in Laravel Eloquent ORM, but getting the following error.

Argument 1 passed to App\Http\Controllers\DashboardController::App\Http\Controllers\{closure}() must be an instance of Illuminate\Database\Eloquent\Builder, instance of Illuminate\Database\Eloquent\Relations\HasMany given

I'm using the latest version of Laravel 6. Any ideas what might have caused this?

Controller

class DashboardController extends Controller
{
    public function __construct()
    {
        $this->middleware('auth:api');
    }

    public function formIndex(Request $request)
    {
        $id = auth()->user()->id;
        $item = Groupe::find($id)->with(
            [
                'etudiants' => function (Builder $query) {
                    $query->select('id');
                }
            ]
        )->first();

        return $item;
    }
}

Model

class Groupe extends Authenticatable implements JWTSubject
{
    public function etudiants()
    {
        return $this->hasMany('App\Etudiant');
    }
}

Alec Joy · Accepted Answer · 2019-12-13 23:00:25Z

5

The error comes from the type hint you put on the $query variable, as the error message said the object that gets passed in there is a relationship not a raw Query Builder. Just remove the type hint. Also ::find() executes a query, so you're be executing 2 queries, use the query below instead

Groupe::where('id', $id)->with(['etudiants' => function ($query) {
        $query->select('id');
    }])->first();

Additionally, you don't need to use the callback syntax to only eager load certain columns, the callback syntax is for putting contraints on which records get returned. Try this instead.

Groupe::where('id', $id)->with('etudiants:id,name,email')->first();

answered Dec 13, 2019 at 23:00

Alec Joy

2,02911 silver badges20 bronze badges

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

4 Comments

lagbox Over a year ago

make sure to also select the foreign key for the relationship

Mostafa AGUERRAM Over a year ago

Thanks a lot that worked, with adding the foreign key to the query

VirusEcks Over a year ago

And Hell Broke loose because of that one type hint xD .. thanks a lot it really helped, never would've guessed it in million years

woens Over a year ago

The Laravel Documentation is giving exact this example. The documentation is wrong. Indeed without typehint it works.

CarlosG. · Accepted Answer · 2019-12-13 22:57:41Z

0

But what do you want return? groupe->students[]?? you can use

    $item = Groupe::where('id',$id)->with('etudiants')->first();

answered Dec 13, 2019 at 22:57

CarlosG.

37 bronze badges

2 Comments

Mostafa AGUERRAM Over a year ago

Yes I want to return that students data, but with specified columns, like name, email not all fields

CarlosG. Over a year ago

ok so you can use protected $hidden = ['id','created_at','others'] in the model

GBEGONNOUDE Miguel · Accepted Answer · 2023-06-22 11:44:40Z

0

le probleme viens tous simplement de limport du builder utilise ceci "use Illuminate\Contracts\Database\Eloquent\Builder;"

answered Jun 22, 2023 at 11:44

GBEGONNOUDE Miguel

1

1 Comment

Community Over a year ago

Your answer could be improved with additional supporting information. Please edit to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers in the help center.

Collectives™ on Stack Overflow

Laravel error using with() method in Eloquent

3 Answers 3

4 Comments

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related