<?php
$json = '{"locations":"Bangalore","requestor_department":"DC","requestor_department_count":"3"}{"locations":"Bangalore","requestor_department":"EBA","requestor_department_count":"1"}{"locations":"Chennai","requestor_department":"DC","requestor_department_count":"34"}{"locations":"Chennai","requestor_department":"EBA","requestor_department_count":"20"}{"locations":"Cochin","requestor_department":"DC","requestor_department_count":"4"}{"locations":"Cochin","requestor_department":"EBA","requestor_department_count":"2"}{"locations":"Hyderabad","requestor_department":"DC","requestor_department_count":"58"}{"locations":"Hyderabad","requestor_department":"EBA","requestor_department_count":"18"}{"locations":"Kolkata","requestor_department":"DC","requestor_department_count":"37"}{"locations":"Kolkata","requestor_department":"EBA","requestor_department_count":"8"}{"locations":"Pune","requestor_department":"DC","requestor_department_count":"26"}{"locations":"Pune","requestor_department":"EBA","requestor_department_count":"11"}';
$array = json_decode($json, true);
$dcData = array(); $ebaData = array();
foreach($array as $row)
{
if($row['requestor_department'] == "DC")
array_push($dcData, $row['requestor_department_count']);
if($row['requestor_department'] == "EBA")
array_push($ebaData, $row['requestor_department_count']);
}
echo json_encode($dcData);
echo json_encode($ebaData);
?>
preferences:
30.86 ms | 402 KiB | 5 Q