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

You can use http://sg2.php.net/manual/en/function.extension-loaded.php instead of dl — Andreas Wong, Dec 04 '10 at 08:15
Just with simple SQL query. Here you go: http://code.openark.org/blog/mysql/sql-pie-chart — Your Common Sense, Dec 04 '10 at 08:21
java command line tool showing how to create pie chart of mysql data http://www.sqldashboards.com/b/sql-pie-chart-mysql/. Call the command from php. — Ryan Hamilton, Nov 20 '16 at 12:34
I quickly assembled a simple this tool https://github.com/harish2704/sql-chart — harish2704, Sep 30 '18 at 18:53

score 14 · Accepted Answer · answered Dec 04 '10 at 08:16

14

You can use JPGraph and Graphpite

http://jpgraph.net/

http://graphpite.sourceforge.net/

answered Dec 04 '10 at 08:16

sushil bharwani

29,685
30
94
128

do you have a copy of the jpgraph?I cannot download it from their site, every browser that I have used is unable to download jpgraph, its unable to determine the download site – Wern Ancheta Dec 04 '10 at 08:20
1

A very good example with php code using mysql database can be found here: http://www.css-resources.com/Make-Line-Chart-from-MySQL-Table-Data.html – Dexter Sep 30 '14 at 18:59
Try [www.chartphp.com](http://chartphp.com) – Azghanvi Feb 12 '16 at 06:53

score 14 · Answer 2 · answered Jan 11 '12 at 14:50

14

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.

answered Jan 11 '12 at 14:50

Brett

721
2
10
20

Hi @Brett, could you explain a little about what you mean by having to get creative to get the Data from the MySQL database? I'm in the situation where I need to draw graphs to a website from a database and highcharts looks great, I'm not very proficient at JS however. – Gideon Sep 18 '12 at 21:50

belteshazzar · Answer 3 · 2014-08-25T13:48:48.400

10

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.

edited Aug 25 '14 at 13:48

answered Apr 18 '13 at 08:30

belteshazzar

2,163
2
21
30

This google chart is very good, and very easy to use. – Vignesh Chinnaiyan Sep 02 '16 at 12:34

score 3 · Answer 4 · answered Dec 11 '12 at 19:08

3

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

answered Dec 11 '12 at 19:08

dsomnus

1,391
14
21

Version 2 is located at http://www.pchart.net/ – evilspoons Feb 14 '13 at 15:42

How to generate graphs and charts from mysql database in php

4 Answers4

Linked