Laravel using paginate() with select() method

Question

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

Answer 1

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

Answer 2

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