In this example we will see laravel 8 has many through relationship example. hasManyThrough relationship difficult to understand compare to other relationship. you use hasManyThrough relationship laravel 6, laravel 7 and laravel 8. The has-many-through relationship provides a convenient way to access distant relations via an intermediate relation.
For example, a categories is connected with products and products connected with orders, then we can access all orders connected with a specific categories. So, simply you can access or get data using intermediate model relation using hasManyThrough in laravel 8.
Now, we will create categories, products and orders table. categories table connected with products and products table connected with orders table like below screenshot and we also create migration and model for all table and retrive data using model.
Categories Table :
Schema::create('categories', function (Blueprint $table) {
$table->increments('id');
$table->string('name');
$table->timestamps();
});
Products Table :
Schema::create('products', function (Blueprint $table) {
$table->increments('id');
$table->integer('categories_id')->unsigned();
$table->timestamps();
$table->foreign('categories_id')->references('id')->on('categories')->onDelete('cascade');
});
Orders Table :
Schema::create('orders', function (Blueprint $table) {
$table->increments('id');
$table->integer('product_id')->unsigned();
$table->timestamps();
$table->foreign('product_id')->references('id')->on('products')->onDelete('cascade');
});
Now, we will create categories model and define relationship on model.
Category Model :
<?php
namespace App\Models;
use Illuminate\Database\Eloquent\Model;
class Category extends Model
{
public function order()
{
return $this->hasManyThrough(Order::class, Product::class);
}
}
The first argument passed to the hasManyThrough
method is the name of the final model we wish to access, while the second argument is the name of the intermediate model.
Though the Order model table does not contain category_id column, the hasManyThrough relation we can access to $categories->orders like this.
Now, retrive record using intermediate model through like below code example.
$category = Category::find(1);
dd($category->order);
You might also like :
In this article, we will see how to install Vue JS 3 in laravel 9. Laravel is a web application framework with...
Oct-07-2022
In this article, we will see how to encrypt and decrypt a string in laravel 9. Using crypt helper, As we all know larave...
Mar-09-2022
In this example, I will show you how to implement/install data tables in laravel. Datatables provides users with many fu...
May-16-2020
In this article, we will see laravel 9 socialite login with twitter account. Many websites provide different t...
Nov-12-2022