I have generated a xml from my database but the line is above the chart.
It does have the right x-axis names but not the y-axis values.
I'm using the $strDataURL to get the XML data.
This is the generated XML if I run data.php alone:
<graph caption="Share prijs" xAxisName="Datum" yAxisName="Prijs" showNames="1" decimalPrecision="2" yAxisMinValue="8" yAxisMaxValue="14" decimalSeparator=",">
<set name="05-11-2008" value="10,23" />
<set name="05-12-2008" value="9,30" />
<set name="05-01-2009" value="9,80" />
<set name="05-02-2009" value="9,21" />
<set name="06-07-2009" value="9,46" />
<set name="05-08-2009" value="10,35" />
<set name="07-09-2009" value="10,68" />
<set name="05-10-2009" value="10,74" />
<set name="05-11-2009" value="10,69" />
<set name="07-12-2009" value="10,98" />
<set name="05-01-2010" value="11,61" />
<set name="05-02-2010" value="11,12" />
<set name="05-03-2010" value="11,82" />
<set name="06-04-2010" value="12,48" />
<set name="06-05-2010" value="11,99" />
<set name="07-06-2010" value="11,80" />
<set name="05-07-2010" value="11,15" />
<set name="05-08-2010" value="11,84" />
</graph>
Can anyone tell me why it isn't showing as it's supposed to be.
deafault.php:
<?php
//We've included ../Includes/FusionCharts.php, which contains functions
//to help us easily embed the charts.
include("FusionCharts.php");
?>
<HTML>
<HEAD>
<TITLE> FusionCharts Free - dataURL and Database Example</TITLE>
<SCRIPT LANGUAGE="Javascript" SRC="FusionCharts.js"></SCRIPT>
</HEAD>
<BODY>
<?php
//In this example, we show how to connect FusionCharts to a database
//using dataURL method. In our previous example, we've used dataXML method
//where the XML is generated in the same page as chart. Here, the XML data
//for the chart would be generated in PieData.php.
//We've included ../Includes/FusionCharts.php, which contains functions
//to help us easily embed the charts.
include("FusionCharts.php");
?>
<HTML>
<HEAD>
<TITLE> FusionCharts Free - dataURL and Database Example</TITLE>
<SCRIPT LANGUAGE="Javascript" SRC="FusionCharts.js"></SCRIPT>
</HEAD>
<BODY>
<?php
//In this example, we show how to connect FusionCharts to a database
//using dataURL method. In our previous example, we've used dataXML method
//where the XML is generated in the same page as chart. Here, the XML data
//for the chart would be generated in PieData.php.
//For the sake of ease, we've used an an MySQL databases containing two
//tables.
//tables.
//the php script in piedata.php interacts with the database,
//converts the data into proper XML form and finally
//relays XML data document to the chart
$strDataURL = "data.php";
//converts the data into proper XML form and finally
//relays XML data document to the chart
$strDataURL = "data.php";
//Create the chart - Pie 3D Chart with dataURL as strDataURL
echo renderChart("FCF_Line.swf", $strDataURL, "", "test", 650, 450);
?>
</BODY>
</HTML>
echo renderChart("FCF_Line.swf", $strDataURL, "", "test", 650, 450);
?>
</BODY>
</HTML>
Thanks !
Back to top
MultiQuote
