|
|
|
Forum Newbie
Group: Forum Members
Last Login: 12/1/2007 11:20:45 AM
Posts: 3,
Visits: 10
|
|
Hey everyone!
Has anyone created a page where they're using AJAX to grab and display charts (using php with a mysql database delivering the data)?
I have an AJAX script setup and it replaces the chart area with the file called, however it fails at the rendering of the chart and I get "Chart." instead of the animated chart.
Any suggestions?
Thanks!
- Also it might be worth noting that the chart page(s) render properly on their own, it's only when called from AJAX.
|
|
|
|
|
Supreme Being
Group: Moderators
Last Login: Today @ 5:38:52 AM
Posts: 884,
Visits: 1,420
|
|
Hi,
If you are re rendering the chart or reloading another/same SWF using AJAX you better avoid using PHP renderChart() function. Because that would simply write the HTML DIV with 'Chart' text in it and javascript to render the chart inside that DIV. Since AJAX is used the javascript wont be eval'ed and hence you could only see 'Chart'. I would rather suggest you to use renderChartHTML() function. This will put only OBJECT/EMBED tags as HTML and not javascript to eval'ed. This wont show you the IE 'Click here to Activate..' message since AJAX uses JavaScript to put that HTML. This would solve your problem.
Regards,
Sudipto Choudhury
FusionCharts Team
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 12/1/2007 11:20:45 AM
Posts: 3,
Visits: 10
|
|
!!!
It was that easy!! I can't believe it!
Thank you, it's working perfectly now!
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 12/8/2007 3:55:14 PM
Posts: 1,
Visits: 5
|
|
Even though you've found a solution, another option would be to use the php wrapper class to create the raw XML data by creating a normal chart and using getXML() and pass that to a javascript function to render the chart...
I'm mainly doing things this way because i'm also passing other data to the javascript function via a single AJAX request to build a whole section of reports.
maybe thats not the best way i'm not really sure, but the phpClass wrapper doesn't seem to have the renderChartHTML() function in the class...but oh well the direct XML also works.
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 3/28/2008 11:00:05 AM
Posts: 5,
Visits: 16
|
|
Hi, i was wondering if it is possible not to use xml for your solution. For example, I'm populating arrays from a mysql database, and I'm generating a graph like this:
$FC = new FusionCharts("MSLine","600","300");
$FC->setSwfPath("FusionCharts/Charts/");
$strParam="caption=Sales by Product;numberPrefix=$;formatNumberScale=1;rotateValues=1;decimalPrecision=0";
$FC->setChartParams($strParam);
$FC->addChartDataFromArray($arrData, $arrCatNames);
echo "";
$FC->renderChart();
All of which i took from the documentation. As you can see, i use the $arrData variable which has all my data. Is there a way to continue doing with with the solution provided (using renderChartHTML() ), or do i have to convert my arrays to an xml string?
|
|
|
|