-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathFrequent items.php
50 lines (42 loc) · 1.35 KB
/
Frequent items.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
<?php
include("toconnect.php");
$sql = "CALL createGraph();";
$result = mysqli_query($connection,$sql);
?>
<!DOCTYPE html>
<html lang="en">
<head>
<script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>
<script type="text/javascript">
google.charts.load('current', {'packages':['bar']});
google.charts.load('current', {'packages':['corechart']});
google.charts.setOnLoadCallback(drawChart);
function drawChart() {
var data = google.visualization.arrayToDataTable([
['Product Name', 'Frequency'],
<?php
if(mysqli_num_rows($result) > 0){
while($row = mysqli_fetch_array($result))
{
echo "['".$row["Product_name"]."','".$row["COUNT(*)"]."'],";
}
}
?>
]);
var options = {
titleTextStyle : { color: 'black' , fontSize: 30 , fontName: "Times",bold:true},
colors : '#e6693e',
titlePosition: 'none'
};
var chart = new google.charts.Bar(document.getElementById('columnchart_material'));
chart.draw(data, google.charts.Bar.convertOptions(options));
}
</script>
</head>
<body>
<div style="text-align: center;">
<br> </br>
<div id="columnchart_material" style="width:800px;height:500px;display:inline-block;"></div>
</div>
</body>
</html>