Error with pagination with laravel DB::select query

Question

Error with pagination, my code:

public function index() {

     $cards1= DB::select('select rm.user_id, u.email,rm.fecha,rm.tarjeta as t1,cm.tarjeta as t2,
            cm.autorizacion as aut2, rm.autorizacion as aut1, date (cm.created_at) as creacion
            from consultas.contracargos_mediakey cm
            left join repsmediakey rm on rm.autorizacion=cm.autorizacion
            left join mediakey.users u on u.id=rm.user_id
            where right(cm.tarjeta,2)=right(rm.tarjeta,2) 
            or rm.autorizacion is null 
            order by cm.id')->paginate(15);
    return view('mediakey.index',compact('cards1'));
}

Call to a member function paginate() on array

Please edit your post for better formatting

Swifty
– Swifty

2019-06-11 00:23:27 +00:00
Commented Jun 11, 2019 at 0:23 — Swifty
– Swifty, Commented Jun 11, 2019 at 0:23

MarkSkayff · Accepted Answer · 2019-06-12 17:40:54Z

1

First, I would use some select() with join() and where() and orWhere() clauses in Laravel. I'm not sure you can type all that within a select() method for DB.

If you want to input some raw query you have to use the DB::raw(<your-raw-sql-code>) within your DB::select() statement.

But I suggest you learn how to use the Laravel DB query builder to build those queries.

I guess then paginate will work.

edited Jun 12, 2019 at 17:40

answered Jun 11, 2019 at 0:52

MarkSkayff

1,40410 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Daniel Carrillo Tapia Over a year ago

without paginate it works and doing the query with DB :: table I do not find how to use the right in my query

MarkSkayff Over a year ago

@DanielCarrilloTapia I suggest you learn how to put all that big query you did inside a select, using the DB query builder.

Collectives™ on Stack Overflow

Error with pagination with laravel DB::select query

1 Answer 1

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Related