Viewing file:  InsertResearch1.php (5.31 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;
/** Table --> personal_tb */
$query0 = " SELECT * FROM personal_tb WHERE Username='$Username' ";
$result0 = $dbObj->execQuery($query0);
$rs0 = $dbObj->fetchArray($result0);
$Teacher_code = $rs0['Teacher_code'];
foreach ($_POST as $f=>$v) $_POST[$f] = addslashes($v);
/** Receive values */
$Prod_name = htmlspecialchars(trim($_POST[Prod_name]));
$Prod_type = htmlspecialchars(trim($_POST[Prod_type]));
$Benefit = htmlspecialchars(trim($_POST[Benefit]));
$Fund_resource = htmlspecialchars(trim($Fund_resource));
$Propagate = htmlspecialchars(trim($_POST[Propagate]));
$Date_start = $_POST['mYear1']."-".$_POST['mMonth1']."-".$_POST['mDate1'];
$Date_finish = $_POST['mYear2']."-".$_POST['mMonth2']."-".$_POST['mDate2'];
$Term = htmlspecialchars(trim($_POST[Term]));
$Benefit = htmlspecialchars(trim($_POST[Benefit]));
$Use_ref = htmlspecialchars(trim($_POST[Use_ref]));
//--- ชื่อผู้ร่วมวิจัยที่ xx
$name1 = trim( $_POST['name1'] );
$name2 = trim( $_POST['name2'] );
$name3 = trim( $_POST['name3'] );
$name4 = trim( $_POST['name4'] );
$name5 = trim( $_POST['name5'] );
$name6 = trim( $_POST['name6'] );
$name7 = trim( $_POST['name7'] );
$Year_start = $_POST['mYear']."-".$_POST['mMonth']."-".$_POST['mDate']; // วัน/เดือน/ปีที่เริ่ม
$Year_finish = $_POST['mYear2']."-".$_POST['mMonth2']."-".$_POST['mDate2']; // ปีที่แล้วเสร็จ
$Year_sprop = $_POST['mYear3']."-".$_POST['mMonth3']."-".$_POST['mDate3']; // ปีที่เผยแพร่
$Year_prop = $mYear3;
$Path = "../Research_pic";
//--- Table --> 'research_tb'
//### Upload Image File
if( $_FILES['Filetex']['name'] != "" ) {
$Filetex = $_FILES['Filetex']['name'];
@copy( $_FILES['Filetex']['tmp_name'] , $Path."/".$Filetex );
@unlink( $_FILES['Filetex']['tmp_name'] );
InsertProduct($Teacher_code,$Prod_name,$Date_start,$Date_finish,$Term,$Prod_type,$name1,$name2,$name3,$name4,$name5,$name6,$name7,$Fund_resource,$Fund,$Propagate,$Benefit,$Use_ref,$Filetex);
}
else {
InsertProduct($Teacher_code,$Prod_name,$Date_start,$Date_finish,$Term,$Prod_type,$name1,$name2,$name3,$name4,$name5,$name6,$name7,$Fund_resource,$Fund,$Propagate,$Benefit,$Use_ref,$Fiketex);
} # else
} # else
?>
ข้อมูลทั่วไปบุคลากร - ข้อมูลงานวิจัย - เพิ่มประวัติผลงานวิจัย
freeresult($result0);
/** Close the Database */
$dbObj->disconn();
/** Unset Class */
unset($dbObj);
?> |