分页搜索结果laravel [英] Paginate search result laravel

问题描述

在上一篇文章中获得帮助后 Laravel-搜索设施使用Eloquent在现场进行现在，我需要使用内置的laravel分页类对结果进行分页.

After some help in a previous post Laravel - Search Facility on site using Eloquent I now need to some help on paginating the result using the built in laravel pagination class.

public function search()  //no parameter now
{
 $q = Input::get('term');
 if($q && $q != ''){
  $searchTerms = explode(' ', $q);
  $query = DB::table('wc_program');  // it's DB::table(), not DB::tables

if(!empty($searchTerms)){

  foreach($searchTerms as $term) {
    $query->where('JobRef', 'LIKE', '%'. $term .'%');
  }
}
$results = $query->get();

dd($results); // for debugging purpose. Use a View here
 }
}

推荐答案

只需将get更改为paginate，然后每页提供项目数.

Simply change get to paginate and provide number of items per page.

$results = $query->paginate(10);

这篇关于分页搜索结果laravel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！