Is it possible to use paginate() with the select() method? Using the code below I get the error:
Call to a member function paginate() on a non-object
$query = 'SELECT * FROM items';
$results = DB::select($query)->paginate(10);
I know the following code works with paginate() with just the table() method:
$results = DB::table('plans_shared')->paginate(10);
It seems much easier for me to use the select() since I have many conditional AND/WHERE clauses
select() method returns array so paginate() cannot be called on it. You can only try to use \Paginator::make(DB::select($query)) if you like
If you have an array and want to paginate it use Paginate::make() Paginate Laravel 4.2
Ex:
$pages = Paginate::make(DB::select($query), 10);
$items = DB::table('team')
->selectRaw('SELECT *,earth_distance(ll_to_earth(team.lat, team.lng), ll_to_earth(23.1215939329,113.3096030895)) AS distance')
->whereRaw('earth_box(ll_to_earth(23.1215939329,113.3096030895),1000) @> ll_to_earth(team.lat, team.lng)')
->paginate(10);
