PHP Developers Network

A community of PHP developers offering assistance, advice, discussion, and friendship.
 
Loading
It is currently Thu Dec 18, 2014 8:29 pm

All times are UTC - 5 hours




Post new topic Reply to topic  [ 5 posts ] 
Author Message
 Post subject: Graph from Database
PostPosted: Sun Apr 29, 2012 1:52 am 
Offline
Forum Newbie

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


Top
 Profile  
 
 Post subject: Re: Graph from Database
PostPosted: Sun Apr 29, 2012 1:27 pm 
Offline
Site Administrator
User avatar

Joined: Wed Aug 25, 2004 7:54 pm
Posts: 12721
Location: New York, NY, US
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)


Top
 Profile  
 
 Post subject: Re: Graph from Database
PostPosted: Mon Apr 30, 2012 1:44 pm 
Offline
Forum Newbie

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


Top
 Profile  
 
 Post subject: Re: Graph from Database
PostPosted: Wed Jun 13, 2012 10:41 am 
Offline
Forum Contributor

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


Top
 Profile  
 
 Post subject: Re: Graph from Database
PostPosted: Wed Jun 13, 2012 3:51 pm 
Offline
Briney Mod
User avatar

Joined: Mon Jan 19, 2004 7:11 pm
Posts: 6434
Location: 53.01N x 112.48W
Live24x7 wrote:


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.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 5 posts ] 

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group