I have three tables:

• Products
  • id
  • other values
• Downloads
  • id
  • user_id
  • product_id
• Users
  • id
  • name

I'd like to fetch last X Download table rows, get their product_id & user_id, product_id match Product table as user_id match User table, then make

foreach ($values as $value) {
    <div > {{$product->name}} </div>
    <div > {{$user->name}} </div>
}

I can pass in my controller Download model, but it doesn't get me anywhere close

public function index() {
    return view('nav/index', [
        'trendings' => Template::orderBy('views', 'DESC')->where('is_active', 'yes')->take(8)->get(),
        'latests_downloads' => Downloads::orderBy('id', 'DESC')->take(8)->get(),
    ]);
}

'latests_downloads' => Downloads::orderBy('id', 'DESC')->take(8)->get() function just gives me:

But how can I take these values and put in view?

CodePudding user response：

1. Add the following methods to your Download model class (If they don't already exist.)

public function user()
{
    return $this->belongsTo(User::class, 'user_id');
}

public function product()
{
    return $this->belongsTo(Product::class, 'product_id');
}

2. Change your controller.

'latests_downloads' => Downloads::orderBy('id', 'DESC')->take(8)->get(),

// replace with the following

'latests_downloads' => Downloads::with(['user', 'product'])->orderBy('id', 'DESC')->take(8)->get(),

3. Fetch it in your view file.

@foreach($latest_downloads as $latest_download)

User Id: {{ $latest_download->user->id }}
Product Id: {{ $latest_download->product->id }}

@endforeach

CodePudding user response：

Yes for this type of scenario you need to use a relationship-based Eloquent model query of Laravel and it is very powerful for this type of scenario.

First You need to add two relationships in the Download model :

public function user()
{
return $this->belongsTo(User::class, 'user_id');
}

public function product()
{
return $this->belongsTo(Product::class, 'product_id');
}

And rest of the things work well with this single query.

// user this query

$latest_downloads = Downloads::with(['user', 'product'])->latest()->take(8)->get();

instead of => getting two different queries in two different variables.

You only need to get a single collection of records in a minimum query and a minimum number of variables. You can do it with Eloquent easily.

And last you can use inside blade as like normal we use daily.

@foreach($latest_downloads as $key => $latest_download)
User ID: {{ $latest_download->user->id ?? '' }}
Product ID: {{ $latest_download->product->id ?? '' }}
@endforeach