agan agn tolong di koreksi dong,, ini kok gak keluar grafiknya sih,, tolong bantuannya gan..
<?php
include('config.php');
$menu=array();
$ret=01;
while( $ret <= 31 ){
$merek="2013-07-$ret";
$sql_jumlah = "SELECT sum(time) AS total FROM ot WHERE date='$merek'";
$qry = mysql_query( $sql_jumlah ) or die(mysql_error());
while($row=mysql_fetch_array($qry)){
$menu[] = $row['total'];
}
$ret++;
}
$aray1= join(" ,", $menu);
$aray2= "'".join("',' ",$menu)."'";
echo $aray1;
echo $aray2;
?>
<html>
<head>
<script src="js/jquery.min.js" type="text/javascript"></script>
<script src="js/highcharts.js" type="text/javascript"></script>
<script type="text/javascript">
var chart1; // globally available
$(document).ready(function() {
chart1 = new Highcharts.Chart({
chart: {
renderTo: 'container',
type: 'column'
},
title: {
text: 'grafik ot summary '
},
xAxis: {
categories: [<?php echo $aray2;?>]
},
yAxis: {
title: {
text: 'Minute'
}
},
series: [{
name: 'TCH Traffic',
data: [<?php echo $aray1;?>]
}]
});
});
</script>
</head>
<body>
<div id='container'></div>
</body>
</html>
Tidak ada komentar:
Posting Komentar