Viewing file: EditPlan.php (2.21 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php
include("../include/FunctionDB.php");
ConnectDB();
// $Start_date = $_POST[mYear]."-".$_POST[mMonth]."-".$_POST[mDate];;
$strSQL="UPDATE tech_plan_tb SET programId='$programId',conditionId1='$conditionId1',conditionId2='$conditionId2',Method_code='$Method_code',Status='$Status',courseId='$courseId',Start_date='$Start_date',Objective='$Objective',Mainidea='$Mainidea',Title_name ='$Title_name',Total_hour='$Total_hour',Total_std='$Total_std',Assess_code='$Assess_code',Place='$Place',Media='$Media',Appendix='$Appendix',Res_unit='$Res_unit',Apply='$Apply',Asses1='$Asses1', Asses2='$Asses2',Asses3='$Asses3',Asses4='$Asses4' WHERE Plan_code='$Plan_code' ";
$result = mysql_query($strSQL) or die("Update Error $strSQL $result".mysql_error());
$strSQL1 = "UPDATE tech_spec_tb SET Sp1='$Sp1',Sp2='$Sp2',Sp3='$Sp3',Sp4='$Sp4',Sp5='$Sp5',Sp6='$Sp6',Sp7='$Sp7',Sp8='$Sp8',Sp9='$Sp9',Sp10='$Sp10',Sp11='$Sp11',Else_desc='$Else_desc' Where Plan_code='$Plan_code' ";
$result1 = mysql_query($strSQL1) or die("Update Error $strSQL $result1".mysql_error());
// code Plan_code Teacher_code Subject_no M1 M2 M3 M4 M5 M6 M7 M8 M9 M10 M11 M12 M13 M14 M15 M16 M17 M18 M19 M20 M21 M_else Else_desc
$strSQL2 = "UPDATE techplan_method_tb SET M1='$M1',M2='$M2',M3='$M3',M4='$M4',M5='$M5',M6='$M6',M7='$M7',M8='$M8',M9='$M9',M10='$M10',M11='$M11',M12='$M12',M13='$M13',M14='$M14',M15='$M15',M16='$M16',M17='$M17',M18='$M18',M19='$M19',M20='$M20',M_else='$M_else',Else_desc='$Else_desc' Where Plan_code='$Plan_code' ";
$result2 = mysql_query($strSQL2) or die("Update Error $strSQL $result2".mysql_error());
echo "<center>";
echo"<font face=\"Ms san serif\"size=\"4\"><font color=\"0000FF\">$Fname</font>' Edit Complete </font></center>";
header("Location:EditPlanList.php?Teacher_code=$Teacher_code");
CloseDB();
?>
|