Get count of filter data, while return a small set of records

You can get the count of filter data using count method and get the small set of records from filtered data using take(), paginate() and get() method by specifying the number of records which you want to get

Answers 2

  • Count all and get 10 records after where condition in laravel 

    $query = $request->get('query');
$users = User::where('name','like','%'.$query.'%');
$usersCount = $users->count();
$users = $users->select('*')->take(10)->get();
echo $usersCount;
print_r($users);
    0

    This code snippet will help you to get the count of all filltered data and get only 10 records from filttered data.

  • Count all and get records using pagination after where condition in laravel 

    $query = "john";
$users = User::where('name','like','%'.$query.'%');
$usersCount = $users->count();
$users = $users->select('*')->paginate(3);
echo $usersCount;
print_r($users);

//Import user model
use App\Models\User;
    0

    You can get the count of all filtered records from users table and get data using pagination in laravel

    • Back to code snippet queries related laravel

Log in to add code snippet
Bootstrap C C++ Cmd CodeIgniter Css Drupal Git Html Java Javascript Jquery Laravel Nodejs Php Python Sql Typescript Wordpress
Random Code Snippet Queries: Laravel
Ask Query

Copyright © 2018 - 2022 w3codegenerator.com

All Rights Reserved.

We use cookies to ensure that we give you the best experience on our website.