<html> <head> <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script> <script type="text/javascript"> google.charts.load('current', {'packages':['corechart']}); google.charts.setOnLoadCallback(drawChart); function drawChart() { var data = google.visualization.arrayToDataTable([ ['Task', 'Hours per Day'], <?php $query = "SELECT name, score FROM `Users` order by score desc limit 5"; $result = mysqli_query($conn, $query); if ($result->num_rows > 0) { while($row = mysqli_fetch_array($result)) { echo "['".$row['name']."', '".$row['score']."'],"; } } ?> ]); var options = { title: 'My Daily Activities' }; var chart = new google.visualization.PieChart(document.getElementById('piechart')); chart.draw(data, options); } </script> </head> <body> <div id="piechart" style="width: 900px; height: 500px;"></div> </body></html>我的代碼有什么問(wèn)題嗎？我讀到我的值存儲(chǔ)為字符串，以便圖表顯示 100% 其他。我該如何讓它發(fā)揮作用？我嘗試使用(int)$varPHP 函數(shù)，但這還不能使它工作.. while($row = mysqli_fetch_array($result)) { $score = $row['score']; $int = (int)$score; echo "['".$row['name']."', '".$row['score']."'],"; } }
1 回答
慕的地6264312
TA貢獻(xiàn)1817條經(jīng)驗(yàn) 獲得超6個(gè)贊
不要自己生成json。json_encode 始終使用：
<?php
$query = "SELECT name, score FROM `Users` order by score desc limit 5";
$result = mysqli_query($conn, $query);
$chartData = [
['Task', 'Hours per Day'],
];
if ($result->num_rows > 0) {
while($row = mysqli_fetch_array($result))
{
$chartData[] = [$row['name'], $row['score']];
}
}?>
<script type="text/javascript">
google.charts.load('current', {'packages':['corechart']});
google.charts.setOnLoadCallback(drawChart);
function drawChart() {
var data = google.visualization.arrayToDataTable(<?php echo json_encode($chartData)?>);
var options = {
title: 'My Daily Activities'
};
var chart = new google.visualization.PieChart(document.getElementById('piechart'));
chart.draw(data, options);
}
</script>
- 1 回答
- 0 關(guān)注
- 100 瀏覽
添加回答
舉報(bào)
0/150
提交
取消