Page 1 of 1

Graph from Database

Posted: Sun Apr 29, 2012 1:52 am
by jamhussain
Salam,
Dear,I have database with 3 tables.
country, birth rate, and effecting factor.
I want to Make Bar Graph, Pie Chart , Line Graph.
from database.
I m uing Wamp server.
Can any body help me , How can i make Graphs by database values.
Please help me or provide link.
thanks.

Re: Graph from Database

Posted: Sun Apr 29, 2012 1:27 pm
by Christopher
There are several types of solutions:

- Create graphs as images on the server with image libararies such as GD.

- Create simple graphs in HTML using tables or divs. This is only good for bar charts.

- Create graphs using a Javascript or Flash library. With these you pass the data to the library and it generates the graph.

Re: Graph from Database

Posted: Mon Apr 30, 2012 1:44 pm
by jamhussain
Dear, it is simple student project. it will run on localhost.
we have a csv file.
we have to upload it in mysql databse.
and from this database, we have to prepare the Graphs that may be bar, pie chart, line graph.
please give us suggetion. how can we do all this.

Re: Graph from Database

Posted: Wed Jun 13, 2012 10:41 am
by Live24x7
the simplest solution would be to use a graph chart library for this.

I have recently used Pchart (www.pchart.net) which is perhaps the most widely used php library for creating graphs & charts.
The graph quality is good. The tutorials are good and if you have some experience in PHP rendering charts should be very easy.

Their documentation at:
http://wiki.pchart.net/documentation.pdf

covers all about using CSV or Mysql sources.

Re: Graph from Database

Posted: Wed Jun 13, 2012 3:51 pm
by pickle
Live24x7 wrote: Their documentation at:
http://wiki.pchart.net/documentation.pdf
The documentation is also viewable on the live website: http://wiki.pchart.net