Laravel Relationship with Comma Separated Values Example
In this post, we will learn how to make relationship with comma separated column values in laravel application.
Sometimes, we need to store IDs in a comma separated values format. But if we want to get data from another table, how do we create a relationship with a comma separated values field? We can use the `ghanuz/relations` package to solve this problem. In this example, I'll create two tables: `products` and `colors`. When we add a product, we will save color IDs in a comma separated values column. Then, we’ll retrieve the color details using a Laravel relationship. Let us look at the example below.
Let's see the example:
Step 1: Install Laravel 11
This step is not required; however, if you have not created the Laravel app, then you may go ahead and execute the below command:
composer create-project laravel/laravel example-app
Step 2: Install ghanuz/relations
Now, in this step, we will install ghanuz/relations composer package. So, run the following command:
composer require ghanuz/relations
Step 3: Create Migration
In this step, we will create migration for products and colors table. so let's run the following command:
php artisan make:migration create_products_colors_table
next, let's update the migration:
database/migrations/2024_11_04_134601_create_products_colors_table.php
<?php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
return new class extends Migration
{
/**
* Run the migrations.
*/
public function up(): void
{
Schema::create('products', function (Blueprint $table) {
$table->id();
$table->string("name");
$table->string("color");
$table->timestamps();
});
Schema::create('colors', function (Blueprint $table) {
$table->id();
$table->string("name");
$table->timestamps();
});
}
/**
* Reverse the migrations.
*/
public function down(): void
{
Schema::dropIfExists('products');
Schema::dropIfExists('colors');
}
};
Now we need to run migration.
So let's run the below command:
php artisan migrate
Step 4: Create Models
Now, we will create model for products and colors table. so, let's run the following commands and update model.
php artisan make:model Product
php artisan make:model Color
we will use FindInSetMany() method for colors relationship.
app/Models/Product.php
<?php
namespace App\Models;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
use GhanuZ\FindInSet\FindInSetRelationTrait;
class Product extends Model
{
use HasFactory, FindInSetRelationTrait;
protected $fillable = ["name", "color"];
/**
* Write code on Method
*
* @return response()
*/
public function colors()
{
return $this->FindInSetMany( Color::class, 'color', 'id');
}
}
app/Models/Color.php
<?php
namespace App\Models;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
class Color extends Model
{
use HasFactory;
protected $fillable = ["name"];
}
Step 5: Create Route
Here, we will create one route to test relationsihp data. let's update code:
routes/web.php
<?php
use Illuminate\Support\Facades\Route;
Route::get('/', function () {
return view('welcome');
});
Route::get('/products', [App\Http\Controllers\ProductController::class, 'index']);
Step 6: Create Controller
Here, we will create ProductController and write index() methos.
1. We will create three color object.
2. Then we will create two products and assign colors as comma saparated values.
3. get the colors from product object.
php artisan make:controller ProductController
app/Http/Controllers/ProductController.php
<?php
namespace App\Http\Controllers;
use Illuminate\Http\Request;
use App\Models\Product;
use App\Models\Color;
class ProductController extends Controller
{
/**
* Write code on Method
*
* @return response()
*/
public function index()
{
$red = Color::create(["name" => "Red"]);
$white = Color::create(["name" => "White"]);
$blue = Color::create(["name" => "Blue"]);
$gold = Product::create(["name" => "Gold", "color" => "{$red->id},{$white->id}"]);
$silver = Product::create(["name" => "Silver", "color" => "{$red->id},{$blue->id}"]);
print_r("GOLD:");
print_r($gold->toArray());
print_r($gold->colors->toArray());
print_r("SILVER:");
print_r($silver->toArray());
print_r($silver->colors->toArray());
}
}
Run Laravel App:
All the required steps have been done, now you have to type the given below command and hit enter to run the Laravel app:
php artisan serve
Now, Go to your web browser, type the given URL and view the app output:
http://localhost:8000/products
Output:
GOLD:
Array
(
[name] => Gold
[color] => 1,2
[updated_at] => 2024-11-08T04:01:28.000000Z
[created_at] => 2024-11-08T04:01:28.000000Z
[id] => 1
)
Array
(
[0] => Array
(
[id] => 1
[name] => Red
[created_at] => 2024-11-08T04:01:28.000000Z
[updated_at] => 2024-11-08T04:01:28.000000Z
)
[1] => Array
(
[id] => 2
[name] => White
[created_at] => 2024-11-08T04:01:28.000000Z
[updated_at] => 2024-11-08T04:01:28.000000Z
)
)
SILVER:
Array
(
[name] => Silver
[color] => 1,3
[updated_at] => 2024-11-08T04:01:28.000000Z
[created_at] => 2024-11-08T04:01:28.000000Z
[id] => 2
)
Array
(
[0] => Array
(
[id] => 1
[name] => Red
[created_at] => 2024-11-08T04:01:28.000000Z
[updated_at] => 2024-11-08T04:01:28.000000Z
)
[1] => Array
(
[id] => 3
[name] => Blue
[created_at] => 2024-11-08T04:01:28.000000Z
[updated_at] => 2024-11-08T04:01:28.000000Z
)
)
I hope it can help you...
Hardik Savani
I'm a full-stack developer, entrepreneur and owner of ItSolutionstuff.com. I live in India and I love to write tutorials and tips that can help to other artisan. I am a big fan of PHP, Laravel, Angular, Vue, Node, Javascript, JQuery, Codeigniter and Bootstrap from the early stage. I believe in Hardworking and Consistency.
We are Recommending you
- Laravel 11 Pagination with Relationship Example
- Laravel Eloquent Relationship withTrashed() Method Example
- Laravel Check If Relationship Data is Empty Example
- Laravel Replicate Model with Relationships Example
- Laravel Order By Relationship Sum Column Example
- Laravel Relationship Eager Loading with Condition Example
- Laravel Relationship Eager Loading with Count Example
- Laravel Relationship Eager Loading Example
- Laravel Relationship Where Condition Example
- Laravel Eloquent Relationships Tutorial From Scratch
- Laravel Many to Many Eloquent Relationship Tutorial
- Laravel Has Many Through Eloquent Relationship Tutorial
- Laravel One to Many Polymorphic Relationship Tutorial
- Laravel Many to Many Polymorphic Relationship Tutorial