eloquent laravel relation hasManyThrough

Question

I have 3 tables:

Schema::create('users', function (Blueprint $table) {
            $table->id();
            $table->string('name');
            $table->string('email')->unique();
            $table->timestamp('email_verified_at')->nullable();
            $table->string('password');
            $table->rememberToken();
            $table->timestamps();
        });

        Schema::create('cities', function (Blueprint $table) {
            $table->integer('id')->primary();
            $table->string('name',100);
            $table->string('state',50)->nullable();
            $table->string('country',10);
            $table->float('lot');
            $table->float('lat');
        });

        Schema::create('followed_cities', function (Blueprint $table) {
            $table->id();
            $table->integer('user_id');
            $table->integer('city_id');
        });

And i made that relation in User class:

    public function cities()
    {
        return $this->hasManyThrough(City::class,FollowedCity::class);
    }

I tried putting this code into Controller and it doesn't work

        $id=Auth::user()->id;
        $followedCities = User::with('cities')->findOrFail($id);

I'm trying to get details for every city that this user is following. Can someone help me?

Jignesh Joisar · Accepted Answer · 2021-09-14 07:33:57Z

1

you need to use Many to Many relation

in User.php

public function cities()
{
    return $this->belongsToMany(City::class , 'followed_cities');
}

edited Sep 14, 2021 at 7:33

Jignesh Joisar

15.4k6 gold badges69 silver badges61 bronze badges

answered Sep 14, 2021 at 7:04

Hanan Alhasan

3003 silver badges15 bronze badges

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

1 Comment

Lyzvaleska Over a year ago

Watch out, you forgot to drop a comma between the class name and the association table name

Collectives™ on Stack Overflow

eloquent laravel relation hasManyThrough

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related