<?php
    include ("../jpgraph.php"); //Sesuaikam dengan folder Anda
    include ("../jpgraph_bar.php"); //Sesuaikam dengan folder Anda


    $dbid = mysql_connect('host_Anda', 'username_Anda', 'password_Anda');

     mysql_select_db('database_Anda',$dbid)

       or die ("Cannot find database");


    $sql = mysql_query("SELECT * FROM data_grafik LIMIT 0,6");
    while($row = mysql_fetch_array($sql))
    {
    $data1[] = $row[0];
    $data2[] = $row[1];
    $data3[] = $row[2];
    }

    // We need some data

    $b1plot = new BarPlot($data1);
    $b2plot = new BarPlot($data2);
    $b3plot = new BarPlot($data3);

    // Setup the graph.
    $graph = new Graph(500,350,"auto");
    $graph->SetScale("textlin",0,20);
    $graph->img->SetMargin(25,85,25,25);
    $graph->SetBackgroundImage("bg.jpg",BGIMG_FILLPLOT); //"bg.jpg" bisa Anda ganti dengan background Anda.
    $graph->title->Set('"GRAFIK PERBANDINGAN JUMLAH PENDAFTAR PER-HARI"');
    $graph->title->SetColor('darkred');
    $graph->title->SetFont(FF_ARIAL);
    $graph->legend->Pos( 0.02,0.5,"right" ,"center");


    // Setup font for axis
    $graph->xaxis->SetFont(FF_ARIAL);
    $graph->yaxis->SetFont(FF_ARIAL);

    // Create the bar pot

    $b1plot->SetWidth(0.8);
    $b1plot->SetLegend("2006");

    $b2plot->SetWidth(0.8);
    $b2plot->SetLegend("2007");

    $b3plot->SetWidth(0.8);
    $b3plot->SetLegend("2008");

    // Setup values
    $b1plot->value->Show();
    $b1plot->value->SetFormat('%d');
    $b1plot->value->SetFont(FF_TIMES);
    $b1plot->value->SetColor("navy");

    $b2plot->value->Show();
    $b2plot->value->SetFormat('%d');
    $b2plot->value->SetFont(FF_TIMES);
    $b2plot->value->SetColor("olivedrab");

    $b3plot->value->Show();
    $b3plot->value->SetFormat('%d');
    $b3plot->value->SetFont(FF_TIMES);
    $b3plot->value->SetColor("orangered");

    // Setup color for gradient fill style
    $b1plot->SetFillGradient("navy","lightsteelblue",GRAD_WIDE_MIDVER);
    $b2plot->SetFillGradient("olivedrab","olivedrab1",GRAD_WIDE_MIDVER);
    $b3plot->SetFillGradient("orangered","khaki",GRAD_WIDE_MIDVER);

    // Set color for the frame of each bar
    $b1plot->SetColor("navy");
    $b2plot->SetColor("olivedrab");
    $b3plot->SetColor("orangered");

    //create the grouped bar plot
    $gbplot = new GroupBarPlot (array($b1plot ,$b2plot ,$b3plot));

    $graph->Add($gbplot);

    // Finally send the graph to the browser
    $graph->Stroke();
    ?>