PDA

View Full Version : Charts, Graphs & MI From MySQL


Corrosive
03-29-2009, 10:02 AM
Morning troops.

I am currently building a monster application using PHP and MySQL. The nuts and bolts are pretty much there (less some serious de-bugging which I have been putting off!!)

I know full well that the business will want pretty charts and graphs (Management Information) to look at and I would like to include some pre-built reports into the admin area. I.e. they push a button and the chart/graph generates and displays.

Has anyone used any programs or plug-ins that can do this or will I have to hand-code solutions? I'm thinking something along the lines of the 'Chart Wizard' you get with Excel and I would like it to fit seamlessly into my site.

Any guidance greatly appreciated as ever. :-D

davidj
03-29-2009, 11:51 AM
google chart API is the tool i use for such malarkey

http://code.google.com/apis/chart/

get your head round the simple query string and then use PHP to construct the charts as you like them

Its free too!

Corrosive
03-29-2009, 01:04 PM
google chart API is the tool i use for such malarkey

http://code.google.com/apis/chart/

get your head round the simple query string and then use PHP to construct the charts as you like them

Its free too!

Oh yes, I'd forgotten that you used that. I think that will do nicely. Cheers DJ.

davidj
03-29-2009, 03:14 PM
cant wait to see how you use them

Corrosive
03-29-2009, 03:32 PM
cant wait to see how you use them

He, he. Don't worry mate, you will!! :wink: