How to pass foreach inside laravel DB::select query

Question

I want to iterate through list of words broken down in a function processNeedle. This is working fine with ordinary php but not in laravel.

    $query = $request->input('query');  

    $trim = new SearchTrim();

    $words = $trim->ProcessNeedle($query);


    $concat = "CONCAT(";        

     $concat.="title,";

    $concat.="'')";


    $sql =DB::select("SELECT DISTINCT id,title,code,abstract FROM projects WHERE 0 ";

    foreach ($words as $word) $sql.=" OR $concat LIKE '%$word%'";
    $sql.=" ORDER BY id DESC";

My query function well like this in php

SQL query: SELECT DISTINCT id,title,code FROM projects WHERE 0 OR CONCAT(title,'') LIKE '%intranet%' OR CONCAT(title,'') LIKE '%mailing%' ORDER BY id DESC;

How do i achieve this in Laravel Please help

Okkk.. But how do I achieve this in laravel? iterating the words from array along with the concat statement — Angwa Moses
– Angwa Moses, Commented Apr 28, 2020 at 11:31
why do u concat title with empty string '' and why where 0? — TsaiKoga
– TsaiKoga, Commented Apr 28, 2020 at 11:35
SELECT DISTINCT id,title,code FROM projects WHERE 0 OR CONCAT(title,'') LIKE '%intranet%' OR CONCAT(title,'') LIKE '%mailing%' ORDER BY id DESC; — Angwa Moses
– Angwa Moses, Commented Apr 28, 2020 at 11:44
This query works perfectly in ordinary php... Its only in laravel its not working.. — Angwa Moses
– Angwa Moses, Commented Apr 28, 2020 at 11:44

PHP Geek · Accepted Answer · 2020-04-28 12:13:47Z

1

Try this example . i hope it helps you .

Pass foreach inside laravel DB::select query

$items = ['condition1', 'condition2', 'condition3'];
        $results = App\Model::where(function ($query) use ($items) {
            foreach($items as $item) {
                $query->orWhere('dbfield', 'LIKE', "%$item%");
            }
        })
            ->get();
        dd($results);

answered Apr 28, 2020 at 12:13

PHP Geek

4,0632 gold badges19 silver badges32 bronze badges

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

1 Comment

Angwa Moses Over a year ago

Hello, Please how do I edit this query to display the row that have the highest words first

Collectives™ on Stack Overflow

How to pass foreach inside laravel DB::select query

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related