Viewing file:  student_stat_graph.php (2.1 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
include("../includes/FunctionDB.php");
include ("jpgraph/src/jpgraph.php");
include ("jpgraph/src/jpgraph_bar.php");
ConnectDB();
$sql = "SELECT * FROM StudentMaster Where studentStatus='1' GROUP By admitAcadYear ";
$result = mysql_query($sql) ;
$row = mysql_num_rows($result);
$num = mysql_num_rows($result );
while($rs = mysql_fetch_array($result)){
$admitAcadYear = $rs["admitAcadYear"];
$sql1= "Select * From StudentMaster Where studentStatus='1' and admitAcadYear='$admitAcadYear' and studentSex ='M' ";
$result1 = mysql_query($sql1);
$countnum1 = mysql_num_rows($result1);
$data1y[] = $countnum1;
$sql2= "Select * From StudentMaster Where studentStatus='1' and admitAcadYear='$admitAcadYear' and studentSex ='F' ";
$result2 = mysql_query($sql2);
$countnum2 = mysql_num_rows($result2);
$data2y[] = $countnum2;
$xLabels[] = $admitAcadYear;
}
// Create the graph. These two calls are always required
$graph = new Graph(650,400,"auto");
$graph->SetScale("textlin");
$graph->SetShadow();
$graph->img->SetMargin(40,120,20,40);
// Create the bar plots
$b1plot = new BarPlot($data1y);
$b1plot->SetFillColor("orange");
$b1plot->SetLegend("Male");
$b1plot->value->Show();
$b2plot = new BarPlot($data2y);
$b2plot->SetFillColor("blue");
$b2plot->SetLegend("Female");
$b2plot->value->Show();
// Specify X-labels
$graph->xaxis->SetTickLabels($xLabels);
// Create the grouped bar plot
$gbplot = new GroupBarPlot(array($b1plot,$b2plot));
// ...and add it to the graPH
$graph->Add($gbplot);
$graph->title->Set("กราฟแสดงจำนวนนักศึกษาจำแนกตามปีการศึกษา");
//$graph->xaxis->title->Set("X-title");
$graph->yaxis->title->Set("จำนวน(คน)");
$graph->xaxis->SetFont(FF_TAHOMA,FS_NORMAL);
$graph->title->SetFont(FF_COURIER,FS_BOLD);
$graph->yaxis->title->SetFont(FF_COURIER,FS_BOLD);
$graph->xaxis->title->SetFont(FF_FONT1,FS_BOLD);
// Display the graph
$graph->Stroke("student_stat_graph.png");
echo "<img src='student_stat_graph.png' border=0/>";
?>
|