<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<title>PENDUDUK SUMATERA BARAT MENURUT KABUPATEN TAHUN 2007</title>
<script src="js/jquery-1.9.1.min.js"></script>
<script src="js/highcharts.js"></script>
<script src="js/exporting.js"></script>
<script type="text/javascript">
var chart1; // globally available
$(document).ready(function() {
chart1 = new Highcharts.Chart({
chart: {
renderTo: 'container',
type: 'column'
},
title: {
text: 'PENDUDUK SUMATERA BARAT MENURUT KABUPATEN TAHUN 2007'
},
xAxis: {
categories: ['Kabupaten']
},
yAxis: {
title: {
text: 'Jumlah Penduduk Per Seratus Ribu'
}
},
series:
<?php
$server = "localhost";
$username = "user_mysql";
$password = "password_mysql";
$database = "grafik";
mysql_connect($server,$username,$password) or die("Koneksi gagal");
mysql_select_db($database) or die("Database tidak bisa dibuka");
$sql = "SELECT * from datapenduduk";
$query = mysql_query( $sql ) or die(mysql_error());
while($ambil = mysql_fetch_array($query)){
$kabupaten=$ambil['kabupaten'];
$sql_jumlah = "SELECT * from datapenduduk where kabupaten='$kabupaten'";
$query_jumlah = mysql_query( $sql_jumlah ) or die(mysql_error());
while( $data = mysql_fetch_array( $query_jumlah ) ){
$jumlahx = $data['jumlah'];
}
?>
{
name: '<?php echo $kabupaten; ?>',
data: [<?php echo $jumlahx; ?>]
},
<?php } ?>
]
});
});
</script>
</head>
<body>
<div id="container" style="min-width: 400px; height: 400px; margin: 0 auto"></div>
</body>
</html>