Viewing file:  DetailFormProject.php (16.63 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" );
require_once( "../include/FunctionDB.php" );
/** Create Database Object */
$dbObj = new DBConn;
//=== SESSION
$Username = $valid_user;
/** Config Table for This Page */
$myTable1 = "personal_tb";
$myTable2 = "formproject";
$myTable3 = "project_tb";
/** Table --> personal_tb */
$query = " SELECT *, prefixName as First_name FROM personal_tb LEFT JOIN prefix ON personal_tb.First_name = prefix.prefixId WHERE Teacher_code='$Teacher_code' ";
$result = $dbObj->execQuery($query);
$rss = $dbObj->fetchArray($result);
$Teacher_code = $rss['Teacher_code'];
/** Table --> tech_plan_tb */
$query1 = " SELECT * FROM $myTable2 WHERE proId='$proId' ";
$result1 = $dbObj->execQuery($query1);
$rs1 = $dbObj->fetchArray($result1);
/** Table --> techplan_method_tb */
//$query2 = " SELECT * FROM $myTable3 WHERE proId='$proId' ";
// $result2 = $dbObj->execQuery($query2);
// $rs2 = $dbObj->fetchArray($result2);
$query = " SELECT * , formproject.Budget_use as formproject_Budget_use , project_type_tb.Budget_total as project_type_tb_Budget_total FROM formproject , project_tb , project_type_tb , money_source_tb WHERE formproject.proId = '".$_REQUEST['proId']."' and formproject.proId = project_tb.proId and formproject.ProjectId = project_type_tb.ProjectId and project_tb.MoneyS_C = money_source_tb.MoneyS_C ";
$result3 = $dbObj->execQuery($query);
$rs3 = $dbObj->fetchArray($result3);
} # else
?>
บันทึกการขอไปราชการ
bool(false)
|
