How to start a query in Laravel with Eloquent?

Question

I'm trying to write the following code:

foreach($relations as $relation){
    $query->orWhereHas($relation, function ($query) use ($filter) {
        $query->where('name', 'like', '%'.$filter.'%');
    });
}

but I don't know how to initialize the $query variable, I'd prefer not to write the first orWhereHas before the foreach starts. Anyone knows how to achieve this? Thanks!

Show all code from model

Illia Yaremchuk
– Illia Yaremchuk

2016-10-26 21:14:56 +00:00
Commented Oct 26, 2016 at 21:14 — Illia Yaremchuk
– Illia Yaremchuk, Commented Oct 26, 2016 at 21:14
$query = Model::query();

user2094178
– user2094178

2016-10-26 21:17:56 +00:00
Commented Oct 26, 2016 at 21:17 — user2094178
– user2094178, Commented Oct 26, 2016 at 21:17
Thanks user2094178! That works! <3

Sofia Gilardino
– Sofia Gilardino

2016-10-26 21:23:20 +00:00
Commented Oct 26, 2016 at 21:23 — Sofia Gilardino
– Sofia Gilardino, Commented Oct 26, 2016 at 21:23
@user2094178 You may want to use your comment as an answer

Yahya Uddin
– Yahya Uddin

2018-04-05 20:02:29 +00:00
Commented Apr 5, 2018 at 20:02 — Yahya Uddin
– Yahya Uddin, Commented Apr 5, 2018 at 20:02
Thanks for the info :D

abr
– abr

2018-05-18 10:39:06 +00:00
Commented May 18, 2018 at 10:39 — abr
– abr, Commented May 18, 2018 at 10:39

pablorsk · Accepted Answer · 2018-06-03 22:28:37Z

12

Eloquent models has query() method. Then, you can do this

$query = App\User::query();

answered Jun 3, 2018 at 22:28

pablorsk

4,4462 gold badges36 silver badges39 bronze badges

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

Collectives™ on Stack Overflow

How to start a query in Laravel with Eloquent?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related