PHP Graphing LibraryPHPGraphLib

Lightweight PHP Graphing Library

Documentation Table of Contents - PHPGraphLib
Tutorial #2: MYSQL and PHPGraphLib

Bullet Overview

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

BulletInclude 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.

Bullet 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.

Bullet 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.

Here is the graph you just created:

Example PHP Generated Graph #2

BulletFor other examples, view the Examples page