Viewing file: EditUpProject.php (5.27 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;
$Faculty_code = trim( $_POST['Faculty_code'] );
$programId = trim( $_POST['programId'] );
$Orderlist_2 = htmlspecialchars( trim( $_POST['Orderlist_2'] ) );
$Project_plan = htmlspecialchars( trim( $_POST['Project_plan'] ) );
$Project_name = htmlspecialchars( trim( $_POST['Project_name'] ) );
$Project_rep = htmlspecialchars( trim( $_POST['Project_rep'] ) );
$Period = htmlspecialchars( trim( $_POST['Period'] ) );
$Period_1 = htmlspecialchars( trim( $_POST['Period_1'] ) );
$Teacher_code = trim( $_POST['Teacher_code'] );
$MoneyS_C = trim( $_POST['MoneyS_C'] );
$Budget_Year = trim( $_POST['Budget_Year'] );
$Date = dmyE2ymdT($_REQUEST["mDate"]); // วัน/เดือน/ปีที่เริ่ม
$sql = "SELECT * FROM formproject_edit_tb WHERE upId ='$upId' and Teacher_code='$Teacher_code' ";
$result = mysql_query($sql);
$num_rows = mysql_num_rows($result);
$rs = mysql_fetch_array($result);
if($num_rows){
if($_FILES['Filetex']['name'] != ""){
//ลบไฟล์เก่า
unlink($ResearchPicPath.$rs["Filetex"]);
//Upload ไฟล์เอกสารใหม่
$Filetex = date('YmdHis').strrchr($_FILES['Filetex']['name'], ".");
@copy( $_FILES['Filetex']['tmp_name'] , $ResearchPicPath.$Filetex );
@unlink( $_FILES['Filetex']['tmp_name'] );
/** ---------- */
$query = " UPDATE formproject_edit_tb SET ProjectId='$ProjectId' , Date='$Date' , Training_name='$Training_name', Orderlist='$Orderlist' , Project_plan='$Project_plan' , Budget='$Budget' , nameDetail='$nameDetail' , Month='$Month' , Budget_Year='$Budget_Year', Year_std='$Year_std' , Status1='$Status1', Status2='$Status2' , Status3='$Status3', Status4='$Status4' , Filetex='$Filetex' WHERE upId ='$upId' and Teacher_code='$Teacher_code' ";
}
else{
$query = " UPDATE formproject_edit_tb SET ProjectId='$ProjectId' , Date='$Date' , Training_name='$Training_name', Orderlist='$Orderlist' , Project_plan='$Project_plan' , Budget='$Budget' , nameDetail='$nameDetail' , Month='$Month' , Budget_Year='$Budget_Year', Year_std='$Year_std' , Status1='$Status1', Status2='$Status2' , Status3='$Status3', Status4='$Status4' WHERE upId ='$upId' and Teacher_code='$Teacher_code' ";
}
$result = $dbObj->runQuery($query);
$dbObj->freeresult($result);
}
} # else
?>
ข้อมูลแผนดำเนินงานและรายงาน : ข้อมูลแผนดำเนินการ รายปีงบประมาณ - แก้ไขข้อมูลแผน/โครงการรดำเนินงาน (ข้อย่อย)
freeresult($result);
/** Close the Database */
$dbObj->disconn();
/** Unset Class */
unset($dbObj);
?> |