grafik


<!DOCTYPE html>
<html lang="en">
<head>
	<meta charset="utf-8">
	<meta name="viewport" content="width=device-width, initial-scale=1.0">
	<meta name="author" content="ilmu-detil.blogspot.com">
	<title>Bootstrap Graph Using Highcharts </title>
	<!-- Bagian css -->
	<script src="assets/js/jquery-1.10.1.min.js"></script>
	<script src="assets/js/highcharts.js"></script>
	<script>
		var chart1;
		$(document).ready(function() {
			  chart1 = new Highcharts.Chart({
				 chart: {
					renderTo: 'mygraph',
					type: 'column'
				 },
				 title: {
					text: 'Grafik Pengunjung '
				 },
				 xAxis: {
					categories: ['Grafik']
				 },
				 yAxis: {
					title: {
					   text: 'Jumlah Pengunjung'
					}
				 },
					  series:
					[
						<?php
						include "../koneksi.php";
						$sql   = "SELECT kelas  FROM tbl_pengunjung";
						$query = mysqli_query( $mysqli, $sql )  or die(mysqli_error());
						while( $temp = mysqli_fetch_array( $query ) )
						{
							$trendbrowser=$temp['kelas'];
							$sql_total   = "SELECT tgl_kunjung FROM tbl_pengunjung WHERE kelas='$trendbrowser'";
							$query_total = mysqli_query($mysqli,$sql_total ) or die(mysql_error());
							while( $data = mysqli_fetch_array( $query_total ) )
							{
								$tgl_kunjung = $data['tgl_kunjung'];
							}
						?>
							{
							  name: '<?php echo $trendbrowser; ?>',
							  data: [<?php echo $tgl_kunjung; ?>]
							},
							<?php
						} 	?>
						]
			  });
		   });
	</script>
</head>
<body>

<!--- Bagian Judul-->
<div class="container" style="margin-top:20px">
	<div class="col-md-10">
		<div class="panel panel-primary">
			<div class="panel-heading">The Graph of Browser Trends</div>
				<div class="panel-body">
					<div id ="mygraph"></div>
				</div>
		</div>
	</div>
</div>
</body>
</html>