Get single column array in database and display in laravel blade

Question

I'm trying to display values separately from a specific column "category" from my database table "order" which is an array with values like "value1,value2,value3".

I want to get those values and display them separately in laravel blade. Something like $order->category[1]. I can't figure out how I can do it because I still want to display all values from other columns at the same time.

Here's my controller:

 public function index()
    
    { $orders =  DB::table('order')
        ->where('email', auth()->user()->email)
        ->get();


    return view('dashboard', [
        'orders' => $orders,
       
    ]);
       
    }

And here's my blade:

 @foreach ($orders->reverse() as $key => $order )
   <div class="layout__primary"> 
     <div class="works header-item2">
      <div class="item-text2">{{ $order->name }}</div>
        <img src="{{ $order->category[1] }}" class="works-img" style="max-width: 280px">
          <div class="item-labels">{{ $order->category[2] }}</div>
                  </div>
                </div>
               @endforeach

And dd($order)

Illuminate\Support\Collection {#1374 ▼
  #items: array:1 [▼
    0 => {#1386 ▼
      +"id": 50
      +"name": "Name"
      +"email": "[email protected]"
      +"mobile": 12348890
      +"category": "Personal,assets/img/personal.png,Personal Website"
      +"contact": "email"
      +"domain": null
      +"new_domain": null
      +"alojamento": null
      +"criar_email": null
      +"facebook": null
      +"instagram": null
      +"linkedin": null
      +"plan": null
      +"order_date": "2021-02-19 12:06:48"
      +"state": "Processing"
    }
  ]
}

show to us the database schema for table order , category, and reverse relationship that you use ? — Mohamed Ahmed
– Mohamed Ahmed, Commented Feb 19, 2021 at 13:16
You can explode $order-> categoria on the ", " char, so it becomes an array. — Gert B.
– Gert B., Commented Feb 19, 2021 at 13:37
@GertB. Yes, but how would I pass it to the view and display? — Nayana
– Nayana, Commented Feb 19, 2021 at 14:59

msbomrel · Accepted Answer · 2021-02-19 15:33:50Z

1

@foreach ($orders->reverse() as $key => $order )
       <div class="layout__primary"> 
         <div class="works header-item2">
          <div class="item-text2">{{ $order->name }}</div>
            <img src="{{ explode(",", $order->category)[1] }}" class="works-img" style="max-width: 280px">
              <div class="item-labels">{{ $order->category[2] }}</div>
                      </div>
                    </div>
                   @endforeach

answered Feb 19, 2021 at 15:33

msbomrel

5197 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Get single column array in database and display in laravel blade

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related