";
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( "../includes/FunctionDB.php" );
/** Create Database Object */
$dbObj = new DBConn;
//=== SESSION
$Username = $valid_user;
//### รับค่าจาก Form
$Category = htmlspecialchars(trim($_POST['Category']));
$Agency = htmlspecialchars(trim($_POST['Agency']));
$Name_info = htmlspecialchars(trim($_POST['Name_info']));
$DateYear = dmyE2ymdT($_REQUEST["mDate"]);
$Path = "../Research_pic";
//### Upload Text File -----*//
if( $_FILES['Filetex']['name'] != "" ) {
$Filetex = date('YmdHis').strrchr($_FILES['Filetex']['name'], ".");
@copy( $_FILES['Filetex']['tmp_name'] , $ResearchPicPath.$Filetex);
@unlink( $_FILES['Filetex']['tmp_name'] );
}
$sql = "SELECT * FROM research_download WHERE dowId ='$dowId' and Research_code='$Research_code' ";
$result1 = mysql_query($sql);
$num_rows = mysql_num_rows($result1);
if($num_rows){
if($Filetex){
$query1 = " UPDATE research_download SET Research_Id='$Research_Id' , Research_code='$Research_code' , CatId ='$CatId' , Agency='$Agency' , Name_info='$Name_info' , DateYear='$DateYear' , academic_year_finish ='$academic_year_finish', Filetex ='$Filetex' WHERE dowId ='$dowId' and Research_code='$Research_code' ";
}
else{
$query1 = " UPDATE research_download SET Research_Id='$Research_Id' , Research_code='$Research_code' , CatId ='$CatId' , Agency='$Agency' , Name_info='$Name_info' , DateYear='$DateYear' , academic_year_finish ='$academic_year_finish' WHERE dowId ='$dowId' and Research_code='$Research_code' ";
}
$result1 = $dbObj->runQuery($query1);
$dbObj->freeresult($result1);
}
else{
InsertDownload ($Research_Id, $Research_code, $CatId , $Agency , $Name_info , $DateYear, $academic_year_finish, $Filetex ) ;
}
$dbObj->disconn();
unset($dbObj);
echo "";
echo "";
echo "";
exit();
} # else
?>
-