Filter a 2d array to only keep rows where a specific column value is greater than nominated value

Question

I have a form that submits the following data. I only want to select the data with QTY of 1 or more.

array (size=4)
  17 => 
    array (size=4)
      'id' => string '17' (length=2)
      'TicketName' => string 'General admission' (length=17)
      'price' => string '50.00' (length=5)
      'qty' => string '0' (length=1)
  18 => 
    array (size=4)
      'id' => string '18' (length=2)
      'TicketName' => string 'General admission' (length=17)
      'price' => string '50.00' (length=5)
      'qty' => string '2' (length=1)
  19 => 
    array (size=4)
      'id' => string '19' (length=2)
      'TicketName' => string 'General admission' (length=17)
      'price' => string '50.00' (length=5)
      'qty' => string '0' (length=1)
  20 => 
    array (size=4)
      'id' => string '20' (length=2)
      'TicketName' => string 'General admission' (length=17)
      'price' => string '50.00' (length=5)
      'qty' => string '0' (length=1)

I know I can use something like. I'm not sure how to filter by the qty key.

$arrays = array_filter($inputs, function($val) {
                return $val > 0;
          });

possible duplicate of Filter multidimensional arrays

Jay Blanchard
– Jay Blanchard

2014-11-07 15:50:23 +00:00
Commented Nov 7, 2014 at 15:50 — Jay Blanchard
– Jay Blanchard, Commented Nov 7, 2014 at 15:50

dynamic · Accepted Answer · 2014-11-07 15:48:26Z

4

Each element of your array $input, is an array. So you need to access the value associated to the key qty:

$arrays = array_filter($inputs, function($elem){
    return (int)$elem['qty'] > 0;
});

answered Nov 7, 2014 at 15:48

dynamic

48.2k56 gold badges163 silver badges236 bronze badges

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

1 Comment

Fraserk Over a year ago

Thanks, but when I run this code i'm getting a "Illegal string offset 'qty'" error

M K · Accepted Answer · 2014-11-07 16:04:09Z

1

$array = array();    
foreach($main_array as $chunk){
  if($chunk['qty'] > 0 ){
    $array[] = $chunk;
  }
}
var_dump($array);

answered Nov 7, 2014 at 16:04

M K

3955 silver badges14 bronze badges

Collectives™ on Stack Overflow

Filter a 2d array to only keep rows where a specific column value is greater than nominated value

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related