grafik - with db (not realy db)

<?php

//=============DATA YANG KITA MILIKI
$label = "Year"; //nama yang muncul di sumbu x (bawah)
$header=array(
    'sales', //Grafik 1
    'Expenses' //Grafik 2
);

//-------------pastikan data sesuai urutannya
$data=array(
    array('year'=>2004, 'sales'=>1000, 'Expenses'=>400),
    array('year'=>2005, 'sales'=>1100, 'Expenses'=>700),
    array('year'=>2006, 'sales'=>1600, 'Expenses'=>800),
);

//===========JADIKAN ARRAY SESUAI DENGAN FORMAT YANG BISA DIKENALI
$ar=array();
//=======Header
//--------sumbu X
$a =array($label);
//--------Header lainnya
foreach($header as $v)
  array_push($a,$v);

 $ar[]=$a;

//==========Data
foreach($data as $row){
  $a=array();$i=0;
  foreach( $row as $val){
    $i++;
    if($i==1){
      $a[]=(string)$val;
    }else{
//---------dibuat jadi angka!
      $a[]=intval( $val );
    }
  }

  $ar[]=$a;
}

//echo'<pre>'.print_r($ar,1)."\n".json_encode($ar);
$json=json_encode($ar);
?>
<script src='https://www.google.com/jsapi'></script>
<script>
google.load("visualization", "1", {
    packages: ["corechart"]
});
google.setOnLoadCallback(drawChart);

function drawChart() {

    var data = google.visualization.arrayToDataTable(<?php print $json; ?>);
/*
Silakan edit manual
*/
    var options = {
        title: 'Company Performance',
        hAxis: {
            title: 'Year',
            titleTextStyle: {
                color: 'red'
            }
        }
    };

    var chart = new google.visualization.ColumnChart(document.getElementById('chart_div'));

    chart.draw(data, options);
}
</script>
<div id="chart_div" style="width: 900px; height: 500px;"></div>