FusionCharts_Gen.php and mysqli

[stainedrug]

I recently started using Fusion Charts, Aside from the obvious of changing my FusionCharts_Gen.php to use mysqli, I was wondering If I have an old file or does FC not support mysqli or PDO yet?

Edited April 8, 2014 by stainedrug

[Guest Sashibhusan]

Hi,

 

Please note that the "FusionCharts_Gen.php" file provided by FusionCharts Suite XT is quite older file and is internally implementing the modules to build the XML string for the chart, as per the db query result.

 

So, if you are trying to implement mysqli or PDO, it might not give work properly.

 

So, we will suggest you to use the FusionCharts PHP wrapper "FusionCharts.php" to just output  the required JavaScript and XML/JSON for rendering the chart and implement mysqli or PDO of your own to fetch the data from DB and building required XML/JOSN string as per FusionCharts data format.

 

For details on the implementation of the FusionCharts.php wrapper, please visit the blog link: http://blog.fusioncharts.com/2012/03/javascript-charts-using-php-and-mysql-with-fusioncharts-xt-part-2/

 

Hope this helps!