我正在使用此chart example,其中我使用以下数据更新了data.php中的查询
工作
"SELECT student_id,student_name,marks FROM tbl_marks WHERE student_id IN(1,2,3)"
不起作用
"SELECT student_id,2)"
基本上单项输入和多项输入都可以正常工作,但是当我选择两个数据行时,它会在条形图的一侧显示空白。
<script>
$(document).ready(function () {
showGraph();
});
function showGraph()
{
{
$.post("data.php",function (data)
{
console.log(data);
var name = [];
var marks = [];
for (var i in data) {
name.push(data[i].student_name);
marks.push(data[i].marks);
}
var chartdata = {
labels: name,datasets: [
{
label: 'Student Marks',backgroundColor: '#49e2ff',borderColor: '#46d5f1',hoverBackgroundColor: '#CCCCCC',hoverBorderColor: '#666666',data: marks
}
]
};
var graphTarget = $("#graphCanvas");
var barGraph = new Chart(graphTarget,{
type: 'bar',data: chartdata
});
});
}
}
</script>