Laravel - 在非对象上调用成员函数paginate（）

Question

I am making a search page in Laravel and cant understand how to use the paginate method for this usage.

I have used it else where, but not like this.

So my route is:

Route::get('search', function()
{
  $q = Input::get('srch-term');
  $searchTerms = explode(' ', $q);
  $query = DB::table('blogs');

  foreach($searchTerms as $term)
  {
    $query->where('blogtitle', 'LIKE', '%'. $term .'%')
        ->where('frontpage', '1')
        ->orderBy('id', 'desc');
  }

  $results = $query->get()->paginate(15);
  $countBuilds = count($results);
  return View::make('search', compact('results')); 
});

That gives me the error in the title. If i dont use the paginate method then it works fine.

Where am I going wrong?

P.S. As a side note, I know I shouldn't be doing my DB things in the route, still getting my head around how to use functions from controllers etc in routes but thats not for here.

Answer 1

Route::get('search', function()
{
  $q = Input::get('srch-term');
  $searchTerms = explode(' ', $q);
  $query = DB::table('blogs');

  foreach($searchTerms as $term)
  {
    $query = $query->where('blogtitle', 'LIKE', '%'. $term .'%')
        ->where('frontpage', '1')
        ->orderBy('id', 'desc');
  }

  //remove ->get()

  $results = $query->paginate(15);
  $countBuilds = count($results);
  return View::make('search', compact('results')); 
});