Viewing file: EditOutreac.php (7.44 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( "../includes/Function.php" );
require_once( "../includes/FunctionDB.php" );
/** Create Database Object */
$dbObj = new DBConn;
//=== SESSION
$Username = $valid_user;
/** Config Table for This Page */
$myTable = "edu_service_tb";
$myTableFK = "Project_code";
/** Receive values */
//$Path = $_Config_live_site."/personal_pic";
/** Receive values */
$Project_name = htmlspecialchars(trim($_POST[Project_name]));
$M21 = htmlspecialchars(trim($_POST[M21]));
$M22 = htmlspecialchars(trim($_POST[M22]));
$M23 = htmlspecialchars(trim($_POST[M23]));
$M24 = htmlspecialchars(trim($_POST[M24]));
$M3 = htmlspecialchars(trim($_POST[M3]));
$M3_Detail = htmlspecialchars(trim($_POST[M3_Detail]));
$M4 = htmlspecialchars(trim($_POST[M4]));
$M5 = htmlspecialchars(trim($_POST[M5]));
$Budget_Year = htmlspecialchars(trim($_POST[Budget_Year]));
$AcademicYear = htmlspecialchars(trim($_POST[AcademicYear]));
//$Date_start = $_POST['mYear']."-".$_POST['mMonth']."-".$_POST['mDate'];
//$Date_finish = $_POST['mYear1']."-".$_POST['mMonth1']."-".$_POST['mDate1'];
$Date_in = $_POST['mYear2']."-".$_POST['mMonth2']."-".$_POST['mDate2'];
$Date_out = $_POST['mYear3']."-".$_POST['mMonth3']."-".$_POST['mDate3'];
$Faculty_code = htmlspecialchars(trim($_POST[Faculty_code]));
$M7 = htmlspecialchars(trim($_POST[M7]));
$Location = htmlspecialchars(trim($_POST[Location]));
$M8 = htmlspecialchars(trim($_POST[M8]));
$M8_Detail = htmlspecialchars(trim($_POST[M8_Detail]));
$M9 = htmlspecialchars(trim($_POST[M9]));
$Budget_fee = htmlspecialchars(trim($_POST[Budget_fee]));
$M101 = htmlspecialchars(trim($_POST[M101]));
$M101_Detail = htmlspecialchars(trim($_POST[M101_Detail]));
$M102 = htmlspecialchars(trim($_POST[M102]));
$Target_group = htmlspecialchars(trim($_POST[Target_group]));
$M103 = htmlspecialchars(trim($_POST[M103]));
$Budget = htmlspecialchars(trim($_POST[Budget]));
$M104 = htmlspecialchars(trim($_POST[M104]));
$M1041 = htmlspecialchars(trim($_POST[M1041]));
$M1041_Detail = htmlspecialchars(trim($_POST[M1041_Detail]));
$M106 = htmlspecialchars(trim($_POST[M106]));
$Cradit = htmlspecialchars(trim($_POST[Cradit]));
$Budget_colleg = htmlspecialchars(trim($_POST[Budget_colleg]));
$M107 = htmlspecialchars(trim($_POST[M107]));
$LecturerIn = htmlspecialchars(trim($_POST[LecturerIn]));
$HoursIn = htmlspecialchars(trim($_POST[HoursIn]));
$M108 = htmlspecialchars(trim($_POST[M108]));
$LecturerOut = htmlspecialchars(trim($_POST[LecturerOut]));
$HoursOut = htmlspecialchars(trim($_POST[HoursOut]));
$Filetex1 = htmlspecialchars(trim($_POST[Filetex1]));
$Filetex2 = htmlspecialchars(trim($_POST[Filetex2]));
//*------------*//
$Path = "../Plan_pic";
//### Upload Text File -----*//
if( $_FILES['Filetex1']['name'] != "" ) {
$Filetex1 = date('YmdHis').strrchr($_FILES['Filetex1']['name'], ".");
@copy( $_FILES['Filetex1']['tmp_name'] , $PlanPicPath.$Filetex1);
@unlink( $_FILES['Filetex1']['tmp_name'] );
}
//*------------*//
$Path = "../Plan_pic";
//### Upload Text File -----*//
if( $_FILES['Filetex2']['name'] != "" ) {
$Filetex2 = date('YmdHis').strrchr($_FILES['Filetex2']['name'], ".");
@copy( $_FILES['Filetex2']['tmp_name'] , $PlanPicPath.$Filetex2);
@unlink( $_FILES['Filetex2']['tmp_name'] );
}
$query = " UPDATE edu_service_tb SET Orderlist='$Orderlist' , Project_name='$Project_name', M21='$M21', M22='$M22' ,M23='$M23' ,M24='$M24' , M31='$M31', M32='$M32', M33='$M33', M34='$M34', M35='$M35', M36='$M36', M37='$M37', M35_Detail='$M35_Detail' , M4='$M4', M5='$M5', proId='$proId', Budget_Year='$Budget_Year', AcademicYear='$AcademicYear', Date_start='$Date_start' , Date_finish='$Date_finish' , Date_in='$Date_in' , Date_out='$Date_out' , Faculty_code='$Faculty_code' , M7='$M7' , Location='$Location' , LocationOut ='$LocationOut' , M8='$M8' , M8_Detail ='$M8_Detail' , M9='$M9' , Budget_fee='$Budget_fee' , M101='$M101' , M101_Detail='$M101_Detail' , M102='$M102', Target_group='$Target_group', M103='$M103', Budget='$Budget', M104='$M104', M1041='$M1041', M1041_Detail='$M1041_Detail' , M105='$M105', M106='$M106' , Cradit='$Cradit' , Budget_colleg='$Budget_colleg' , M107='$M107', LecturerIn='$LecturerIn' , HoursIn='$HoursIn' , M108='$M108' , LecturerOut='$LecturerOut' , HoursOut='$HoursOut' , M11='$M11' , M11_Detail='$M11_Detail', M12_Detail='$M12_Detail', Filetex1='$Filetex1' , Filetex2='$Filetex2' WHERE outreacId ='$outreacId' " ;
$result = $dbObj->runQuery($query);
$dbObj->freeresult($result);
} # else
?>
ข้อมูลทั่วไปบุคลากร - ข้อมูลงานวิจัย - เพิ่มประวัติผลงานวิจัย
freeresult($result0);
/** Close the Database */
$dbObj->disconn();
/** Unset Class */
unset($dbObj);
?> |