Viewing file: InsertDurableType.php (4.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( "../include/Function.php" );
require_once( "../include/FunctionDB.php" );
/** Create Database Object */
$dbObj = new DBConn;
//=== SESSION
$Username = $valid_user;
/** Config Table for This Page */
$myTable1 = "personal_tb";
$myTable2 = "durable_tb";
$myTable2PK = "duraId";
/** Table --> personal_tb */
$query1 = " SELECT * FROM $myTable1 WHERE Teacher_code='$Teacher_code' ";
$result1 = $dbObj->execQuery($query1);
$rs1 = $dbObj->fetchArray($result1);
$Teacher_code = $rs1['Teacher_code'];
// $add_updated = ($_POST['mYear2']-543)."-".$_POST['mMonth2']."-".$_POST['mDate2'];
$add_updated = dmyE2ymdE2($_REQUEST['mDate']);
$query = " UPDATE $myTable2 SET DetailDura='$DetailDura' ,DetailDura_name='$DetailDura_name' ,Detail='$Detail', Detail_name='$Detail_name' , Status ='$Status' , Time_total='$Time_total' , add_updated='$add_updated' WHERE duraId='$duraId' and Teacher_code='$Teacher_code' ";
$result = $dbObj->runQuery($query);
$dbObj->freeresult($result);
$i = 1;
while($i <= 5){
if($_POST['Teacher_code'.$i]){
InsertDuraTeacher($_POST['Teacher_code'.$i], $duraId, $Budget_year );
}
$i++;
}
if( isset($action) && !empty($action) ) {
switch($action) {
case "DeletePerson" :
$qryDel = "DELETE FROM manament_tb WHERE codeTh ='$codeTh' AND duraId='$duraId' ";
break;
} # switch
$resultDel = $dbObj->runQuery($qryDel);
$dbObj->freeresult($resultDel);
} # if
} # else
?>
=$_Config_sitename;?>
freeresult($result1);
/** Close the Database */
$dbObj->disconn();
/** Unset Class */
unset($dbObj);
?> |