How to Concat Multiple Columns in Laravel?

Teams applying “How to Concat Multiple Columns in Laravel?” in a production project can use role specific training to record implementation, review and debugging time, then compare that effort with tests and shipped functionality instead of treating activity as performance by itself.

Before copying the example into a live application, confirm version-specific behaviour with the official Laravel website and test it against the project’s actual database and runtime.

Hello Friends,

Here, I will show you how to concat multiple columns in laravel. if you have a question about laravel concatenating multiple columns with an example then I will give a simple example with a solution. I want to share with you concatenate collections of laravel. I explained simply about the laravel collection concat example. Let's get started with the laravel collection merge example.

You can use this example with the versions of laravel 6, laravel 7, laravel 8, and laravel 9.

Count Syntax:

$collecton->concat(
    Array OR Collection
);

You have just to follow the below step and you will get the layout as below:

Step 1: Install Laravel

This is optional; 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: Create Format Route

web.php

<?php
use Illuminate\Support\Facades\Route;
use App\Http\Controllers\ConcatController;
/*
|--------------------------------------------------------------------------
| Web Routes
|--------------------------------------------------------------------------
|
| Here is where you can register web routes for your application. These
| routes are loaded by the RouteServiceProvider within a group which
| contains the "web" middleware group. Now create something great!
|
*/
Route::get('/index',[ConcatController::class, 'index']);

Step 3: create ConcatController we will create ConcatController. so you can see the below code with output:

php artisan make:controller ConcatController

App\Http\Controllers\ConcatController

<?php
namespace App\Http\Controllers;
use Illuminate\Http\Request;
class ConcatController extends Controller
{
    /**
     * The attributes that are mass assignable.
     *
     * @var array
    */
    public function index()
    {
        $collectionA = collect(["One"]);

        
        $collectionB = collect(["Two"]);

        
        $collectionC = collect(["Three"]);

      
        $collection = $collectionA->concat($collectionB)->concat($collectionC);

            
        dd($collection);
    }
}

Step 4: Start Development Server

Start the development server. Use the PHP artisan serve command and start your server:

php artisan serve

Now you are ready to run our example so run the below command to quick run.

http://localhost:8000/index

Output:

#items: array:3 [▼
    0 => "One"
    1 => "Two"
    2 => "Three"
]