Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!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>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement