Viewing file:  InsertPublicizing.php (4 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
session_start();
/** Define Validate Access */
define( '_VALID_ACCESS', 1 );
/** Check Session User Login */
if (! session_is_registered("valid_user") ) {
echo "<meta http-equiv=\"Content-Type\" content=\"text/html; charset=windows-874\" />";
echo "<p style=padding-top:115px><p align=center><br /><font color=red><strong>กรุณาทำการ Login ก่อน</strong></font></p></p>";
echo "<meta http-equiv=\"refresh\" content=\"1; URL=../login.php\" />";
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" );
require_once( "../includes/cURLRes.php" );
/** Create Database Object */
$dbObj = new DBConn;
//### รับค่าจาก Form
$Destination = htmlspecialchars(trim($_POST['Destination']));
$TopicName = htmlspecialchars(trim($_POST['TopicName']));
$DatePublic = dmyE2ymdT($_REQUEST["mDate4"]);
$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_dissemination Where pubId='$pubId' ";
$result1 = mysql_query($sql);
$num_rows = mysql_num_rows($result1);
if($num_rows){
if($Filetex){
$query1 = " UPDATE research_dissemination SET Feature='$Feature', Flag='$Flag' , Warsan='$Warsan', Quality='$Quality' , Proceeding='$Proceeding' , Results='$Results' ,DatabaseName='$DatabaseName' , JournalName='$JournalName' , Year='$Year' , Issue='$Issue' , Page='$Page', fiscal_year_finish='$fiscal_year_finish' , academic_year_finish='$academic_year_finish' , MeetingName='$MeetingName' , Agencies='$Agencies' , DatePublic='$DatePublic' , Filetex='$Filetex' WHERE pubId='$pubId' ";
}
else{
$query1 = " UPDATE research_dissemination SET Feature='$Feature' , Flag='$Flag' , Warsan='$Warsan' ,Quality='$Quality' , Proceeding='$Proceeding' ,Results='$Results' , DatabaseName='$DatabaseName' , JournalName='$JournalName' , Year='$Year' , Issue='$Issue' , Page='$Page', fiscal_year_finish='$fiscal_year_finish' , academic_year_finish='$academic_year_finish' , MeetingName='$MeetingName' , Agencies='$Agencies' , DatePublic='$DatePublic' WHERE pubId='$pubId' ";
/*----Curl---*/
$res = rsDisseCurl($pubId, $Research_code, $Feature, $Warsan, $Quality, $Proceeding, $Results, $DatabaseName, $JournalName, $Year, $Issue, $Page, $fiscal_year_finish, $academic_year_finish, $MeetingName, $Agencies, $DatePublic, $Filetex );
}
$result1 = $dbObj->runQuery($query1);
$dbObj->freeresult($result1);
}
else{
InsertPubliczing($Research_code, $Feature, $Warsan , $Quality , $Proceeding , $Results, $DatabaseName, $JournalName, $Year, $Issue, $Page, $fiscal_year_finish , $academic_year_finish, $MeetingName, $Agencies , $DatePublic ,$Filetex );
}
$dbObj->disconn();
unset($dbObj);
echo "<meta http-equiv=\"Content-Type\" content=\"text/html; charset=windows-874\" />";
echo "<script>alert('บันทึกข้อมูลเรียบร้อยแล้ว');</script>";
echo "<script>window.opener.document.all.myForm; window.opener.location.reload(); window.close();</script>";
exit();
} # else
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874" />
<title>-</title>
<link href="../css/default.css" rel="stylesheet" type="text/css" />
</head>
<body topmargin="0" rightmargin="0" bottommargin="0" leftmargin="0">
</body>
</html>
|