grafik.php

<?php
$bc = mysql_query("
    select
  ifnull((SELECT sum(jumlah) FROM (pemasukan)WHERE((Month(tanggal)=1)AND (YEAR(tanggal)=2015))),0) AS `Januari`,
  ifnull((SELECT sum(jumlah) FROM (pemasukan)WHERE((Month(tanggal)=2)AND (YEAR(tanggal)=2015))),0) AS `Februari`,
  ifnull((SELECT sum(jumlah) FROM (pemasukan)WHERE((Month(tanggal)=3)AND (YEAR(tanggal)=2015))),0) AS `Maret`,
  ifnull((SELECT sum(jumlah) FROM (pemasukan)WHERE((Month(tanggal)=4)AND (YEAR(tanggal)=2015))),0) AS `April`,
  ifnull((SELECT sum(jumlah) FROM (pemasukan)WHERE((Month(tanggal)=5)AND (YEAR(tanggal)=2015))),0) AS `Mei`,
  ifnull((SELECT sum(jumlah) FROM (pemasukan)WHERE((Month(tanggal)=6)AND (YEAR(tanggal)=2015))),0) AS `Juni`,
  ifnull((SELECT sum(jumlah) FROM (pemasukan)WHERE((Month(tanggal)=7)AND (YEAR(tanggal)=2015))),0) AS `Juli`,
  ifnull((SELECT sum(jumlah) FROM (pemasukan)WHERE((Month(tanggal)=8)AND (YEAR(tanggal)=2015))),0) AS `Agustus`,
  ifnull((SELECT sum(jumlah) FROM (pemasukan)WHERE((Month(tanggal)=9)AND (YEAR(tanggal)=2015))),0) AS `September`,
  ifnull((SELECT sum(jumlah) FROM (pemasukan)WHERE((Month(tanggal)=10)AND (YEAR(tanggal)=2015))),0) AS `Oktober`,
  ifnull((SELECT sum(jumlah) FROM (pemasukan)WHERE((Month(tanggal)=11)AND (YEAR(tanggal)=2015))),0) AS `November`,
  ifnull((SELECT sum(jumlah) FROM (pemasukan)WHERE((Month(tanggal)=12)AND (YEAR(tanggal)=2015))),0) AS `Desember`
 from pemasukan GROUP BY YEAR(tanggal)
    ");
$cabang = array();
while($row = mysql_fetch_assoc($bc))
$cabang[] = $row;
?>
<script src="<?php echo $base_url;?>assets/lib/highchart/highcharts.js"></script>
<script type="text/javascript">
$(function () {
    var chart;
    $(document).ready(function() {
        chart = new Highcharts.Chart({
            chart: {
                renderTo: 'chart',
                type: 'column',
                marginRight: 130,
                marginBottom: 25
            },
            title: {
                text: 'Pemasukan',
                x: -20 //center
            },
              xAxis: {
               categories: ['Jan', 'Feb', 'Mar', 'Apr', 'Mei', 'Jun',
                                'Jul', 'Ags', 'Sep', 'Okt', 'Nov', 'Des']
              },
              yAxis: {
               title: {
                text: 'Banyak Pemasukan'
               }
              },
              series: [{
               name: 'Bulan',
               data: <?php echo json_encode($cabang); ?>
              }]
 });
});
});
</script>
<div id="chart" style="min-width: 400px;
height: 400px; margin: 0 auto"></div>