Laravel 5.0 Query Builder - Where with multiple parameters

Question

I've a Laravel 5.0 project, that I need to implement the following logic

$var1= 'A';
$var2= 'B';
$var3= 50;
$data = DataModel::select('attr1','attr2')->where(function($q){
    $q->where('attr3','like','%'.$var1.'%');
    $q->where('attr4','like',$var2.'%');
    $q->where('attr5','=',$var3);
})->get();

The problem is for the "Where" function $var1, var2 and $var3 are undefined variables.

My Question is, How can I pass multiple parameters to the where function?

Muhammed Imran Hussain · Accepted Answer · 2016-11-01 09:19:33Z

5

Here, closure function passed in where argument. To inherit variables you have to use use keyword

For example function($q) use($var1, $var2, $var3){...

To learn more about closure function please check php manual.

answered Nov 1, 2016 at 9:19

Muhammed Imran Hussain

2,13318 silver badges24 bronze badges

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

Comments

Hari Darshan · Accepted Answer · 2016-11-01 09:27:33Z

3

Try this

$var1= 'A';
$var2= 'B';
$var3= 50;
$data = DataModel::select('attr1','attr2')->where(function($q) use ($var1, $var2, $var3) {
    $q->where('attr3','like','%'.$var1.'%')
        ->orWhere('attr4','like',$var2.'%')
        ->orWhere('attr5','=',$var3);
})->get();

answered Nov 1, 2016 at 9:27

Hari Darshan

1,9181 gold badge25 silver badges42 bronze badges

Collectives™ on Stack Overflow

Laravel 5.0 Query Builder - Where with multiple parameters

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related