Need Some Help Getting Data From Database Into Angular Guage

[siric]

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

[siric]

Ok,

 

I think I got it..

 

I changed the print statement to print "value=".$util;

 

 

 

Thanks

[Swarnam]

[ror]

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

[Guest Sashibhusan]

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!