Graph from Database

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

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

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

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

[pickle]

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

The documentation is also viewable on the live website: http://wiki.pchart.net