dyncoder Report post Posted December 26, 2015 Hello is there an example with php pdo non-deprecated commands. I found the following but it is written with deprecated coding. http://www.fusioncharts.com/dev/using-with-server-side-languages/php/creating-charts-with-data-from-a-database.html mysql_fetch_array — Fetch a result row as an associative array, a numeric ... This extension was deprecated in PHP 5.5.0, and it was removed in PHP 7.0.0. Please let me know, thanks. Share this post Link to post Share on other sites
dyncoder Report post Posted December 27, 2015 (edited) I wanted to add, I can get the following array results: Array ( [0] => Array ( [id] => 6 [Name] => John Smith [Pet] => Dog [Visits] => 5 [DateTime] => 11/26 22:24 ) ) using $results = $stm->fetchAll(PDO::FETCH_ASSOC); but unsure how to convert it into the following form for fusion charts: [ { label: "CJ Anderson", value: "25" }, { label: "Imran Tahir", value: "25" }, ... ... ] Edited December 27, 2015 by dyncoder Share this post Link to post Share on other sites
dyncoder Report post Posted December 28, 2015 I did figure out how to get a 2dcolumn working. Please go here for details ==> http://stackoverflow.com/questions/34487605/php-pdo-convert-array-to-different-format#comment56718566_34487797 My suggestion I offer is to make the php wrapper use the native output from "json_encode" as it seems it needs to be modified in order to work. Thanks Share this post Link to post Share on other sites
Moonmi Sonowal Report post Posted December 29, 2015 Hi, Thanks for sharing your views we have logged an improvement on it and will keep you posted about any updates. Thanks. Share this post Link to post Share on other sites
Akash Biswas Report post Posted October 23, 2019 Hi, The current PHP wrapper uses the native json_encode output. You can download the version 3.14.1 trial library for the updated PHP wrapper : https://www.fusioncharts.com/download/fusioncharts-suite-xt?framework=js Thanks, Akash. Share this post Link to post Share on other sites