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
MilesWeb Review: Why Go for Its Shared Hosting?
MilesWeb Review: Why Go for It...

For finding the right web hosting provider, you need to do a lot of research. There are hundreds of web hosting provider...

Read More

Nov-12-2021

Laravel 9 Group Column Chart Using Highcharts
Laravel 9 Group Column Chart U...

In the world of web development, Laravel 9 is a user-friendly PHP framework. When combined with Highcharts, a top JavaSc...

Read More

Jan-02-2023

Import Export CSV/EXCEL File In Laravel
Import Export CSV/EXCEL File I...

Today I will show you how to implement/install the import/export package in laravel 6/7. We will simply create...

Read More

May-19-2020

How to Downgrade PHP 8.2 to 8.1 in Ubuntu
How to Downgrade PHP 8.2 to 8....

Hey there, I recently found myself in a situation where I needed to downgrade my PHP version from 8.2 to 8.1 on my Ubunt...

Read More

Nov-01-2023