Search the Community

Hello, I have been working with Fusion Charts for quite some time now and the product is great. I am now trying to create a Real Time Line Graph using Fusion Charts with the data to be fetched from MySQL. Following your documentation for the same, I have successfully implemented "Line Chart". However if change the chart type to "realtimeline", the chart does not load. It says "No data to display". The code: if ($resulthum) { // The `$arrData` array holds the chart attributes and data $arrDatahum = array( "chart" => array( "caption" => "Real-time stock price monitor", "subCaption" => "Harry's SuperMart", "xAxisName" => "Time", "yAxisName" => "Stock Price", "numberPrefix" => "$", "refreshinterval" => "5", "yaxisminvalue" => "35", "yaxismaxvalue" => "36", "numdisplaysets" => "10", "labeldisplay" => "rotate", "showValues" => "0", "showRealTimeValue" => "0", "theme" => "fint" ) ); $arrDatahum["data"] = array(); // Push the data into the array while($row = mysqli_fetch_array($resulthum)) { array_push($arrDatahum["data"], array( "label" => $row["timestamp"], "value" => $row["humidity"] ) ); } /*JSON Encode the data to retrieve the string containing the JSON representation of the data in the array. */ $jsonEncodedDatahum = json_encode($arrDatahum); /*Create an object for the column chart using the FusionCharts PHP class constructor. Syntax for the constructor is ` FusionCharts("type of chart", "unique chart id", width of the chart, height of the chart, "div id to render the chart", "data format", "data source")`. Because we are using JSON data to render the chart, the data format will be `json`. The variable `$jsonEncodeData` holds all the JSON data for the chart, and will be passed as the value for the data source parameter of the constructor.*/ $columnCharthum = new FusionCharts("realtimeline", "myFirstChart2" , 600, 330, "chart-2", "json", $jsonEncodedDatahum); // Render the chart $columnCharthum->render(); // Close the database connection $dbhandle->close(); If you could please identify the mistake I am making, it would be great. Waiting for a reply soon. Abhijit Nathwani

Hello, I am doing a project and for that I have to create a website in that I have to generate interactive graphs daily,weekly,monthly,yearly on it which pull their data from excel files(very long files i can not type them manually) from other website which get updated with time. Or I have another method, same self updating data is on a website in form of table which gets updated with time. So , is it possilble to pull data from there for specific parameters and generate live data graphs? Can you please help me in suggesting some ideas? How can I do it and if you are not clear with the situation then please let me know. Is this possible with javascript or I need something else. As I am a beginner , so do not know much. Thanks