Viewing file: InsertAcc.php (4.98 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php session_start(); if (session_is_registered("valid_user")) { $Username = $valid_user; include("../include/FunctionDB.php"); include("../include/Function.php"); ConnectDB(); $Flag = true; $Acc_code = htmlspecialchars(trim($_POST[Acc_code])); $Acc_name = htmlspecialchars(trim($_POST[Acc_name])); $Faculty_code = htmlspecialchars(trim($_POST[Faculty_code])); $Acc_type_code = htmlspecialchars(trim($_POST[Acc_type_code])); $Store = htmlspecialchars(trim($_POST[Store])); $Fix_History = htmlspecialchars(trim($_POST[Fix_History])); $Contact = htmlspecialchars(trim($_POST[Contact])); $Date_buy = $_POST['mYear']."-".$_POST['mMonth']."-".$_POST['mDate']; $Statistic = htmlspecialchars(trim($_POST[Statistic])); $Description = htmlspecialchars(trim($_POST[Description])); $Fix_budget = htmlspecialchars(trim($_POST[Fix_budget])); $Status = htmlspecialchars(trim($_POST[Status])); $Price = htmlspecialchars(trim($_POST[Price]));
///////////////check รหัสซ้ำ ////////////// $sql3 = "Select * From accessories_tb Where Acc_code='$Acc_code'"; $result3 = mysql_query($sql3) or die("Error $result3".mysql_error()); $Check= mysql_num_rows($result3); if ($Check >0) { $msg .="<li>รหัสครุภัณฑ์ มีรหัส $Acc_code ในฐานข้อมูลแล้ว"; $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 ($Acc_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 period time long or short if ($Acc_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; } /////////////////// type if ($Acc_type_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; } /////////////////// Store if ($Store =="") { $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 period time long or short if ($Status =="") { $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 Address ///////////////////////////// if( $Flag) { $Path = "../Acc_pic"; if ( isset($Img1)) if (copy($Img1,"$Path/$Img1_name")) { unlink ($Img1); $Img1 = "$Path/$Img1_name"; } else echo"Can't Copy"; InsertAcc($Acc_code,$Acc_name,$Faculty_code,$Acc_type_code,$Store,$Img1,$Fix_History,$Contact, $Date_buy,$Price,$Fix_budget,$Status,$Statistic,$Description); $msg.="<li>ระบบจัดเก็บข้อมูลเรียบร้อยแล้ว"; echo"<meta http-equiv=\"refresh\" content=\"1;URL=AccList.php?Faculty_code=$Faculty_code\">\n"; } CloseDB(); ?> <html> <head> <title>Inserting Accesores</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"> <form> <br> <table width="68%" border="0" cellspacing="0"cellpadding="2"align="center"> <tr> <td><div align="center"><span><b><font color="#000000" size="3" face="Tahoma">::ฟอร์มการเพิ่มข้อมูลครุภัณฑ์::</font></b></span></div></td> </tr> <tr> <td> <table width="74%" border="0" cellspacing="1"cellpadding="2"align="center"bordercolor="#0B62D9" class="table"> <tr> <td bgcolor="#CCCCFF"> <div align="center"><b><font color="#003366" size="3" face="Tahoma">ระบบแจ้งการทำงาน</font></b></div></td> </tr> <tr> <td bgcolor="#000000"> <table width="90%" border="0" cellspacing="0"cellpadding="2"align="center"> <tr> <td><font color="#FFFFFF" size="3" face="Tahoma"><strong><span><?php echo $msg;?></span></strong></font></td> </tr> </table></td> </tr> <tr> <td bgcolor="#CCCCFF"> <div align="center"><b><font color="#CCFF00"><?php echo $button;?></font></b></div></td> </tr> </table> </td> </tr> </table> <br> <br> </form> </body> </html> <?php } else { echo"<meta http-equiv=\"refresh\" content=\"3;URL=../../login.php\">\n"; echo"Please Login "; } ?>
|