"; 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; $num = count($_POST['Budget_agree'])-1; for($j=0;$j<=$num;$j++) { $Budget_use += $_POST['Budget_agree'][$j]; } $sql = " UPDATE formagree SET MoneyS_C='$MoneyS_C' ,Training_name='$Training_name' , Date='$Date' , Dayout='$Dayout' , Budget_use='$Budget_use' 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()); } } # else ?> MIS -- Teacher
 
หน้าหลัก » จัดการข้อมูล
 
ระบบจัดเก็บข้อมูลของท่านเรียบร้อยแล้ว
กรุณารอส้กครู่ กำลังเปลี่ยนหน้าอัตโนมัติ
"; ?>
 
freeresult($result); /** Close the Database */ $dbObj->disconn(); /** Unset Class */ unset($dbObj); ?>