Google图表不显示MySql数据库的结果 [英] Google chart does not display results from MySql database
本文介绍了Google图表不显示MySql数据库的结果的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我在使用Google图表时遇到了问题，但是什么也没出现.当我删除php代码时，它没有显示任何数据，但是在代码中却没有出现.这是代码:
I have a problem with google charts but nothing appears. When I delete php code, it says no data, but with the code it just does not appear. Here's the code:
<?php
$con = mysqli_connect('localhost', 'root', '');
mysqli_select_db($con, 'gamefort');
$s = " select naziv, broj from konzola group by naziv ";
$result = mysqli_query($con, $s);
?>
<script type="text/javascript">
google.charts.load('current', {
'packages': ['corechart']
});
google.charts.setOnLoadCallback(drawChart);
function drawChart() {
var data = new google.visualization.arrayToDataTable([
['Naziv','Broj'],
<?php
while($row = mysqli_fetch_assoc($result)){
echo "['".$row["naziv"].",".$row["broj"]."'],";
}
?>
]);
var options = {
'title': 'Statistika',
'width': 400,
'height': 300
};
var chart = new google.visualization.PieChart(document.getElementById('chart_div'));
chart.draw(data, options);
}
</script>
有什么建议吗?预先感谢.
Any suggestions? Thanks in advance.
推荐答案
使用动态php代码
<?php
$con = mysqli_connect('localhost', 'root', '','gamefort');
$s = "select naziv, broj from konzola group by naziv";
$result = mysqli_query($con, $s);
$data_array = array();
while($row = mysqli_fetch_assoc($result)){
//$data_array[] = array_values($row);
$data_array[] = ($row);
}
$chart= json_encode($data_array);
?>
<!DOCTYPE html>
<html>
<head>
<title></title>
<!-- <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.1/jquery.min.js"></script> -->
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.3.1/jquery.min.js"></script>
<script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>
</head>
<body>
<!-- <input type="text" value="x" id="test" /> -->
<div id="Salesman" style="width: 650px; height: 500px;"></div>
</body>
</body>
</html>
<script type="text/javascript">
google.charts.load('current', {'packages':['corechart']});
google.charts.setOnLoadCallback(drawVisualization);
function drawVisualization() {
var chart_array= <?php echo $chart; ?>;
var header = ['Naziv', 'Broj'];
var row = "";
var rows = new Array();
jQuery.each(chart_array, function( i, d ) {
row = [d.naziv,Number(d.broj)];
rows.push(row);
});
var jsonData = [header].concat(rows);
var data = google.visualization.arrayToDataTable(jsonData);
var options = {
title : 'Month & Yearly Total Sales Values',
vAxis: {title: 'Total Sales'},
hAxis: {title: 'Month & Year'},
seriesType: 'bars',
showRowNumber: 'false'
};
var chart = new google.visualization.ComboChart(document.getElementById('Salesman'));
chart.draw(data, options);
}
</script>
这篇关于Google图表不显示MySql数据库的结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
