<?php
 
/** *********************************************************************************************************************
 
 * This is main class of graph which can be generate a bar graph or line graph.
 
 * @author Shailesh Patel
 
 * @version  1.0
 
 * Date: 5th March.
 
 ** *********************************************************************************************************************
 
 */
 
include dirname(__FILE__) . "/class.linegraph.php";
 
 
$dbHost = 'localhost';
 
$dbUser = 'root';
 
$dbPass = '';
 
$dbName = 'graph';
 
 
mysql_connect($dbHost, $dbUser, $dbPass);
 
mysql_selectdb($dbName);
 
 
$graph = new LineGraph();
 
 
/** Data added for line graph pass value of findingsId
 
***/
 
$findingsId=$_REQUEST['fId'];
 
$query =mysql_query("SELECT id, val FROM graph_tbl ");
 
if(mysql_num_rows($query) > 0)
 
{
 
    while ($row=mysql_fetch_array($query)) {
 
        $data[$row['id']] = $row['val'];
 
    }
 
}
 
 
// below array used in design graph
 
$line['color']='#ff5500';
 
$line['background-color']='#ff8833';
 
$graphval['padding-left']=60;
 
$graphval['padding-top']=10;
 
$graphval['padding-right']=10;
 
$graphval['padding-bottom']=40;
 
$graphval['background-color']='#384C6A';
 
$graphval['background-transparent']='no';
 
$graphval['border-width']=0;
 
$graphval['area-height']=200;
 
$graphval['area-width']=300;
 
$graphval['title-color']='#fff';
 
$graphval['transparency']=50;
 
$axis['step-size']=0;
 
$axis['y-step-mode']='dynamic';
 
$axis['gridlines']='yes';
 
$axis['scale-color']='#fff';
 
$axis['border-color']='#7184A5';
 
$axis['background-color']='#56657F';
 
$axis['deepness']=1;
 
$scale['x-round']=0;
 
$scale['y-round']=1;
 
$axis['y-step']=5;
 
$graphArray['data'] = $data;
 
$graphArray['line'] = $line;
 
$graphArray['graph'] = $graphval;
 
$graphArray['axis'] = $axis;
 
$graphArray['scale'] = $scale;
 
 
$graph->__LoadGraphDefinitions($graphArray);
 
$graph->DrawGraph();
 
 
?>
 
 |