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

• 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);
  

  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;
  

  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