Sunday, January 13, 2013

php mysql ghraph chart example

PHPGraphLib Tutorial #2: MYSQL and PHPGraphLib

Overview

 

In this example, we are going to show a simple example of how to use PHPGraphLib with MYSQL.

Include the source file in a new script and create the PHPGraphLib Object

Include the source PHPGraphLib class file at the top of your stand alone php script. This script will only include the PHP calls to create your graph. Next, create a PHPGraphLib object.





<?php
include("phpgraphlib.php");
$graph=new PHPGraphLib(550,350);

Add data from MYSQL

We are going to query our database, add that data to an array, and then pass that information to PHPGraphLib. The sales count will be used as y-axis values, and the sales group name will be used as the x -axis values. See http://www.php.net/mysql for more information on how to connect to your MYSQL server with PHP. You will need to change the system dependent variables, such as username, password, database, and table name when using this example.



$link = mysql_connect('localhost''username''password')
or die('Could not connect: ' . mysql_error());     
mysql_select_db('salestracking'or die('Could not select database');
$dataArray=array(); 
//get data from database
$sql="SELECT salesgroup, COUNT(*) AS 'count' FROM sales GROUP BY salesgroup";
$result = mysql_query($sqlor die('Query failed: ' . mysql_error());
if ($result) {
  while ($row = mysql_fetch_assoc($result)) {
      $salesgroup=$row["salesgroup"];
      $count=$row["count"];
      //add to data areray
      $dataArray[$salesgroup]=$count;
  }
}
//configure graph
$graph->addData($dataArray);
$graph->setTitle("Sales by Group");
$graph->setGradient("lime""green");
$graph->setBarOutlineColor("black");
$graph->createGraph();
?>

Include the created script as the src of an image on the desired page

On the page you want the graph to appear, create an HTML image tag and set the src="" to the location of the script you created above.


<html>
<h3>This is where I want to display my graph</h3>
<img src="mysql_graph_bar.php" />
</html>

Here is the graph you just created:
For other examples, view the Examples page

4 comments:

  1. Hi there. Very cool website!! Man .. Beautiful .. Wonderful .. I will bookmark your site and take the feeds also…I’m happy to locate a lot of useful information right here within the post. Thank you for sharing.
    Web development Company

    ReplyDelete
  2. Thanks for commenting and appreciation i always experiment new think if you have any new question you can ask by comment i always in here

    thanks
    Bikash ranajn

    ReplyDelete
  3. img src="mysql_graph_bar.php"

    This tag is not showing me the output.
    Please guide

    ReplyDelete
  4. Well somehow I got to read lots of articles on your blog. It’s amazing how interesting it is for me to visit you very often
    Web development Company in India Company | Web development Company Bangalore
    Web Development Company in Bangalore | Responsive Web development

    ReplyDelete