siric Report post Posted June 8, 2012 Hi, I am trying to get a real-time angular gauge with data from a mysql table. I am trying to use the dataStreamURL but my question is how do I get the returned data into the dial value? Gauge.html <div class="gen-chart-render"> <div id="chartContainer">FusionWidgets will load here</div> <script type="text/javascript"><!-- var myChart = new FusionCharts( "../../Charts/AngularGauge.swf", "myChartId", "400", "200", "0", "1" ); myChart.setXMLData('<chart lowerLimit="0" upperLimit="100" lowerLimitDisplay="Good" upperLimitDisplay="Bad" numberSuffix="%" showValue="1" dataStreamURL="getutil.php" refreshInterval="3">\n\ <colorRange>\n\ <color minValue="0" maxValue="50" code="8BBA00"/>\n\ <color minValue="50" maxValue="80" code="F6BD0F"/>\n\ <color minValue="80" maxValue="100" code="FF654F"/>\n\ </colorRange>\n\ <dials>\n\ <dial value="0" />\n\ </dials>\n\ </chart>'); myChart.render("chartContainer"); // --> </script> </div> getutil.php $username = "xxx"; $password = "yyy"; $db = "fusionchartsdb"; $hostname = "localhost"; // make connection to database mysql_connect($hostname, $username, $password) or die("Unable to connect to host $hostname"); mysql_select_db($db) or die("Unable to select database $db"); $portid='1'; $strSQL = "SELECT util from utilisation WHERE portid = '$portid'"; $result=mysql_query($strSQL) or die(mysql_error()); $util = mysql_result($result,0,"util"); print $util; I have checked the getutl by itself and it is working fine. Thanks Share this post Link to post Share on other sites
siric Report post Posted June 8, 2012 Ok, I think I got it.. I changed the print statement to print "value=".$util; Thanks Share this post Link to post Share on other sites
ror Report post Posted June 11, 2012 (edited) Hi Siric , i need Your help I just add your code to implment the angular gauge , but it seems that it does not support SetXMLData function or there is a syntax error on the below , please help am new in using this tool myChart.setXMLData('<chart lowerLimit="0" upperLimit="100" lowerLimitDisplay="Good" upperLimitDisplay="Bad" numberSuffix="%" showValue="1" dataStreamURL="getutil.php" refreshInterval="3">\n\ <colorRange>\n\ <color minValue="0" maxValue="50" code="8BBA00"/>\n\ <color minValue="50" maxValue="80" code="F6BD0F"/>\n\ <color minValue="80" maxValue="100" code="FF654F"/>\n\ </colorRange>\n\ <dials>\n\ <dial value="0" />\n\ </dials>\n\ </chart>'); Edited June 11, 2012 by ror Share this post Link to post Share on other sites
Guest Sashibhusan Report post Posted June 11, 2012 Hi, Could you please paste your complete code of rendering the chart as well as the Data provider page (getutil.php) code, to better look into this issue? Also please confirm once that you have provided the correct relative URL of the chart SWF file and data provider page. Awaiting your response! Share this post Link to post Share on other sites