Viewing file: EditPlan.php (2.02 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 Course_code='$Course_code',Method_code='$Method_code',Status='$Status',Subject_no='$Subject_no',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()); header("Location:EditPlanList.php?Teacher_code=$Teacher_code"); CloseDB(); ?>
|