Grafik-PHP-MySQL-dan-ChartJS/index.php at master · Braggo/Grafik-PHP-MySQL-dan-ChartJS · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
<!doctype html>
<html>

<head>
	<title>Menampilkan data dari database MySQL ke grafik dengan PHP dan Chart JS | www.hakkoblogs.com</title>
	<script src="dist/Chart.bundle.js"></script>
	<script src="dist/utils.js"></script>
	<style>
	canvas {
		-moz-user-select: none;
		-webkit-user-select: none;
		-ms-user-select: none;
	}
	</style>
</head>

<body>
	<div id="container" style="width: 75%;">
		<canvas id="canvas"></canvas>
	</div>
	<?php
$db_host = "localhost";
$db_user = "root";
$db_pass = "";
$db_name = "mahasiswa";

$koneksi = mysqli_connect($db_host, $db_user, $db_pass, $db_name);

if(mysqli_connect_errno()){
	echo 'Gagal melakukan koneksi ke Database : '.mysqli_connect_error();
}
$mi = "Manajemen Informatika";
?>
	<script>
		var MONTHS = ['January', 'February', 'March', 'April', 'May', 'June', 'July', 'August', 'September', 'October', 'November', 'December'];
		var color = Chart.helpers.color;
		var barChartData = {
			labels: ['Sistem Informasi', 'Teknik Informatika', 'Manajemen Informatika', 'Teknik Industri', 'Psikologi'],
			datasets: [{
				label: 'Mahasiswa',
				backgroundColor: [color(window.chartColors.red).alpha(0.5).rgbString(),
								  color(window.chartColors.blue).alpha(0.5).rgbString(),
								  color(window.chartColors.yellow).alpha(0.5).rgbString(),
								  color(window.chartColors.blue).alpha(0.5).rgbString(),
								  color(window.chartColors.default).alpha(0.5).rgbString()],
				borderColor: [window.chartColors.red,
							  window.chartColors.blue,
							  window.chartColors.yellow,
							  window.chartColors.blue,
							  window.chartColors.default],

				borderWidth: 3,
				data: [
					<?php $tampil1=mysqli_query($koneksi, "select * from  mahasiswa WHERE jurusan='Sistem Informasi'");
                     echo mysqli_num_rows($tampil1);
                    ?>,
					<?php $tampil2=mysqli_query($koneksi, "select * from  mahasiswa WHERE jurusan='Teknik Informatika'");
                     echo mysqli_num_rows($tampil2);
                    ?>,
					<?php $tampil3=mysqli_query($koneksi, "select * from  mahasiswa WHERE jurusan='Manajemen Informatika'");
                     echo mysqli_num_rows($tampil3);
                    ?>,
					<?php $tampil4=mysqli_query($koneksi, "select * from  mahasiswa WHERE jurusan='Teknik Industri'");
                     echo mysqli_num_rows($tampil4);
                    ?>,
					<?php $tampil5=mysqli_query($koneksi, "select * from  mahasiswa WHERE jurusan='Psikologi'");
                     echo mysqli_num_rows($tampil5);
                    ?>
				]
			}]

		};

		window.onload = function() {
			var ctx = document.getElementById('canvas').getContext('2d');
			window.myBar = new Chart(ctx, {
				type: 'bar',
				data: barChartData,
				options: {
					responsive: true,
					legend: {
						position: 'top',
					},
					title: {
						display: true,
						text: 'Tabel Jurusan Mahasiswa | www.hakkoblogs.com'
					}
				}
			});

		};


	</script>
</body>

</html>