Data hosted with ♥ by Pastebin.com - Download Raw - See Original
  1. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
  2. <html xmlns="http://www.w3.org/1999/xhtml">
  3. <head>
  4. <meta http-equiv="content-type" content="text/html; charset=utf-8" />
  5. <title>PENDUDUK SUMATERA BARAT MENURUT KABUPATEN TAHUN 2007</title>
  6. <script src="js/jquery-1.9.1.min.js"></script>
  7. <script src="js/highcharts.js"></script>
  8. <script src="js/exporting.js"></script>
  9. <script type="text/javascript">
  10.     var chart1; // globally available
  11. $(document).ready(function() {
  12.       chart1 = new Highcharts.Chart({
  13.          chart: {
  14.             renderTo: 'container',
  15.             type: 'column'
  16.          },  
  17.          title: {
  18.             text: 'PENDUDUK SUMATERA BARAT MENURUT KABUPATEN TAHUN 2007'
  19.          },
  20.          xAxis: {
  21.             categories: ['Kabupaten']
  22.          },
  23.          yAxis: {
  24.             title: {
  25.                text: 'Jumlah Penduduk Per Seratus Ribu'
  26.             }
  27.          },
  28.               series:            
  29.            
  30. <?php
  31.            
  32. $server = "localhost";
  33. $username = "user_mysql";
  34. $password = "password_mysql";
  35. $database = "grafik";
  36. mysql_connect($server,$username,$password) or die("Koneksi gagal");
  37. mysql_select_db($database) or die("Database tidak bisa dibuka");
  38. $sql   = "SELECT * from datapenduduk";
  39. $query = mysql_query( $sql )  or die(mysql_error());        
  40. while($ambil = mysql_fetch_array($query)){
  41.     $kabupaten=$ambil['kabupaten'];
  42.     $sql_jumlah   = "SELECT * from datapenduduk where kabupaten='$kabupaten'";        
  43.     $query_jumlah = mysql_query( $sql_jumlah ) or die(mysql_error());
  44.     while( $data = mysql_fetch_array( $query_jumlah ) ){
  45.        $jumlahx = $data['jumlah'];                
  46.       }            
  47.      
  48.       ?>
  49.       {
  50.           name: '<?php echo $kabupaten; ?>',
  51.           data: [<?php echo $jumlahx; ?>]
  52.       },
  53.       <?php } ?>
  54. ]
  55. });
  56. });
  57. </script>
  58. </head>
  59. <body>
  60. <div id="container" style="min-width: 400px; height: 400px; margin: 0 auto"></div>
  61. </body>
  62. </html>