- buka file index.php lalu edit seperti dibawah ini.
include "connect-to-database.php";
//include "validation.php";
?>
<html><head>
<a href="../index2.php"><img src="../chart2_button.png" width="70" height="80" ></a>
<form>
<table>
<tr><td>
<script type="text/javascript" src="Charts/FusionCharts.js"></script>
<div id="chartContainers">FusionCharts will load here</div>
<script type="text/javascript"><!--
var myCharts = new FusionCharts( "Charts/Column3D2.swf","myChartId", "1300", "630");
myCharts.setXMLUrl( "get-data2.php" );
myCharts.render( "chartContainers" );
// -->
</script>
</td></tr>
</table>
</form>
</body>
</html>
- buka file get_data lalu edit seperti dibawah ini.
//Sanitizing the input
$Type = $_GET['type'];
$Year = intval($_GET['tgl']);
$Month = intval($_GET['StatusMhswID']);
$Day = intval($_GET['TahunID']);
//Months Names
//$MonthsNames = array('Aktif', 'Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec');
//Prepare variables according to type-of-chart
switch($Type)
{
default:
case 'monthly':
$Query = "SELECT tgl AS Value, COUNT(*) AS Total FROM `v_graph` WHERE tgl={$Year} GROUP BY Value";
$ResultArray = array_fill(0, 0, 0); // fill the Result array with 0 values for each month
$ChartHeading = 'Grafik Jurusan Mahasiswa ';
$XaxisName = 'Jurusan Mahasiswa';
break;
case 'daily':
$Query = "SELECT pelanggaran AS Value, count(*) AS Total FROM `v_graph` WHERE pelanggaran={$Month} AND tgl={$Year} GROUP BY Value";
$ResultArray = array_fill(0, 0, 0); // fill the Result array with 0 values for each day
$ChartHeading = 'Jumlah Mahasiswa Perjurusan';
$XaxisName = 'Jurusan';
break;
case 'hourly':
$Query = "SELECT TahunID AS Value, count(*) AS Total FROM `mhsw` WHERE StatusMhswID={$Month} AND TahunID={$Day} AND ProdiID={$Year} GROUP BY Value";
$ResultArray = array_fill(0, 0, 0); // fill the Result array with 0 values for each hour
$ChartHeading = 'User Baru Perjam: '.$Day.'/'.$MonthsNames[$Month].'/'.$Year;
$XaxisName = 'Tahun Akademik';
break;
}
//Connect to database
require 'connect-to-database.php';
//Query the database
$QueryResult = mysql_query($Query);
//Fetch results in the Result Array
while($Row = mysql_fetch_assoc($QueryResult))
$ResultArray[$Row['Value']]=$Row['Total'];
//Generate Chart XML: Head Part
$Output = '<chart caption="'.$ChartHeading.'" xAxisName="'.$XaxisName.'" yAxisName="Jumlah Mahasiswa" showNames="1" bgColor="E6E6E6,F0F0F0" bgAlpha="100,50" bgRatio="50,100" bgAngle="270" showBorder="1" borderColor="AAAAAA" baseFontSize="12">';
//Generate Chart XML: Main Body
switch($Type)
{
default:
case 'monthly':
foreach($ResultArray as $MonthNumber => $value) // MonthNumber is month number (1-12)
$Output .= '<set value="'.$value.'" name="'.$MonthNumber.'" link="newchart-xmlurl-get-data2.php?type=daily&TahunID='.$Year.'&ProdiID='.$MonthNumber.'"/>';
break;
case 'daily':
foreach($ResultArray as $DayNumber => $value) // DayNumber is day (1-31)
$Output .= '<set value="'.$value.'" name="'.$DayNumber.'" link="newchart-xmlurl-get-data2.php?type=hourly&TahunID='.$Year.'&ProdiID='.$Month.'&StatusMhswID='.$key.'"/>';
break;
case 'hourly':
foreach($ResultArray as $HourNumber => $value) // HourNumber is hour (0-23)
$Output .= '<set value="'.$value.'" name="'.$HourNumber.'" link="newchart-xmlurl-get-data2.php?type=hourly&TahunID='.$Year.'&ProdiID='.$Month.'&StatusMhswID='.$key.'"/>';
break;
}
//Generate Chart XML: Last Part
$Output .= '</chart>';
//Set the output header to XML
header('Content-type: text/xml');
//Send output
echo $Output;
?>
download file nya disini
Comments