How to count repeated values from an array or json in php

Question

I would like to know how to tell the value of an array or json. Example: I want to count the value of the item GRUPO_OK = SIM and MRS_central = 1001.

Output:

MRS_central: "1001" => 2 GRUPO_OK: "SIM" => 3

Example array

Array ( [data] => Array ( [0] => Array ( [MRS_central] => 1003 [MRS_ipsat] => [GRUPO_OK] => NÃO ) [1] => Array ( [MRS_central] => 1001 [MRS_ipsat] => [GRUPO_OK] => SIM ) [2] => Array ( [MRS_central] => 1001 [MRS_ipsat] => [GRUPO_OK] => SIM ) [3] => Array ( [MRS_central] => 1002 [MRS_ipsat] => 10.4.0.253 [GRUPO_OK] => SIM ) ) )

Example json

{
data: [
{
MRS_central: "1001",
MRS_ipsat: "",
GRUPO_OK: "SIM"
},
{
MRS_central: "1001",
MRS_ipsat: "",
GRUPO_OK: "SIM"
},
{
MRS_central: "1003",
MRS_ipsat: "",
GRUPO_OK: "SIM"
},
{
MRS_central: "1002",
MRS_ipsat: "10.4.0.253",
GRUPO_OK: "NÃO"
}
]
}

Possible duplicate of array_count_values of a multi dimensional array? — GrumpyCrouton
– GrumpyCrouton, Commented Oct 5, 2018 at 16:58

hrkyoung · Accepted Answer · 2018-10-06 07:06:18Z

0

If you have array_column(), you can extract each column. Then, you can use array_count_values() to count how many times a value appears in an array.

$mrs_grupo = array_column($arr['data'], 'GRUPO_OK');
$count = array_count_values($mrs_grupo);

print_r($count);


//RESULT
array(2) {
  ["SIM"]=>
  int(3)
  ["NÃO"]=>
  int(1)
}

answered Oct 6, 2018 at 7:06

hrkyoung

1

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

Collectives™ on Stack Overflow

How to count repeated values from an array or json in php

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related