PHP counting JSON elements with specific property

Question

I have a json like this:

{
"data": [
{
"prop1":"aaa",
"prop2":"bbb",
"prop3":"1234",
"prop4":"2006"
},
{
"prop1":"ccc",
"prop2":"ddd",
"prop3":"4567",
"prop4":"2016"
},
{
"prop1":"aaa",
"prop2":"ddd",
"prop3":"4567",
"prop4":"2002"
}
]}

It will have ~100 elements and I need to count elements with specified property, I tried something with

echo count($json['data']);

but it will get me count of all elements of json - I need to know the number of elements with prop1 => "aaa"

what I have so far:

$file = "test.json";

$fh = fopen($file, 'a') or die();
$json = json_decode(file_get_contents($file), true);



echo '<pre>';
print_r($json);
exit();

?>

deedoo · Accepted Answer · 2016-05-22 17:48:14Z

1

Use array_filter to create a callback filter function

<?php 


$json = '{
"data": [
{
"prop1":"aaa",
"prop2":"bbb",
"prop3":"1234",
"prop4":"2006"
},
{
"prop1":"ccc",
"prop2":"ddd",
"prop3":"4567",
"prop4":"2016"
},
{
"prop1":"aaa",
"prop2":"ddd",
"prop3":"4567",
"prop4":"2002"
}
]}';



echo '<pre>';
$data = json_decode($json);
print_r($data->data);
$data->data = array_filter($data->data, function($item) { 
    return $item->prop1 == 'aaa';
});
print_r($data->data);
exit();

?>

edited May 22, 2016 at 17:48

answered May 22, 2016 at 17:33

deedoo

828 bronze badges

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

Collectives™ on Stack Overflow

PHP counting JSON elements with specific property

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related