Graph from Database

Need help with Photoshop, the GIMP, Illustrator, or others? Want to show off your work? Looking for advice on your newest Flash stuff?

Moderator: General Moderators

Post Reply
jamhussain
Forum Newbie
Posts: 17
Joined: Sat Apr 07, 2012 2:04 am

Graph from Database

Post 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.
User avatar
Christopher
Site Administrator
Posts: 13595
Joined: Wed Aug 25, 2004 7:54 pm
Location: New York, NY, US

Re: Graph from Database

Post 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.
(#10850)
jamhussain
Forum Newbie
Posts: 17
Joined: Sat Apr 07, 2012 2:04 am

Re: Graph from Database

Post 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.
Live24x7
Forum Contributor
Posts: 194
Joined: Sat Nov 19, 2011 9:32 am

Re: Graph from Database

Post 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.
User avatar
pickle
Briney Mod
Posts: 6445
Joined: Mon Jan 19, 2004 6:11 pm
Location: 53.01N x 112.48W
Contact:

Re: Graph from Database

Post 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
Real programmers don't comment their code. If it was hard to write, it should be hard to understand.
Post Reply