Program to graph MySQL data

I have a fairly simple mysql database. I want to extract data from it and display as a graph to analyze it. Nothing advance开发者_StackOverflow中文版d, just line diagrams and such. As a programmer I can always write some code for this myself. But does anybody know of a program that can load data (using sql queries?) and display it in various graphs?

Checkout DBPlot for Windows environment.

You can also have a look at Google Charts, if you want your graphs displayed in web pages.

Don't know what type of output you're looking for, but FusionCharts has helped me a lot... http://www.fusioncharts.com/free/

You can use GNUPLOT if you are in linux environment. I am currently using this for generating automated EOD reports which contains graphs. The graphs are drawn using the data fetched from mysql (Currently we are using in csv) But gnuplot is not as good as Fusion Chart in UI Perspective

I'd have to recommend JQplot if you want these graphs in web pages - it's non Flash (hooray!), uses JQUery (hooray!) and has some very, very cool features (hooray! - check out the examples page).

As per the docs page, you can just pass an array of values to it and it'll plot what you want, and generating an array is simple in server side languages such as PHP.

Hope this helps,

James

An extremely flexible library for graphs (images and applets) would be JFreeChart. On the other hand, if what you actually need it is a reporting engine, Jasperreports should be your first and final stop but you will have to do A LOT of reading before starting doing something with the latter and it won't be time lost for nothing.

Try Smart chart maker it is used to create many type of charts that can be fed from a MySQL database . supported chart types include line charts , pie charts, bar charts, and scattered charts.