How to generate graphs and charts from mysql datab

2019-01-31 03:55发布

问题:

How can I generate graphs and charts from a mysql database using php?

I'm trying to use "chart director" but I can't even install it properly, because I'm using php version 5.3, and it's using a deprecated function dl.

Do you know of any alternatives that:

  • fully support php 5.3
  • are easy to use for beginners
  • can access the mysql database and chart its data

回答1:

You can use JPGraph and Graphpite

http://jpgraph.net/

http://graphpite.sourceforge.net/



回答2:

I use highcharts. They are very interactive (and very fancy I might add). You do have to get a little creative to access data from MySQL database, but if you have a general understanding of JavaScript and PHP, you should have no problems.



回答3:

I use Google Chart Tools https://developers.google.com/chart/ It's well documented and the charts look great. Being javascript, you can feed it json data via ajax.



回答4:

http://pchart.sourceforge.net/ looks very good and it's free.