Laravel Like Eloquent with array value?

Question

How can I do a Like-query, with multiple values to search for?

$searchWords = explode(' ', Input::get('search'));

Then I get an array of words that were given for the search.

How can I pass it in this:

$pages = Page::where('content', 'LIKE', '%'.$singleWord.'%')->distinct()->get();

A loop can't work, then it overwrites the $pages always; then it keeps always the latest search:

foreach($searchWords as $word){
    $pages = Page::where('content', 'LIKE', '%'.$word.'%')->distinct()->get();
}

lukasgeiter · Accepted Answer · 2014-12-29 21:25:07Z

28

A loop is the solution but you only need to add the where condition without executing the query

$pages = Page::query();
foreach($searchWords as $word){
    $pages->orWhere('content', 'LIKE', '%'.$word.'%');
}
$pages = $pages->distinct()->get();

answered Dec 29, 2014 at 21:25

lukasgeiter

154k29 gold badges349 silver badges280 bronze badges

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

4 Comments

lukasgeiter Over a year ago

Can you use ->toSql() instead of ->get() and show me the return value?

Jarek Tkaczyk Over a year ago

It works, you must be using keyword that returns all pages, that's all.

user1469734 Over a year ago

added trim() to the searchword ;-)

Ariful Haque Over a year ago

trim() is the key to haven.

Aouidane Med Amine · Accepted Answer · 2017-09-12 09:27:17Z

8

i will code it for you :

$pages = Page->where(function($query) use($word){

foreach($searchWords as $word){
    $query->orWhere('content', 'LIKE', '%'.$word.'%');
}

})->get();

you can try that , i hope that will help :)

answered Sep 12, 2017 at 9:27

Aouidane Med Amine

1,72118 silver badges17 bronze badges

Collectives™ on Stack Overflow

Laravel Like Eloquent with array value?

2 Answers 2

4 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related