Viewing file: ExcelResearchYear.php (5.14 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
";
echo " กรุณาทำการ Login ก่อน ";
echo "";
exit();
}
else {
/** Configuration */
header('Content-type: application/xls');
header('Content-Disposition: attachment; filename="testing.xls"');
require_once( "../configuration.php" );
require_once( $_Config_absolute_path . "/includes/framework.php" );
require_once( "../includes/Function.php" );
/** Create Database Object */
$dbObj = new DBConn;
/** Config Table for This Page */
$myTable1 = "personal_tb";
$myTable2 = "research_tb";
$param = "&";
/** Query เพื่อหา Numrows ก่อน */
//$query = " SELECT * FROM $myTable2 GROUP BY Year_prop ";
//$result = $dbObj->execQuery($query);
//$numrows = $dbObj->_numrows
} # else
?>
ข้อมูลงานวิจัย
|
No. |
ปีการศึกษา |
จำนวนผลงานวิจัย |
จำนวนเงินทั้งหมด (บาท) |
fetchArray($result) ) {
$bgColor = ( $bgColor == "#FFFFFF" ) ? "#F9FBFB" : "#FFFFFF";
?>
=$no;?> |
=$rs["academic_year_finish"];?> |
execQuery($query2);
$countnum = $dbObj->_numrows;
$dbObj->freeresult($result2);
echo $countnum;
?> |
execQuery($query6);
$rs6 = $dbObj->fetchArray($result6);
$dbObj->freeresult($rs6);
echo "". number_format($rs6['Sum'],2,'.',',') ."";
?> |
(รวมทั้งหมด) execQuery($query6);
$rs6 = $dbObj->fetchArray($result6);
$dbObj->freeresult($rs6);
echo "". number_format($rs6['Sum'],2,'.',',') ."";
?> |
|
|
freeresult($result);
/** Close the Database */
$dbObj->disconn();
/** Unset Class */
unset($dbObj);
?> bool(false)
|