How To Filter Chart Before Render

[foonmod]

Hi ,

I'm new with php and fusioncharts.

I follow step by step and can able render charts as well.

But, I wonder how to make a filter before render a chart to page . I mean make an option for choose parameter and send to php and query data from database

then plot graph out.

 

my query as below , I need to call data by month.

 

$strQuery = "select date_format(keepdate,'%d') as keepday ,keepvalue from keeprecord

where keeplocid = 5

and DATE_FORMAT(keepdate,'%M') = 'March'

order by keepdate ";

 

I'd like to make as file attached.

 

Thank you

 

Nont

Edited April 25, 2012 by foonmod

[Guest Sashibhusan]

Hi,

 

With regards to your query, you can make a drop down for the dates and make the filter of your data to represent them in FusionCharts using PHP. So you only need to query the database accordingly.

 

As it seems to be an issue with your PHP code, so I am afraid, we would not be able to provide extensive support on the same.

 

In case you have any queries related to FusionCharts, please feel free to ask.