php query array

Question

I have an array like this:

$array=[
    0 => [col_a => 1, col_b => 2, col_c =>3],
    1 => [col_a => 2, col_b => 3, col_c =>4]
];

Is there a way to do something like:

$result=query_array($array,"SELECT col_c FROM ARRAY WHERE col_a=2 AND col_b=3");
print_r($result);
// array (col_c => 4)

EDIT:

where query_array is a function that executes SQL to an array.

I know I can loop between the elements and test every "row". I was wondering if there is a build-in function that does that like that fictional query_array function.

nope, it's not query_array, you could only filter it based on its keys or value. reference if you're interested.. — Bagus Tesa
– Bagus Tesa, Commented Jan 3, 2017 at 10:29
well, if you really need it, you could use array_filter(..) and make the callbacks to emulate your where clause.. — Bagus Tesa
– Bagus Tesa, Commented Jan 3, 2017 at 10:41

Akkapong Kajornwongwattana · Accepted Answer · 2017-01-03 10:59:20Z

1

$arrays = [
   ['col_a' => 1, 'col_b' => 2, 'col_c' => 3],
   ['col_a' => 2, 'col_b' => 3, 'col_c' => 4]
];


foreach ($arrays as $array) {
   $res = array_filter($array, function($v, $k) {
      return ($k == 'col_a' && $v == 2) || ($k == 'col_b' && $v == 3);
   }, ARRAY_FILTER_USE_BOTH);

   if (count($res) == 2) {
      print_r([
          'col_c' => $array['col_c']
      ]);
   }
}

Try something like this

answered Jan 3, 2017 at 10:59

Akkapong Kajornwongwattana

5135 silver badges9 bronze badges

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

Comments

Bagus Tesa · Accepted Answer · 2017-01-03 11:26:20Z

1

 $array=[
    0 => ['col_a' => 1, 'col_b' => 2, 'col_c' =>3],
    1 => ['col_a' => 2, 'col_b' => 3, 'col_c' =>4]
];


$val1 =2;
$val2 = 3;
$isArray = array_values(array_filter($array, function ($data) use ($val1,$val2) {
    return ($data['col_a'] == $val1 &&  $data['col_b'] == $val2);
}));

edited Jan 3, 2017 at 11:26

Bagus Tesa

1,7152 gold badges24 silver badges49 bronze badges

answered Jan 3, 2017 at 10:47

Rohit Bhalani

1431 gold badge5 silver badges14 bronze badges

1 Comment

Bagus Tesa Over a year ago

additional note, this will not preserve original array's key.. while array_filter does.

Collectives™ on Stack Overflow

php query array

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related