Laravel query building with variables

Question

Assume that i have variables like $var1 and $var2.

Assume that i want to have a query like

$myQuery = DB::table('myTable')
           ->where('firstField', '=', $var1)
           ->where('secondField', '=', $var2)
           ->get();

Of course this one doesn't work when my variables are null. I want to control them, and do something if they are null.

I should create a query based on those variables and filter them with the values they hold.

Any other ideas how to do this ?

Someone · Accepted Answer · 2017-01-16 18:25:20Z

6

Here's a solution:

$results = DB::table('myTable')->where(function($query) use ($var1, $var2) {
               if ( ! empty($var1)) {
                   $query->where('firstField', '=', $var1);
               }
               if ( ! empty($var2)) {
                   $query->where('secondField', '=', $var2);
               }
           })->get();

Edit: Corrected ::where to ->where

edited Jan 16, 2017 at 18:25

Someone

9043 gold badges22 silver badges43 bronze badges

answered Feb 10, 2015 at 13:21

ffsantos92

3661 silver badge3 bronze badges

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

Comments

lukasgeiter · Accepted Answer · 2015-02-10 13:16:08Z

1

Not sure this is what you want but you can easily build a query in multiple "steps" using conditionals:

$query = DB::table('myTable');

if($var1 !== null){
    $query->where('firstField', $var1);
}
if($var2 !== null){
    $query->where('secondField', $var2);
}

$result = $query->get();

answered Feb 10, 2015 at 13:16

lukasgeiter

154k29 gold badges349 silver badges280 bronze badges

2 Comments

saimcan Over a year ago

this might be a solution too, but that doesn't work in my case. I join tables. Also there's a syntax error out there like 'firstField', '$var1' should be 'firstField', '=', $var1 but thank you for giving me ideas anyway.

lukasgeiter Over a year ago

Well in your question there is no join... And I don't see why this shouldn't work with joins. Also = can be omitted

Mario · Accepted Answer · 2015-02-10 13:19:11Z

1

For example you can make like this:

$myQuery = DB::table('myTable')
       ->where('firstField', '=', is_null($var1)?0:$var1)
       ->where('secondField', '=', is_null($var2)?0:$var2)
       ->get();

answered Feb 10, 2015 at 13:19

Mario

1971 gold badge3 silver badges10 bronze badges

5 Comments

Jon Surrell Over a year ago

Can you provide some explanation?

Mario Over a year ago

blankBird_ said its code doesn't work if those vars are null. Its means that you can check it, and if it are null you can find in table 0 or, for example 'null'.

Jon Surrell Over a year ago

Maybe it would be helpful to explain the ternary logic you're using, some people may be unfamiliar with it.

Mario Over a year ago

Ok, its like simple 'if-else', but in srort form. Syntax is simple: echo (condition == 0) ? "do something if true" : "do somsing if false";

Jon Surrell Over a year ago

You can edit your answer to elaborate or make it clearer. No need to restrict yourself to comments.

Collectives™ on Stack Overflow

Laravel query building with variables

3 Answers 3

Comments

2 Comments

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related