laravel multiple where clauses within a loop

Question

Pretty much I want the query to select all records of users that are 25 years old AND are either between 150-170cm OR 190-200cm.

I have this query written down below. However the problem is it keeps getting 25 year olds OR people who are 190-200cm instead of 25 year olds that are 150-170 OR 25 year olds that 190-200cm tall. How can I fix this? thanks

 $heightarray=array(array(150,170),array(190,200));
 $user->where('age',25);

   for($i=0;$i<count($heightarray);i++){
 if($i==0){
   $user->whereBetween('height',$heightarray[$i])
}else{
   $user->orWhereBetween('height',$heightarray[$i])
 }
 }
      $user->get();

Edit: I tried advanced wheres (http://laravel.com/docs/queries#advanced-wheres) and it doesn't work for me as I cannot pass the $heightarray parameter into the closure.

from laravel documentation

 DB::table('users')
        ->where('name', '=', 'John')
        ->orWhere(function($query)
        {
            $query->where('votes', '>', 100)
                  ->where('title', '<>', 'Admin');
        })
        ->get();

You need to make use of advance wheres.

Jeemusu
– Jeemusu

2013-10-21 03:46:31 +00:00
Commented Oct 21, 2013 at 3:46 — Jeemusu
– Jeemusu, Commented Oct 21, 2013 at 3:46
I tried that but I can't pass variables into the closures

user1424508
– user1424508

2013-10-21 03:47:52 +00:00
Commented Oct 21, 2013 at 3:47 — user1424508
– user1424508, Commented Oct 21, 2013 at 3:47
Can you post the advanced where statement that you tried?

Jeemusu
– Jeemusu

2013-10-21 03:52:42 +00:00
Commented Oct 21, 2013 at 3:52 — Jeemusu
– Jeemusu, Commented Oct 21, 2013 at 3:52
I did something simliar Jeemusu in the bottom

user1424508
– user1424508

2013-10-21 04:06:14 +00:00
Commented Oct 21, 2013 at 4:06 — user1424508
– user1424508, Commented Oct 21, 2013 at 4:06

Community · Accepted Answer · 2017-05-23 11:46:25Z

10

Like Jeemusu and the OP stated, you need to use advance wheres. But if you want to pass a variable to the closure function you need to make use of the "use" approach:

$heightarray = array(array(150,170),array(190,200));

DB::table('users')
  ->where('name', '=', 'John')
  ->orWhere(function($query) use ($heightarray){
    //...
  })
  ->get();

edited May 23, 2017 at 11:46

CommunityBot

11 silver badge

answered Oct 21, 2013 at 4:10

FR6

3,1673 gold badges26 silver badges28 bronze badges

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

Comments

user1424508 · Accepted Answer · 2013-10-21 04:09:47Z

2

I found the answer. I need to include "use" in the closure to pass my $heightarray variable in. Once $heightarray is in then laravel's advance wheres work.

$heightarray=array(array(150,170),array(190,200));
  $user->where('age',25);

 $userprofile->Where(function($query) use ($heightarray) {

 for($i=0;$i<count($heightarray);i++){
 if($i==0){
 $user->whereBetween('height',$heightarray[$i])
 }else{
 $user->orWhereBetween('height',$heightarray[$i])
  }
}

 });

  $user->get();

answered Oct 21, 2013 at 4:09

user1424508

3,31113 gold badges43 silver badges67 bronze badges

Comments

Jeemusu · Accepted Answer · 2013-10-21 04:13:30Z

2

This is completely untested, but looking at the documentation for advance wheres, it would seem you want to try something like this:

DB::table('users')
->where('age',25)
->Where(function($query)
{
    for($i=0;$i<count($heightarray);i++){
       if($i==0){
          $query->whereBetween('height', $heightarray[$i]);
       }else{
          $query->orWhereBetween('height', $heightarray[$i]);
       }
    }
})->get();

edited Oct 21, 2013 at 4:13

answered Oct 21, 2013 at 3:52

Jeemusu

10.5k3 gold badges46 silver badges68 bronze badges

1 Comment

user1424508 Over a year ago

I tried that but you need to pass heightarray into the closure otherwise it doesn't know what you are talking about

Collectives™ on Stack Overflow

laravel multiple where clauses within a loop

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related