Convert Mysql Query into Laravel 4 Eloquent

Question

I want to convert this query into Laravel 4 Eloquent.

$query = SELECT * FROM standard_products WHERE frame_category like "%1%" OR
frame_category like "%2%" OR frame_category like "%3%";

Here I have an array

$frame = Array([1]=1,[2]=2,[3]=3);

Requirement:

Using $frame array I want to get same result in Laravel Eloquent

My effort is:

 foreach ($frame as $val) {
     $match = Standard_product::orWhere('frame_category','like','%'.$val.'%');
 }
     $match =  $match->get()->toArray();

But result of $match is not equal to $query. Please help me to

Could you format your code snippets to make them readable?

Matt Komarnicki
– Matt Komarnicki

2015-11-13 06:30:39 +00:00
Commented Nov 13, 2015 at 6:30 — Matt Komarnicki
– Matt Komarnicki, Commented Nov 13, 2015 at 6:30

Narendrasingh Sisodia · Accepted Answer · 2015-11-13 06:51:48Z

3

You can do it like as

Model::where(function ($query) use ($frame) {
    foreach($frame as $val){
        $query->orWhere('frame_category','like',"%$val%");
    }
})->get();

edited Nov 13, 2015 at 6:51

answered Nov 13, 2015 at 6:38

Narendrasingh Sisodia

21.4k6 gold badges51 silver badges54 bronze badges

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

Comments

JRD · Accepted Answer · 2015-11-13 06:37:20Z

2

$frame = Array(1,2,3);
$q = DB::table('standard_products');
foreach ($frame as $val) {
    $q = $q->orWhere('frame_category','like','%'.$val.'%');
}

Produces

select *
from   `standard_products`
where  `frame_category` like ?
or     `frame_category` like ?
or     `frame_category` like ?

answered Nov 13, 2015 at 6:37

JRD

1,9871 gold badge13 silver badges17 bronze badges

Collectives™ on Stack Overflow

Convert Mysql Query into Laravel 4 Eloquent

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related