How to generate graphs and charts from mysql database in php

php mysql graph charts
Wern Ancheta picture Wern Ancheta · Dec 4, 2010 · Viewed 207.1k times · Source

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

Answer

sushil bharwani picture sushil bharwani · Dec 4, 2010

You can use JPGraph and Graphpite

http://jpgraph.net/

http://graphpite.sourceforge.net/

Related questions

MySQL, PHP based website statistics

Trying to integrate something like tracewatch into admin panel of my PHP, MySQL based website. But I need 1 page solution, not heavy system like twatch with user management. I wonder, is there any simple php class or mini app for …

Read More
How can I prevent SQL injection in PHP?

If user input is inserted without modification into an SQL query, then the application becomes vulnerable to SQL injection, like in the following example: $unsafe_variable = $_POST['user_input']; mysql_query("INSERT INTO `table` (`column`) VALUES ('$unsafe_variable')"); That's …

Read More
Import file size limit in PHPMyAdmin

I have changed all the php.ini parameters I know: upload_max_filesize, post_max_size. Why am I still seeing 2MB? Im using Zend Server CE, on a Ubuntu VirtualBox over a Windows 7 host.

Read More