Chart In Php/mysql

[jlscunha]

Hello,

 

I tried to see your basic examples at http://docs.fusionch...icExamples.html but I found too confusing for a noob like me.

 

What I want is a line chart where the x-axis was time format (HH: MM: SS).

 

In my database, I have two columns, the collumn of time/x-axis (measurement_time) and the column of y-axis (temperature)

 

$ strQuery = "SELECT * FROM temperature_table";

$ result = mysql_query ($ strQuery) or die (mysql_error ());

 

If it were possible, would like to zoom the graph and / or scrool.

 

I would be very grateful if someone could help me

 

regards,

Edited March 29, 2012 by jlscunha

[Guest Sashibhusan]

Hi,

 

Thank you for the post.

 

Please find the response to your queries inline, below:

 

I tried to see your basic examples at http://docs.fusionch...icExamples.html but I found too confusing for a noob like me.

>>This link of FusionCharts Documentation is using the "FusionCharts with PHP API" to render the charts. Before going to this you should have basic knowledge of FusionCharts using PHP.

 

For more information on "FusionCharts with PHP > Basic Example", please follow the link below:

http://docs.fusioncharts.com/charts/contents/?guide-for-web-developers/php/PHP_BasicExample.html

 

What I want is a line chart where the x-axis was time format (HH: MM: SS).

>>FusionCharts does not support time format for X-Axis labels as of now.

 

However you can pass the time (HH: MM: SS) as a string to the labels of the <set> element manually for each data plot.

 

Also if you have the time and temperature as two columns of the database, you can query these data and pass the value to generate the XMl file for the chart.

 

For more information on "Plotting from Database > Example", please follow the link below:

http://docs.fusioncharts.com/charts/contents/?guide-for-web-developers/php/PHP_DB.html

 

If it were possible, would like to zoom the graph and / or scrool.

>>Yes, you can use ZoomLine chart (Zooming feature available) or else use ScrollLine2D chart (Scrolling feature available) for your charts.

 

For more information on "ZoomLine Charts", please follow the link below:

http://docs.fusioncharts.com/charts/contents/?ChartSS/ZoomLine.html

 

For more information on "ScrollLine2D Chart", please follow the link below:

http://docs.fusioncharts.com/charts/contents/?ChartSS/ScrollLine2D.html

 

Hope this helps!