Viewing file: EditFromProjectAgree.php (5.17 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( "../includes/FunctionDB.php" );
/** Create Database Object */
$dbObj = new DBConn;
/** Config Table for This Page */
$myTable1 = "personal_tb";
$myTable2 = "formagree";
$myTable2PK = "proId";
$Teacher_code = $_POST['Teacher_code'];
$Noagree = trim($_POST['Noagree']);
$maNo = trim( $_POST['maNo'] );
$Date = dmyE2ymdT($_REQUEST['mDate']);
$Training_name = trim( $_POST['Training_name'] ); //ขออนุมัติ
$Year_std = trim( $_POST['Year_std'] );
$MoneyS_C = trim( $_POST['MoneyS_C'] );
$Dayout = trim( $_POST['Dayout'] );
/*
$query = " SELECT * FROM $myTable2 ORDER BY agreeId DESC ";
$result = $dbObj->execQuery($query);
$rss= $dbObj->fetchArray($result);
$myTable2 = $rss[0]+1 ; // นำค่า id มาเพิ่มให้กับค่ารหัสสมาชิกครั้งละ1
$Noagree = "$Ageer$myTable2" ;
$Flag = "Y";
/*-----------------*/
// $Budget_use = 0;
$sql = " UPDATE formagree SET MoneyS_C='$MoneyS_C' ,Training_name='$Training_name' , Date='$Date' ,Dayout='$Dayout' , Budget_use='$Budget_use',Year_std='$Year_std' WHERE agreeId='$agreeId' AND Teacher_code='$Teacher_code'";
$result = mysql_query($sql) or die("Update Error $sql".mysql_error());
/* --------------------------------------------------------------------------------- */
// $agreeId = mysql_insert_id();
/*
$num_values = count($_POST['agreeName'])-1;
for($i=0;$i<=$num_values;$i++)
{
$agreeName = $_POST['agreeName'][$i];
$Budget_agree=$_POST['Budget_agree'][$i];
$sql1 = " UPDATE formagree_type SET agreeName='$agreeName' , Budget_agree='$Budget_agree' WHERE agreeId='$agreeId' ";
$result1= mysql_query($sql1) or die("Update Error $sql1".mysql_error());
}
*/
/** Botton Name Action */
$action = $_REQUEST['action'];
$id = $_REQUEST['id'];
if( isset($action) && !empty($action) ) {
switch($action) {
case "Delete" :
$num = count($id);
for( $i=0; $i<$num; $i++ ) {
$qrySel = " SELECT * FROM formagree_type WHERE agtyId ='$id[$i]' ";
$resultSel = $dbObj->execQuery($qrySel);
$rsSel = $dbObj->fetchObject($resultSel);
$qryDel = " DELETE FROM formagree_type WHERE agtyId ='$id[$i]' ";
$resultDel = $dbObj->runQuery($qryDel);
$dbObj->freeresult($resultDel);
if( $resultSel ) {
} # if
}
break;
} # switch
} # if
} # else
?>
=$_Config_sitename;?>
freeresult($result);
/** Close the Database */
$dbObj->disconn();
/** Unset Class */
unset($dbObj);
?> bool(false)
|