laravel - php get variable value and append it to a query in a dynamic manner

Solution:

You are overcomplicating things a little here. Grab the collection of keywords, and iterate those, then useorWhere() on the keywords name, and voila. Open up a query on your items with thequery() method, then applyorWhere() for each iteration. Laravel will handle the rest. Once done, you just need toget() your data!

$keywords = ProductKeyword::orderBy('name', 'asc')->get();

$items = Item::query();
foreach ($keywords as $key => $keyword) {
    $items->orWhere('description', 'like', '%'.$keyword->name.'%');
}

$items = $items->get();
dd($items);
Copy code

Note that if there are no keywords, it will essentially becomeItem::all(), since you do not apply any where-clauses.

Solution:

you need to improve and fix your code:

  $query = Item::query();
  foreach ($keywords as $keyword) {
     $query->orWhere('description', 'like', '%'.$keyword.'%');
  }
  $result=$query->get();
Copy code

Solution:

you are using a complex way to achieve it. my answer would be almost same as @Qirel

//prepare your query
$query = Item::query();
  foreach ($keywords as $keyword) {
     //loop through the keywords in the description column of Item Table match the records which will be available in the $query
     $query->orWhere('description', 'like', '%'.$keyword.'%');
  }
  // get the records which are matched and store it in $result variable
  $result=$query->get();`enter code here`
Copy code