Displaying latest news for each in Laravel

Mohanad Shahin 0
Viewed 41

I want to display only 3 news in each category to display the last 3 news that were added.

Class category:

class category extends Model
{
    use HasFactory;

    public function articles(){
        return $this->hasMany(Article::class)->limit(3)->orderBy('created_at', 'desc');
      }
  
}

Class Article:

class Article extends Model
{
    use HasFactory;

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

$categories = category::with('articles')->limit(3)->get();
$articles = Article::orderBy('created_at', 'desc')->get();

return response()->view('news.index', compact('categories','articles'));
laravel-8 eloquent mysql php
2 Answers

use whereHas

$categories = category::whereHas('articles', function($query){
        return $query->orderBy('created_at', 'desc')->limit(3);
    })->get();

return view('news.index', compact('categories'));
Waad Mawlood0

By using latest()

$categories = category::whereHas('articles', function($query){
        return $query->latest()->take(3);
    })->get();

return view('news.index', compact('categories'));
Usama Arslan0
Related