จำนวนนักศึกษา จำแนกตามปีการศึกษา |
ปีการศึกษา |
ชาย |
หญิง |
จำนวนนักศึกษาทั้งหมด |
fetchArray($result) ) {
$bgColor = ( $bgColor == "#FFFFFF" ) ? "#F9FBFB" : "#FFFFFF";
$admitAcadYear = $rs['admitAcadYear'];
?>
![](../images/icons/linesub.gif) |
=$rs["admitAcadYear"];?> |
execQuery($sql1);
$countnum1 = $dbObj->_numrows;
$dbObj->freeresult($result1);
echo $countnum1;
?> |
execQuery($query2);
$countnum2 = $dbObj->_numrows;
$dbObj->freeresult($result2);
echo $countnum2;
?> |
execQuery($query3);
$countnum3 = $dbObj->_numrows;
$dbObj->freeresult($result3);
echo $countnum3;
?> |
สรุปจำนวนนักศึกษา |
execQuery($query4);
$countnum4 = $dbObj->_numrows;
$dbObj->freeresult($result4);
echo $countnum4;
?> |
execQuery($query5);
$countnum5 = $dbObj->_numrows;
$dbObj->freeresult($result5);
echo $countnum5;
?> |
execQuery($query6);
$countnum6 = $dbObj->_numrows;
$dbObj->freeresult($result6);
echo number_format( $countnum6 );
?> |
ทั้งหมด ปี |
";
// Fetch all factory records
$strQuery = " SELECT * FROM $myTable WHERE studentStatus='1' GROUP BY admitAcadYear ";
$result1 = mysql_query($strQuery);
//Iterate through each factory
if( $result1 ) {
while( $rs1 = mysql_fetch_array($result1) ) {
$admitAcadYear = $rs1['admitAcadYear'];
$strQuery2 = " SELECT * FROM $myTable WHERE studentStatus='1' AND admitAcadYear='$admitAcadYear' AND studentSex ='M' ";
$result2 = mysql_query($strQuery2);
$numAmt2 = mysql_num_rows($result2);
mysql_free_result($result2);
$strQuery3 = " SELECT * FROM $myTable WHERE studentStatus='1' AND admitAcadYear='$admitAcadYear' AND studentSex ='F' ";
$result3 = mysql_query($strQuery3);
$numAmt3 = mysql_num_rows($result3);
mysql_free_result($result3);
$strXML .= "";
$strXML .= "";
} # while
} # if
mysql_free_result($result1);
//Finally, close element
$strXML .= "";
//Create the chart - Pie 3D or Column3D Chart with data from strXML
echo renderChart("../charts/Column3D.swf", "", $strXML, "", 750, 375, false, false);
?> |
|