How to generate graphs and charts from mysql database in php

Question

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

Solution 1

You can use JPGraph and Graphpite

http://jpgraph.net/

http://graphpite.sourceforge.net/

Solution 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.

Solution 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.

Solution 4

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

View more solutions