php charts

[Butters]

Does anyone use some form of php charts (pie, bar, line, etc) to show data from a database?

I've been having a look at PHP/SWF Charts and tbh its the crappest thing I've ever used. Somehow it cashes your data and wont update the chart unless you rename the file each and everytime.

I've looked at, and liked the style of amCharts, but it seems that it can't work directly with php and mysql, you have to export a csv or xml file, place that in a directory and then it will read it.

I need this to have no human interaction at all, other than, they choose to look at the data chart, it pulls the info from the mysql database and creates a bar chart or pie chart or whatever.

Any help is greatly appreciated.

 

[platty]

Have you looked into PEAR. Sure there's chart and graphs classes in there.

 

[paulsheff]

I've been having a look at PHP/SWF Charts and tbh its the crappest thing I've ever used. Somehow it cashes your data and wont update the chart unless you rename the file each and everytime.

Is it caching the data from php file? If so why not generate a random number and append it to the querystring everytime you call the page i.e.

datapage.php?rn=" + rn

I've looked at, and liked the style of amCharts, but it seems that it can't work directly with php and mysql, you have to export a csv or xml file, place that in a directory and then it will read it.

You could do a mod_rewrite on the htaccess file to hide a dynamic php file outputting a text/xml content header.

 

[Mark JB]

We use jpGraph and find it excellent to work with using both static and dynamic data.

jpgraph