forked from abhii14758/QR-code-based-feedbackform
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathpie4.php
65 lines (59 loc) · 1.4 KB
/
pie4.php
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
<?php
$con = mysqli_connect('localhost','root','','feedback');
?>
<!DOCTYPE HTML>
<html>
<head>
<meta charset="utf-8">
<title>
Analysis
</title>
<script type="text/javascript" src="https://www.google.com/jsapi"></script>
<script type="text/javascript">
google.load("visualization", "1", {packages:["corechart"]});
google.setOnLoadCallback(drawChart);
function drawChart() {
var data = google.visualization.arrayToDataTable([
['Browser', 'Visits'],
<?php
$query = "SELECT count(No) AS count, Station FROM feedback GROUP BY Station";
$exec = mysqli_query($con,$query);
while($row = mysqli_fetch_array($exec)){
echo "['".$row['Station']."',".$row['count']."],";
}
?>
]);
var options = {
title: 'Analysis'
};
var chart = new google.visualization.PieChart(document.getElementById('piechart'));
chart.draw(data, options);
}
</script>
</head>
<style>
*{
/* margin: 6vh;
padding: 6vh; */
background-color: wheat;
}
body{
margin: 6vh;
padding: 6vh;
}
h3{
text-align: center;
font-size: 40px;
font-family: 'Lato', sans-serif;
}
#piechart{
margin: 10px 200px;
padding: 10px 20px;
/* border-radius: 10px; */
}
</style>
<body>
<h3>Police Station</h3>
<div id="piechart" style="width: 900px; height: 500px;"></div>
</body>
</html>