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

Graph from Database

Postby jamhussain » Sun Apr 29, 2012 1:52 am

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

Re: Graph from Database

Postby Christopher » Sun Apr 29, 2012 1:27 pm

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

Re: Graph from Database

Postby jamhussain » Mon Apr 30, 2012 1:44 pm

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

Re: Graph from Database

Postby Live24x7 » Wed Jun 13, 2012 10:41 am

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

Re: Graph from Database

Postby pickle » Wed Jun 13, 2012 3:51 pm

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


Return to Graphics

Who is online

Users browsing this forum: No registered users and 0 guests