Bar Graph from MySql 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.

Ashley_Sheridan

There are countless ways of doing this, but it depends really what you're looking for specifically. Are you wanting graphs created on the server or on the client? Do they need to be interactive, or will a static image suffice? What format is required? Will they be grouped into one document or delivered as individual graphs in a report/web page?

jamhussain

Dear, Actually, i m trying to make a web application

In which
client upload the csv file into database.
csv file has
country name, birth rate, and year as columns.
After creation of database, we have to analyse it in the form of Graphs.
please guide me. thanks.

Ashley_Sheridan

As I asked before:

Ashley Sheridan;11003087 wrote:
it depends really what you're looking for specifically. Are you wanting graphs created on the server or on the client? Do they need to be interactive, or will a static image suffice? What format is required? Will they be grouped into one document or delivered as individual graphs in a report/web page?

jamhussain

it is simple application that will run on localhost.
it is student project

Ashley_Sheridan

Can you answer any of these questions though?:

Do they need to be interactive, or will a static image suffice?
Do you need the graphs for a web page or embedding in a document, such as a PDF?
Will there be one graph shown at a time, or multiple in one page/document
Do they need to be created on the server or in the browser?

Like I said before, there are many, many options, but you need to be a bit more specific about what it is exactly that you want and need?

jamhussain

Dear,it is acceptable
if it is interactive, or a static image

it is Graph for a Web page.
There will be one Graph shown at a time.
it will be created on the server and and brower will show required data in the form of graph.
thanks.

Ashley_Sheridan

OK, well you have quite a few different options. You could use something like RGraph which is a Javascript canvas-based graph library. The only disadvantage is that older versions of IE can't display HTML5 canvas elements.

You could create them as images yourself with GD. In the main, it's just a case of arranging your data and drawing some lines or boxes, the math for that is pretty simple (just think how you would do it if you were drawing it out on paper and you won't go wrong). You could also "draw" graphs using <div> tags and a lot of CSS, which would allow you to create all kinds of interactive tooltips, etc.

Then there are libraries like Pear Graph which create those graph images for you. The package isn't maintained, but generally there's not too much that would need updating in such a library in terms of maintenance.