Adding Multi-axis not working in mysql/php mult idata chart

[safadig]

Adding the <axis> as strXML prevents the chart from Rendering. 

$strXML .="<axis title='item 2014' tickwidth='10' divlinedashed='1'>";
	$strXML .="<dataset seriesName='item 2014' >";
	 if ($result2) {
          while($ors1 = mysql_fetch_array($result2)) {
           $strXML .= "<set   value='".$ors1['item']."' />";
         }
     }
	 $strXML .= "</dataset>";
	 $strXML .="</axis>";
	 
	 $strXML .="<axis title='item 2015' tickwidth='10' divlinedashed='1'>";
	 $result3 = mysql_query($strQuery15) or die(mysql_error());
	 $strXML .="<dataset seriesName='item 2015'>";
	 if ($result3) {
         while($ors1 = mysql_fetch_array($result3)) {
          $strXML .= "<set   value='".$ors1['item']."' />";
         }
    }
	$strXML .= "</dataset>";
	$strXML .="</axis>";
	
	
	 $strXML .="<axis title='item 2016' numdivlines='10' tickwidth='10' divlinedashed='1'>";
	 $result4 = mysql_query($strQuery16) or die(mysql_error());
	 $strXML .="<dataset seriesName='item 2016'>";
	 if ($result4) {
         while($ors1 = mysql_fetch_array($result4)) {
          $strXML .= "<set   value='".$ors1['item']."' />";
         }
    }
	 
	  
	 	 
           mysql_close($link);
		   
		   
           $strXML .= "</dataset></axis>";

[Prerana]

Hello,

 

I have tried to create a sample as per your requirement ie. Multi-axis line chart in xml using mysql and it is working as expected from our end.

 

Kindly refer the link below for your implementation.

https://www.dropbox.com/s/n2t8njyfjr6rbdg/multiAxisLine.zip?dl=0

 

You can also refer our docs for creating charts in php using database . http://www.fusioncharts.com/dev/using-with-server-side-languages/php/creating-charts-with-data-from-a-database.html

 

Hope this helps,

Thanks

[safadig]

Thank you for the sample implementation...

 

Yes it works in "multiaxisline"

 

But unfortunately,  it did not work in "mssplinearea" or "msspline"   That would truly be desirable

[Prerana]

Hello,

Thanks for replying back.

 

As the xml structure of multi axis line chart and the msspline or mssplinearae chart are not same. 

So the previous code won't work in case of msspline or mssplinearae chart. 

 

I have tried to create a new sample as per the requirement ie. multi series spline chart in xml using database.

 

For any other multi series chart,please change the chart type in the sample.

 

Kindly refer the link below for the implementation.

https://www.dropbox.com/s/03p5foaltf4t7q0/multiAxis%2BmsSpline_Chart.zip?dl=0

 

Hope this  helps,

Thanks

[safadig]

Thanks again..

 

It would be great to have multiaxis functionality (i.e. add 'axis' as Child)  in msspline and mssplinearea,

[Prerana]

Hello,

 

It's not supported by FusionCharts.

 

Thanks

[safadig]

May be in a future update?

[Prerana]

Hello,

 

Thanks for replying back.

 

If feasible, we will include this.

 

Thanks,

Prerana Singh