How to Get Last 15 Records in Laravel 10

Websolutionstuff | Dec-08-2023 | Categories : Laravel PHP MySQL

Welcome, fellow developers! In this guide, I'll walk you through the straightforward process of fetching the latest records in Laravel 10. Specifically, we'll focus on getting the last 15 records from your database using Laravel's Eloquent ORM.

In this article, I'll use the latest(), orderBy(), and take() eloquent method to get the last 15 records from the database in laravel 10.

Also, you can use this example in Laravel 7, Laravel 8, Laravel 9 and Laravel 10.

So, let's see laravel 10 gets the last 15 records, laravel gets last week's records, and laravel gets the the latest record by date.

Example: Retrieve the Last 15 Records using Latest() and Take()

In your controller or wherever you need to fetch the records, use the latest() and take() methods provided by Eloquent

app/Http/Controllers/UserController.php

<?php
  
namespace App\Http\Controllers;
  
use Illuminate\Http\Request;
use App\Models\User;
  
class UserController extends Controller
{
    /**
     * Write code on Method
     *
     * @return response()
     */
    public function getLast15Records(Request $request)
    {
        $last15Records = User::latest()->take(15)->get();
  
        return view('home', ['records' => $last15Records]);
    }
}

 

Example 2: Retrieve the Last 15 Records using orderBy()

In this example, orderBy('id', 'desc') is used to order the records by the id column in descending order, meaning the newest records will be fetched first.

app/Http/Controllers/UserController.php

<?php
  
namespace App\Http\Controllers;
  
use Illuminate\Http\Request;
use App\Models\User;
  
class UserController extends Controller
{
    /**
     * Write code on Method
     *
     * @return response()
     */
    public function getLast15Records(Request $request)
    {
        $last15Records = User::orderBy('id', 'DESC')->take(15)->get();
  
        return view('home', ['records' => $last15Records]);
    }
}

 


You might also like:

Recommended Post
Featured Post
Laravel 8 Google Bar Chart Example
Laravel 8 Google Bar Chart Exa...

Today, we will see laravel 8 google bar chart example, Google charts is use to visualize data on you...

Read More

Jul-23-2021

How To Get Last 30 Days Record In Laravel 8
How To Get Last 30 Days Record...

in this tutorial, we see how to get last 30 days record in laravel 8. You can simply get the last 30 days reco...

Read More

Feb-02-2022

How To Add Bootstrap 5 Modal In Laravel 10
How To Add Bootstrap 5 Modal I...

In this article, we will see how to add the bootstrap 5 modal in laravel 10. Here, we will learn about the bootstra...

Read More

Apr-12-2023

How To Toggle Dark and Light Mode using jQuery
How To Toggle Dark and Light M...

In this article, we will see how to toggle between dark and light modes using jquery. As per the current trend of web de...

Read More

Nov-24-2020