Two array in one foreach Laravel

Question

I have two table the first called codes, and second is company.

Codes table structure:
id| title | desc | company | order

Company table structure:
id| name

Here is code from my controller

 $codes= DB::table('codes')->orderBy('company', 'ASC')->get();
 $company = Company::all();
 return view('codes.index',compact('codes', 'company'));

And here is codes from my view.

 @foreach($codes as $code)
   <tr>
    <td>{{$code->title}}</td>
    <td>{{$code->code}}</td>
    <td>{{$company->name}}</td>  
    <td>{{$code->order}}</td>
   </tr>
  @endforeach

I can not get name of company. How is possible? Thanks for all

How do you know which company belongs to which code? Currently you are trying to displaying a random company for a code, what is the point of this? — Remul
– Remul, Commented Oct 27, 2020 at 9:15
You did not defin $codes on your controller, how can you get $codes on blade ? — STA
– STA, Commented Oct 27, 2020 at 9:17

Akbar Rahmanii · Accepted Answer · 2020-10-27 10:28:40Z

3

$services = Services::orderBy('company', 'ASC')->with('company')->get();
return view('services.index',compact('services'));

view

@foreach($codes as $code)
   <tr>
    <td>{{$code->title}}</td>
    <td>{{$code->code}}</td>
    <td>{{$code->company->name}}</td>  
    <td>{{$code->order}}</td>
   </tr>
@endforeach

I did not know the names exactly because I wrote them because of that approximation. If the company is defined as id, you can get company information using. You just have to define this model in the service model.

 public function company()
 {
    return $this->belongsTo(Companies::class);
 }

answered Oct 27, 2020 at 10:28

Akbar Rahmanii

1447 bronze badges

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

Comments

Khalid Khan · Accepted Answer · 2020-10-27 09:46:46Z

0

Replace your view code with this

 @foreach($codes as $key => $code)
   <tr>
    <td>{{$code->title}}</td>
    <td>{{$code->code}}</td>
    <td>{{$company[$key]->name}}</td>  
    <td>{{$code->order}}</td>
   </tr>
  @endforeach

And it'll work

answered Oct 27, 2020 at 9:46

Khalid Khan

3,1951 gold badge13 silver badges30 bronze badges

Collectives™ on Stack Overflow

Two array in one foreach Laravel

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related