month_highchart.php

<?php

// example data get query month asc
$sql = array(
            array('amount'=>2,'nama negara'=> 'Saudi Arabia','month'=>3),
            array('amount'=>2,'nama negara'=> 'Taiwan','month'=>3),
            array('amount'=>1,'nama negara'=> 'Singapore','month'=>3),
            array('amount'=>1,'nama negara'=> 'Malaysia','month'=>4),
            array('amount'=>1,'nama negara'=> 'Saudi Arabia','month'=>4),
            array('amount'=>2,'nama negara'=> 'Korea','month'=>4),
            array('amount'=>1,'nama negara'=> 'Taiwan','month'=>4),
            array('amount'=>1,'nama negara'=> 'Brunei','month'=>5),
            array('amount'=>5,'nama negara'=> 'Saudi Arabia','month'=>5),
            array('amount'=>2,'nama negara'=> 'Korea','month'=>5),
            array('amount'=>3,'nama negara'=> 'Taiwan','month'=>5),
            array('amount'=>4,'nama negara'=> 'Singapore','month'=>5),

        );
// example data get query distinct month asc
$month = array(0=>3,1=>4,2=>5);
//echo "<pre>";echo print_r($month)."</pre><br/>";

// example data get name negara
foreach($sql as $a)
{
    $negara[$a['nama negara']] = 0;
}
//echo "<pre>";echo print_r($negara)."</pre><br/>";

// search value group by month and negara
$data = array();
foreach($month as $a => $b)
{
    foreach($sql as $c => $d)
    {
        if($d['month'] == $b && $d['nama negara'] == $negara[$d['nama negara']])
        {
            $data[$b][$d['nama negara']] = $d['amount'];
        }
    }
}
//echo "<pre>";echo print_r($data)."</pre><br/>";

// generate series data
$series = array();
$i=0;
foreach($negara as $a => $b)
{
    $series[$i]['name'] = $a;
    foreach($month as $c => $d)
    {
        $series[$i]['data'][] = ($data[$d][$a]) ? $data[$d][$a]:0;
    }
    $i++;
}
//echo "<pre>";echo print_r($series)."</pre><br/>";

$final = array('category' => $month,'series' => $series);
//echo "<pre>";echo print_r($final)."</pre><br/>";

echo json_encode($final, JSON_NUMERIC_CHECK)
?>