query builder laravel if var null or "" load all data

Question

I have a var let's say $var1

I want to run it in query builder like this

DB::table('test')->join('... `many join here` ....')->where('testA', '=', '$var1')->get();

the problem is if $var = "" or null it's not return any data

I try to follow this link @phill answer

but confused implemented in query builder laravel

@update

when i add $get in 3 it's not display anything

and when i check console it's error 500 (object of class can't be converted to string)

when i add $get in 2 it's can give result when $var not empty..but when $var empty it's error

where i'm missing?

i'm little bit confused. What do you want to achieve if the `var` is empty? — ssuhat, Jan 09 '16 at 14:54
@SSuhat i want to load all data...default where will give no result because `$var` is empty — Surya Matadewa, Jan 09 '16 at 14:55

ssuhat · Accepted Answer · 2016-01-09T15:30:33.480

1

You can try this way:

$var1 = "";
$q = DB::table('test')->join('... `many join here` ....');

$result = !isset($var1) ? $q : $q->where('testA', '=', $var1);
$result = $result->orderBy('column')->get();
 return $result;

You can change empty to !isset if you prefer using it.

edited Jan 09 '16 at 15:30

answered Jan 09 '16 at 14:57

ssuhat

7,387
18
61
116

i tried using this code..it's can load all data when `$var` empty` but when `$var` have value it's still load all data..not spesific value `where $var` – Surya Matadewa Jan 09 '16 at 15:08
1

I've update my `where` query. I mistakenly put string instead of variable. – ssuhat Jan 09 '16 at 15:10
hmm i get a little error implement it in my script...wait a minute i will updalod it..maybe you can check – Surya Matadewa Jan 09 '16 at 15:20
1

I've update my answer. Try `dd($var)` look what it gives you when you not fill it and fill it. – ssuhat Jan 09 '16 at 15:31
`$var` is undifined when empty i `dd()` – Surya Matadewa Jan 09 '16 at 15:37
1

What if you fill it with value? – ssuhat Jan 09 '16 at 15:40
the value of var let say it's `S001` – Surya Matadewa Jan 09 '16 at 15:45
What you fix? Can i know? – ssuhat Jan 09 '16 at 15:50
it's actually my bad...i misplace and mistype my real variabel `$suplier` with my example variabel `$var` – Surya Matadewa Jan 09 '16 at 15:57

query builder laravel if var null or "" load all data

1 Answers1