Laravel Advanced - Has Many Through Relationship

Let's be friends:
/ aashish_dhamala
Github Repo:
Please read the readme to access the code for the specific video.
github.com/lar...
Laravel Has One Through Relationship Video:
• Laravel Advanced - Has...
Laravel Collections Video:
• Laravel Basics - Colle...
In this video, I have explained the has many through relationship in laravel.
It is an advanced version of has many relationship.
The "has-many-through" relationship provides a convenient shortcut for accessing distant relations via an intermediate relation. For example, a Country model might have many Post models through an intermediate User model. In this example, you could easily gather all blog posts for a given country.

[@raya8540]

Thank you very much! It is very helpful, hope you always have a great day! Thanks thanks thanks

[@Laratips]

Thank you 🙂

[@pyongits]

Can you make videos about complex queries in Laravel, both eloquent and query builder a comparison of them? And using closures in queries like the use of anonymous functions.

[@Laratips]

Thank you for the idea. I will note this and make a video dedicated to it in the future.

[@bizhanhejazi8174]

This video is the best I could ever imagined of.

[@Laratips]

Thank you 🙂

[@deepakagarwal663]

I have three tables namely: category, subcategory, and services respectively. Now I want relationships between these tables as a category has many subcategories, then each subcategory has many services. so can you help me how to resolve such type of relations for this scenario

[@Laratips]

I guess that you are trying to directly get the services from the category. In that case you can do it like this.
Make sure there is 'category_id' column in sub_categories table and 'sub_category_id' column in services table.
class Category extends Model
{
/**
* Get all of the deployments for the project.
*/
public function deployments()
{
return $this->hasManyThrough(Service::class, SubCategory::class);
}
}

[@davidson7838]

Thank you so much, this is extremely helpful and informative. I really really liked your videos and teaching techniques. This channel is one of the best on RUclips. 🙂

[@Laratips]

🙏🤘

[@LaravelRo]

Thank you for this amazing tutorials! I would like to ask you to make an advanced tutorial with grouping records with goupBy clause. Specificaly how to create a list with articles grouped by year, by month, by week - ierarchicaly. Best regards!

[@Laratips]

Thanks for the video idea. I will definitely make one

[@kvanca2330]

Thank you for video. Can we use this more than 3 tables?

[@sportsandstudy6985]

How can i show users in blade please reply

[@Laratips]

You can make belongs to relationships in posts and get user from that

[@sportsandstudy6985]

@@Laratips please explain i am new to relationship so if you can explain i will be thakfull

[@Laratips]

I already have video on all the relationship in laravel. You can check my channel

[@sportsandstudy6985]

@@Laratips i am following your channel

[@phenixbd]

Awesome !!!!!

[@Laratips]

Thank you! Cheers!

[@ajaykj8925]

i need to fetch users with all posts and active posts in separate , so i have a post function in my user model. is that possible to call post inside with () in laravel ? like user ::with('posts')->with('posts'=>fun (qry){ qry-> where('isactive',1)}) ... It returns only one posts , so is there any other options ? Or do i need to create another function for active posts in my model ??

[@Laratips]

The syntax that you are using is not supported yet.
For that you need to create another relationship method named "activePosts" and use it like this:
In the User model,
public function posts()
{
return $this->hasMany(Post::class);
}
public function activePosts()
{
return $this->posts()->where('isactive', 1);
}
Then you can access it like this:
User::with(["posts", "activePosts"])->get();
If you do it like this, then it will be reusable.

[@ajaykj8925]

@@Laratips ❤️✌️

[@mmsskk1413]

As always thank You.

[@Laratips]

No worries!

[@leonvanrijswijk8409]

Thanks, I learned new things

[@Laratips]

Glad to hear that.
Please share so that other would also know what you have learned and they could also learn some new things 🙂