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($sql) or 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