Trying to insert a chart of data into a website. Help please!

[Al Neri]

OK I have a MySQL backend and I am using php to display this data.

There are several sets - for the y axis - some are 0>x>1 - some are 0>x>100 - some are 0>x>1000 - the x axis could range from 1-30 - so the axes would change depending on what the max and min of the data is.

I have the data loaded up into two arrays

$x and $y

is there some library where I could just write :

callchart $x, $y

or like callchart $x, $y, upperX,lowerX,upperY,lowerY

and it display something that would look like the chart on this excel sheet screenshot: http://www.shopforeveryone.com/graph.jpg

doesn't matter what language it is in...


Thanks in Advance!

Don R.

 

[Markbnj]

There are _tons_ of solutions to this problem, from complete reporting packages that integrate directly with the data back-end, to preprocessing libs that consume XML.

Here's one that takes XML and renders flash charts, that is free and seems pretty popular:

http://www.maani.us/xml_charts/

You could select the data you want out of MySQL and write it as XML, then pass it to this lib.

Here's one that is commercial and uses php to create reports on a MySQL back-end:

http://www.hkvstore.com/phpreportmaker/features.asp

There's really a lot of options. But probably none of them are quite as simple as a library call. You're goign to need some set-up and integration at least.

 

[Al Neri]

where can I find more?

 

[Crusty]

Im sure GD and ImageMagick have some charting functionality, even if they don't it's not that hard to write a method that generates charts via images using those libraries. In fact, I'm sure there are tons of samples on the net about it already. I'd start checking google first for some tips.

 

[troytime]

i'd share the one i use (i wrote it), but there's no documentation and i don't know if i'm ready to 'support it'

 

[Drakkon]

http://www.aditus.nu/jpgraph/ - probably the most flexible of the PHP GD graphing projects - I use it all the time to create graphs from mySQL data.