Getting Call to a member function paginate() on array error in laravel

Question

I am getting Getting Call to a member function paginate() on array error in laravel with the following code

public static function search_query($query)
{
    $tokenizeitem = array();
    $tokenizeitem = queryarr($query);

    //$tokenizeitem = $this->bbbootstrap->tokenizeStringIntoFTSWords($item);

    $sql = "SELECT * FROM snippets WHERE MATCH(snippets_name,seo_description) 
    AGAINST (' ";

    foreach ($tokenizeitem as $w) {
        $sql .= '+' . $w . '* ';
    }

    $sql .= "' IN BOOLEAN MODE)";

    $searchdata=DB::select( DB::raw($sql))->paginate(15);

    return $searchdata;
}

Mayank Pandeyz · Answer 1 · 2020-03-31T08:16:50.740

0

The error is self explanatory:

Call to a member function paginate() on array error in laravel

your following code:

DB::select( DB::raw($sql))->paginate(15);

return an array and you can't call paginate() on array. So instead of this use:

DB::table("your query")->paginate();

Laravel Raw Query Reference

edited Mar 31 '20 at 08:16

answered Mar 31 '20 at 08:15

Mayank Pandeyz

25,704
4
40
59

can i pass $sql inside table like DB::table($sql)->paginate(); – Upasana Chauhan Mar 31 '20 at 08:16
Then i am not able to understand how to rectify! – Upasana Chauhan Mar 31 '20 at 08:18
Search, you will get something – Mayank Pandeyz Mar 31 '20 at 08:29
I did it like this and getting results but pagination not working now $searchdata = DB::table('snippets') ->selectRaw("*") ->whereRaw($sql) ->paginate(20); – Upasana Chauhan Mar 31 '20 at 08:32
Look into this: https://stackoverflow.com/questions/44090392/how-to-use-pagination-with-laravel-dbselect-query – Mayank Pandeyz Mar 31 '20 at 09:16
Let us [continue this discussion in chat](https://chat.stackoverflow.com/rooms/210645/discussion-between-mayank-pandeyz-and-upasana-chauhan). – Mayank Pandeyz Mar 31 '20 at 09:17

Getting Call to a member function paginate() on array error in laravel

1 Answers1