Has-many-through in Laravel - Mini Project: Build & Apply

Building a Has-Many-Through Relationship in Laravel

📖 Scenario: You are creating a simple Laravel app to manage countries, their users, and the posts those users write.Each Country has many Users, and each User has many Posts.You want to get all posts written by users from a specific country using Laravel's hasManyThrough relationship.

🎯 Goal: Build a Laravel model relationship using hasManyThrough so you can access all posts of a country through its users.

📋 What You'll Learn

Create a Country model with a hasManyThrough relationship to Post

Create User and Post models with correct foreign keys

Use exact method and variable names as instructed

Follow Laravel conventions for model relationships

💡 Why This Matters

🌍 Real World

This pattern is useful when you want to access related data through an intermediate model, like getting all posts from users of a country without querying users separately.

💼 Career

Understanding hasManyThrough relationships is important for Laravel developers to write clean, efficient code for complex data relations.

1

Create the initial models and database tables

Create three Laravel models: Country, User, and Post. Each model should have the following database columns:

- countries: id (primary key), name (string)
- users: id (primary key), country_id (foreign key), name (string)
- posts: id (primary key), user_id (foreign key), title (string)

Write the Eloquent model classes Country, User, and Post with the correct protected $fillable properties for name and title where applicable.

Laravel

# Create Country, User, and Post models with fillable properties
# Your code here

Hint

Remember to add protected $fillable arrays in each model for mass assignment.

2

Add the hasMany relationship from Country to User

In the Country model, add a public method called users that returns a hasMany relationship to the User model using the foreign key country_id.

Laravel

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class Country extends Model
{
    protected $fillable = ['name'];

    // Add the users() method here
    // Your code here
}

class User extends Model
{
    protected $fillable = ['name', 'country_id'];
}

class Post extends Model
{
    protected $fillable = ['title', 'user_id'];
}

Hint

Use hasMany with the foreign key 'country_id' in the users method.

3

Add the hasManyThrough relationship from Country to Post

In the Country model, add a public method called posts that returns a hasManyThrough relationship to the Post model through the User model. Use the foreign keys country_id on User and user_id on Post.

Laravel

hasMany(User::class, 'country_id');
    }

    // Add the posts() method here
    // Your code here
}

class User extends Model
{
    protected $fillable = ['name', 'country_id'];
}

class Post extends Model
{
    protected $fillable = ['title', 'user_id'];
}

Hint

Use hasManyThrough with Post::class, User::class, and the foreign keys 'country_id' and 'user_id'.

4

Use the hasManyThrough relationship in a controller

In a Laravel controller method, write code to find the Country with id 1 and get all its posts using the posts relationship. Assign the posts collection to a variable called $countryPosts.

Laravel

<?php

// In a controller method
// Your code here

Hint

Use Country::find(1) to get the country, then access posts property.

Practice

1. What is the main purpose of the hasManyThrough relationship in Laravel?

easy

A. To eager load unrelated models

B. To define a direct one-to-one relationship

C. To create a many-to-many relationship with a pivot table

D. To access related models through an intermediate model

Solution

1. Step 1: Understand relationship types

   Laravel offers different relationships like one-to-one, many-to-many, and has-many-through for specific data access patterns.

2. Step 2: Identify hasManyThrough purpose

   The hasManyThrough relationship allows accessing distant related models through an intermediate model, simplifying queries.

3. Final Answer:

   To access related models through an intermediate model -> Option D

4. Quick Check:

   hasManyThrough = access through intermediate model [OK]

Hint: Think: two-step relation via a middle model [OK]

Common Mistakes:

• Confusing hasManyThrough with many-to-many
• Using it for direct one-to-one relations
• Assuming it loads unrelated models

2. Which of the following is the correct syntax to define a hasManyThrough relationship in a Laravel model?

easy

A. return $this->belongsToMany(Target::class, Intermediate::class);

B. return $this->hasManyThrough(Target::class, Intermediate::class);

C. return $this->hasOneThrough(Target::class, Intermediate::class);

D. return $this->hasMany(Target::class);

Solution

1. Step 1: Recall method signatures

   The hasManyThrough method requires the target model and the intermediate model as parameters.

2. Step 2: Match correct syntax

   return $this->hasManyThrough(Target::class, Intermediate::class); correctly uses hasManyThrough(Target::class, Intermediate::class), matching Laravel's pattern.

3. Final Answer:

   return $this->hasManyThrough(Target::class, Intermediate::class); -> Option B

4. Quick Check:

   hasManyThrough syntax = hasManyThrough(Target, Intermediate) [OK]

Hint: Remember: hasManyThrough needs target and intermediate classes [OK]

Common Mistakes:

• Using belongsToMany instead of hasManyThrough
• Confusing hasOneThrough with hasManyThrough
• Omitting the intermediate model parameter

3. Given these models:
class Country extends Model { public function posts() { return $this->hasManyThrough(Post::class, User::class); } }
And the database has:
- Country with id=1
- Users with country_id=1
- Posts with user_id matching those users

What will Country::find(1)->posts return?

medium

A. All posts regardless of country

B. All users from country with id 1

C. All posts written by users from country with id 1

D. An empty collection

Solution

1. Step 1: Understand the hasManyThrough chain

   The posts() method on Country accesses posts through users, linking country -> users -> posts.

2. Step 2: Trace the query result

   Calling Country::find(1)->posts fetches posts where the post's user belongs to users with country_id=1.

3. Final Answer:

   All posts written by users from country with id 1 -> Option C

4. Quick Check:

   hasManyThrough fetches distant related posts [OK]

Hint: Think: posts linked through users of country 1 [OK]

Common Mistakes:

• Expecting users instead of posts
• Ignoring the intermediate user model
• Assuming posts from all countries

4. Consider this incorrect hasManyThrough definition:

public function posts() { return $this->hasManyThrough(Post::class); }

What is the main issue here?

medium

A. Missing the intermediate model class as second argument

B. Using hasManyThrough instead of belongsToMany

C. The method should return hasOneThrough

D. The target model class is incorrect

Solution

1. Step 1: Check method parameters

   The hasManyThrough method requires two arguments: the target model and the intermediate model.

2. Step 2: Identify missing argument

   The code only passes Post::class but omits the intermediate model, causing an error.

3. Final Answer:

   Missing the intermediate model class as second argument -> Option A

4. Quick Check:

   hasManyThrough needs target and intermediate models [OK]

Hint: Always pass two models: target and intermediate [OK]

Common Mistakes:

• Forgetting the intermediate model argument
• Confusing hasManyThrough with belongsToMany
• Assuming one argument is enough

5. You have three models: Country, User, and Post. Users belong to countries, and posts belong to users.

How would you define a hasManyThrough relationship in the Country model to get all posts written by users from that country, assuming foreign keys are nation_id in users table, author_id in posts table?

hard

A. return $this->hasManyThrough(Post::class, User::class, 'nation_id', 'author_id');

B. return $this->hasManyThrough(Post::class, User::class, 'user_id', 'country_id');

C. return $this->hasManyThrough(User::class, Post::class, 'country_id', 'user_id');

D. return $this->hasManyThrough(Post::class, User::class);

Solution

1. Step 1: Understand parameter order in hasManyThrough

   The method signature is hasManyThrough(Target, Intermediate, foreignKeyOnIntermediate, foreignKeyOnTarget).

2. Step 2: Match keys to models

   Users have nation_id linking to Country, and Posts have author_id linking to User, so keys are 'nation_id' and 'author_id' respectively.

3. Step 3: Choose correct option

   return $this->hasManyThrough(Post::class, User::class, 'nation_id', 'author_id'); correctly passes Post::class, User::class, 'nation_id', and 'author_id' in order.

4. Final Answer:

   return $this->hasManyThrough(Post::class, User::class, 'nation_id', 'author_id'); -> Option A

5. Quick Check:

   hasManyThrough keys = intermediate FK, target FK [OK]

Hint: Order keys: intermediate FK, then target FK [OK]

Common Mistakes:

• Swapping foreign key order
• Using wrong model classes order
• Omitting foreign keys when needed