Viewing file: InsertSubject.php (5.08 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php include("../include/FunctionDB.php"); // Subject_code Subject_name Unit Class Total_hour Objective Detail ConnectDB(); $Flag = true; $Subject_code = htmlspecialchars(trim($_POST[Subject_code])); $SubCate_code = htmlspecialchars(trim($_POST[SubCate_code])); $Subject_group = htmlspecialchars(trim($_POST[Subject_group])); $Subject_no = htmlspecialchars(trim($_POST[Subject_no])); $Subject_name = htmlspecialchars(trim($_POST[Subject_name])); $Unit = htmlspecialchars(trim($_POST[Unit])); $Term = htmlspecialchars(trim($_POST[Term])); $Total_hour = htmlspecialchars(trim($_POST[Total_hour])); $Class_level = htmlspecialchars(trim($_POST[Class_level])); $Objective = htmlspecialchars(trim($_POST[Objective])); $Detail = htmlspecialchars(trim($_POST[Detail])); $Class_Affect = htmlspecialchars(trim($_POST[Class_Affect])); $Affect_sub = htmlspecialchars(trim($_POST[Affect_sub])); ///////////////////// check Duplicate SubjectCode //$sql = "Select * From subject_tb Where Subject_code='$Subject_code'"; //$result = mysql_query($sql) or die("Error ".mysql_error()); //$row = mysql_num_rows($result); //if( $row >= 1) //{ //$msg .="<li>รหัสวิชานี้มีซ้ำ กรุณาระบุ รหัสวิชาใหม่อีกครั้ง"; //$button ="<input type=\"button\" value=\"Back to Edit\" onclick=\"history.back();\" style=\"font-weight:bold;color:#FFF;background-color:#036;border-style:outset;border-color:#69F;font-family:Tohoma;\">"; //$Flag = false; //}
////////////////////////////////////////////// if ($Subject_code =="") { $msg .="<li>กรุณาระบุ รหัสวิชา"; $button ="<input type=\"button\" value=\"Back to Edit\" onclick=\"history.back();\" style=\"font-weight:bold;color:#FFF;background-color:#036;border-style:outset;border-color:#69F;font-family:Tohoma;\">"; $Flag = false; } ///////////////////// check name if ($Subject_name =="") { $msg .="<li>กรุณาระบุ ชื่อวิชา"; $button ="<input type=\"button\" value=\"Back to Edit\" onclick=\"history.back();\" style=\"font-weight:bold;color:#FFF;background-color:#036;border-style:outset;border-color:#69F;font-family:Tohoma;\">"; $Flag = false; } ///////////////////// check name if ($Unit =="") { $msg .="<li>กรุณาระบุ หน่วยกิต"; $button ="<input type=\"button\" value=\"Back to Edit\" onclick=\"history.back();\" style=\"font-weight:bold;color:#FFF;background-color:#036;border-style:outset;border-color:#69F;font-family:Tohoma;\">"; $Flag = false; } if ($Term =="") { $msg .="<li>กรุณาระบุ ภาคการศึกษา"; $button ="<input type=\"button\" value=\"Back to Edit\" onclick=\"history.back();\" style=\"font-weight:bold;color:#FFF;background-color:#036;border-style:outset;border-color:#69F;font-family:Tohoma;\">"; $Flag = false; } /////////////////// Check Lastname if ($Class_level =="") { $msg .="<li>กรุณาระบุ ชั้นปี"; $button ="<input type=\"button\" value=\"Back to Edit\" onclick=\"history.back();\" style=\"font-weight:bold;color:#FFF;background-color:#036;border-style:outset;border-color:#69F;font-family:Tohoma;\">"; $Flag = false; }
///////////////////////// Check Status to Insert Data ///////////////////////////// if( $Flag) { // Subject_no Course_code SubCate_code Subject_group Subject_code Subject_name Unit Class_level Total_hour Objective Detail Class_Affect Affect_sub InsertSubject($Course_code,$SubCate_code,$Subject_group,$Subject_code,$Subject_name,$Unit,$Term,$Class_level,$Total_hour,$Objective,$Detail,$Class_Affect,$Affect_sub); $msg.="<li>ระบบจัดเก็บข้อมูลของท่านเรียบร้อยแล้ว"; // $button = "<input type=\"reset\" value=\"Close Windows\" onclick=\"javascript:parent.close();\" style=\"font-weight:bold;color:#FFF;background-color:#036;border-style:outset;border-color:#69F;font-family:Tohoma;\">"; echo"<br><br><center><font face=\"Ms San serif\"size=\"6\" color=\"#FF0000\">Complete</font></center>"; echo"<meta http-equiv=\"refresh\" content=\"1;URL=SubjectList.php\">"; } CloseDB(); ?> <html> <head> <title>Inserting Subject....</title> <meta http-equiv="Content-Type" content="text/html; charset=windows-874"> <link href="../../css/style1.css" rel="stylesheet" type="text/css"> </head> <body bgcolor="#FFFFFF" leftmargin="0" topmargin="0"marginwidth="0"marginheight="0"> <form> <br> <table width="70%" border="0" cellspacing="0"cellpadding="2"align="center"> <tr> <td><div align="center"><span><b><font color="#003399" size="4" face="Tahoma">::แบบฟอร์มการกรอกข้อมูลวิชา::</font></b></span></div></td> </tr> <tr> <td> <table width="100%" border="0" cellspacing="1"cellpadding="0"align="center"bordercolor="#0B62D9" class="table"> <tr> <td bgcolor="#9ABFED"><div align="center"><b><font color="#000000" size="4" face="Tahoma">ระบบแจ้งการทำงาน</font></b></div></td> </tr> <tr> <td bgcolor="#000000"> <table width="90%" border="0" cellspacing="0"cellpadding="2"align="center"> <tr> <td><span><b><font color="#FFFFFF"><?php echo $msg;?></font></b></span></td> </tr> </table> </td> </tr> <tr> <td bgcolor="#9ABFED"> <div align="center"><b><font color="#CCFF00"><?php echo $button;?> </font></b></div></td> </tr> </table> </td> </tr> </table> <br> </form>
</body> </html>
|