<?php
define('NAME', "your-db");
define("USER", "your-username");
define("PASS", "your-password");
define("HOST", "your-hostname");
$db = new mysqli(HOST, USER, PASS, NAME);
$db->set_charset("utf8");
$dataPoints = array();
$result = mysqli_query($db, "
SELECT COUNT(column1) AS x, y
FROM table
GROUP BY column2 ");
while($row = mysqli_fetch_array($result))
{
array_push($dataPoints, array("label"=> $row['x'], "y"=> $row['y']));
}
?>
<!DOCTYPE html>
<html lang="th">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Document</title>
<script>
window.onload = function() {
var chart = new CanvasJS.Chart("chartContainer", {
animationEnabled: true,
exportEnabled: true,
theme: "light1",
title: {
text: "PHP Column Chart from Database"
},
data: [{
type: "column",
dataPoints: <?php echo json_encode($dataPoints, JSON_NUMERIC_CHECK); ?>
}]
});
chart.render();
}
</script>
</head>
<body>
<div id="chartContainer" style="height: 370px; width: 100%;"></div>
<script src="https://canvasjs.com/assets/script/canvasjs.min.js"></script>
</body>
</html>
@boychawin
