Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to generate graphs and charts from mysql database in php [closed]

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
like image 271
Wern Ancheta Avatar asked Dec 04 '10 08:12

Wern Ancheta


People also ask

Can you make graphs in MySQL?

Nope, a database is for storing and retrieving data efficiently and safely. Not for other purposes. Use any client application to retrieve the data the way you need it (from MySQL), and to graph it accordingly. Show activity on this post.

How can you retrieve data from the MySQL database using PHP?

Data can be fetched from MySQL tables by executing SQL SELECT statement through PHP function mysql_query. You have several options to fetch data from MySQL. The most frequently used option is to use function mysql_fetch_array(). This function returns row as an associative array, a numeric array, or both.


1 Answers

You can use JPGraph and Graphpite

http://jpgraph.net/

http://graphpite.sourceforge.net/

like image 87
sushil bharwani Avatar answered Oct 14 '22 15:10

sushil bharwani