<?php require(“config.inc”); ?>
<?php
/** */
$sql1=” SELECT count(TTM_TEMPERATURE) as CNT, TTM_TEMPERATURE
from trace_temperature_main
group by TTM_TEMPERATURE
order by TTM_TEMPERATURE”;
$stmt1 = OCIParse($conn, $sql1) or die(“Couldn’t parse statement.”);
$result1=OCIExecute($stmt1) or die(“Couldn’t execute statement.”);
while($row1 = oci_fetch_array($stmt1))
{
$suhu=str_replace(“‘”,””,$row1[“TTM_TEMPERATURE”]);
$nilaisuhu[]=”‘”.$suhu.”‘”;
$bilsuhu[] = $row1[‘CNT’];
}
?>
<html>
<head>
<title>Bar – ChartJS</title>
<script src=”https://cdnjs.cloudflare.com/ajax/libs/Chart.js/2.3.0/Chart.bundle.js”></script>
<style type=”text/css”>
.container {
width: 50%;
margin: 15px auto;
}
</style>
</head>
<body>
<div class=”container”>
<canvas id=”myChart” width=”100″ height=”100″></canvas>
</div>
<script>
var ctx = document.getElementById(“myChart”);
var myChart = new Chart(ctx, {
type: ‘bar’,
data: {
labels: [<?php echo join(‘,’,$nilaisuhu);?>],
datasets: [{
label: ‘Bilangan pergerakan individu’,
data: [<?php echo join(‘,’,$bilsuhu);?>],
backgroundColor: [
‘rgba(255, 99, 132, 0.2)’,
‘rgba(54, 162, 235, 0.2)’,
‘rgba(255, 206, 86, 0.2)’,
‘rgba(75, 192, 192, 0.2)’,
‘rgba(153, 102, 255, 0.2)’,
‘rgba(255, 159, 64, 0.2)’,
‘rgba(255, 99, 132, 0.2)’,
‘rgba(54, 162, 235, 0.2)’,
‘rgba(255, 206, 86, 0.2)’,
‘rgba(75, 192, 192, 0.2)’,
‘rgba(153, 102, 255, 0.2)’,
‘rgba(255, 159, 64, 0.2)’
],
borderColor: [
‘rgba(255,99,132,1)’,
‘rgba(54, 162, 235, 1)’,
‘rgba(255, 206, 86, 1)’,
‘rgba(75, 192, 192, 1)’,
‘rgba(153, 102, 255, 1)’,
‘rgba(255, 159, 64, 1)’,
‘rgba(255, 99, 132, 0.2)’,
‘rgba(54, 162, 235, 0.2)’,
‘rgba(255, 206, 86, 0.2)’,
‘rgba(75, 192, 192, 0.2)’,
‘rgba(153, 102, 255, 0.2)’,
‘rgba(255, 159, 64, 0.2)’
],
borderWidth: 1
}]
},
options: {
scales: {
yAxes: [{
ticks: {
beginAtZero: true
}
}]
}
}
});
</script>
</body>
</html>
Recent Comments