This example demonstrates how to implement the applet so that the graph data
is acquired from a database. Here we set up the applet to acquire the configuration data from a text file and the graph data from
a server side process which in turn acquires the data from a database.
The Graphing Software provides several methods by which data can be acquired
from databases. For a full discussion on the various methods and Template Scripts please see the
The configuration data is acquired from the text file ../../../bar_graph/svbargraph/Examples/barprops.txt
(click here to view)
The SVbarDataScriptDB.php is designed to
retrieve product sales data from a MySQL database, from a table with the following structure,
|Table Name : SalesBar
Our PHP script will pick out the sales figures for three products ( ProductX,
ProductY and ProductZ) and return the data in the correct format for the graph.
The method is as follows,
- Set the output characteristics for the return data
- Establish the database connection
- Build the query statement and retrieve the database records
- Process the database records and return the Data
- All finished so close the database connection
The full script code is contained in the SVbarDataScriptDB.php
(Click here to view the code).
For a full explanation of and range of values for the above parameters please
see the Documentation - Configuration Options».
« back to Examples Index
« back to Getting Started