admin管理员组文章数量:1125920
I'm new to Chart.js, and am trying to display a bar chart, with data called using jquery's AJAX call to a PHP file contains mysql query where the data are stored.
The page where the chart is supposedly displayed, only displayed the X and Y axis, but no chart is displayed, even though the array I got from Ajax call is present.
I have spent 5 days tinkering about, and I think it's time to throw in the towel and ask around,
HTML Page
<!DOCTYPE html>
<html>
<head>
<title>Chart.js Sample</title>
<script type="text/javascript" src="chart.umd.js"></script>
<script type="text/javascript" src="jquery-3.6.0.min.js"></script>
<style type="text/css">
#myChart {
min-width: 100px;
max-width: 500px;
min-height: 200px;
max-height: 400px;
}
</style>
</head>
<body>
<canvas id="myChart"></canvas>
<script type="text/javascript">
var chData = [];
$(document).ready(function(){
$.ajax({
url: "ajax.php",
method: "GET",
dataType: "JSON",
contentType: "application/json; charset=utf-8",
success: function(data) {
chData = data;
}
});
var chartId = new Chart($("#myChart"), {
type: 'bar',
data: {
labels: ["HTML", "CSS", "JAVASCRIPT", "CHART.JS", "JQUERY"],
datasets: [{
label: "Subjects",
data: chData
}]
}
});
});
</script>
</body>
</html>
AJAX Page:
<?php
$conn = mysqli_connect("localhost", "root", "mypass", "chart") or die("Mysql Error Connect: ".mysqli_error());
$arr = [];
$q = mysqli_query($conn, "SELECT score FROM score");
if(mysqli_num_rows($q)>0) {
while($x = mysqli_fetch_array($q)) {
$score = $x["score"];
array_push($arr, $score);
}
}
header('Content-type: application/json');
echo json_encode($arr);
?>
If you run the code, and open the console in the developer options, you'd find the JSON array is already there:
chData
(5) ['44', '35', '22', '28', '73']
Could someone please point me out where did I do wrong? Thank you for your time and help
I'm new to Chart.js, and am trying to display a bar chart, with data called using jquery's AJAX call to a PHP file contains mysql query where the data are stored.
The page where the chart is supposedly displayed, only displayed the X and Y axis, but no chart is displayed, even though the array I got from Ajax call is present.
I have spent 5 days tinkering about, and I think it's time to throw in the towel and ask around,
HTML Page
<!DOCTYPE html>
<html>
<head>
<title>Chart.js Sample</title>
<script type="text/javascript" src="chart.umd.js"></script>
<script type="text/javascript" src="jquery-3.6.0.min.js"></script>
<style type="text/css">
#myChart {
min-width: 100px;
max-width: 500px;
min-height: 200px;
max-height: 400px;
}
</style>
</head>
<body>
<canvas id="myChart"></canvas>
<script type="text/javascript">
var chData = [];
$(document).ready(function(){
$.ajax({
url: "ajax.php",
method: "GET",
dataType: "JSON",
contentType: "application/json; charset=utf-8",
success: function(data) {
chData = data;
}
});
var chartId = new Chart($("#myChart"), {
type: 'bar',
data: {
labels: ["HTML", "CSS", "JAVASCRIPT", "CHART.JS", "JQUERY"],
datasets: [{
label: "Subjects",
data: chData
}]
}
});
});
</script>
</body>
</html>
AJAX Page:
<?php
$conn = mysqli_connect("localhost", "root", "mypass", "chart") or die("Mysql Error Connect: ".mysqli_error());
$arr = [];
$q = mysqli_query($conn, "SELECT score FROM score");
if(mysqli_num_rows($q)>0) {
while($x = mysqli_fetch_array($q)) {
$score = $x["score"];
array_push($arr, $score);
}
}
header('Content-type: application/json');
echo json_encode($arr);
?>
If you run the code, and open the console in the developer options, you'd find the JSON array is already there:
chData
(5) ['44', '35', '22', '28', '73']
Could someone please point me out where did I do wrong? Thank you for your time and help
Share Improve this question edited 2 days ago Your Common Sense 158k42 gold badges221 silver badges363 bronze badges asked 2 days ago ElectricowElectricow 132 bronze badges New contributor Electricow is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.1 Answer
Reset to default 0The AJAX request is asynchronous. From your current code, it will proceed to the var chartId = ... line without waiting for the request to be completed.
Hence, you should move the part to create the Chart instance to the success callback so that when the response is returned with the success status code, it will pass the data to create the Chart instance.
$.ajax({
url: "ajax.php",
method: "GET",
dataType: "JSON",
contentType: "application/json; charset=utf-8",
success: function(data) {
var chartId = new Chart($("#myChart"), {
type: 'bar',
data: {
labels: ["HTML", "CSS", "JAVASCRIPT", "CHART.JS", "JQUERY"],
datasets: [{
label: "Subjects",
data: data
}]
}
});
}
});
And you don't need to declare the global variable for chData.
本文标签： jqueryUnable to put JSON data into ChartJSStack Overflow
版权声明：本文标题：jquery - Unable to put JSON data into Chart.JS - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1736623887a1945634.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。
发表评论