Viewing file: InsertProjectedu_01.php (4.2 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php include("./include/FunctionDB.php"); include("./include/Function.php"); ConnectDB(); $Flag = true; $Code_no = htmlspecialchars(trim($_POST[Code_no])); $Project_code = htmlspecialchars(trim($_POST[Project_code])); $Program = htmlspecialchars(trim($_POST[Program])); $Program_1 = htmlspecialchars(trim($_POST[Program_1])); $Program_2 = htmlspecialchars(trim($_POST[Program_2])); $Program_3 = htmlspecialchars(trim($_POST[Program_3])); $Program_4 = htmlspecialchars(trim($_POST[Program_4])); $Program_5 = htmlspecialchars(trim($_POST[Program_5])); $Teacher_code = htmlspecialchars(trim($_POST[Teacher_code])); $Faculty_code = htmlspecialchars(trim($_POST[Faculty_code])); $Detail = htmlspecialchars(trim($_POST[Detail])); /////////////////// $sql3 = "Select * From persnal_project_tb Order by Persnal_code desc"; $result3 = mysql_query($sql3) or die("Error $result3".mysql_error()); $rs = mysql_fetch_row($result3); $persnal_project_tb = $rs[0]+1 ; // นำค่า id มาเพิ่มให้กับค่ารหัสสมาชิกครั้งละ1 if($persnal_project_tb>=100) { $Code_in = "0$persnal_project_tb" ; } else { if($persnal_project_tb>=10) { $Code_in = "00$persnal_project_tb" ; } else { $Code_in = "000$persnal_project_tb" ; } } $Code_no = "$Projectcode_01$Code_in" ; // รหัสสมาชิกเช่น ip0001 /////////////// Check เลขที่ ///////////////////////////////////// echo "$Teacher_code<br>"; $sql = "Select * From persnal_project_tb Where Teacher_code='$Teacher_code'"; $result = mysql_query($sql) or die("Error $result".mysql_error()); $sum = mysql_num_rows($result); if ($sum>1) { $msg .="<li>รหัส $Teacher_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 Address ///////////////////////////// if( $Flag) { $Path = "../Project_pic"; if ( isset($Img1)) if (copy($Img1,"$Path/$Img1_name")) { unlink ($Img1); $Img1 = "$Path/$Img1_name"; } else echo"Can't Copy"; $Flag = 2; InsertProject_edu($Code_no,$Project_code,$First_name,$Name,$Last_name,$Class,$Addname,$citizenId,$Work,$Addwork,$Room,$Amount,$Program,$Program_1,$Program_2,$Program_3,$Program_4,$Program_5,$Teacher_code,$Faculty_code,$Foot,$programId,$collegeCode,$Code,$Age,$Sex,$Address ,$Amper,$ProvinceId ,$Img1,$Zipcode,$Email,$Phone ,$Education,$Education_1,$Education_2,$Detail,$Flag); $msg.="<li>คุณ<b> $Teacher_code $Faculty_code</b>"; $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"<meta http-equiv=\"refresh\" content=\"1;URL=ProjectEduList_03.php?Project_code=$Project_code\">"; } CloseDB(); ?> <html> <head> <title>Inserting Manament</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>
|