Laravel if condition query

Question

I have four input fields : Like this

$cou = Input::get('activitycou');
$type = Input::get('activitytype');
$Des = Input::get('activityDes');

I do the following :

If ($type!=null){
$query=Activity::where('id', $type)->get();   
}
If ($Des!=null){
$query=Activity::where('des_id', $Des)->get();   
}

etc However the problem is that $query is not displayed correctly can someone suggest a solution.

I need the query for my post view.So it needs to be query at every if. — user3142452
– user3142452, Commented Jul 4, 2016 at 18:16
no but the query is connected and gives me combined results what I want is each query a result maybe another way than if — user3142452
– user3142452, Commented Jul 4, 2016 at 18:20

Panagiotis Koursaris · Accepted Answer · 2016-07-04 20:58:20Z

1

If you want to get the result combined with all of your options you can do the follow (with union method you can combine multiple queries):

If ($type!=null && $Des!=null && $cou!=null){
   $query1 = Activity::where('id', $type);   
   $query2 = Activity::where('des_id', $Des);
   $query3 = Activity::where('des_id', $cou);
   $allQueries = $query1->union($query2)->union($query3)->get();
 } elseif ($type!=null && $Des!=null){
   $query1 = Activity::where('id', $type);   
   $query2 = Activity::where('des_id', $Des);
   $allQueries = $query1->union($query2)->get();
 } elseif ($type!=null && $cou!=null){
   $query1 = Activity::where('id', $type);   
   $query2 = Activity::where('des_id', $cou);
   $allQueries = $query1->union($query2)->get();
 } elseif ($type!=null && $cou!=null){
   $query1 = Activity::where('id', $type);   
   $query2 = Activity::where('des_id', $Des);
   $allQueries = $query1->union($query2)->get();
 } elseif ($Des!=null && $cou!=null){
   $query1 = Activity::where('id', $cou);   
   $query2 = Activity::where('des_id', $Des);
   $allQueries = $query1->union($query2)->get();
 } elseif ($type!=null){
   $query1 = Activity::where('id', $type)->get();
 } elseif ($Des!=null){
   $query1 = Activity::where('id', $Des)->get();
 } elseif ($cou!=null){
   $query1 = Activity::where('id', $cou)->get();
 }

edited Jul 4, 2016 at 20:58

answered Jul 4, 2016 at 19:57

Panagiotis Koursaris

4,0534 gold badges29 silver badges49 bronze badges

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

6 Comments

user3142452 Over a year ago

I will use it but I want for everyone of the three of them .Its a user he picks destination if the destination is not null i want the Query to be bulit.If he picks the type only i want the Query to be built.

Panagiotis Koursaris Over a year ago

you can do it with if else like my answer

user3142452 Over a year ago

i will try it but i did something similar and did not work it kept asking me to use the first condition (Choose destination) no matter what.

user3142452 Over a year ago

is there a way to make this without ifs?

Panagiotis Koursaris Over a year ago

I don't know any better way without if else

|

Collectives™ on Stack Overflow

Laravel if condition query

1 Answer 1

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related