Using fusion charts from php

[maximnl]

Good day
Fusioncharts are a part of SC, great, however,
how to call them from php directly? the examples on fusionchart start from

include("includes/fusioncharts.php");

has anyone used them from PHP code (initiating, configuring etc)?

[ctmservice]

Hi Maxim,

Is this something you can do with:

Sales map with the FusionCharts library

[maximnl]

thanx, that is something!
however, there is code at step 6 : ```
sc_include_lib (“fusioncharts”);

this was exactly my point, there is no single word about this library, where does it come from? if i just test this include in PHP, it gives some error, and the page is not loading.

[Vincenzo]

Look here it’a a sample that include fusionchart to show a gantt chart.

GANTT chart & Job possiblity

sample_gantt.txt (30.5 KB) Here the sample… The sample render two gantt, using two json data structure in JavaScript. The first gantt rendered use a js data structured filled with variables filled with data read from a DB, the functions return php array then translated in json data for javascript. If something is not clear just ask. bye

[maximnl]

thanks man,
so it is added as a javascript lib sc_include_lib(“fusioncharts”);

can we actually use fusioncharts in PHP mode directly? there should be fusioncharts php library somewhere.

[Vincenzo]

I haven’t found the PHP version of that library, maybe Netmake can only distribute the js version.

[maximnl]

indeed, there is no php lib, it is just a wrapper on fusioncharts site.

[maximnl]

Hi Vincenzo,
i noticed you use some custom PHP functions to convert indexed array to json.
could you share your best practice , how to do it in efficient way?

[Vincenzo]

Very easy, I just wrote a function that read from database tasks, filling an associative array in PHP, with all data the graph needs, and then with

var fasidate = <?php echo json_encode( $tasks , JSON_PRETTY_PRINT | JSON_UNESCAPED_SLASHES) ?>;

convert the php array in a json output that is good for javascript.