Hallo,
ich habe folgende Javascript/HTML Datei 'PieDonut3D.html':
HTML-Code:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>amCharts examples</title>
<link rel="stylesheet" href="amchart/samples/style.css" type="text/css">
<script src="amchart/amcharts/amcharts.js" type="text/javascript"></script>
<script src="amchart/amcharts/pie.js" type="text/javascript"></script>
<script type="text/javascript">
$(function(){
$.ajax({
url:"holen.php",
dataType:"json"
}).done(function(data){
var chart;
var chartData = [
{
"country": "United States",
"visits": data[1][0]
},
{
"country": "China",
"visits": 1882
},
{
"country": "Japan",
"visits": 1809
},
{
"country": "Germany",
"visits": 1322
},
{
"country": "United Kingdom",
"visits": 1122
},
{
"country": "France",
"visits": 1114
},
{
"country": "India",
"visits": 984
},
{
"country": "Spain",
"visits": 711
}
];
AmCharts.ready(function () {
// PIE CHART
chart = new AmCharts.AmPieChart();
// title of the chart
chart.addTitle("Visitors countries", 16);
chart.dataProvider = chartData;
chart.titleField = "country";
chart.valueField = "visits";
chart.sequencedAnimation = true;
chart.startEffect = "elastic";
chart.innerRadius = "30%";
chart.startDuration = 2;
chart.labelRadius = 15;
chart.balloonText = "[[title]]<br><span style='font-size:14px'><b>[[value]]</b> ([[percents]]%)</span>";
// the following two lines makes the chart 3D
chart.depth3D = 10;
chart.angle = 15;
// WRITE
chart.write("chartdiv");
});
}).fail(function(err)
{
alert(err);
});
});
</script>
</head>
<body>
<div id="chartdiv" style="width:600px; height:400px;"></div>
</body>
</html>
Und die PHP Datei 'holen.php' schaut so aus:
PHP-Code:
<?php
$con = mysqli_connect("****","****","****");
mysqli_select_db($con, "kunden");
$sql = "SELECT * FROM teilnehmer";
$rs = mysqli_query($con, $sql);
$num = mysqli_num_rows($rs);
$list = array();
$list1 = array();
$list2 = array();
$list3 = array();
while($dsatz = mysqli_fetch_assoc($rs)) {
$list[] = $dsatz['benutzer'];
$list1[] = $dsatz['aufrufe'];
$list2[] = $dsatz['anzahl'];
$list3[] = $dsatz['anzahl1'];
}
echo json_encode(array($list,$list1,$list2,$list3));
mysqli_close($con);
?>
Ich möchte nun, in der 'PieDonut3D.html' , den AJAX Request in die das Array 'CHARTDATA' schreiben. Wenn ich aber, wie zu sehen, data[1][0] bei visits schreibe, tut sich gar nichts.
Schreibe ich jedoch eine Zahl hinein, wie bei allen anderen, so funktioniert alles.
Die Daten sollen aber per AJAX in das Array CHARTDATA geschrieben werden!
Was ist falsch?
Vielen Dank:)