Where like queries on multidimensional arrays in php

Question

Suppose I have a php array like this:

$shop = array( array("name"=>"Tom", "level"=> 1.25 ),
               array("name"=>"Mike","level"=> 0.75 ),
               array("name"=>"John","level"=> 1.15 ) 
             );

I want to filter this array similar to filtering a mysql table with where conditions. Supposedly I want every array where level is higher than 1. I could iterate through and check with if statements. Are there any php solutions to this?

This might Interest you : http://stackoverflow.com/questions/14972025/implementing-mongodb-like-query-expression-object-evaluation — Baba, Mar 26 '13 at 20:00

score 7 · Accepted Answer · answered Mar 26 '13 at 19:56

7

array_filter is what you are looking for:

$results= array_filter($shop, function($item) { return $item['level'] > 1; });

print_r($results);

Output:

Array
(
    [0] => Array
    (
        [name] => Tom
        [level] => 1.25
    )

    [2] => Array
    (
        [name] => John
        [level] => 1.15
    )
)

answered Mar 26 '13 at 19:56

tuffkid

1,323
9
8

I wanted to up-vote but your current reputation of 666 is far too perfect. – Jacob Raccuia Apr 24 '13 at 06:25

Where like queries on multidimensional arrays in php

1 Answers1