How to get Laravel Collection from Builder?

Question

I want to get all results from two tables akcii, feeds and after search throw them (now query just returns all records without any conditions for search), here is the query (mysql):

DB::query('SELECT id, title, text FROM (
        SELECT id, title, text FROM `akcii` UNION ALL
        SELECT id, title, body FROM `feeds`
    ) temp_table
        ORDER BY `id` desc
        LIMIT 0, 10')

Results are exacly that I need but after I can't convert it Collection? If I call ->get() method I'm getting an error:

QueryException in Connection.php line 651:
SQLSTATE[HY000]: General error: 1096 No tables used (SQL: select *)

What am I doing wrong?

In phpmyadmin this query return records well.

Андрей Федотов
– Андрей Федотов

2015-12-15 08:42:21 +00:00
Commented Dec 15, 2015 at 8:42 — Андрей Федотов
– Андрей Федотов, Commented Dec 15, 2015 at 8:42
I'm using Mysql 5.5.41

Андрей Федотов
– Андрей Федотов

2015-12-15 08:42:50 +00:00
Commented Dec 15, 2015 at 8:42 — Андрей Федотов
– Андрей Федотов, Commented Dec 15, 2015 at 8:42

jedrzej.kurylo · Accepted Answer · 2015-12-15 08:46:08Z

2

DB::query() method does not get any arguments, so the query you pass there is simply ignored. You're calling get() on an empty builder, which does not know what table to run the query on. Generated query is just SELECT *, hence the SQL error.

If you want that to work, you should call DB::select() method, e.g.:

$results = DB::select($your_query);

Still, what you'll get is an array, not a Collection object. If you want to make a collection out of it, do the following:

$collection = new Collection($results);

answered Dec 15, 2015 at 8:46

jedrzej.kurylo

41.1k10 gold badges108 silver badges112 bronze badges

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

8 Comments

Amarnasan Over a year ago

Can you show us the API documentation where you see that DB::query() takes no arguments?

jedrzej.kurylo Over a year ago

github.com/laravel/framework/blob/5.1/src/Illuminate/Database/…

jedrzej.kurylo Over a year ago

Connection is the class behind DB facade

Андрей Федотов Over a year ago

Thanks, works, but now, cant use paginate() method.

jedrzej.kurylo Over a year ago

You can't have Eloquent do the pagination on database level if you're using a raw query. Query needs to be built using query builder so that Eloquent knows how to apply pagination criteria.

|

Collectives™ on Stack Overflow

How to get Laravel Collection from Builder?

1 Answer 1

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related