01.<?php
02.$EMP_NO = $_POST['EMP_NOO'];
03. $depart = $_POST['departt'];
04. $types = $_POST['typess'];
05. $issue = $_POST['issuee'];
06. $doc = $_POST['docc'];
07. $sn = $_POST['snn'];
08.
09.$a=date("m/d/Y H:i:s");
10.if(isset($EMP_NO)&& isset($depart) && isset($types ) && isset($issue) && isset($doc) && isset($sn) )
11. {
12.
13. if($_POST["postId"] != '')
14. {
15.
16. $sql = "UPDATE rework_process SET emp_no = '".trim($EMP_NO)."', department = '".trim($depart)."' , type = '".trim($types)."' , issue = '".trim($issue)."', doc = '".trim($doc)."', sn = '".trim($sn)."'
17.
18.
19. WHERE post_id = '".$_POST["postId"]."'";
20. mssql_query($sql);
21. }
22. else
23. {
24. foreach( $sn as $key => $n ) {
25.
26. $sql = "INSERT INTO rework_process(emp_no,department,type,issue,doc,sn,date_in, status) VALUES ('".trim($EMP_NO)."','".trim($depart)."','".trim($types)."','".trim($issue)."','".trim($doc)."','".trim($n)."','".trim($a)."', 'pass')";
27. mssql_query($sql);
28. }
29. }
30. }
31.?>
