Viewing file: ExcelDevPlanPerson.php (5.03 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
";
echo " กรุณาทำการ Login ก่อน ";
echo "";
exit();
}
else {
/** Configuration */
require_once( "../configuration.php" );
require_once( $_Config_absolute_path . "/includes/framework.php" );
require_once( "../include/Function.php" );
/** Create Database Object */
$dbObj = new DBConn;
//=== SESSION
$Username = $valid_user;
/** Config Table for This Page */
$myTable = "formproject";
$myTablePK = "Teacher_code";
$query = " SELECT * FROM $myTable WHERE Year_std='$Year_std' Group By Teacher_code ";
$result = $dbObj->execQuery($query);
//$rs = $dbObj->fetchArray($result);
} # else
?>
แผนการดำเนินงาน : รายงานประเภทต่างๆ - ประวัติการขอไปราชการ
No |
รหัส |
ชื่อ-นามสกุล |
จำนวนรายการ |
จำนวนเงิน (บาท) |
fetchArray($result) ) {
$bgColor = ( $bgColor == "#FFFFFF" ) ? "#F9FBFB" : "#FFFFFF";
$Teacher_code = $rs['Teacher_code'];
$sql1 = " SELECT * FROM personal_tb WHERE Teacher_code='$Teacher_code' ";
$result1 = $dbObj->execQuery($sql1);
$rs1 = $dbObj->fetchArray($result1);
?>
=$no;?> |
=$rs1['Teacher_id'];?> |
=$rs1['First_name'];?>
=$rs1['Teacher_name'];?>
=$rs1['Teacher_lastname'];?> |
execQuery($sql2);
$numrows2 = $dbObj->_numrows;
echo $numrows2;
?> |
execQuery($sql3);
$rs3 = $dbObj->fetchArray($result3);
echo number_format($rs3['SumB1'],2,'.',',');
?> |
freeresult($result3);
$dbObj->freeresult($result2);
$dbObj->freeresult($result1);
?>
|
|
รวมเงิน |
execQuery($sql4);
$rs4 = $dbObj->fetchArray($result4);
$dbObj->freeresult($result4);
echo number_format($rs4['SumB2'],2,'.',',');
?>
|
freeresult($result1);
/** Close the Database */
$dbObj->disconn();
/** Unset Class */
unset($dbObj);
?> bool(false)
|